dbWalker - @PrimaryServer property not found in UnitySetupParameters

[kc-ussugar]

dbWalker in prep for upgrade from 4.0.5 to 5.0.1 gets following message:

1694:(error) The '@PrimaryServer' property could not be found in the 'UnitySetupParameters' table. This can cause problems if you try to upgrade this system to a newer version of Unity. Please contact TAC.

Primary server name found = [the correct current servername]

SchemaMajorVersion = [ 3]

SchemaMinorVersion = [ 17]

Checking LastModifiedTime column for all entries in the Configuration table

In reading some similar posts (but none running dbWalker), it appears the workaround is as follows:

Open SQL Enterprise Manager > Databases > UnityDB > UnitySetupParameter.

Right click and return all rows.

Go to the bottom of table.

Under Name column enter: @PrimaryServer

Under Value column enter: Name of Unity server.

Can someone confirm or deny? Thanks.

[Tray Stoutmeyer · Accepted solution]

Yes, I verified this.

Scope/Symptoms: configuration missing

TroubleShooting Steps/Resolution:

1694:(error) The '@PrimaryServer' property could not be found in the

'UnitySetupParameters' table.

To solve this issue follow the steps below:

Check the correct primary server name under following location,

HKEY_LOCAL_MACHINE\Software\ActiveVoice\Commserver\1.0\PrimaryServer,

Find the key populated with right servername.

You can run following SQL query to insert the Unity server name in

UnitySetupParameters using query analyzer ;

INSERT INTO UnitySetupParameters (Name,

[Value])VALUES('@PrimaryServer', 'servername')

Where 'servername' is the primaryserver name of the unity server.

Then run the dbwalker and see if you get the same error.

Tray

[kc-ussugar]

Thanks, Tray. That confirmed the source of the error.

Query Analyzer was not installed on the machine, so I manually entered the record as detailed in the original post, and that made dbWalker happy.

[Tray Stoutmeyer]

Yep that should also take care of it. The analyzer just does it via script so you don't have to manually do it. Glad I could help. Please rate if it fixed your issue.

Thanks!

Tray