Integration server not Starting

Hello All,

I am Starting Integration Server it shows the below error.Any body know regarding this issue please help me to solve this problem.

ErrorMsg=com.wm.app.b2b.server.AccessException: [ISS.0084.9004] Access Denied,$$$AUDITPROCESS={MemData:DefaultJDBCConfig_1=4},ERRORINFO=java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
<<<.

Thanks & Regards,
Cheri Sri

Check with your database team for the correct password. The error says “Access Denied”

Either the Database user credentials got revoked or someone might have deleted the tables from the database.

Thank u for ur reply.

But Database Credentials are correct what i have given.
After installation, when iam trying to start in server.bat i got this error. its not opening in command prompt itself…

What is your webMethods version? After starting the server through command prompt do you see the server.log

Post the error if you see any on server.log.

Hi Cherry,

please also share the products and/or components from DB configurator you have created in your db schema.

Looks like you might have missed some.

Regards,
Holger

Hi Mahesh

I got this error Plz look at the attached file

and in server.log the last error is

2015-02-11 22:59:50 IST [ISS.0028.0005I] Loading WmPRT package
2015-02-11 22:59:51 IST [ISS.0134.0053I] Unable to start JMS Trigger wm.prt.status:JMSControlTrigger: com.wm.app.b2b.server.jms.JMSSubsystemException: [ISS.0134.9017] No JMS Connection Alias found with name “PE_NONTRANSACTIONAL_ALIAS”
2015-02-11 22:59:51 IST [ISS.0134.0064E] Unable to register JMS Trigger wm.prt.status:JMSControlTrigger: com.wm.app.b2b.server.jms.JMSSubsystemException: [ISS.0134.9017] No JMS Connection Alias found with name “PE_NONTRANSACTIONAL_ALIAS”
2015-02-11 22:59:52 IST [ISS.0028.0005I] Loading WmMonitor package
2015-02-11 22:59:55 IST [ISS.0028.0005I] Loading WmLogUtil package
2015-02-11 22:59:56 IST [ISS.0028.0005I] Loading WmDesigner package
2015-02-11 22:59:57 IST [ISS.0028.0005I] Loading WmEstdCommonLib package
2015-02-11 22:59:59 IST [ISS.0028.0005I] Loading WmChem package
2015-02-11 22:59:59 IST [ISS.0028.0005I] Loading WmRosettaNet package
2015-02-11 23:00:00 IST [ISS.0028.0005I] Loading WmRNIF11TRP package
2015-02-11 23:00:00 IST [ISS.0028.0005I] Loading WmRNIF20TRP package
2015-02-11 23:00:00 IST [ISS.0028.0005I] Loading WmMSCodegen package
2015-02-11 23:00:00 IST [ISS.0028.0005I] Loading WmDotNet package
2015-02-11 23:00:01 IST [ISS.0028.0005I] Loading WmIPCore package
2015-02-11 23:00:01 IST [ISS.0026.0002E] Failure while loading service wm.ip.bizdoc:addErrorContentPart: [ISS.0026.9106] No method addErrorContentPart in class wm.ip.bizdoc
2015-02-11 23:00:01 IST [ISS.0026.0002E] Failure while loading service wm.ip.bizdoc:decodeErrorContentPart: [ISS.0026.9106] No method decodeErrorContentPart in class wm.ip.bizdoc
2015-02-11 23:00:02 IST [ISS.0028.0005I] Loading WmFINTransport package
2015-02-11 23:00:02 IST [ISS.0028.0005I] Loading WmCASmf package
2015-02-11 23:00:02 IST [ISS.0028.0005I] Loading WmFIN package
2015-02-11 23:00:04 IST [ISS.0028.0005I] Loading WmFINSamples package
2015-02-11 23:00:04 IST [ISS.0028.0005I] Loading WmFINDev package
2015-02-11 23:00:04 IST [ISS.0028.0005I] Loading WmFINMarketPractice package
2015-02-11 23:00:11 IST [ISS.0028.0005I] Loading WmUNIFI package
2015-02-11 23:00:15 IST [ISS.0028.0005I] Loading WmHipaaTransactions package
2015-02-11 23:00:39 IST [ISS.0028.0005I] Loading WmHipaa package
2015-02-11 23:00:40 IST [ISS.0028.0005I] Loading WmHipaaSample package
2015-02-11 23:00:45 IST [ISS.0028.0005I] Loading WmSWIFTNetServer package
2015-02-11 23:00:45 IST [ISS.0028.0005I] Loading WmSWIFTNetServerSample package
2015-02-11 23:00:45 IST [ISS.0028.0005I] Loading WmPIPTools package
2015-02-11 23:00:47 IST [ISS.0028.0005I] Loading WmebXML package
2015-02-11 23:00:53 IST [ISS.0028.0005I] Loading WmFIXMessages package
2015-02-11 23:00:54 IST [ISS.0028.0005I] Loading WmFIX package
2015-02-11 23:00:54 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:shutdown: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:54 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:init: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:54 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:sendRawFIX: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:55 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:checkAppiaConnection: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:55 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:connect: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:55 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:disconnect: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:55 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:createPID: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:56 IST [ISS.0026.0002E] Failure while loading service wm.fix.appia.wrapper:FIXAdminListener: java.lang.NoClassDefFoundError: com/javtech/appia/middleware/MiddlewareEventListenerIF
2015-02-11 23:00:56 IST [ISS.0028.0005I] Loading WmFIXSamples package
2015-02-11 23:00:57 IST [ISS.0028.0005I] Loading WmSWIFTNetClient package
2015-02-11 23:00:57 IST [ISS.0028.0005I] Loading WmSWIFTNetClientSample package
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading WmHipaaCodeSource package
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading Default package
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading WmTaskClient package
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading WmIPRoute package
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading WmIPCommon package
2015-02-11 23:00:59 IST [ISS.0026.0002E] Failure while loading service wm.ip.ui:addSubmenu: [ISS.0026.9109] Already registered in WmIPCore
2015-02-11 23:00:59 IST [ISS.0026.0002E] Failure while loading service wm.ip.ui:removeSubmenu: [ISS.0026.9109] Already registered in WmIPCore
2015-02-11 23:00:59 IST [ISS.0028.0005I] Loading WmIPPersist package
2015-02-11 23:01:00 IST [ISS.0028.0005I] Loading WmACH package
2015-02-11 23:01:00 IST [ISS.0028.0005I] Loading WmACHForTN package
2015-02-11 23:01:00 IST [ISS.0028.0005I] Loading WmACHForTNSamples package
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.event:startEventAgentPort)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.email:init)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.ftp:init)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.ftps:init)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.http:init)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.ns:syncToNamespace)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.remote:init)
2015-02-11 23:01:01 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.schedule:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.dispatcher:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.tx:init)
2015-02-11 23:01:02 IST [ISC.0063.0011I] Start
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.soap:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.dbalias:initRepoAlias)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.tspace:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmRoot: Startup service (wm.server.ws:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmFlatFile: Startup service (wm.server.ff:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmFlatFile: Startup service (wm.server.ff:setACLs)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmPublic: Startup service (pub.ldap:init)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmPublic: Startup service (pub.storage:startup)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmVCS: Startup service (wm.server.vcsadmin:startup)
2015-02-11 23:01:02 IST [VCS.0132.0050I] VCS package initializing
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmVCS: Startup service (wm.server.vcsui:addSolutions)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmSourceSafe: Startup service (wm.server.vss.admin:startup)
2015-02-11 23:01:02 IST [VCS.0132.0056I] VCS not enabled
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmART: Startup service (wm.art.admin:startup)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmJDBCAdapter: Startup service (wm.adapter.wmjdbc.admin:registerAdapter)
2015-02-11 23:01:02 IST [ART.0114.1100I] Adapter Runtime: Facility 1 - JDBCAdapter registered with bundle com.wm.adapter.wmjdbc.JDBCAdapterResourceBundle.
2015-02-11 23:01:02 IST [ADA.0001.0701W] Exception while creating “SampleConnectionProperties.xml”
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmJDBCAdapter: Startup service (pub.pollingNotificationUtils:startup)
2015-02-11 23:01:02 IST [ISS.0028.0012I] WmDB: Startup service (wm.server.db:startup)
2015-02-11 23:01:03 IST [ISS.0004.0003E] Logging JDBC diagnostics to logs/jdbc.log
2015-02-11 23:01:03 IST [ISS.0028.0012I] WmTomcat: Startup service (wm.tomcat.admin:startup)
2015-02-11 23:01:04 IST [ISS.0100.0008I] Starting tomcat server
2015-02-11 23:01:05 IST [ISS.0100.0008I] Starting Servlet Engine: Apache Tomcat/5.0
2015-02-11 23:01:05 IST [ISS.0100.0008I] Tomcat XML validation is disabled
2015-02-11 23:01:07 IST [ISS.0100.0001C] Web Container started
2015-02-11 23:01:07 IST [ISS.0100.0008I] Create Host deployer for direct deployment ( non-jmx )
2015-02-11 23:01:08 IST [ISS.0100.0008I] Processing Context configuration file URL file:C:\webMethods7\IntegrationServer\web\conf\WmTomcat\localhost\web#WmTomcat.xml
2015-02-11 23:01:08 IST [ISS.0100.0008I] Installing web application from URL file:C:\webMethods7\IntegrationServer\packages\WmTomcat\web
2015-02-11 23:01:08 IST [ISS.0028.0012I] WmTN: Startup service (wm.tn.admin:startup)
2015-02-11 23:01:08 IST [ISU.0000.9999C] TRANET: Starting webMethods Trading Networks
2015-02-11 23:01:08 IST [ISU.0000.9999I] TRANET: Loading system configuration
2015-02-11 23:01:09 IST [ISS.0028.0012I] WmTN: Startup service (wm.tn.mime:init)
2015-02-11 23:01:09 IST [ISS.0028.0012I] WmEDI: Startup service (wm.b2b.edi.templateMgr:init)
2015-02-11 23:01:09 IST [EDI.0002.0004I] Unable to find config file: properties.cnf.
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmEDI: Startup service (wm.b2b.edi.util.formatServices:init)
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmEDI: Startup service (wm.b2b.edi.util.GUI:init)
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmTNWeb: Startup service (wm.tnweb.wrapper:startupSvc)
2015-02-11 23:01:10 IST [TNS.0007.1060I] Updated user and group configuration to 6.0 schema
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmTNWeb: Startup service (wm.tnweb.wrapper:installTNWebACLs)
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmEDIforTN: Startup service (PGP.util:init)
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmEDIforTN: Startup service (VAN.VANConnectivity:regVANFTP)
2015-02-11 23:01:10 IST [ISS.0028.0012I] WmEDIforTN: Startup service (wm.b2b.editn.TPA:createDefaultTPA)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmEDIforTN: Startup service (wm.b2b.editn:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmEDIINT: Startup service (wm.EDIINT.util:init)
2015-02-11 23:01:11 IST [TNS.0005.1042I] Warning: Trying to register delivery service EDIINT SimpleDelivery that is already registered
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmEDIINT: Startup service (wm.EDIINT.util.mime:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmPKI: Startup service (wm.server.pki.admin:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmISExtDC: Startup service (com.wm.isextdc.PkgInit:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmARTExtDC: Startup service (com.wm.artextdc.pkginit:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmTNExtDC: Startup service (wm.tnextdc.PkgInit:init)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmXSLT: Startup service (wm.xslt.Admin:startup)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmDeployer: Startup service (wm.deployer.Util:startup)
2015-02-11 23:01:11 IST [ISS.0028.0012I] WmDeployer: Startup service (wm.deployer.Util:verifyPlugins)
2015-02-11 23:01:12 IST [ISS.0028.0012I] WmOptimize: Startup service (wm.optimize.admin:startup)
2015-02-11 23:01:12 IST [ISS.0028.0012I] WmPRT: Startup service (wm.prt.admin:startup)
2015-02-11 23:01:12 IST [PRT.0101.0830I] JMS Connection Alias for PRT ‘PRT_NONTRANSACTIONAL_ALIAS’ has not been configured.
2015-02-11 23:01:12 IST [PRT.0101.1100E] Error trying to get JDBC pool configuration using functional alias CentralUsers. Business calendar based timeouts will not be able to be evaluated.
2015-02-11 23:01:12 IST [ISS.0028.0012I] WmMonitor: Startup service (wm.monitor.admin:startup)
2015-02-11 23:01:12 IST [MON.0119.0701I] Not performing Broker push (not connected)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmLogUtil: Startup service (wm.loggingUtility:start)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmDesigner: Startup service (wm.administrator.repo:centralRepoRegister)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmDesigner: Startup service (wm.administrator.admin:initialize)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmDesigner: Startup service (wm.designer.metadata.AuditLogAccess:init)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmEstdCommonLib: Startup service (wm.estd.common.bootStrap:startUp)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmChem: Startup service (wm.estd.chemical.bootStrap:startUp)
2015-02-11 23:01:14 IST [ISU.0000.9999E] java.util.MissingResourceException: Can’t find resource for bundle com.wm.estd.chemical.RosettaNetResourceBundle, key RosettaNetChem
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmRosettaNet: Startup service (wm.estd.rosettaNet.bootStrap:startUp)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmRNIF11TRP: Startup service (wm.estd.rosettaNet.rnif11.bootStrap:startUp)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmRNIF20TRP: Startup service (wm.estd.rosettaNet.rnif20.bootStrap:startUp)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmDotNet: Startup service (wm.dotnet.Runtime:registerISMenu)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmDotNet: Startup service (wm.dotnet.Runtime:startCLR)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmIPCore: Startup service (wm.ip.util:init)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmCASmf: Startup service (wm.casmf.init:startup)
2015-02-11 23:01:14 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: CASmf not initialized
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmFIN: Startup service (wm.fin.init:startup)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmFINSamples: Startup service (wm.fin.sample.init:startup)
2015-02-11 23:01:14 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.BE.codeSourceValidation:loadCache)
2015-02-11 23:01:15 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:15 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HB.codeSourceValidation:loadCache)
2015-02-11 23:01:15 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:15 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HC.codeSourceValidation:loadCache)
2015-02-11 23:01:15 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:15 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HCX097.codeSourceValidation:loadCache)
2015-02-11 23:01:16 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:16 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HCX098.codeSourceValidation:loadCache)
2015-02-11 23:01:16 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:16 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HIReq.codeSourceValidation:loadCache)
2015-02-11 23:01:16 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:16 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HIRes.codeSourceValidation:loadCache)
2015-02-11 23:01:17 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:17 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HN.codeSourceValidation:loadCache)
2015-02-11 23:01:17 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:17 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HR.codeSourceValidation:loadCache)
2015-02-11 23:01:17 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:17 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HS.codeSourceValidation:loadCache)
2015-02-11 23:01:17 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:17 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.HP.codeSourceValidation:loadCache)
2015-02-11 23:01:18 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:18 IST [ISS.0028.0012I] WmHipaaTransactions: Startup service (wm.ip.hipaa.transaction.X12.V4010.RA.codeSourceValidation:loadCache)
2015-02-11 23:01:18 IST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2015-02-11 23:01:18 IST [ISS.0028.0012I] WmHipaa: Startup service (wm.ip.hipaa.startup:addHIPAAIDTypes)
2015-02-11 23:01:18 IST [ISS.0028.0012I] WmHipaa: Startup service (wm.ip.hipaa.ui:addMenu)
2015-02-11 23:01:18 IST [ISS.0028.0012I] WmHipaa: Startup service (wm.ip.hipaa.startup:addTA1DocType)
2015-02-11 23:01:18 IST [ISS.0028.0012I] WmSWIFTNetServer: Startup service (wm.swiftnet.server.init:startup)
Capture.JPG

Version webmethods 7.1

Successfully installed components

Analysis 35 (Already exists)
Archive 22 (Already exists)
CrossReference 11 (Already exists)
DataPurge 20 (Already exists)
DatabaseManagement 16 (Already exists)
DistributedLocking 20 (Already exists)
DocumentHistory 10 (Already exists)
ISCoreAudit 13 (Already exists)
ISInternal 30 (Already exists)
MetadataReasoner 30 (Already exists)
MetadataRepository 30 (Already exists)
MyWebMethodsServer 21 (Already exists)
OperationManagement 20 (Already exists)
ProcessAudit 32 (Already exists)
ProcessEngine 36 (Already exists)
ProcessTracker 35 (Already exists)
Reporting 15 (Already exists)
Staging 15 (Already exists)
TradingNetworks 25 (Already exists)
TradingNetworksArchive 20 (Already exists)

Products installed

products.JPG

Hi,

Please try to install latest DataDirect JDBC Driver version “wm-cjdbc37-0008” if in case you are using wm-cjdbc36-0007 as below:

  1. Take the backup of sl53_cj36.jar present at location /IS/lib/jars
  2. Replace it with the new jar file at the same location
  3. Restart the Integration server.

Update the forum with the new updates.

Thanks,

Hi Cherry,

looks like you are missing some native libraries and jar files in your environment.
Please check (esp. the requirements for the WmFIX-package).

Additionally the WmHipaaTransactions-Package seems to be missing some tables in its database schema.

Can you share the output of “http://:/WmRoot/updates.dsp” and “http://:/WmRoot/server-environment.dsp”?

Regards,
Holger

the latest Driver available is 4.2.

You can find it on Empower under SCG_7.1.3_DataDirect4.2_Fix3.

Do not bother about the Version being 7.1.3 instead of 7.1.2.
As this fix only contains the sl53_cj42.jar, this can also be applied to 7.1.2.

When replacing this jar remember to correct the name in IntegrationServer/bin/ini.cnf, otherwise the IS will fail startup with DB-Connectivity errors due to not finding the driver classes.

MWS has its own copy of this driver under MWS/lib/jars/sl53_cjxx_driver.jar:

  • Stop MWS
  • Copy the common/lib/ext/sl53_cjxx.jar to MWS/lib/jars/sl53_cjxx_driver.jar
  • Move the old sl53_cjxx_driver.jar to sl53_cjxx_driver.jar_orig
  • mws.sh -s default update
  • Restart MWS

Regards,
Holger

Hi all Thank You for Your Help I got the solution…

Solution:

This libswlnk.dll is required for WmSwift module, I simply uninstalled this in e-standard.
Now it is working fine.
We have another alternate for this
In IntegrationServer/lib you just paste the two (WmSWIFTNetServer.dll and libswlnk.dll) dll files and run the integration server.

Thanks & Regards,
Cherry Sri.