Profile picture for user keesh

Our situation:

We are using ARIS 7.2 on a Microsoft Windows Server 2008 R2 Enterprise and an Oracle database (11.2.0.1.0). ARIS Business Server 7.2 and Service Enabling 1.0 run on this machine, the ARIS Busines Publisher runs on an other machine.

When we restart the server mostly the start up is fine but sometimes the Business Server stops (last test 1 out of 3).

The error is:

2013-06-19T15:31:25,46 ARIS Server
2013-06-19T15:31:25,46 (c) 2013 Software AG
2013-06-19T15:31:25,46
2013-06-19T15:31:25,46
2013-06-19T15:31:25,46 [ ARIS Server Startup process ]
2013-06-19T15:31:25,46
2013-06-19T15:31:25,46 supported oem profile: ARIS
2013-06-19T15:31:25,46
2013-06-19T15:31:25,46
2013-06-19T15:31:25,233 Started profile Agent@16073
2013-06-19T15:31:25,233
2013-06-19T15:31:25,233 Starting ARIS Admin Agent 7.2.3.654794(7.1.0.654794)(Agent)
2013-06-19T15:31:25,296 [ARIS Agent] 19.06.2013 15:31:25 Starting ARIS Server Site ...
2013-06-19T15:36:25,444 [ARIS Agent]
2013-06-19T15:36:25,444 [ARIS Agent] Could not start ARIS Server Site : timeout exceeded!
2013-06-19T15:36:25,444 [ARIS Agent] ARIS Lockservice could not be started properly!
2013-06-19T15:36:25,444 [ARIS Agent]
2013-06-19T15:36:25,444 [ARIS Agent] 19.06.2013 15:36:25 Shutting down ARIS Server Site ...
2013-06-19T15:36:25,444 [ARIS Agent] 19.06.2013 15:36:25 Shutting down ARIS Report Adapter ...
2013-06-19T15:37:20,310 [ARIS Agent] Shutting down ARIS Admin Agent ...
2013-06-19T15:37:20,310 [ARIS Agent] 19.06.2013 15:37:20 Shutting down ARIS Server Site ...
2013-06-19T15:37:20,325 [ARIS Agent] 19.06.2013 15:37:20 Shutting down ARIS Report Adapter ...
2013-06-19T15:38:15,81 Launch of ARIS Admin Agent failed!
2013-06-19T15:38:15,81
2013-06-19T15:38:15,81 [ There have been ERRORS, ARIS Server is going down ... ]
2013-06-19T15:38:15,81 Terminating ARIS Server ...
2013-06-19T15:38:15,81 ARIS Server terminated!
2013-06-19T15:38:15,81
2013-06-19T15:38:15,81 [ ARIS Server is down ]
2013-06-19T15:38:15,81
2013-06-19T15:43:23,995
2013-06-19T15:43:23,995 ARIS Server
2013-06-19T15:43:23,995 (c) 2013 Software AG
2013-06-19T15:43:23,995
2013-06-19T15:43:23,995
2013-06-19T15:43:23,995 [ ARIS Server Startup process ]
2013-06-19T15:43:23,995
2013-06-19T15:43:24,11 supported oem profile: ARIS
2013-06-19T15:43:24,11
2013-06-19T15:43:24,11
2013-06-19T15:43:24,182 Started profile Agent@16073
2013-06-19T15:43:24,182
2013-06-19T15:43:24,198 Starting ARIS Admin Agent 7.2.3.654794(7.1.0.654794)(Agent)
2013-06-19T15:43:24,260 [ARIS Agent] 19.06.2013 15:43:24 Starting ARIS Server Site ...
2013-06-19T15:43:50,807 [ARIS Agent] registering Agent@CASTOR ...
2013-06-19T15:43:50,901
2013-06-19T15:43:50,901 [ Press Ctrl-C to shutdown server ]
2013-06-19T15:43:50,901
2013-06-19T15:43:50,901 [ ARIS Server is running ]
2013-06-19T15:43:50,901

When we start the service manual it keeps on running. Nothing is changed and now it keeps on running.

Anyone any sugestions?

 

by André Vitor Oliveira
Posted on Wed, 06/19/2013 - 16:52

Hi,

This log file doesn't show anything...



Check if the lockservice is configured correct to use Oracle

Program files\Server\Config\lockservice.cfg

BR,

 

0
by Kees Hoogenboezem Author
Posted on Thu, 06/20/2013 - 08:35

Yeah, I checked it and think it is alright.

For me all the settings looks fine.

#D:\ARIS7.2\server\config\Lockservice.cfg.bak
#Wed Jun 19 15:43:49 CEST 2013
url=jdbc\:oracle\:thin\:@oyama.hhs.nl\:1521\:aristest
startdb=yes
ls.mappingclass=com.idsscheer.dl.mapimpl.ora.AMapping
dl.mappingclass=com.idsscheer.dl.mapimpl.ora.dl.AMapping
arisadm_user=aris71
db.startup.maxwait=180000
dbms_major_version=11
arisadm_schema=aris71adm
pwderrcode=e;1017
dbadmin_pwd=95c6c8fc5f7af626b7b87630d1094ce1
lssid=23
arisadm_pwd=cf5062b3e1da3b92e6a52bfd63bffdba
dbmsname=Oracle
driver=oracle.jdbc.OracleDriver
0
by Rui Santos
Posted on Thu, 06/20/2013 - 12:05

Hi

You can check the exception when the connection is attempted on internalerr0.log.

Regards

Rui

0
by André Vitor Oliveira
Posted on Thu, 06/20/2013 - 16:05

Hi Kees,

You are using the complete name of Oracle server as "oyama.hhs.nl" you could change for IP Address of Oracle server and also check if the DBA changed the password of "aris71" user which is used by application to login on the Oracle BD. If DBA changed the password on the Oracle he also have to set the same password on the Lockservice.cfg ..

Also copy the internalerr0.log here as our friend said and we will know better whats happen...



BR,

0
by Kees Hoogenboezem Author
Posted on Fri, 06/21/2013 - 14:56

Hi,

Thanx, yes i see "There is already an instance of the lockservice running". The complete errorlog is at the botom.

Were are running on VMware and it looks to me that the machine is going very fast down and the lockservice isn't properly closed.

I will do some tests to check it.

@ Andre: I don't think it is the passwd or server name because when I start the service manual (with the same config file) it keeps on running.

Thanks for the reply's,

 

Best regards,

Kees Hoogenboezem

2013-06-19T15:31:29,117 com.idsscheer.aris.server.Exceptions - Launch failed!
com.idsscheer.aris.server.launcher.AArisLauncher.trystart
com.idsscheer.aris.server.common.launch.AFatalLaunchableInitException: Launch of ARIS Lockservice failed!
    at com.idsscheer.aris.server.launcher.AArisLaunchable.startup(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.startService(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.startServices(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.launchAll(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.trystart(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.startup(Unknown Source)
    at com.idsscheer.aris.server.launcher.AArisLauncher.main(Unknown Source)
    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 com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.lang.RuntimeException: There is already an instance of the lockservice running
    at com.idsscheer.aris.server.launcher.ARemoteLockServiceLaunchable$ALaunchableImpl.startup(Unknown Source)
    ... 13 more
Caused by: com.idsscheer.dl.ls.core.AFatalInitException: There is already an instance of the lockservice running
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager.<init>(AORADatabaseManager.java:255)
    at com.idsscheer.dl.mapimpl.ora.AMapping.createDatabaseManager(AMapping.java:62)
    at com.idsscheer.dl.ls.core.logic.ALockServiceFactoryInternal.createLockService(ALockServiceFactoryInternal.java:73)
    at com.idsscheer.dl.ls.core.ALockServiceFactory.createLockService(ALockServiceFactory.java:23)
    ... 14 more
Caused by: com.idsscheer.dl.ls.core.ALockServiceAlreadyRunningException: There is already an instance of the lockservice running
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager$AORAValidDatabaseManager.<init>(AORADatabaseManager.java:93)
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager.changeStateToValid(AORADatabaseManager.java:302)
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager.<init>(AORADatabaseManager.java:252)
    ... 17 more
Caused by: java.sql.SQLException: ORA-00054: De resource is bezet. Ophalen met NOWAIT is verlopen of de time-out is verlopen.

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager$AORAValidDatabaseManager.lockDummyTable(AORADatabaseManager.java:212)
    at com.idsscheer.dl.mapimpl.ora.ls.AORADatabaseManager$AORAValidDatabaseManager.<init>(AORADatabaseManager.java:74)
    ... 19 more


0
by André Vitor Oliveira
Posted on Fri, 06/21/2013 - 16:45

Hi Kees,

Thanks for info...



I saw the error in Log :

ORA-00054:

resource busy and acquire with NOWAIT specified
Cause: Resource interested is busy.
Action: Retry if necessary.

Try to do the step below:

 1- Stop the ARIS server

 2- Stop the instance which ARIS is using on the Oracle 

 3- Start the instance again on the Oracle

 4- Start the ARIS server

Try to do the tests again and see if the service keep running..

The steps above will close any busy resource in Oracle DB and ARIS will reconnect on the instance again..



Let me know the results



BR,

0
by Kees Hoogenboezem Author
Posted on Mon, 06/24/2013 - 15:09

Hi,

Andre thanks for your response ...

Last Friday I did some more tests and yes when the serer reboots not all the database sessions are closed. Mostly two (sometimes more) sessions keep existing in de db-server.

The result is that ARIS Busines Server can't start. When you wait for about 10-15 min. then the service wil start.

Starting the sevice direct after the failure can result in a mess, and then the only solution is stop/start apllication/database instance (as you suggested).

When you stop/start the service manual all works fine (all sessions are closed).

 

So it looks like a reboot of the VMware server (MS-Windows) is too fast so the ARIS application can't close all the database sessions.

Does anybody knows a solution for this problem?

0
by André Vitor Oliveira
Posted on Tue, 06/25/2013 - 14:16

Hi Kees, thanks for info...

In particular I don't know what exactly caused this behavior, but is probably that ARIS lost a connection with DB server and reconnected in short time because some resources keep running on the DB server...

Also you could check why Oracle got the ORA00054 error, and if there is a info to avoid this  error...



If anybody here in community knows could help ..



BR



 

0
by Jayshree Asutkar
Posted on Tue, 05/21/2019 - 11:57

Hi,

I am facing same issue as that of Kees. Can anyone provide me the correct solution over it?

0
by Gerald Klein
Posted on Tue, 05/21/2019 - 13:47

Hi Jayshree,

you can workaround this issue on startup of ARIS 7.2 Business Server by adding the following line to your Lockservice.cfg file:

 

dbmslock=no

 

Cheers

Gerald

 

0
by Jayshree Asutkar
Posted on Wed, 05/22/2019 - 14:03

Thanks Gerald for your response... 

But it is not working, still facing the same issue & I have checked with many test cases but no solution yet.

 

0
by André Vitor Oliveira
Posted on Tue, 06/04/2019 - 16:53

In reply to by Jaya

Hi Jayshree, 

Try this configuration to Oracle side :)

Oracle specific:

After a specified time, Oracle sees that the Session doesn't exist any more and deletes it.  After this the ARIS-Server will start again. To solve this Problem please add the following line to your SQLNET.ORA-File. 

     SQLNET.EXPIRE_TIME = 2

If this Line is activated, Oracle checks every 2 Minutes for inactive Sessions and deletes them. After this 2 Minutes the ARIS-Server will start again.

 

BR

AO

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

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