Encountered pmsql_50065 : [ERROR] ODL...

Encountered pmsql_50065 : [ERROR] ODL error:

Posted in the Informatica Forum

Owtotnyu

Quezon City, Philippines

#1 May 18, 2011
I am encountering this issue when I am processing data to load to a target table. The entire log is below:

2011-05-17 18:37:00 : ERROR :(1253560 | TRANSF_1_6_1):(IS | INTSVC_REP_xxxx): node1_company_DEV : pmsql_50065 :[ERROR] ODL error:
Database driver error... Function Name : Execute SQL Stmt : SELECT TA_SEQ.NEXTVAL FROM DUAL Database driver error... Function Name : Execute SQL Stmt : SELECT TA_SEQ.NEXTVAL FROM DUAL.

What it is doing is just fetching data for the next sequence value in Oracle. Informatica version is 8.6.1 and Oracle version is 11g. Any help to resolve issue will be greatly appreciated. Thanks!

Owtotnyu

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Informatica Admin & Cloud Deployment May '17 avi_infa 1
Converting row data to column data (Sep '16) Sep '16 Roopa 1
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... (Apr '16) Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... (Mar '16) Mar '16 anil 1
More from around the web