OBIA 796 Informatica mapping, SDE_PSFT_PROJECTCOSTLINEFACT, fails with ORA-26002
(Doc ID 987714.1)
Last updated on NOVEMBER 14, 2019
Applies to:
Siebel CRM Analytics - Version 7.9.6 [1340] and laterInformation in this document applies to any platform.
Symptoms
In OBIA 7.9.6, Informatica mapping SDE_PSFT_PROJECTCOSTLINEFACT, fails with following error during ETL:
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-26002: Table BAW.W_PROJ_COST_LINE_FS has index defined upon it.
Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_PROJ_COST_LINE_FS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_PROJ_COST_LINE_FS]]
WRITER_1_*_1> WRT_8168 End loading table [W_PROJ_COST_LINE_FS] at: Tue Dec 15 13:35:31 2009
WRITER_1_*_1> WRT_8035 Load complete time: Tue Dec 15 13:35:31 2009
ORA-26002: Table BAW.W_PROJ_COST_LINE_FS has index defined upon it.
Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_PROJ_COST_LINE_FS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_PROJ_COST_LINE_FS]]
WRITER_1_*_1> WRT_8168 End loading table [W_PROJ_COST_LINE_FS] at: Tue Dec 15 13:35:31 2009
WRITER_1_*_1> WRT_8035 Load complete time: Tue Dec 15 13:35:31 2009
LOAD SUMMARY
============
WRT_8036 Target: W_PROJ_COST_LINE_FS (Instance Name: [W_PROJ_COST_LINE_FS])
WRT_8044 No data loaded for this target
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |