Clarity PPM SaaS - ORA-00904: "VIEW_BY_USER": invalid identifier" from GD Data Extraction Adapter

book

Article ID: 193871

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We are getting below error when we try to run the Global Delivery Data extraction job 

"java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "VIEW_BY_USER": invalid identifier"

could you please let us know below query run the DB.

Environment

Release : 15.8

Component : CA PPM SAAS XML OPEN GATEWAY (XOG)

Resolution

There was a missing column on the custom table used for the Global Delivery Extraction tool, that was missing.
The column "VIEW_BY_USER" was missing on the GD_DATA_EXTRACTION_HISTORY table

SQL> desc GD_DATA_EXTRACTION_HISTORY
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER NAME VARCHAR2(100)

CODE VARCHAR2(100)

FILE_NAME VARCHAR2(100)

FILE_PATH VARCHAR2(2000)

FILE_SIZE NUMBER(30,2)

CREATED_ON DATE

CREATED_BY VARCHAR2(100)

STATUS VARCHAR2(100)

MODIFIED_BY VARCHAR2(100)

VIEW_BY_USER VARCHAR2(2)

 

DBAs have added the missing column