Unable to write to ODBC file

jatz_da_way · Post by **jatz_da_way** » Wed Jan 26, 2005 1:46 pm

HI Guys !!
I am a beginner to Datastage 6.0....
I am trying to do the tutorial that comes along with the Datastage. In Exercise 5 & 6, we are supposed to write some transformed data into the ODBC file... the job gets aborted when I run the job.

Whereas if I replace the ODBC with sequential, it runs fine & the data is written into the sequential file. I am unable to fix this prob. Any help wud be appreciated.

Regards,
Jatz

ketfos · Post by **ketfos** » Wed Jan 26, 2005 2:16 pm

Hi,
What error message do you get?

Ketfos

jatz_da_way · Post by **jatz_da_way** » Wed Jan 26, 2005 5:36 pm

Hi Ketfos
This is the error that I am getting from the log generated during the run :

example6..Transformer_1.DSLink5: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO SCOTT.FACTS(ORDERDATE, EMPNO, CUSTID, ORDID, PRODID, QTY, TOTALSALE, SHIPDATE) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=23000, DBMS.CODE=2291
[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle]ORA-02291: integrity constraint (SCOTT.FACTS_TIME_FK) violated - parent key not found

Regards,
Jatz

bryan · Post by **bryan** » Wed Jan 26, 2005 6:43 pm

The problem is with referential integrity

the column into which you are writing to is a foreign key and which is also is a primary key to someother table.

This is a database concept. Unless the value is present in Parent table, the value cannot be inserted into child table. This is for data integrity.

Ex: We cant insert any values for columns in fact table that are not primary keys in Dimension table.

OR

it can also be that you didnt enter a value for the primary column(key) of your table