Skip to Content
0
Former Member
Mar 15, 2015 at 06:46 PM

Job Fails when Scheduled but executes within Designer

25 Views

Hi,

I have scheduled a job via the "add schedule" from the management console to run every day. But the job fails immediately within 2 secs with the below error. But if I execute the same job from within the Designer, the job runs fine without any problem. I do have global variables assigned which are referenced in the where clause of the query transform. I am using a Salesforce adapter as my source is Salesforce. .

(12.2) 03-13-15 22:20:14 (E) (5796:11844) PAR-010201: |Session BJ_SFDC_Production

Too many errors. Parsing cannot continue.

(12.2) 03-13-15 22:20:14 (E) (5796:11844) PAR-010102: |Session BJ_SFDC_Production

Syntax error at line <1>: <>: near <;> found <a string> expecting <')', ','>.

Syntax error at line <1>: <>: near <;> found <a string> expecting <'(', '.'>.

Syntax error at line <1>: <>: near <,> found <','> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

Syntax error at line <1>: <>: near <select> found <SESSION> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

Syntax error at line <1>: <>: near <)> found <')'> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

Syntax error at line <1>: <>: near <;> found <a string> expecting <')', ','>.

Syntax error at line <1>: <>: near <;> found <a string> expecting <'(', '.'>.

Syntax error at line <1>: <>: near <,> found <','> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

Syntax error at line <1>: <>: near <select> found <SESSION> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

Syntax error at line <1>: <>: near <)> found <')'> expecting <&ERROR_STEP, __AL_IFDEF, IF, IN, READ, RETURNS, VARCHAR,

VARIABLE, __BODI_PARTITION>.

10 error(s), 0 warning(s).

Check and fix the syntax and retry the operation.

(12.2) 03-13-15 22:20:14 (E) (5796:11844) PAR-010202: |SESSION BJ_SFDC_Production

Error parsing global variable values from the command line: <$Orderhistorydate=sql('DS_SFDC_DB', 'select

max(CREATEDDATE) from ORDERHISTORY ');$TaskCreateddate=sql('DS_SFDC_DB', 'select max(CREATEDDATE) from

TASK');$Notecreateddate=sql('DS_SFDC_DB', 'select max(CREATEDDATE) from NOTE

');$OpportunityModDate=sql('DS_SFDC_DB', 'select max(lastmodifieddate) from

Opportunity');$InventoryHistorycreateddate=sql('DS_SFDC_DB', 'select max(CREATEDDATE) from INVENTORYHISTORY

');>. Please check the syntax and try again.

Now, I have tried putting the variables in a Script component, but this way, the pushdown sql does not have the proper where clause and the entire table is read, but only required data is loaded. Even though the end result is good, the production time is severely compromised.

So, the job can be executed without any issue from the Designer, but the same job when scheduled fails immediately.

Please advise.

Thanks.