cancel
Showing results for 
Search instead for 
Did you mean: 

Error <DBS-070300> BODS Execution

0 Kudos

Hi, I have 3 existing datastore.

Datastore 1 - Source

D2- Target

D3 - SAP tables

251193130234624DBS-0703004/8/2016 3:34:16 AM|Data flow DF_FIN_CON002_Cost_Center_Get_Data|Loader QRY_GET_DATA_FIN_CON002_COST_CENTER_STG
251193130234624DBS-0703004/8/2016 3:34:16 AMSQL submitted to Oracle Server <DI1> resulted in error <ORA-00942: table or view does not exist
251193130234624DBS-0703004/8/2016 3:34:16 AM>. The SQL submitted is <select "ZSOURCE_SYSTEM", "KOKRS", "KOSTL", "DATAB", "DATBI", "KTEXT", "LTEXT", "VERAK_USER", "VERAK",
251193130234624DBS-0703004/8/2016 3:34:16 AM"ABTEI", "KOSAR", "KHINR", "BUKRS", "FUNC_AREA", "WAERS", "PRCTR", "SPRAS", "MGEFL", "BKZKP", "PKZKP", "BKZKS", "BKZER",
251193130234624DBS-0703004/8/2016 3:34:16 AM"BKZOB", "PKZKS", "PKZER", "VMETH", "ZZZBHLINE", "ZZZPLCUST"
251193130234624DBS-0703004/8/2016 3:34:16 AMFROM "SAPDSSTGPG"."FIN_CON002_COST_CENTER_STG">.
251101364907808DBS-0703004/8/2016 3:34:32 AM|Data flow DF_FIN_CON002_Cost_Center_Get_Data|Loader QRY_GET_DATA_FIN_CON002_COST_CENTER_STG
251101364907808DBS-0703004/8/2016 3:34:32 AMSQL submitted to Oracle Server <DI1> resulted in error <ORA-00942: table or view does not exist
251101364907808DBS-0703004/8/2016 3:34:32 AM>. The SQL submitted is <select "ZSOURCE_SYSTEM", "KOKRS", "KOSTL", "DATAB", "DATBI", "KTEXT", "LTEXT", "VERAK_USER", "VERAK",
251101364907808DBS-0703004/8/2016 3:34:32 AM"ABTEI", "KOSAR", "KHINR", "BUKRS", "FUNC_AREA", "WAERS", "PRCTR", "SPRAS", "MGEFL", "BKZKP", "PKZKP", "BKZKS", "BKZER",
251101364907808DBS-0703004/8/2016 3:34:32 AM"BKZOB", "PKZKS", "PKZER", "VMETH", "ZZZBHLINE", "ZZZPLCUST"
251101364907808DBS-0703004/8/2016 3:34:32 AMFROM "SAPDSSTGPG"."FIN_CON002_COST_CENTER_STG">.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos

The table SAPDSSTGPG.FIN_CON002_COST_CENTER_STG does not exist. Or the user from the datastore definition was not granted correct access rights.