Encountered pmsql_50065 : [ERROR] ODL error:

Posted in the Informatica Forum

Owtotnyu

Makati, 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
Selecting from 3 tables in informatica Apr 29 inf_user 1
tsallis entropy Apr 22 ahmadoo 1
Informatica 9.1.0 installation Apr 18 Vijay 1
how to create this mapping Apr 5 nick 1
Informatica 9 certification dumps (Dec '12) Apr '15 sahana7 27
Informatica (Feb '14) Mar '15 Yuriy 2
How to load multiple XML files to Oracle tables... Mar '15 Anonymous 1
More from around the web