Jan 18, 2011 at 10:02 PM

Data Services error 051004 (ORA-00933)

120 Views

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