Skip to Content
Author's profile photo Former Member

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.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo MohanBabu Konisa
      MohanBabu Konisa

      Hi ,

       

      Please let me know how you solved this issue , me too facing same issue