4 Radnor Corporate Center
Suite 350
Radnor, PA 19087
+1 (888) 507-2270
OpenCDISC Validator Excel Report has missing tabs and only partial contents
Forums: Troubleshooting and Problems
Hi Barry, Please confirm
Hi Barry,
Please confirm that you has run the same validation directly from a command line rather than using a GUI application and did not have such problems with reports?
Thanks,
Sergiy
Solution Found
Hi Sergiy,
I've discovered why the Excel file corruption occurred. It has nothing to do with the OpenCDISC tool. It has to do with the FTP software I was using to download the Excel file. When I used a different FTP tool, there was no corruption. I was able to open the Excel file perfectly fine. I'm not sure why my FTP software is not working properly with the new Linux server but it’s not a problem for this forum. Many thanks for the quick replies from you both.
Barry A.
FTP
While it's not a problem for this forum, i have seen similar issues before with FTP tools which have a setting (usually for text only, but may apply to binary) that says " convert tab to spaces" or vice versa. it sounds like the problematic FTP tool did some type of conversion detrimental to the .xls. But it's possible you can continue to use that tool by tweaking a settting in it.
I've recently installed the OpenCDISC Validator tool (v1.4.1) on a Linux server. The Linux server has Java 1.7.0_25 installed. Using Exceed, I was able to start the user interface with the command "java -Xms256m -Xmx1024m -jar lib/validator-gui-1.4.1.jar". In the UI, I entered the prompts and started the job. The job completed, generating the Excel report. No indications of any errors or problems.
However, when I tried to open the generated report using Excel (2007), I got a dialog box with the error message "opencdisc-report-2014-01-07T15-38-15.xls cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only". I pressed the "Cancel" button, which was followed immediately with another Excel dialog box with the error message "Excel found unreadable content in 'opencdisc-report-2014-01-07T15-38-15.xls'. Do you want to recover the contents of ths workbook? If you trust the source of the workbook, click Yes". I select the "Yes" button and the file was opened but had a new dialog box titled "Repairs to 'opencdisc-report-2014-01-07T15-38-15.xls'. The message in this last dialog box was "Excel recovered your formulas and cell values, but some data may have been lost." There was a message also at the bottom of the dialog box that pointed to a "error031040_01.xml" file.
The XML file contained:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error031040_01.xml</logFileName><summary>Errors were detected in file 'c:\OpenCDISC-Validator\v1.4.1\reports\opencdisc-report-2014-01-07T15-38-15.xls' </summary><additionalInfo><info>Excel recovered your formulas and cell values, but some data may have been lost.</info></additionalInfo></recoveryLog>
In the Excel file there were only 2 tabs "Dataset Summary" and "Issue Summary" instead of the expected 4 tabs. Also for each tab only partial results were found.
Any ideas on what causing this problem? I have been running from a UNIX system, generating reports without any of these problems.