DAC notification error
JosephJun 24 2011 — edited Jun 29 2011Hi everybody,
i started my etl process many times and got this error
i need help
if someone please can tell me what is wrong!!!
-------------------------------------------------
DAC Notification: 'Failed' status for the process 'JoEtlProcess: ETL Run - 2011-06-20 18:03:51.156
ETL Process Id : 21809884
ETL Name : JoEtlProcess
Run Name : JoEtlProcess: ETL Run - 2011-06-20 18:03:51.156
DAC Server : obi10g
DAC Port : 3141
Status: Failed
Log File Name: JoEtlProcess.21809884.log
Database Connection(s) Used :
JDE_8_12_DATA jdbc:oracle:thin:@192.168.0.4:1521:JDETEST10
JDE_8_12_SYS jdbc:oracle:thin:@192.168.0.4:1521:JDETEST10
JDE_8_12_DD jdbc:oracle:thin:@192.168.0.4:1521:JDETEST10
JDE_8_12_CTRL jdbc:oracle:thin:@192.168.0.4:1521:JDETEST10
DataWarehouse jdbc:sqlserver://obi10g:1433;databaseName=obawdb10
Informatica Server(s) Used :
intrepservice-intrepservice:(10)
Start Time: 2011-06-24 14:11:48.39
Message: Some steps failed.Number of incomplete tasks whose status got updated to stopped :0 Number of incomplete task details whose status got updated to stopped :2042
Actual Start Time: 2011-06-20 18:03:51.25
End Time: 2011-06-24 14:13:54.687
Total Time Taken: 5530 Minutes
Start Time For This Run: 2011-06-24 14:11:48.39
Total Time Taken For This Run: 2 Minutes
Listing of all step statuses...
Completed Sessions ....
'Update Parameters' Status : 'Completed'
'SIL_GlobalCurrencyGeneral_Update' Status : 'Completed'
'SIL_ListOfValuesGeneral_Unspecified' Status : 'Completed'
'SIL_HourOfDayDimension' Status : 'Completed'
'SIL_TimeOfDayDimension' Status : 'Completed'
'PLP_ProjectDimension_Update_ProjectManagerIdandName' Status : 'Completed'
'SIL_CurrencyTypes' Status : 'Completed'
'SDE_JDE_Stage_GroupAccountNumberDimension' Status : 'Completed'
'SDE_JDE_CodeDimension_File_To_Temp_Load' Status : 'Completed'
'SDE_JDE_Stage_GLAccountHierarchyCodes' Status : 'Completed'
'SDE_JDE_Stage_GLAccountDimension_CatCodesFlatFile' Status : 'Completed'
Failed Sessions...
'SDE_JDE_Decimal_Shift' Status : 'Failed'
'PLP_ARXactsGroupAccount_A_Stage' Status : 'Stopped'
'PLP_ARXactsGroupAccount_A2_Load' Status : 'Stopped'
'QUERY_INDEX_CREATION' Status : 'Stopped'
'SIL_ARTransactionFact_Gl_Info_Update' Status : 'Stopped'
'PLP_ARFutureActivityDelete' Status : 'Stopped'
'SIL_InventoryProductDimension' Status : 'Stopped'
'PLP_ARXactsGroupAccount_A1_Load' Status : 'Stopped'
'PLP_ARBalanceFutureActivityLoad' Status : 'Stopped'
'SIL_ARTransactionFact' Status : 'Stopped'
'SIL_BusinessLocationDimension_SCDUpdate' Status : 'Stopped'
'PLP_ARBalanceDateUpdate' Status : 'Stopped'
'TASK_GROUP_Load_ARBalanceFact' Status : 'Stopped'
'PLP_ARSnapshotInvoiceAging' Status : 'Stopped'
'SIL_ProductDimension_SCDUpdate' Status : 'Stopped'
'SIL_InventoryProductDimension_SCDUpdate' Status : 'Stopped'
'PLP_ARIncrActivityLoad' Status : 'Stopped'
'SIL_InternalOrganizationDimension_SCDUpdate' Status : 'Stopped'
'PLP_ARFutureActivityUpdate' Status : 'Stopped'
'PLP_ARFutureActivityDerive' Status : 'Stopped'
'SIL_UserDimension_SCDUpdate' Status : 'Stopped'
'SIL_InternalOrganizationHierarchy' Status : 'Stopped'
'PLP_ARSnapshotCustomerAgingAggregate' Status : 'Stopped'
'PLP_ARBalanceCurrentActivityLoad' Status : 'Stopped'
'SDE_JDE_AR_Transaction_Fact_Extract' Status : 'Stopped'
'TASK_GROUP_GLRecon_ARTransactionFact' Status : 'Stopped'
'SDE_JDE_InventoryProductDimension' Status : 'Stopped'
'SDE_JDE_CodeDimension_UDC' Status : 'Failed'
'SIL_TransactionTypeDimension' Status : 'Stopped'
'SIL_InternalOrganizationDimension' Status : 'Stopped'
'SIL_SupplierAccountDimension' Status : 'Stopped'
'SIL_HierarchyDimension' Status : 'Stopped'
'SIL_ProfitCenterDimension' Status : 'Stopped'
'SIL_CustomerLocationDimension_SCDUpdate' Status : 'Stopped'
'SIL_GLAccountDimension_NewFinStmtGroupAcct_Update' Status : 'Stopped'
'SIL_LedgerDimension' Status : 'Stopped'
'SIL_BusinessLocationDimension' Status : 'Stopped'
'SIL_SalesProductDimension' Status : 'Stopped'
'SIL_EmployeeDimension' Status : 'Stopped'
'SIL_StatusDimension' Status : 'Stopped'
'SIL_TaxTypeDimension' Status : 'Stopped'
'SIL_CustomerFinancialProfileDimension_SCDUpdate' Status : 'Stopped'
'SIL_SalesProductDimension_SCDUpdate' Status : 'Stopped'
'TASK_GROUP_Load_StatusDimension' Status : 'Stopped'
'SIL_UserDimension' Status : 'Stopped'
'PLP_GLGroupAccountDimension' Status : 'Stopped'
'SIL_CostCenterDimension' Status : 'Stopped'
'SIL_CostCenterDimension_SCDUpdate' Status : 'Stopped'
'SIL_ProfitCenterDimension_SCDUpdate' Status : 'Stopped'
'SIL_GLAccountDimension' Status : 'Stopped'
'SIL_GLAccountDimension_HierarchyUpdate' Status : 'Stopped'
'SIL_GLAccountDimension_SCDUpdate' Status : 'Stopped'
'SIL_PaymentTermsDimension' Status : 'Stopped'
'SIL_ChannelTypeDimension' Status : 'Stopped'
'SIL_ExchangeRateGeneral' Status : 'Stopped'
'SIL_PaymentTermsDimension_SCDUpdate' Status : 'Stopped'
'SIL_EmployeeDimension_SCDUpdate' Status : 'Stopped'
'SIL_GeoCountryDimension' Status : 'Stopped'
'SIL_SupplierAccountDimension_SCDUpdate' Status : 'Stopped'
'SIL_CustomerLocationDimension' Status : 'Stopped'
'Load into Product Dimension' Status : 'Stopped'
'SIL_PaymentMethodDimension' Status : 'Stopped'
'SIL_CustomerFinancialProfileDimension' Status : 'Stopped'
'TASK_GROUP_Load_PartyDimension' Status : 'Stopped'
'SIL_PartyOrganizationDimension' Status : 'Stopped'
'SIL_PartyOrganizationDimension_SCDUpdate' Status : 'Stopped'
'SIL_PartyDimension_Organization' Status : 'Stopped'
'PLP_EmployeeDimension_Update_ProjectManager_Flg' Status : 'Stopped'
'TASK_GROUP_Extract_EmployeeDimension_SalesReps_AOS' Status : 'Stopped'
'SDE_JDE_InternalOrganizationHierarchy' Status : 'Stopped'
'SDE_JDE_InternalOrganizationHierarchy_Tmp_Load' Status : 'Stopped'
'SDE_JDE_CodeDimension_Company' Status : 'Stopped'
'TASK_GROUP_JDE_InternalOrganizationHierarchy' Status : 'Stopped'
'SDE_JDE_Code_PayTerms_Load' Status : 'Stopped'
'SDE_JDE_Code_AP_PayTerms_Load' Status : 'Stopped'
'SDE_JDE_StatusDimension' Status : 'Stopped'
'SDE_JDE_CodeDimension_ProfitCenter_Company' Status : 'Stopped'
'SDE_JDE_CodeDimension_ProfitCenter_Currency' Status : 'Stopped'
'TASK_GROUP_Extract_StatusDimension' Status : 'Stopped'
'SDE_JDE_CodeDimension_Fin_Stmt_Item_Names' Status : 'Stopped'
'SDE_JDE_CodeDimension_Fin_Sub_Names' Status : 'Stopped'
'SDE_JDE_CodeDimension_Group_Acct_Names' Status : 'Stopped'
'SDE_JDE_Code_Pay_Terms_Load_Customer_Account' Status : 'Stopped'
'SDE_JDE_CodeDimension_CostCenterName' Status : 'Stopped'
'SDE_JDE_CodeDimension_PositionType' Status : 'Stopped'
'SDE_JDE_CodeDimension_TransactionType' Status : 'Stopped'
'SDE_JDE_Code_Dimension_Load_Acct_Doc_Status' Status : 'Stopped'
'SDE_JDE_CodeDimension_State_Load' Status : 'Stopped'
'SDE_JDE_CodeDimension_Load_City' Status : 'Stopped'
'SIL_CustomerAccountDimension' Status : 'Stopped'
'SIL_CustomerAccountDimension_SCDUpdate' Status : 'Stopped'
'SDE_JDE_CodeDimension_CustomerAccount_Company' Status : 'Stopped'
'SDE_JDE_CodeDimension_DepartmentName' Status : 'Stopped'
'SDE_JDE_CodeDimension_GLAccountNames' Status : 'Stopped'
'SDE_JDE_CodeDimension_GLCatCodes' Status : 'Stopped'
'SDE_JDE_CodeDimension_GLSegmentMisc' Status : 'Stopped'
'SDE_JDE_InternalOrganizationHierarchyCompany' Status : 'Stopped'
'SDE_JDE_InternalOrganizationHierarchyBusinessUnits' Status : 'Stopped'
'SIL_ProductMultipleCategories' Status : 'Stopped'
'SDE_JDE_StatusDimension_SalesOrder' Status : 'Stopped'
'SDE_JDE_CodeDimension_Commodity_Name' Status : 'Stopped'
'SDE_JDE_InternalOrganization_BusinessUnits' Status : 'Failed'
'SDE_JDE_InternalOrganization_Company' Status : 'Stopped'
'SDE_JDE_ExchangeRateGeneral' Status : 'Failed'
'SDE_JDE_ProductDimensions' Status : 'Failed'
'SDE_JDE_TimeDimension_FiscalPeriod_Extract' Status : 'Failed'
'SIL_YearDimension' Status : 'Stopped'
'SIL_YearDimension_UpdateFlag' Status : 'Stopped'
'TASK_GROUP_Load_DayDimension' Status : 'Stopped'
'SIL_DayDimension_GenerateSeed' Status : 'Stopped'
'SIL_DayDimension_UpdateFlag' Status : 'Stopped'
'SIL_DayDimension' Status : 'Stopped'
'SIL_DayDimension_CleanSeed' Status : 'Stopped'
'SIL_DayDimension_GenerateRows1' Status : 'Stopped'
'SIL_DayDimension_GenerateRows2' Status : 'Stopped'
'SIL_DayDimension_GenerateRows3' Status : 'Stopped'
'SIL_DayDimension_GenerateRows4' Status : 'Stopped'
'SIL_DayDimension_GenerateRows5' Status : 'Stopped'
'SIL_DayDimension_GenerateRows7' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseWeek_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseYear' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseYear_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_MCalCalendar_Generated' Status : 'Stopped'
'SIL_DayDimension_GenerateRows6' Status : 'Stopped'
'SIL_MonthDimension' Status : 'Stopped'
'SIL_MonthDimension_UpdateFlag' Status : 'Stopped'
'SIL_QuarterDimension' Status : 'Stopped'
'SIL_QuarterDimension_UpdateFlag' Status : 'Stopped'
'SIL_WeekDimension' Status : 'Stopped'
'SIL_WeekDimension_UpdateFlag' Status : 'Stopped'
'SIL_TimeDimension_MCalDay' Status : 'Stopped'
'SIL_TimeDimension_MCalDay_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_MCalPeriod' Status : 'Stopped'
'SIL_TimeDimension_MCalPeriod_Generated' Status : 'Stopped'
'SIL_TimeDimension_MCalPeriod_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_MCalPeriod_UpdateFlg' Status : 'Stopped'
'SIL_TimeDimension_MCalQuarter' Status : 'Stopped'
'SIL_TimeDimension_MCalQuarter_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_MCalWeek13Period' Status : 'Stopped'
'SIL_TimeDimension_MCalWeek445' Status : 'Stopped'
'SIL_TimeDimension_MCalWeek_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_MCalWeek_UpdateFlag' Status : 'Stopped'
'SIL_TimeDimension_MCalYear' Status : 'Stopped'
'SIL_TimeDimension_MCalYear_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_UpdateEnterpriseAttributes' Status : 'Stopped'
'SIL_TimeDimension_EnterprisePeriod' Status : 'Stopped'
'SIL_TimeDimension_EnterprisePeriod_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseQuarter' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseQuarter_Unspecified' Status : 'Stopped'
'SIL_TimeDimension_EnterpriseWeek' Status : 'Stopped'
'SDE_JDE_TimeDimension_McalContext' Status : 'Stopped'
'SDE_JDE_Stage_GLAccountDimension_AidSblSbltLkp' Status : 'Failed'
'SIL_Stage_GroupAccountNumberDimension_FinStatementItem' Status : 'Stopped'
'SDE_JDE_Stage_GLAccountDimension_FinSubCodes' Status : 'Stopped'
'SDE_JDE_GLAccountDimension' Status : 'Stopped'
'SDE_JDE_BusinessLocationDimension_Company' Status : 'Failed'
'SDE_JDE_BusinessLocationDimension_Plant' Status : 'Stopped'
'SDE_JDE_BusinessLocationDimension_Other' Status : 'Stopped'
'SDE_JDE_TimeDimension_Calendar' Status : 'Failed'
'SDE_JDE_UserDimension' Status : 'Failed'
'SDE_JDE_EmployeeDimension' Status : 'Failed'
'SIL_EmployeeDemographicsAggregate_Load' Status : 'Stopped'
'SIL_EmployeeDemographicsDimension_Unspecified' Status : 'Stopped'
'SDE_JDE_PartyOrganisationDimension' Status : 'Failed'
'SDE_JDE_Customer_Account_Dimension' Status : 'Failed'
'SDE_JDE_TransactionTypeDimension' Status : 'Failed'
'SDE_JDE_XactTypeDimension_SalesPickLine' Status : 'Stopped'
'SDE_JDE_XactTypeDimension_SalesScheduleLine' Status : 'Stopped'
'SDE_JDE_XactTypeDimension_ProdXacts' Status : 'Stopped'
'SDE_JDE_XactTypeDimension_SalesInvoiceLine' Status : 'Stopped'
'SDE_JDE_XactTypeDimension_SalesOrderLine' Status : 'Stopped'
'SDE_JDE_ChannelTypeDimension' Status : 'Failed'
'SDE_JDE_CustomerLocationDimension' Status : 'Failed'
'SDE_JDE_CustomerFinProfileDimension' Status : 'Failed'
'SDE_JDE_Supplier_Account' Status : 'Failed'
'SDE_JDE_ProfitCenterDimension' Status : 'Failed'
'SDE_JDE_PaymentTermsDimension' Status : 'Failed'
'SDE_JDE_PaymentMethodDimension' Status : 'Failed'
'SDE_JDE_TerritoryDimension' Status : 'Failed'
'Load into Territory Dimension' Status : 'Stopped'
'SDE_JDE_LedgerDimension' Status : 'Failed'
Queued Sessions....
---------------------------------
i connected my source to jde,
some tasks are successful (10) while other failed (more than 100) and today i had some in qeues
What can be the probleme ?
i followed the doc e14843, now i try to run a full load of my jde source
???