My Oracle Support Banner

Unable to download case details as excel file due to ORA-972 error (Doc ID 2375542.1)

Last updated on JUNE 17, 2019

Applies to:

Oracle Health Sciences Empirica Signal - Version 8.1 and later
Information in this document applies to any platform.

Symptoms


Download Case Details not working as Excel file
Occurs for all case series.


STEPS

Empirica Signal --> Case Series --> View Cases --> Download Case Details --> Excel File


This results in a download of size 0.

When trying to open the xlsx file, an error occurs.

 

ERROR

Error captured in weberror.log

Excel cannot open the file ‘name.xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
ERROR CaseSeriesDetailsDownload -
Error ID: 2c6068e2-affd-4946-9244-bed8b5d7a4da
com.oracle.hsgbu.empirica.jdbc.DatabaseException: ORA-00972: identifier is too long
, SQL: SELECT CASEID, REPORTED_DISEASE AS "Reported Disease/Surgical Procedure", DISEASE_LLT AS "Low Level Term", DISEASE_PT AS "Primary Term", START_DATE AS "Start Date", END_DATE AS "End Date", CONTINUING_YNU AS "Continuing", COMMENTS AS "Comments" FROM SCEPTRE_DRUG_LAST.MEDICAL_HISTORY ,TMP_TABLE_3405542995 WHERE 1=0
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.