1 Reply Latest reply on Nov 25, 2010 10:58 AM by coolmesh84

    Oracle BI Apps financials Full load errors

    user10243788
      Hi, I have Oracle BI Apps 7.9.6, Informatica 8.6, EBS R12 is the source

      When i run a full Load of ETL for Financials- Budget, 24 out of 158 tasks are failing.
      When i check the log file
      the log file is as below
      558  SEVERE  Sat Nov 20 15:08:43 AST 2010  
      --------------------------------------------
      
      START OF ETL
      
      --------------------------------------------
      559  SEVERE  Sat Nov 20 15:09:26 AST 2010  Starting ETL Process.
      560  SEVERE  Sat Nov 20 15:09:28 AST 2010  Request to start workflow : 'SILOS:SIL_InsertRowInRunTable' has completed with error code 0
      561  SEVERE  Sat Nov 20 15:09:49 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
      562  SEVERE  Sat Nov 20 15:10:00 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GLAccount_SegmentConfig_Extract' has completed with error code 0
      563  SEVERE  Sat Nov 20 15:10:00 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimension_BalanceSegmentValue_LegalEntity' has completed with error code 0
      564  SEVERE  Sat Nov 20 15:10:01 AST 2010  Request to start workflow : 'SILOS:SIL_GlobalCurrencyGeneral_Update' has completed with error code 0
      565  SEVERE  Sat Nov 20 15:10:01 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimension_Temporary' has completed with error code 0
      566  SEVERE  Sat Nov 20 15:10:01 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_ExchangeRateGeneral_Full' has completed with error code 0
      567  SEVERE  Sat Nov 20 15:10:02 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GLSegmentDimension_Full' has completed with error code 0
      568  SEVERE  Sat Nov 20 15:10:02 AST 2010  Request to start workflow : 'SILOS:SIL_Parameters_Update' has completed with error code 0
      569  SEVERE  Sat Nov 20 15:10:02 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Project' has completed with error code 0
      570  SEVERE  Sat Nov 20 15:10:03 AST 2010  Request to start workflow : 'SILOS:SIL_Stage_GroupAccountNumberDimension_FinStatementItem' has completed with error code 0
      571  SEVERE  Sat Nov 20 15:10:03 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GLBalanceFact_Full' has completed with error code 0
      572  SEVERE  Sat Nov 20 15:10:20 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
      573  SEVERE  Sat Nov 20 15: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\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
      574  SEVERE  Sat Nov 20 15:10:22 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_Temporary.txt SDE_ORA_InternalOrganizationDimension_Temporary
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      575  SEVERE  Sat Nov 20 15:10:24 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
      576  SEVERE  Sat Nov 20 15:10:25 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
      577  SEVERE  Sat Nov 20 15:10:25 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
      578  SEVERE  Sat Nov 20 15:10:26 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
      579  SEVERE  Sat Nov 20 15:10:26 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GLAccountDimension_FinSubCodes' has completed with error code 0
      580  SEVERE  Sat Nov 20 15:10:27 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_Project.txt SDE_ORA_Project
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      581  SEVERE  Sat Nov 20 15:10:27 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
      582  SEVERE  Sat Nov 20 15:10:29 AST 2010  Request to start workflow : 'SILOS:SIL_CurrencyTypes' has completed with error code 0
      583  SEVERE  Sat Nov 20 15:10:32 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_HROrgsTemporary_LatestVersion' has completed with error code 0
      584  SEVERE  Sat Nov 20 15:10:32 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Stage_GroupAccountNumberDimension' has completed with error code 0
      585  SEVERE  Sat Nov 20 15:10:35 AST 2010  Request to start workflow : 'SILOS:SIL_ListOfValuesGeneral_Unspecified' has completed with error code 0
      586  SEVERE  Sat Nov 20 15: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_GLAccountDimension_FinSubCodes.txt SDE_ORA_Stage_GLAccountDimension_FinSubCodes
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      587  SEVERE  Sat Nov 20 15:10:49 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
      588  SEVERE  Sat Nov 20 15:10:52 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
      589  SEVERE  Sat Nov 20 15:10:53 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
      590  SEVERE  Sat Nov 20 15:10:55 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
      591  SEVERE  Sat Nov 20 15:10:55 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_InvOrgs' has completed with error code 0
      592  SEVERE  Sat Nov 20 15:11: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\DataWarehouse.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_InternalOrganizationDimensionHierarchy_InvOrgs.txt SDE_ORA_InternalOrganizationDimensionHierarchy_InvOrgs
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      593  SEVERE  Sat Nov 20 15:11:18 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_OperatingUnitOrgs' has completed with error code 0
      594  SEVERE  Sat Nov 20 15:11: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_InternalOrganizationDimensionHierarchy_OperatingUnitOrgs.txt SDE_ORA_InternalOrganizationDimensionHierarchy_OperatingUnitOrgs
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      595  SEVERE  Sat Nov 20 15:11:41 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_BusinessGroupOrgs' has completed with error code 0
      596  SEVERE  Sat Nov 20 15:12:01 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_BusinessGroupOrgs.txt SDE_ORA_InternalOrganizationDimensionHierarchy_BusinessGroupOrgs
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      597  SEVERE  Sat Nov 20 15:12:04 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimensionHierarchy_Flatten' has completed with error code 0
      598  SEVERE  Sat Nov 20 15:12:24 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_InternalOrganizationDimensionHierarchy_Flatten.txt SDE_ORA_InternalOrganizationDimensionHierarchy_Flatten
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      599  SEVERE  Sat Nov 20 15:14:32 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_GLBalanceFact_Full.txt SDE_ORA_GLBalanceFact_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      600  SEVERE  Sat Nov 20 15:15:14 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_Product_Categories_Derive' has completed with error code 0
      601  SEVERE  Sat Nov 20 15:15:15 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_InternalOrganizationDimension_Full' has completed with error code 0
      602  SEVERE  Sat Nov 20 15:15:16 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_CodeDimension_Group_Acct_Names' has completed with error code 0
      603  SEVERE  Sat Nov 20 15:15:17 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_ProductMultipleCategories_Full' has completed with error code 0
      604  SEVERE  Sat Nov 20 15:15:18 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_GLBudgetDimension_Full' has completed with error code 0
      605  SEVERE  Sat Nov 20 15:15:18 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_LedgerDimension' has completed with error code 0
      606  SEVERE  Sat Nov 20 15:15:18 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_PositionDimension_Full' has completed with error code 0
      607  SEVERE  Sat Nov 20 15:15:18 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_UserDimension_Full' has completed with error code 0
      608  SEVERE  Sat Nov 20 15:15:19 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_TimeDimension_Calendar_Full' has completed with error code 0
      609  SEVERE  Sat Nov 20 15:15:19 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_CodeDimension_Org_Type' has completed with error code 0
      610  SEVERE  Sat Nov 20 15:15:34 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_Product_Categories_Derive.txt SDE_ORA_Product_Categories_Derive
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      611  SEVERE  Sat Nov 20 15:15:36 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_Full.txt SDE_ORA_InternalOrganizationDimension_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      612  SEVERE  Sat Nov 20 15:15:36 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_CodeDimension_Fin_Sub_Names' has completed with error code 0
      613  SEVERE  Sat Nov 20 15:15:37 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_CodeDimension_Group_Acct_Names.txt SDE_ORA_CodeDimension_Group_Acct_Names
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      614  SEVERE  Sat Nov 20 15:15:37 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_ProductMultipleCategories_Full.txt SDE_ORA_ProductMultipleCategories_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      615  SEVERE  Sat Nov 20 15:15: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_LedgerDimension.txt SDE_ORA_LedgerDimension
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      616  SEVERE  Sat Nov 20 15:15: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_UserDimension_Full.txt SDE_ORA_UserDimension_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      617  SEVERE  Sat Nov 20 15:15:41 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_CodeDimension_Fin_Stmt_Item_Names' has completed with error code 0
      618  SEVERE  Sat Nov 20 15:15:41 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_GLBudgetDimension_Full.txt SDE_ORA_GLBudgetDimension_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      619  SEVERE  Sat Nov 20 15:15:41 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_CodeDimension_Org_Type.txt SDE_ORA_CodeDimension_Org_Type
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      620  SEVERE  Sat Nov 20 15:15:41 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_PositionDimension_Full.txt SDE_ORA_PositionDimension_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      621  SEVERE  Sat Nov 20 15:15:41 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_TimeDimension_Calendar_Full.txt SDE_ORA_TimeDimension_Calendar_Full
      Status Desc : Succeeded
      WorkFlowMessage : Workflow executed successfully.
      Error Message : Successfully completed.
      ErrorCode : 0
      622  SEVERE  Sat Nov 20 15:15:42 AST 2010  Request to start workflow : 'SDE_ORAR12_Adaptor:SDE_ORA_CodeDimension_Gl_Account_Segments' has completed with error code 0
      623  SEVERE  Sat Nov 20 15:15:44 AST 2010  
      ANOMALY INFO::: DataWarehouse:CREATE UNIQUE INDEX 
           W_POSITION_DS_U1 
      ON 
           W_POSITION_DS
      (
           INTEGRATION_ID Asc
           ,DATASOURCE_NUM_ID Asc
           ,SRC_EFF_FROM_DT Asc
      ) 
      NOLOGGING
      MESSAGE:::ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
      
      EXCEPTION CLASS::: java.sql.SQLException
      
      oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
      oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
      oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1451)
      com.siebel.etl.database.cancellable.CancellableStatement.executeUpdate(CancellableStatement.java:171)
      com.siebel.etl.database.DBUtils.executeUpdate(DBUtils.java:276)
      com.siebel.etl.database.WeakDBUtils.executeUpdate(WeakDBUtils.java:357)
      com.siebel.analytics.etl.etltask.SQLTask.doExecute(SQLTask.java:116)
      com.siebel.analytics.etl.etltask.CreateIndexTask.doExecute(CreateIndexTask.java:90)
      com.siebel.analytics.etl.etltask.CreateIndexTaskWrapper.doExecute(CreateIndexTaskWrapper.java:46)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:410)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:306)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:213)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:585)
      com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
      java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      java.util.concurrent.FutureTask.run(FutureTask.java:138)
      java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      java.util.concurrent.FutureTask.run(FutureTask.java:138)
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
      java.lang.Thread.run(Thread.java:619)
      624  SEVERE  Sat Nov 20 15:15:44 AST 2010  
      ANOMALY INFO::: Error while executing : CREATE INDEX:W_POSITION_DS:W_POSITION_DS_U1
      MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX 
           W_POSITION_DS_U1 
      ON 
           W_POSITION_DS
      (
           INTEGRATION_ID Asc
           ,DATASOURCE_NUM_ID Asc
           ,SRC_EFF_FROM_DT Asc
      ) 
      NOLOGGING
       with error DataWarehouse:CREATE UNIQUE INDEX 
           W_POSITION_DS_U1 
      ON 
           W_POSITION_DS
      (
           INTEGRATION_ID Asc
           ,DATASOURCE_NUM_ID Asc
           ,SRC_EFF_FROM_DT Asc
      ) 
      NOLOGGING
      cant paste the entire log because of size issues

      I dont understand the create unique index error! ,
      its a out of the box installation and i am getting data from EBS R12 vision db, but it has duplicate SRC_EFF_FROM_DT, its a standard installation to populate data in the oracle BI Applications preconfigured reports
      EMP_ID     PAR_INTEGRATION_ID     POSITION_NAME     DIVN_NAME     EMP_LAST_NAME     EMP_FST_NAME     EMP_LOGIN     OWNER_ALLOC     TYPE_FLG     POSTN_TYPE_CD     BU_ID     CREATED_BY_ID     CHANGED_BY_ID     CREATED_ON_DT     CHANGED_ON_DT     AUX1_CHANGED_ON_DT     AUX2_CHANGED_ON_DT     AUX3_CHANGED_ON_DT     AUX4_CHANGED_ON_DT     SRC_EFF_FROM_DT     SRC_EFF_TO_DT     DELETE_FLG     DATASOURCE_NUM_ID     INTEGRATION_ID     TENANT_ID     X_CUSTOM
      22823     PER~10596     MGR500.Manager     Vision Stores Distribution     Sanders     Devan     Unspecified                         1384     1384     05/05/2005 11:22:54     06/01/2005 14:17:11     05/05/2005 11:23:11     10/14/2005 16:27:31     05/31/2005 16:51:37          06/01/2005 00:00:00     01/01/4713 00:00:00     N     9     PER~22823     DEFAULT     0
      22823     PER~10596     MGR500.Manager     Vision Stores Distribution     Sanders     Devan     Unspecified                         1384     1384     05/05/2005 11:22:54     06/01/2005 14:17:11     05/05/2005 11:23:11     10/14/2005 16:27:31     05/31/2005 16:51:37          05/31/2005 00:00:00     06/01/2005 00:00:00     N     9     PER~22823     DEFAULT     0
      22823     PER~1273     MGR500.Manager     Global Sales     Sanders     Devan     Unspecified                         1384     1384     05/05/2005 11:22:54     05/31/2005 16:50:24     05/05/2005 11:23:11     10/14/2005 16:27:31     12/13/2004 06:28:52          05/05/2004 00:00:00     05/31/2005 00:00:00     N     9     PER~22823     DEFAULT     0
      thanks in advance,

      Edited by: user10243788 on Nov 20, 2010 7:44 AM