Hi,

I have installed 9.5 wM(New Installation).IS is running fine, But i am getting the below error. kindly provide your thoughts in resolving the below error.

[5760]2014-06-12 15:01:34 BST [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[5759]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.oauth:init)
[5758]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.ws:init)
[5757]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.tspace:init)
[5756]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.soap:init)
[5755]2014-06-12 15:01:34 BST [ISS.0028.0013E] Startup service exited with the following error: [ISC.0063.9107] [TxMgr] Service Disabled
[5754]2014-06-12 15:01:34 BST [ISC.0063.0042I] Job Manager not initialized.
[5753]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.tx:init)
[5752]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.dispatcher:init)
[5751]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.schedule:init)
[5750]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.proxy:init)
[5749]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.remote:init)
[5748]2014-06-12 15:01:34 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.ns:syncToNamespace)
[5747]2014-06-12 15:01:33 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.http:init)
[5746]2014-06-12 15:01:33 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.ftps:init)
[5745]2014-06-12 15:01:33 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.ftp:init)
[5744]2014-06-12 15:01:33 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.net.email:init)
[5743]2014-06-12 15:01:33 BST [ISS.0028.0012I] WmRoot: Startup service (wm.server.event:startEventAgentPort)

Many Thanks,
Sugandarajesh G

Did you run the DB configurator… was it success or did you receive any errors?

Thanks for your reply

Yes . It is successfully migrated.
I did’t get any error.

Adding to that

For every 30 mins i am getting the below error in logs

[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Can you specify from version you migrated?

The Database Scipts are arranged different in 9.5 than before.

Which Scripts did you migrate?

Regards,
Holger

Go to JDBC Pools page in the Integration Server Administrator and use the “Test” button to verify that it can connect to the database.

Also share the screen shot of JDBC pools page on IS

Try the below steps and see you if that solve issue.

1. Remove database pool function from all the references in ?JDBC pool? page.

2. Shutdown Integration Server.

3. Remove all files and folders in DB folder under Integration Server root directory. (Please back up them first).

4. In ISInternal.xml and Xref.xml which are located under:

<SoftwareAG_Directory>\IntegrationServer\config\jdbc\function,

Please reset the connPoolAlias:

I.e. Change Embedded Database Pool to:

And remove: Embedded Database Pool.xml from:

<SoftwareAG_Directory>\IntegrationServer\config\jdbc\pool,

5. Restart Integration Server.
6. Finally assign all the references in ?JDBC pool? again.

Good luck