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

 

Best Regards

by Sashwat Sinha
Posted on Tue, 11/12/2013 - 10:50

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock