External Predicate data is not gained when using CSV Utility. Error: CSVUtil.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier (Doc ID 1499396.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On OTM version 6.2.5 version.

We want to export out of OTM the VPD predicate information.

We do this by using the UPLOAD functionality in OTM in the "Upload an XML/CVS Transmission" and intend for the CSV Utility to do the work.

The CSV file we are using to upload to OTM contains:

 -dataFileName EXTERNAL_PREDICATE.csv -command xcsv -tableName EXTERNAL_PREDICATE -whereClause "VPD_PROFILE_GID like 'OTMSBX.%'"

When we upload this to OTM we get the following error.

ERROR
-----------------------
CSVUtil.SQLException:
java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Aim is to EXPORT data out of OTM.
2. Try to us the UPLOAD functionin OTM
3. Take the details that should be entered in the OTM screen "Export CSV" and place them into a CSV file.
4. Upload that file into OTM.

Cause

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