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
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