Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

dbWalker - @PrimaryServer property not found in UnitySetupParameters

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: dbWalker - @PrimaryServer property not found in UnitySetupPa

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

3 REPLIES
Cisco Employee

Re: dbWalker - @PrimaryServer property not found in UnitySetupPa

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

New Member

Re: dbWalker - @PrimaryServer property not found in UnitySetupPa

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.

Cisco Employee

Re: dbWalker - @PrimaryServer property not found in UnitySetupPa

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

147
Views
0
Helpful
3
Replies
CreatePlease login to create content