DAC Etl finished but informatica workflow failed in workflow monitor
Hi All,
I'm running a execution plan with subject areas is "Financials - General Ledger".and execution plan finished but i find that there are so many failed workflow in workflow monitor.All error detail is "ORA-26002: Table XXXX index defined upon it"
so i'm create a small subject areas add only one task(SDE_ORA_GLAccountDimension) and create a execution plan with this SA to test.the same error occured.
In normal way,DAC will run this workflow follow these setup:
1.Truncate table
2.Drop index
3.Run workflow
4.Create index
5.Analyze table
I'm query the creation date about table index and it has changed after etl end.and i found that the workflow log end time is later than index create time.
So i guess the reason is when dac didn't get the correct status from workflow.when setup3 started,dac get a completed status and run next setup,but in fact the etl still runned so when index created.workflow failed.
I don't know how dac to get status from workflow.I have no idea even though I found the reason.Anyone could help me?
Version:
Source System: EBS R12.1.1 and Oracle DB 11.1.0.7
DataWarhouse: Oracle DB 11.2.0.1
BI Application: 7.9.6.1
DAC:10.1.3.4.1
Informatica:8.6.1 HotFix6
DW is installed on CentOS5 64bit.
BIApps, DAC, Informatica installed on MS Windows2003 64bit.
Many Thanks,
Alther