cancel
Showing results for 
Search instead for 
Did you mean: 

db error when moving 4.5 to new server

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Matthew,

I'll check the port and we used the option "connect to existing database".

Sander

Former Member
0 Kudos

Hi Matthew,

Just checked the port and it is 8080 according to collabs.props

Any other suggestions?

Sander.

Former Member
0 Kudos

Hi Sander,

Are you using the option "Connect to and create a new Vignette Collaboration Database." or existing database?

Regards,

Matthew

Former Member
0 Kudos

connect to existing.

Former Member
0 Kudos

This is getting a bit more urgent, I will create a support message for this as well.

Former Member
0 Kudos

Hi Sander,

That might be best.Unfortunately I don't have an answer for you. Support will be able to help you out.

Let me know how it turns out.

Best Regards,

Matthew