on 12-07-2012 10:58 AM
Hello Ancile,
We are moving our 4.5 PP system to a new server.
We moved the glossary and server (MS sqlsserver 2008R2) databases via backup restore and performed a new installation of the PP software pointing it to the existing databases.
During the vignette install it errors out during the DB upgrade which allows us to continue but causes a version mismatch error during the uperform installation.
Extract form the collaboration install logfile:
(Dec 7, 2012 9:45:54 AM), Install, java.lang.Class, msg1, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:54 INFO (Schema) [com.vignette.tableinstaller.schema.Schema] started: reading schema from D:\uPerform\Vignette\Collaboration\DBSetup\scripts\CreateDatabaseRequiredObjectsMSSQL.xml
(Dec 7, 2012 9:45:54 AM), Install, java.lang.Class, msg1, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:54 INFO (Schema) [com.vignette.tableinstaller.schema.Schema] finished: reading schema from D:\uPerform\Vignette\Collaboration\DBSetup\scripts\CreateDatabaseRequiredObjectsMSSQL.xml
(Dec 7, 2012 9:45:55 AM), Install, java.lang.Class, msg1, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:55 INFO (ConnectionFactory) [com.vignette.tableinstaller.sql.ConnectionFactory] started: connecting to database at jdbc:vignette:sqlserver://<server>:1433;databasename=uPerformServer
(Dec 7, 2012 9:45:55 AM), Install, java.lang.Class, msg1, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:55 INFO (ConnectionFactory) [com.vignette.tableinstaller.sql.ConnectionFactory] finished: connecting to database at jdbc:vignette:sqlserver://<server>:1433;databasename=uPerformServer
(Dec 7, 2012 9:45:55 AM), Install, java.lang.Class, msg1, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:55 INFO (ConnectProps) [com.vignette.tableinstaller.ConnectProps] started: reading schema version
(Dec 7, 2012 9:45:55 AM), Install, java.lang.Class, err, [## COLLAB INSTALL LOG ##] 07-Dec-2012 09:45:55 ERROR (ConnectProps) [com.vignette.tableinstaller.ConnectProps] FAILED: reading schema version
EXCEPTION: java.sql.SQLException
MSG: Datastore does not appear to contain Portal or Builder or Collaboration tables.
Did we forget something when moving the databases?
What causes this error?
We tried using different SQL accounts but it does not look like a permissions problem.
Sander
Hi Sander,
I have run into the same issue, did you get the issue resolved?
If yes, can you please share the resolution with me?
Kind Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sander,
There was a customer with this error, they weren't using the recommended port 8080. Page 40 of the Admin guide. You would see this in Collab.props file.
When installing, did you use the option "Connect to and create a new Vignette Collaboration Database." or did you use the option for existing?
Regards,
Matthew
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.