EL

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

by Runé Becker
Badge for 'Mastermind' achievement
Posted on Tue, 04/18/2017 - 10:58

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

0
by Emma Lv Author
Posted on Tue, 04/18/2017 - 11:20

In reply to by rbe

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

0
by Amol Patil
Posted on Tue, 04/18/2017 - 14:49

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

0
by Emma Lv Author
Posted on Wed, 04/19/2017 - 03:53

In reply to by Amol

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

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