NJ
Hello:
We are getting an error message "The Procedure was Cancelled", "Unable to Create Export" for one of the database. When we restore one day old back up of the same database and publlish, it publish without any error. But current version of the database is not getting published.
I checked the error message which is as follows. Please suggest what is this error and how to resolve it.
IT_142352c4aa3_SEVERE 2013-11-08T06:16:04,451 com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.getDBConnection
cannot start DBMS server.
com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Exception while getting DB connection :
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 16092 with message Connection refused: connect.)
at com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.getDBConnection(ADAOUtils.java:118)
at com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.getDBConnection(ADAOUtils.java:89)
at com.idsscheer.aris.businesspublisher.application.dao.database.ASystemBaseDAO.isSchemaInstalled(ASystemBaseDAO.java:984)
at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.isSchemaInstalled(ADAOSystemFacade.java:100)
at com.idsscheer.aris.businesspublisher.application.web.AGarbageCollector.deleteTemporaryUpdateExports(AGarbageCollector.java:33)
at com.idsscheer.aris.businesspublisher.application.web.servlet.AApplicationManager.startupDBMSServer(AApplicationManager.java:294)
at com.idsscheer.aris.businesspublisher.application.web.servlet.AApplicationManager.init(AApplicationManager.java:153)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3951)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
IT_14236e7fc4b_SEVERE 2013-11-08T14:20:42,379 .
Publish: Rollback export triggered from external
IT_14236f8d49a_SEVERE 2013-11-08T14:39:06,330 .
Abc: Rollback export triggered from external
Hi,
Please check the BusinessPublisher.xml, and see whether the oracle database, server and port number is given correctly or not.
You can find the xml in the below location.
..\APPS\ARIS7.1\BPServer\tomcat\conf\Catalina\localhost\BusinessPublisher.xml
If the above doesn't work then follow the below steps.Hope it should work fine.
This is what helps for me for so far
on the server where the Business Publisher is installed
stop the service of the Business Publisher server.
clear up the log folders:
<ARIS installation directory>/BPServer\tomcat\logs
<ARIS installation directory>/BPServer\tomcat\webapps\businesspublisher\log
Restart the service of the Business Publisher
Br/Sashwat
