getting error while executing lookups jobs

November 1, 2013 Abdul Arshad

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.

 

1750017504VAL-0302992013-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>
1750017504VAL-0302992013-11-01 5:02:41 AMWarning: The data returned by function <replace_substr> could be truncated because return size is reduced to <8192> from
1750017504VAL-0302992013-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
1750017504VAL-0302992013-11-01 5:02:41 AMin DSConfig.txt.
1818018196VAL-0302992013-11-01 5:03:08 AM|DATAFLOW DF_DM_Lookups_Created_Imported|STATEMENT <GUID::'31395562-30d8-4c9a-96a8-6301492e64bb' QUERY Qry_Create>
1818018196VAL-0302992013-11-01 5:03:08 AMWarning: The data returned by function <replace_substr> could be truncated because return size is reduced to <8192> from
1818018196VAL-0302992013-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
1818018196VAL-0302992013-11-01 5:03:08 AMin DSConfig.txt.
1818018300DBS-0704042013-11-01 5:03:08 AM|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create
1818018300DBS-0704042013-11-01 5:03:08 AMSQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or
1818018300DBS-0704042013-11-01 5:03:08 AMaccess violation;257 sql syntax error: incorrect syntax near ".": line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT
1818018300DBS-0704042013-11-01 5:03:08 AMTABLE_NAME FROM .TABLES WHERE TABLE_NAME = 'LKP_1ST_STORE_UNIT_TYPE' AND SCHEMA_NAME = ''>.
1818018300RUN-0503042013-11-01 5:03:08 AM|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create|Function FN_Lookup_Create_Lookup_Table
1818018300RUN-0503042013-11-01 5:03:08 AMFunction call <sql ( DS_STG_MGMT_LKP, SELECT TABLE_NAME FROM .TABLES WHERE TABLE_NAME = 'LKP_1ST_STORE_UNIT_TYPE' AND
1818018300RUN-0503042013-11-01 5:03:08 AMSCHEMA_NAME = '' ) > failed, due to error <70404>: <SQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error
1818018300RUN-0503042013-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
1818018300RUN-0503042013-11-01 5:03:08 AM24 (at pos 24)>. The SQL submitted is <SELECT TABLE_NAME FROM .TABLES WHERE TABLE_NAME = 'LKP_1ST_STORE_UNIT_TYPE' AND
1818018300RUN-0503042013-11-01 5:03:08 AMSCHEMA_NAME = ''>.>.
1818018300RUN-0503042013-11-01 5:03:08 AM|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create
1818018300RUN-0503042013-11-01 5:03:08 AMFunction call <FN_Lookup_Create_Lookup_Table ( LKP_1ST_STORE_UNIT_TYPE, LOOKUP_TAB_CREATION ) > failed, due to error <70404>:
1818018300RUN-0503042013-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
1818018300RUN-0503042013-11-01 5:03:08 AMaccess violation;257 sql syntax error: incorrect syntax near ".": line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT
1818018300RUN-0503042013-11-01 5:03:08 AMTABLE_NAME FROM .TABLES WHERE TABLE_NAME = 'LKP_1ST_STORE_UNIT_TYPE' AND SCHEMA_NAME = ''>.>.
1818018300RUN-0530082013-11-01 5:03:08 AM|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create
1818018300RUN-0530082013-11-01 5:03:08 AMINFO: The above error occurs in the context <|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create|Project Column
1818018300RUN-0530082013-11-01 5:03:08 AMSQL_CREATE|FN_Lookup_Create_Lookup_Table(...) Function Body|6 If Step Condition|sql(...) Function Body|>.
1750017504DBS-0704042013-11-01 5:03:19 AM|Data flow DF_DM_Lookups_Created_Imported|Transform Qry_Create
1750017504DBS-0704042013-11-01 5:03:19 AMSQL submitted to ODBC data source <DM_STG_MGMT_LKP_ERP> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or
1750017504DBS-0704042013-11-01 5:03:19 AMaccess violation;257 sql syntax error: incorrect syntax near ".": line 1 col 24 (at pos 24)>. The SQL submitted is <SELECT
1750017504DBS-0704042013-11-01 5:03:19 AMTABLE_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.

Previous Article
Why Integrated Accounting Software Is Key to Financial Success
Why Integrated Accounting Software Is Key to Financial Success

When it comes to keeping track of our finances, my husband and I couldn’t be...

Next Article
Migrate your SAP NetWeaver BW or SAP Business Suite to SAP HANA – see how easy it is! Join us at SAP TechEd Amsterdam
Migrate your SAP NetWeaver BW or SAP Business Suite to SAP HANA – see how easy it is! Join us at SAP TechEd Amsterdam

Are you looking for overwhelming performance for your SAP NetWeaver BW or SAP Business...