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
runlocally() error with retrieving information from Teradata
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
are there any other error or warnings?
does this query run successfully in sql assistance?
can you change the query to
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