Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DAC notification error

JosephJun 24 2011 — edited Jun 29 2011
Hi 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
???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2011
Added on Jun 24 2011
15 comments
1,944 views