Integration Server Startup service fails in PROD

HI everyone

We are using IS 9.5 and have a startup service on a package, however this startup service fails with error : "Startup service exited with the following error: com.wm.lang.flow.FlowException: ".

This startup service works quite fine in our DEV,TEST and UAT but fails only in PROD environment.

May You Kindly assist.

Thank You in advance.

Ozis

Is your startup service working fine when you run it directly?

HI Prasad

Yes, The startup service runs perfectly when run directly.

Can you set the logging levels for the below to TRACE and reload the package. Check server.log files while you reload.

0026 - Services Flow and coded (for example, Java) services that run in Integration Server.

0028 - Loading, unloading, and other operations of packages.

Hi Ozis,

please check error log additionally to server.log if there are any error messages indicating why the flow exception is arising.

Please provide us these error messages.
Might be that the service is referring to any other services or ressources not being available at the time the service tries to use them.

Regards,
Holger

Hi,

On Designer use “find references” on the startup service and check that the package has their respective packages listed as dependencies.

Also check if the service runs without problems if you reload the package.

Best Regards,

HI Mahesh

The package reloaded successfully after altering the logging levels.

Server.Log :

2017-05-08 18:01:19 SAST [ISS.0028.0042I] Unloading clntMDD_Generic_MasterData package
2017-05-08 18:01:21 SAST [ISS.0028.0005I] Loading clntMDD_Generic_MasterData package
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:getAllRoles
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:updateUser
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSiteClassificationCategories
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listCountryChains
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAgeingMethod
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listTariffClassPerStyle
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listChains
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listPOSMeasure
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:getUserGuideDetails
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listPDPackTypes
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listItemTypes
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listRegionalGroupCategories
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllTradingSites
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listMigGroupPerDept
2017-05-08 18:01:21 SAST [ISC.0088.9998E] Exception → null
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllFABs
2017-05-08 18:01:21 SAST [ISC.0088.9998E] Exception → null
2017-05-08 18:01:21 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSitesAndSiteGroups
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listVolPackTypes
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSiteClassification
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.ConsolidatedSchedulers:resetSchedulerRunFlags
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllDeptGroupElements
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listTariffClassPerTradingCountry
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.ConsolidatedSchedulers:resetListServiceCache
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:relinkAllUsersToRoles
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listClassesByDept
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:searchUsers
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:getUserDetails
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listInterCompanySuppliers
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:getUsersUnderRole
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllDepartments
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listVariantCategoryByDeptNo
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Utils:removeDuplicates
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllClasses
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Utils:mapErrorMessage
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Utils:invokeService
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllVariantCategories
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSubClassesByDeptAndClass
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listBrands
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllSuppliers
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listDealCodes
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllCountryTariffClass
2017-05-08 18:01:22 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllSubClassGrpElements
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllTradingCountries
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listtFABByDeptNo
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listStockStatus
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Utils:multiConcat
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSuppliersByCountries
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:addUserToRole
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSPPackTypes
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllCountries
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllSubClasses
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllUNNumbers
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:hashMapStartUpServiceWrapper
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listUnitOfMeasure
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSiteGroupCategories
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:selectAllUsers
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listBillingCutOffDates
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:getUserInfo
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listDeptGroupElementByDeptNo
2017-05-08 18:01:23 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listToleranceValue
2017-05-08 18:01:24 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listFormatType
2017-05-08 18:01:24 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listBillingChains
2017-05-08 18:01:24 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.ConsolidatedSchedulers:executeMasterDataSchedulers
2017-05-08 18:01:24 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listFABByDeptNo
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listExpenseSuppliers
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listPDRuleTypes
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listAllVariants
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:deleteUser
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows:listSiteClassificationPerDept
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.Flows.UserInfoServices:insertUser
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:insertUser
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:selectMasterDataSchedulers
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:deleteUser
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:dynamicSQL
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:updateUser
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:getRoles
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:selectAllUsers
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:selectUserDetails
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:selectUserGuidesDetails
2017-05-08 18:01:25 SAST [ISS.0026.0001D] Loading service clntMDD_Generic_MasterData.DB_Operations:getUsersUnderRole
2017-05-08 18:01:25 SAST [ISS.0028.0012I] clntMDD_Generic_MasterData: Startup service (clntMDD_Generic_MasterData.Flows:hashMapStartUpServiceWrapper)
2017-05-08 18:01:28 SAST [ISS.0028.0033D] Package clntMDD_Generic_MasterData has reloaded.

HI Gerado

Done and tested . No problems after reloading the package and all necessary packages are referenced.

Thanks,

HI Holger

Checked the error Logs as well, see underneath.

Error Log :

WMERROR 68ff4470-6810-1fef-ac0f-9c994a77b450
com.wm.lang.flow.FlowException:
at com.wm.lang.flow.FlowExit.getFailure(FlowExit.java:289)
at com.wm.lang.flow.FlowState.willExit(FlowState.java:238)
at com.wm.lang.flow.FlowSequence.invoke(FlowSequence.java:269)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:511)
at com.wm.lang.flow.FlowState.step(FlowState.java:389)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:360)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1080)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:640)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:289)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:368)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:544)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:383)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:244)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:108)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:80)
at com.wm.app.b2b.server.SessionInvoke.run(SessionInvoke.java:28)
at com.wm.util.pool.PooledThread.run(PooledThread.java:119)
at java.lang.Thread.run(Thread.java:724) clntMDD_Generic_MasterData.Flows:hashMapStartUpServiceWrapper
clntMDD_Generic_MasterData.Flows:hashMapStartUpServiceWrapper(/0/1/1)

Server.log :

2017-05-04 23:25:40 SAST [ISS.0028.0012I] WmLog4J: Startup service (wm.log.config:loadConfig)
2017-05-04 23:25:40 SAST [ISS.0028.0012I] clntMDD_Generic_MasterData: Startup service (clntMDD_Generic_MasterData.Flows:hashMapStartUpServiceWrapper)
2017-05-04 23:25:40 SAST [ISS.0028.0013E] Startup service exited with the following error: com.wm.lang.flow.FlowException:
2017-05-04 23:25:40 SAST [ISS.0028.0012I] WmTaskClient: Startup service (wm.task.taskclient:init)

Thank You.