ARIS Community - We Love BPM

PPM Client configuration

Timkne's picture
by Tim Knechtel in PPM posted on 2017-12-15

Dear all,

I have created a new client in Aris PPM with SQL2012 database connection. That was not a problem. Then I configured the data source mgt. - no problem. Then I started the extract from the data source - no problem. After that I wanted to reinitialize the database. But this program caused an error message (see attachment). If I want to start the client via Aris Cloud Control (start PPM01_cs), I also get an error message. The aris PPM01_as can be started - no problem. Does anyone have a guess where the problem could be?

 

Error Log:

I: 12/15/17 09:59:22 [STD] Baue Verbindung von Benutzer PPMUSER01 mit jdbc:sqlserver://arisdb.res.root.corp:1433;selectMethod=cursor;databaseName=PPM01;instanceName=aris auf...
I: 12/15/17 09:59:22 [STD] Process Performance Manager 9.9.0.0.837
I: 12/15/17 09:59:22 [STD] Verwendete Datenbankversion: 11.00.6020.
I: 12/15/17 09:59:22 [STD] Verwendeter JDBC-Treiber: Microsoft JDBC Driver 4.2 for SQL Server (4.2.6420.100).
I: 12/15/17 09:59:22 [STD] Baue Verbindung von Benutzer PPMUSER01 mit jdbc:sqlserver://arisdb.res.root.corp:1433;selectMethod=cursor;databaseName=PPM01;instanceName=aris auf...
I: 12/15/17 09:59:23 [SRV] Der PPM-Server des Mandanten "ppm01" ist nicht an der Registry angemeldet.
I: 12/15/17 09:59:23 [STD] Initialisiere ARIS PPM-Datenbank...
I: 12/15/17 09:59:23 [STD] Initialisieren: com.idsscheer.ppm.server.common.impl.ZInitDbBase
E: 12/15/17 09:59:23 [STD] Fehler beim Initialisieren der Datenbank
    General PPM-Exception
    Create Table: AS_TA_ID_TBL (3000) [2714/S0001]
    There is already an object named 'AS_TA_ID_TBL' in the database.    [com.microsoft.sqlserver.jdbc.SQLServerException]
S: 12/15/17 09:59:23 [STD] Meldungen der Komponente "STD":
S: 12/15/17 09:59:23 [STD]     1 Fehler
 

 

991 Views
1 Like
3 Comments
Sorry there are no tags
Rune Becker posted on 2017-12-15

Maybe you tried to initialize the PPM database twice but didn't set the overwrite flag!?

Cheers
Rune

Tim Knechtel posted on 2017-12-20

Hi Rune,

Thanks for your answer, no the flag is set. That's not the problem.

Rune Becker posted on 2017-12-20

And did you check the log files?

C:\SoftwareAG\ppm\server\bin\work\work_PPM01_cs\defaultLog\PPM01_cs_system.out.log
C:\SoftwareAG\ppm\server\bin\work\data_ppm\custom\PPM01\log

In general, I always avoid uppercase PPM client names, but I can't tell whether that's a must. but referring to the PPM example umg_en/umg_de, you won't find uppercase except maybe the database user names/logins/schemas.

Cheers
Rune