Job Fails when Scheduled but executes within Designer

[Former Member]

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.

[aasavaribhave]

check exact version of your DS. This issue seems to be fixed in:  Data Services 3.2 SP3 Patch 4 (12.2.3.4)

[Former Member]

Please could you guide me to the location for that patch. Everywhere in the SMP, I am able to view only patches for 4.1 and above. None for 3.2 Sp3.