Data Services error 051004 (ORA-00933)

[former_member612715]

Hi,

I am trying to execute the job from data services and getting the following error.

16275 867647472 RUN-051004 1/18/2011 1:50:11 PM Cannot <Regular Load Operations> template table <METER>. Possible causes: (1) Database connection is broken; (2) Database

16275 867647472 RUN-051004 1/18/2011 1:50:11 PM related errors such as transaction log is full, etc.; (3) The user defined in the datastore has insufficient privileges for

16275 867647472 RUN-051004 1/18/2011 1:50:11 PM this table operation. Contact your local DBA.

The following error is from management console:

Oracle error message for operation <drop table>: <ORA-00933: SQL command not properly ended

When i check the repository connection to the database then i find its ok. I again updated the repository(oracle), resync it, set the environment variables and restarted the job server but nothing works. tnsnames.ora file is also ok. When i execute the optimized sql in oracle database then it works. Can anybody help on this issue. Data Services version is 3.2 and installed on Linux.

Thanks

[former_member612715]

The problem is solved

[former_member664877]

Hi Sharma,

How did you solve this issue? I'm facing the same error message. Please let me know. Thanks