Additional Blogs by Members
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

getting error while executing lookups jobs

Former Member
‎2013 Nov 01 10:43 AM
0 Kudos
8,449

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.

1 Comment
Popular Blog Posts
Top kudoed authors
View all