ARIS Designer Server Installatio Error

Emma Lv on April 18, 2017

Hi,

I installed ARIS 9.6 designer server on windows 2012 r2 server with MS SQL DB. But the installation failed with unexpected error.

In the umc.log and a few other logs under "work" directory, it shows error message:

2017-04-17 08:27:31,951 [ERROR] (ajp-bio-11082-exec-8) LocalAbstractDao$4 - Failed to initialize persistence layer: {}

java.lang.RuntimeException: com.sag.aris.cip.dbsp.CipTenantDistributionException: could not get a db for tenant(leader did not assign): default

Looks like a database issue? Could someone please help me?

Thanks

Emma

Notify Moderator

4 Replies

Runé Becker on April 18, 2017

Dear Emma,

Did you follow the ARIS Server Installation and Administration Guide which requires to initialize your DBMS before running the setup?

As installation failures could have multiple causes, I'd like to recommend to pass your issue to Software AG's Global Support ARIS on our customer portal Empower: https://empower.softwareag.com/eservice.

Besides, ARIS 9.6 is quite old. It had GA mid of 2014. I strongly recommend to use the latest ARIS 9.8 SR7 (as of Dec 2016) or wait until this week ARIS 10.0 becomes available.

Cheers

Rune

Like

Sign in
or register to reply.

Notify Moderator
EL

Emma Lv on April 18, 2017 as Reply to Runé Becker

Rune,

Thanks for replying. Yes i did initialize my DBMS before running the setup. However the error message still points to DB error. "could not get a db for tenant"

Thanks

Emma

Like

Sign in
or register to reply.

Notify Moderator
Amol Patil on April 18, 2017

Hi Emma,

Check the database parameters you passed on to the installation wizard. There must be some wrong value being supplied.

Also on the other hand, try connecting to the MS SQL server using the MS SQL Client installed on ARIS Design Server machine with the ARIS 9 database user.

Regards,

Amol Patil

Like

Sign in
or register to reply.

Notify Moderator
EL

Emma Lv on April 19, 2017 as Reply to Amol Patil

All,

I saw this error in the install logs.  I dont have SQL client installed on ARIS server. But I tried telnet to the DB server and it failed. Will firewall issue cause this kind of error?

4-14-2017 09:59:21   stdout: Executing command "register external service db url="jdbc:sqlserver://server.xxx.com:40005;DatabaseName=ARIS;instance=ARIS_Dev" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" username="ARIS9" password="A123456!" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false removeAbandonedTimeout=600 logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true host="server.xxx.com""

4-14-2017 09:59:21   stderr: line 1:205 no viable alternative at character 'A'

4-14-2017 09:59:21   stderr: line 1:236 no viable alternative at character '!'

4-14-2017 09:59:21   stderr: line 1:425 mismatched character '<EOF>' expecting '"'

4-14-2017 09:59:21   stderr: Error at line 1 of command file C:\Users\FGLSEA~4\AppData\Local\Temp\{9816D278-3FF9-451D-8E9C-F94ABB58B64F}\{2F95F4D6-FE94-40BE-B916-740F46D7B96D}\DbService.pt: Invalid or erroneous command "register external service db url="jdbc:sqlserver://server.xxx.com:40005;DatabaseName=ARIS;instance=ARIS_DEV" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" username="ARIS" password="A12345!" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false removeAbandonedTimeout=600 logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true host="server.xxx.com"": line 1:226 missing EQ at 'A12345!'

Thanks

Emma

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.