Data Services Error: ORA-03149: Invalid Oracle error code

[Former Member]

Hi Friends,

We recently upgraded from Data Services V4.0 to V4.2

We have been getting the below error once in a while. This does not happen every time. This Job connects to SAP Oracle Database (V 11.2.0.2) and fetches records and creates a Flat File. We did not have this error in BODS 4.0. Error screen shot is below:

Your inputs will be very much appreciated.

Thanks,

SA

Message was edited by: Stephen Hutchins 1. Full version Designer - 14.2.5.800 JobServer - 14.0.1.142 JobEngine - 14.0.1.142 Repository - 14.2.5.0000 IPS -14.1.5.1501 DB - 11.0.2 Browser : IE 11

[former_member198401]

Stephen,

Greetings for the day!!

Check if you are trying to load any invalid values in the flat file. Usually an invalid character in date field

Try to load the contents of the oracle table in to a template table instead of a flat file for testing.

Regards

Arun Sasi