runlocally() error with retrieving information from Teradata

[etlbets]

I get the following below error I think when two jobs at the same time run the following SQL. The job is called lookup but it is really extracting a single row from Teradata.


Item #: 51
Event ID: 26384
Timestamp: 2008-07-15 18:02:15
Type: Fatal
User Name: etluser
Message: ODBC_Tera_Prcs_Ctrl_Lookup,0: The runLocally() of the operator failed.

select SRC_SYS_NUM, PROD_YEAR_MONTH, PRCS_CYC_NUM, PRCS_TYPE_CODE, max(RETRY_NUM) as RETRY_NUM
FROM edw_metadata.PRCS_CTRL
where SRC_SYS_NUM = substr('#pSysParms#', 1, 3)
and PRCS_CYC_NUM = substr('#pSysParms#', 4, 3)
and PROD_YEAR_MONTH = substr('#pSysParms#', 7, 6)
and PRCS_TYPE_CODE like 'REVENUE' || '%'
group by SRC_SYS_NUM, PROD_YEAR_MONTH, PRCS_CYC_NUM, PRCS_TYPE_CODE;

Any thoughts the pSysParms are different for each job. The format is 133001200807

[keshav0307]

are there any other error or warnings?

does this query run successfully in sql assistance?

can you change the query to

select SRC_SYS_NUM, PROD_YEAR_MONTH, PRCS_CYC_NUM, PRCS_TYPE_CODE, max(RETRY_NUM) as RETRY_NUM
FROM edw_metadata.PRCS_CTRL
where SRC_SYS_NUM = substr('#pSysParms#', 1, 3)
and PRCS_CYC_NUM = substr('#pSysParms#', 4, 3)
and PROD_YEAR_MONTH = substr('#pSysParms#', 7, 6)
and PRCS_TYPE_CODE like 'REVENUE%'
group by SRC_SYS_NUM, PROD_YEAR_MONTH, PRCS_CYC_NUM, PRCS_TYPE_CODE