Data Mart Job of 'Oracle Export' Type Generates 'EXP-00011: ZZ_CDR_SI_<ID>.<TABLE_NAME> does not exist'
Last updated on DECEMBER 28, 2016
Applies to:Oracle Life Sciences Data Hub - Version 2.2 and later
Information in this document applies to any platform.
On LSH 126.96.36.199 version, when attempting to use the Oracle Export service from a Data Mart, the following error occurs:
ERROR ----------------------- EXP-00011: ZZ_CDR_SI_20002.DATETIMEFMTCHK does not exist
Oracle Export service is defined on both Apps and DB service locations.
Oracle Data Mart Job doesn't export data when the job goes to Database DP server, but exports data when the job goes to Apps DP Server.
Job status shows 'Success' for both the jobs. The only difference between the Database and App server DP servers is Oracle DB version on App server is 10.1.0.5.0 and on DB server is 188.8.131.52.0.
The issue can be reproduced with the following steps:
1. Submit a Data Mart of type 'Oracle Export' job.
2. When the job goes to DB DP Server:
2.1 Job completes with job status ‘Success’
2.2 Job log file contains the following error:
EXP-00011: ZZ_CDR_SI_20002.DATETIMEFMTCHK does not exist
2.3 Oracle DB version is 184.108.40.206.0
3. When the job goes to App DP Server:
3.1 Job completes with job status ‘Success’
3.2 Job log doesn’t contain any error. It contains the following message to confirm the data export:
. . exporting table DATETIMEFMTCHK 9 rows exported
3.3 Oracle DB version is 10.1.0.5.0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms