Error "ORA-00997: illegal use of LONG datatype" At EXTRACT2STAGING When Running ETL Using Oracle Gateway (Doc ID 2227773.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Primavera Data Warehouse - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When using the Oracle Gateway to connect Primavera Database Warehouse to a P6 Schema on a Microsoft SQL Server Database the following error occurs when running the ETL process:

ERROR

TIMESTAMP setup [INFO] (Message) - ORA-00997: illegal use of LONG datatype
TIMESTAMP setup [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 141
TIMESTAMP setup [INFO] (Message) - ORA-06512: at line 4

Changes

The language of the Oracle Database can be verified by running the following as system or sys.
SELECT USERENV('LANGUAGE') FROM DUAL;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms