getting error while executing lookups jobs
Hi Experts,
I am very new to BODS and we have deployed RDS ERP in our landscape. While we are executing RDS lookups jobs Job_DM_lookups_initialise and Job_DM_Lookups_FileToApp getting below error and we have searched in forums but failed to get resolution.
| 17500 | 17504 | VAL-030299 | 2013-11-01 5:02:41 AM | |SESSION Job_DM_Lookups_Initialise|DATAFLOW DF_DM_Lookups_Created_Imported|STATEMENT <GUID::’31395562-30d8-4c9a-96a8-6301492e64bb’ QUERY Qry_Create> |
| 17500 | 17504 | VAL-030299 | 2013-11-01 5:02:41 AM | Warning: The data returned by function <replace_substr> could be truncated because return size is reduced to <8192> from |
| 17500 | 17504 | VAL-030299 | 2013-11-01 5:02:41 AM | <170750>. If data truncation occurs then increase size of first parameter or adjust Replace_Substr_Max_Return_Size_Characters |
| 17500 | 17504 | VAL-030299 | 2013-11-01 5:02:41 AM | in DSConfig.txt. |
| 18180 | 18196 | VAL-030299 | 2013-11-01 5:03:08 AM | |DATAFLOW DF_DM_Lookups_Created_Imported|STATEMENT <GUID::’31395562-30d8-4c9a-96a8-6301492e64bb’ QUERY Qry_Create> |
| 18180 | 18196 | VAL-030299 | 2013-11-01 5:03:08 AM | Warning: The data returned by function <replace_substr> could be truncated because return size is reduced to <8192> from |
| 18180 | 18196 | VAL-030299 | 2013-11-01 5:03:08 AM | <170750>. If data truncation occurs then increase size of first parameter or adjust Replace_Substr_Max_Return_Size_Characters |
| 18180 | 18196 | VAL-030299 | 2013-11-01 5:03:08 AM | in DSConfig.txt. |
| 18180 | 18300 | DBS-070404 | 2013-11-01 5:03:08 AM | |Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create |
| 18180 | 18300 | DBS-070404 | 2013-11-01 5:03:08 AM | SQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or |
| 18180 | 18300 | DBS-070404 | 2013-11-01 5:03:08 AM | access violation;257 sql syntax error: incorrect syntax near “.”: line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT |
| 18180 | 18300 | DBS-070404 | 2013-11-01 5:03:08 AM | TABLE_NAME FROM .TABLES WHERE TABLE_NAME = ‘LKP_1ST_STORE_UNIT_TYPE’ AND SCHEMA_NAME = ”>. |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | |Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create|Function FN_Lookup_Create_Lookup_Table |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | Function call <sql ( DS_STG_MGMT_LKP, SELECT TABLE_NAME FROM .TABLES WHERE TABLE_NAME = ‘LKP_1ST_STORE_UNIT_TYPE’ AND |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | SCHEMA_NAME = ” ) > failed, due to error <70404>: <SQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near “.”: line 1 col |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | 24 (at pos 24)>. The SQL submitted is <SELECT TABLE_NAME FROM .TABLES WHERE TABLE_NAME = ‘LKP_1ST_STORE_UNIT_TYPE’ AND |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | SCHEMA_NAME = ”>.>. |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | |Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | Function call <FN_Lookup_Create_Lookup_Table ( LKP_1ST_STORE_UNIT_TYPE, LOOKUP_TAB_CREATION ) > failed, due to error <70404>: |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | <SQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | access violation;257 sql syntax error: incorrect syntax near “.”: line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT |
| 18180 | 18300 | RUN-050304 | 2013-11-01 5:03:08 AM | TABLE_NAME FROM .TABLES WHERE TABLE_NAME = ‘LKP_1ST_STORE_UNIT_TYPE’ AND SCHEMA_NAME = ”>.>. |
| 18180 | 18300 | RUN-053008 | 2013-11-01 5:03:08 AM | |Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create |
| 18180 | 18300 | RUN-053008 | 2013-11-01 5:03:08 AM | INFO: The above error occurs in the context <|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create|Project Column |
| 18180 | 18300 | RUN-053008 | 2013-11-01 5:03:08 AM | SQL_CREATE|FN_Lookup_Create_Lookup_Table(…) Function Body|6 If Step Condition|sql(…) Function Body|>. |
| 17500 | 17504 | DBS-070404 | 2013-11-01 5:03:19 AM | |Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create |
| 17500 | 17504 | DBS-070404 | 2013-11-01 5:03:19 AM | SQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or |
| 17500 | 17504 | DBS-070404 | 2013-11-01 5:03:19 AM | access violation;257 sql syntax error: incorrect syntax near “.”: line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT |
| 17500 | 17504 | DBS-070404 | 2013-11-01 5:03:19 AM | TABLE_NAME FROM .TABLES WHERE TABLE_NAME = ‘LKP_1ST_STORE_UNIT_TYPE’ AND SCHEMA_NAME = ”>. |
Please help me out here…with your valuable suggestions.
Thanks in advance.
Hi ,
Please let me know how you solved this issue , me too facing same issue