Hello,
I'm an doing the PPM University Edition Customizing tutorial. But I run into a problem:
In excersise 3 I have to Initialize the database (page 48 of the tutorial), but I get an error message:
[SRV] The PPM server of the client "umg_tutorial" is not registered in the registy.
It won't initilize the database so I can't continue with the next step.
How can I solve this problem?
Thank you very much in advance!
Hi Kai-Hendrik,
Yes MS SQL is running.
I get the folowing error when I run the program " Initialize database" :
I: 03/02/14 21:58:13 [SRV] The PPM server of the client "umg_tutorial" is not registered at the registry.
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\activate_attributes.properties
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\activate_ki.properties
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\activate_merge.properties
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\activate_ptree.properties
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\Initdb_settings.properties
C:\SoftwareAG\PPM51\custom\umg_tutorial\config\InitSystem_settings.properties
6 file(s) copied.
runinitdb ...
I: 03/02/14 21:58:15 [SRV] The PPM server of the client "umg_tutorial" is not registered at the registry.
done
Errors occurred. Watch out messages and log file initdb_20140302_0958.log.
This is the " initdb_20140302_0958.log":
W: 03/02/14 21:58:15 [STD] The key "UMC_URL" was not found in the settings file "Server_settings.properties". The default value "" will be used. I: 03/02/14 21:58:15 [STD] Connecting user UMG_TUTORIAL with jdbc:sqlserver://aep-ppm:1433;selectMethod=cursor;databaseName=UMG_TUTORIAL... I: 03/02/14 21:58:16 [STD] Database version used: 10.50.1600. I: 03/02/14 21:58:16 [STD] JDBC driver used: Microsoft SQL Server JDBC Driver 2.0 (2.0.1803.100). I: 03/02/14 21:58:16 [STD] Connecting user UMG_TUTORIAL with jdbc:sqlserver://aep-ppm:1433;selectMethod=cursor;databaseName=UMG_TUTORIAL... E: 03/02/14 21:58:24 [STD] The database schema is not empty. Either use the "-overwrite" parameter or delete all database objects manually. S: 03/02/14 21:58:24 [STD] Messages of component "STD": S: 03/02/14 21:58:24 [STD] 1 warning(s) S: 03/02/14 21:58:24 [STD] 1 error(s)
Thanks for you help in advance.
Cheers,
Luuk
Hey Luuk,
have you tried the advice in line 6 of your "initdb_20140302_0958.log"?
Best Regards
Kai-Hendrik
Hi Kai-Hendrik,
No I haven't tried that yet because I don't really know what is meant by "delete all database objects". What objects will be deleted when I use the "-overwrite" parameter?
Thanks for you help in advance.
Cheers,
Luuk
Hey Luuk,
there is a hint in Exercise 3, which explains the attribute.
Cheers
Kai-Hendrik
Hi Kai-Hendrik,
It works!
Thanks for your help!
Cheers,
Luuk
Kai-Hendrik Pots on
Hey Luuk,
Is the MS SQL running ?
Which configuration did you used as "Server settings"?
The log-file would also help.
Cheers
Kai-Hendrik