01-15-2009 06:33 AM - edited 03-18-2019 10:18 PM
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.
Solved! Go to Solution.
01-15-2009 08:51 AM
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
01-15-2009 08:51 AM
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
01-15-2009 11:04 AM
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.
01-15-2009 11:07 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide