My Oracle Support Banner

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 MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.

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

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
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.