Session Error PLESE TAKE A LOOK

[coolspartan]

Hello Gurus,

I am getting the following error. Please take a look

READER_1_1_1> Wed Dec 15 14:15:45 2004
READER_1_1_1> RR_4035 SQL Error [
[IBM][CLI Driver] CLI0165E Error in row. SQLSTATE=01S01 sqlstate = 01S01
[IBM][CLI Driver][DB2/6000] SQLSTATE 01003: Null values were
eliminated from the argument of a column function.

sqlstate = 01003
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0165E Error in row. SQLSTATE=01S01 sqlstate = 01S01
[IBM][CLI Driver][DB2/6000] SQLSTATE 01003: Null values were
eliminated from the argument of a column function.

sqlstate = 01003
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 sqlstate = 22005
[IBM][CLI Driver] CLI0165E Error in row. SQLSTATE=01S01 sqlstate = 01S01
[IBM][CLI Driver][DB2/6000] SQLSTATE 01003: Null values were
eliminated from the argument of a column function.

Database driver error...
Function Name : Fetch
SQL Stmt : Select...........

READER_1_1_1> Thu Dec 16 15:15:45 2004
READER_1_1_1> BLKR_16034 ERROR: Fetch failed.
WRITER_1_1_1> WRT_8167 Start loading table [Target_F] at: Wed Dec 15 14:15:45 2004WRITER_1_1_1> WRT_8306 Rollback executed for the target [Target_F]
WRITER_1_1_1> Wed Dec 15 14:15:45 2004
WRITER_1_1_1> WRT_8170 Writer run terminated: Abort Session request
received from the DTM
WRITER_1_1_1> WRT_8168 End loading table [Target_F] at: Thu Dec
16 15:15:45 2004
WRITER_1_1_1> WRT_8035 Load complete time: Wed Dec 15 14:15:45 2004




Thanks,
Spartan

 

[blom0344]

Problem starts in the fetch phase. The engine cannot compile correct SQL statement as it seems. Are you sure that the source definition in Powermart matches the structure of the database table you are trying to read from?

Ties Blom
Information analyst

 

[coolspartan]

Thanks for the reply Ties. The SQL-override statement works fine when tested from db2 client. And I have also verified all the Source definition in the power mart.What else do you suggest me to check?
Thanks,
Spartan

 

[blom0344]

Spartan,

Are you running the session with the SQL override enabled?
Did you choose the correct connection from within Workflow manager? What version of INFA are you using? This is a session aimed at mainframe?

Ties Blom
Information analyst

 

[y0geshkulkarni]

I am not Informatica programmer.. use some other tools with DB2. Just a tip if you already dont know this.. log on to any DB2 database.. at command line type
db2 "? sql0xxxx" (0 is -ve sign and xxxx is errorcode). It describes what the error is and also provides possible options to resolve it.