Did not create Details spreadsheet

c Craig

on April 15, 2011

Hi,

I'm running version 1.2.1 and after running and viewing output report, nothing was written to the Details sheet. I have information written to the Dataset Summary and Issue Summary sheets, but without the Details sheet populated, you don't know which errors go with which datasets, or which records in the datasets are causing them. What would be a likely reason for the sheet not populating, or a way to troubleshoot it?

Thanks,

Craig

Forums: Troubleshooting and Problems

m Max

on April 17, 2011

P21

Re: Did not create Details spreadsheet

Hi Craig,

Could you please provide more information about your inputs:

Standard (SDTM, ADaM, or Define)
Source Format (SAS or Text)
Source Data (full study or a single dataset)
Configuration (SDTM 3.1.1, 3.1.2, etc)
Define.xml (specified or not specified)

Also, if you are validating a full SDTM study try validating just a single dataset and see if this issue occurs. This will help us determine if there is something in the data that is causing this issue.

Thanks,
Max

c Craig

on April 19, 2011

Re: Did not create Details spreadsheet

Hi Max,

Thanks for your reply. Here are the details:

Standard - SDTM
Source Format - SAS .xpt files
Source Data - was full study, but also happened on single dataset
Congfiguration - SDTM 3.1.2
Define.xml not specified

-Craig

m Max

on April 20, 2011

P21

Re: Did not create Details spreadsheet

Hi Craig,

Can you also check the "Excel Message Limit" option under "Report Settings", which is accessible via a link to the right of Report Format? Is it set to 1?

Also, can you try running the validation with "Report Format" set to CSV. Does the report contain any records?

Thanks,
Max

c Craig

on April 27, 2011

Re: Did not create Details spreadsheet

Max,

Thanks once again for the prompt reply. I was out of the office for a few days and forgot about this for a while. Anyway, it was the Excel Message Limit set to 1. I'm not quite sure how I should set it, maybe to max value? I guess it controls how many of the ERROR messages to show? Not sure why setting of 1 shows nothing though. Setting to 2 showed 2 ERROR messages, and many of the warnings and informational messages. Was this supposed to default to 1? Seems it would be better to default to the maximum. But anyway, thanks again!

Craig

m Max

on April 27, 2011

P21

Re: Did not create Details spreadsheet

Hi Craig,

We were able to confirm that there is a bug that causes the Details tab to be empty when Excel Message Limit is set to 1. The default value is actually 1,000 and you can also set it to 0 (unlimited). I would recommend going with 1,000 and only reduce it if the report contains too many messages or you run up against the 65K record limit in Excel.

Regards,
Max

d David

on May 18, 2011

CSV Output and Excel Message Limit

I set "Excel Message Limit" option under "Report Settings" to 5 and chose CSV as the output. The limit does not apply to CSV which contains all the messages.