Skip to Content
0
Apr 08, 2016 at 01:42 AM

Error <DBS-070300> BODS Execution

572 Views

Hi, I have 3 existing datastore.

Datastore 1 - Source

D2- Target

D3 - SAP tables

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