Hi All,
I have configured Oracle BI Apps 7.9.6 and informatica 8.6 i am trying to get a full load from R12.
When i run a full load of financials-receivables, out of 304 tasks 68 fail!, i have the log file below, can someone kindly tell me what could be the problem,
11 SEVERE Tue Nov 02 11:04:37 AST 2010
--------------------------------------------
START OF ETL
--------------------------------------------
12 SEVERE Tue Nov 02 11:04:50 AST 2010 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.InformaticaTask
13 SEVERE Tue Nov 02 11:04:50 AST 2010 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.InformaticaTask
14 SEVERE Tue Nov 02 11:04:50 AST 2010 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.PauseTask
15 SEVERE Tue Nov 02 11:04:50 AST 2010 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.PauseTask
16 SEVERE Tue Nov 02 11:04:56 AST 2010 Unable to evaluate method getNamedSourceIdentifier for class com.siebel.analytics.etl.etltask.TaskPrecedingActionScriptTask
17 SEVERE Tue Nov 02 11:04:56 AST 2010 Unable to evaluate method getNamedSource for class com.siebel.analytics.etl.etltask.TaskPrecedingActionScriptTask
18 SEVERE Tue Nov 02 11:05:05 AST 2010 Starting ETL Process.
19 SEVERE Tue Nov 02 11:05:06 AST 2010 Informatica Status Poll Interval new value : 20000(milli-seconds)
20 SEVERE Tue Nov 02 11:05:10 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\FLAT FILE specified is not a currently existing directory
21 SEVERE Tue Nov 02 11:05:14 AST 2010 Request to start workflow : 'SILOS:SIL_InsertRowInRunTable' has completed with error code 0
22 SEVERE Tue Nov 02 11:05:34 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SILOS.SIL_InsertRowInRunTable.txt SIL_InsertRowInRunTable
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
23 SEVERE Tue Nov 02 11:05:46 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\ORACLE (OCI8) specified is not a currently existing directory
24 SEVERE Tue Nov 02 11:05:46 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\ORACLE specified is not a currently existing directory
25 SEVERE Tue Nov 02 11:05:46 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\Oracle specified is not a currently existing directory
26 SEVERE Tue Nov 02 11:05:46 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\oracle specified is not a currently existing directory
27 SEVERE Tue Nov 02 11:05:51 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GroupAccountNumberDimension' has completed with error code 0
28 SEVERE Tue Nov 02 11:05:53 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_LocalCurrency_Temporary' has completed with error code 0
29 SEVERE Tue Nov 02 11:05:53 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GLSegmentDimension_Full' has completed with error code 0
30 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_ValueSet_Extract' has completed with error code 0
31 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GLJournals_Full' has completed with error code 0
32 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SILOS:SIL_Stage_GroupAccountNumberDimension_FinStatementItem' has completed with error code 0
33 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_ValueSetHier_Extract_Full' has completed with error code 0
34 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_ExchangeRateGeneral_Full' has completed with error code 0
35 SEVERE Tue Nov 02 11:05:54 AST 2010 Request to start workflow : 'SILOS:SIL_GlobalCurrencyGeneral_Update' has completed with error code 0
36 SEVERE Tue Nov 02 11:05:55 AST 2010 Request to start workflow : 'SILOS:SIL_CurrencyTypes' has completed with error code 0
37 SEVERE Tue Nov 02 11:08:58 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SILOS.SIL_GlobalCurrencyGeneral_Update.txt SIL_GlobalCurrencyGeneral_Update
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
38 SEVERE Tue Nov 02 11:09:19 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_LocalCurrency_Temporary.txt SDE_ORA_LocalCurrency_Temporary
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
39 SEVERE Tue Nov 02 11:09:20 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SILOS.SIL_CurrencyTypes.txt SIL_CurrencyTypes
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
40 SEVERE Tue Nov 02 11:09:21 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_GroupAccountNumberDimension.txt SDE_ORA_Stage_GroupAccountNumberDimension
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
41 SEVERE Tue Nov 02 11:09:34 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GLAccountDimension_FinSubCodes' has completed with error code 0
42 SEVERE Tue Nov 02 11:09:34 AST 2010 Request to start workflow : 'SILOS:SIL_Parameters_Update' has completed with error code 0
43 SEVERE Tue Nov 02 11:09:34 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GLAccount_SegmentConfig_Extract' has completed with error code 0
44 SEVERE Tue Nov 02 11:09:34 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity' has completed with error code 0
45 SEVERE Tue Nov 02 11:09:37 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SILOS.SIL_Stage_GroupAccountNumberDimension_FinStatementItem.txt SIL_Stage_GroupAccountNumberDimension_FinStatementItem
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
46 SEVERE Tue Nov 02 11:09:39 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_ValueSet_Extract.txt SDE_ORA_Stage_ValueSet_Extract
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
47 SEVERE Tue Nov 02 11:09:39 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_ValueSetHier_Extract_Full.txt SDE_ORA_Stage_ValueSetHier_Extract_Full
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
48 SEVERE Tue Nov 02 11:09:40 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_GLSegmentDimension_Full.txt SDE_ORA_GLSegmentDimension_Full
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
49 SEVERE Tue Nov 02 11:09:42 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt SDE_ORA_ExchangeRateGeneral_Full
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
50 SEVERE Tue Nov 02 11:09:47 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract' has completed with error code 0
51 SEVERE Tue Nov 02 11:09:57 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_TransactionTypeDimension_ExpenditureCategory' has completed with error code 0
52 SEVERE Tue Nov 02 11:09:57 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract' has completed with error code 0
53 SEVERE Tue Nov 02 11:10:08 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_ARSubType_Extract
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
54 SEVERE Tue Nov 02 11:10:09 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion' has completed with error code 0
55 SEVERE Tue Nov 02 11:10:16 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_GLAccount_SegmentConfig_Extract.txt SDE_ORA_Stage_GLAccount_SegmentConfig_Extract
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
56 SEVERE Tue Nov 02 11:10:17 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity.txt SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
57 SEVERE Tue Nov 02 11:10:17 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SILOS.SIL_Parameters_Update.txt SIL_Parameters_Update
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
58 SEVERE Tue Nov 02 11:10:18 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract.txt SDE_ORA_Stage_TransactionTypeDimension_ARType_Extract
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
59 SEVERE Tue Nov 02 11:10:18 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_TransactionTypeDimension_ExpenditureCategory.txt SDE_ORA_TransactionTypeDimension_ExpenditureCategory
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
60 SEVERE Tue Nov 02 11:10:21 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GL_AR_REV_LinkageInformation_Extract_Full' has completed with error code 0
61 SEVERE Tue Nov 02 11:10:21 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_GLAccountDimension_FinSubCodes.txt SDE_ORA_Stage_GLAccountDimension_FinSubCodes
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
62 SEVERE Tue Nov 02 11:10:22 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication' has completed with error code 0
63 SEVERE Tue Nov 02 11:10:28 AST 2010 Request to start workflow : 'SILOS:SIL_ListOfValuesGeneral_Unspecified' has completed with error code 0
64 SEVERE Tue Nov 02 11:10:33 AST 2010 C:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input\ORACLE (THIN) specified is not a currently existing directory
65 SEVERE Tue Nov 02 11:10:38 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_ValueSetHier_Flatten' has completed with error code 0
66 SEVERE Tue Nov 02 11:10:47 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication.txt SDE_ORA_Stage_TransactionTypeDimension_ARSubType_ExtractApplication
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
67 SEVERE Tue Nov 02 11:10:48 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SILOS.SIL_ListOfValuesGeneral_Unspecified.txt SIL_ListOfValuesGeneral_Unspecified
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
68 SEVERE Tue Nov 02 11:10:51 AST 2010 Request to start workflow : 'SILOS:SIL_TimeOfDayDimension' has completed with error code 0
69 SEVERE Tue Nov 02 11:10:54 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_TransactionTypeDimension_ARDerive' has completed with error code 0
70 SEVERE Tue Nov 02 11:10:57 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion.txt SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
71 SEVERE Tue Nov 02 11:10:58 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\DataWarehouse.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_Stage_ValueSetHier_Flatten.txt SDE_ORA_Stage_ValueSetHier_Flatten
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
72 SEVERE Tue Nov 02 11:11:03 AST 2010 Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_ValueSetHier_DeriveRange' has completed with error code 0
73 SEVERE Tue Nov 02 11:11:12 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SILOS -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\FlatFileConnection.DataWarehouse.SILOS.SIL_TimeOfDayDimension.txt SIL_TimeOfDayDimension
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
74 SEVERE Tue Nov 02 11:11:14 AST 2010 pmcmd startworkflow -sv Oracle_BI_DW_Base_integration_service1 -d Domain_home-9e3bae43d0 -u Administrator -p **** -f SDE_ORAR12_Adaptor -lpf D:\Informatica\PowerCenter8.6.0\server\infa_shared\SrcFiles\DataWarehouse.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_TransactionTypeDimension_ARDerive.txt SDE_ORA_TransactionTypeDimension_ARDerive
Status Desc : Succeeded
WorkFlowMessage : Workflow executed successfully.
Error Message : Successfully completed.
ErrorCode : 0
75 SEVERE Tue Nov 02 11:11:22 AST 2010 Request to start workflow : 'SILOS:SIL_HourOfDayDimension' has completed with error code 0
76 SEVERE Tue Nov 02 11:11:43 AST 2010 pmcmd startworkflow -sv