Informatica, any expert know the error reason? ora-00942
I am newbie to informatica. Any help is really appreciated
When I run the workflow, I got session error. The detailed session log is under below.
I am using oracle11g and informatica 9.0.1
The main reason is table or view is not exist, like this
2011-09-22 14:36:04 : ERROR : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8229 : Database errors occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
So I am wondering:
1) I setup ODBC data source user and ODBC target user, now ODBC source user
have all source data. So, after mapping, am I supposed to have any table definiton
in the target user? where is the target table definiton?
2)Probably, I set up wrong connection. Before I create session, I create native connection. When I create native connection to both source and target database, right? When I create native connection, I need source database user and target
database user. I am confusing, what kind of user should I use? I create two new
users having DBA privileges in both database. Am I wrong?
*****START LOAD SESSION*****
Load Start Time: Thu Sep 22 14:36:04 2011
Target tables:
EMPLOYEES
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : BLKR_16007 : Reader run started.
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : RR_4010 : SQ instance [SQ_EMPLOYEES] SQL Query [SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.JOB_ID, EMPLOYEES.FIRST_NAME, EMPLOYEES.LAST_NAME, EMPLOYEES.ADDRESS1, EMPLOYEES.ADDRESS2, EMPLOYEES.CITY, EMPLOYEES.STATE, EMPLOYEES.POSTAL_CODE, EMPLOYEES.HOME_PHONE, EMPLOYEES.OFFICE_PHONE, EMPLOYEES.EMAIL FROM EMPLOYEES]
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : RR_4049 : RR_4049 SQL Query issued to database : (Thu Sep 22 14:36:04 2011)
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : RR_4050 : RR_4050 First row returned from database to reader : (Thu Sep 22 14:36:04 2011)
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : BLKR_16019 : Read [12] rows, read [0] error rows for source table [EMPLOYEES] instance name [EMPLOYEES]
2011-09-22 14:36:04 : INFO : (3696 | READER_1_1_1) : (IS | inte6) : node01_ang : BLKR_16008 : Reader run completed.
2011-09-22 14:36:04 : INFO : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8167 : Start loading table [EMPLOYEES] at: Thu Sep 22 14:36:04 2011
2011-09-22 14:36:04 : INFO : (3696 | TRANSF_1_1_1) : (IS | inte6) : node01_ang : DBG_21216 : Finished transformations for Source Qualifier [SQ_EMPLOYEES]. Total errors [0]
2011-09-22 14:36:04 : ERROR : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8229 : Database errors occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO EMPLOYEES(EMPLOYEE_ID,JOB_ID,ADDRESS1,ADDRESS2,CITY,STATE,POSTAL_CODE,HOME_PHONE,OFFICE_PHONE,EMAIL) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO EMPLOYEES(EMPLOYEE_ID,JOB_ID,ADDRESS1,ADDRESS2,CITY,STATE,POSTAL_CODE,HOME_PHONE,OFFICE_PHONE,EMAIL) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
2011-09-22 14:36:04 : ERROR : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8425 : ERROR: Writer execution failed.
2011-09-22 14:36:04 : ERROR : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8076 : Writer run terminated. [Commit Error]
2011-09-22 14:36:04 : INFO : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8333 : Rolling back all the targets due to fatal session error.
2011-09-22 14:36:04 : INFO : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8325 : Final rollback executed for the target [EMPLOYEES1] at end of load
2011-09-22 14:36:04 : ERROR : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8081 : Writer run terminated. [Error in loading data to target table [EMPLOYEES]]
2011-09-22 14:36:04 : INFO : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8168 : End loading table [EMPLOYEES] at: Thu Sep 22 14:36:04 2011
2011-09-22 14:36:04 : INFO : (3696 | WRITER_1_*_1) : (IS | inte6) : node01_ang : WRT_8035 : Load complete time: Thu Sep 22 14:36:04 2011
LOAD SUMMARY
============
WRT_8036 Target: EMPLOYEES (Instance Name: [EMPLOYEES1])
WRT_8044 No data loaded for this target