Author Topic: Job failing when scheduled ....  (Read 4359 times)

Offline sudhajan

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 27
  • Forum Citizenship: +0/-0
Job failing when scheduled ....
« on: 26 Nov 2010 03:10:53 am »
Hi,
I have created a job with couple of reports in it.
I have set prompt values and set the report to be sent to a mailing address.

The report query is also set to local processing.

Now When i run the job from "run with options" and run now, the job runs successfully ( report runs and is delivered to the given adress).
But when i schedule the job and make it run at later time, then the job fails saying

" Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'. UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled. UDA-SQL-0477 A literal value is not supported by the database. This operation requires local processing of the data."

Not sure why but report runs fine if the job is run immediately but fails when job is scheduled.

Somebody, pls help out

Thanks in advance

Offline kawabunga

  • Full Member
  • ***
  • Join Date: Aug 2007
  • Posts: 16
  • Forum Citizenship: +1/-0
Re: Job failing when scheduled ....
« Reply #1 on: 25 Aug 2020 09:09:01 am »
Does anybody have a suggestion to resolve this? I am encountering the same issue.

Any assistance would be appreciated.

Thanks!

***************************************************************************************

Hi,
I have created a job with couple of reports in it.
I have set prompt values and set the report to be sent to a mailing address.

The report query is also set to local processing.

Now When i run the job from "run with options" and run now, the job runs successfully ( report runs and is delivered to the given adress).
But when i schedule the job and make it run at later time, then the job fails saying

" Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'. UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled. UDA-SQL-0477 A literal value is not supported by the database. This operation requires local processing of the data."

Not sure why but report runs fine if the job is run immediately but fails when job is scheduled.

Somebody, pls help out

Thanks in advance