Regarding Error meassage in BODS

[Former Member]

Hi,

Please find the below error message while iam executing BODS job.

19628 18984 RUN-050304 2/11/2013 12:22:31 PM Function call <sql ( SQLSERVER_DATASTORE, SELECT END_TIME  FROM AL_HISTORY  WHERE SERVICE = JOB_Delta_ZDS_CRM_PROSPECTS_TRAN) )

19628 18984 RUN-050304 2/11/2013 12:22:31 PM > failed, due to error <70401>: <ODBC data source <10.11.225.45\BOE140> error message for operation <SQLExecute>:

19628 18984 RUN-050304 2/11/2013 12:22:31 PM <[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.>.>.

Kindly help me.

Thanks,

Santhosh.

[Former Member]

Hi Santhosh,

The problem is the extra close bracket at the end of the SQL Statement.  Also the name of the job should be enclosed in single quotes.

Regards

Nigel

[Former Member]

Hi Nigel,

Thanks for your reply.Issue is resolved and i have to mainitain syntax like  SERVICE =\'JOB_Delta_ZDS_CRM_PROSPECTS_TRAN\' .

Regards,

Santhosh.

[Former Member]

Hi Santhosh,

Please close the thread as resolved/Answered.

Regards,

Manu

[Former Member]

Resolved issue based on above solution.

Thank you all.