dbWalker - @PrimaryServer property not found in UnitySetupParameters

Answered Question
Jan 15th, 2009
User Badges:

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


1694:(error) The [email protected]' 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.

Correct Answer by Tray Stoutmeyer about 8 years 4 months ago

Yes, I verified this.


Scope/Symptoms: configuration missing


TroubleShooting Steps/Resolution:


1694:(error) The [email protected]' 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([email protected]', 'servername')

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

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


Tray

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Tray Stoutmeyer Thu, 01/15/2009 - 08:51
User Badges:
  • Cisco Employee,

Yes, I verified this.


Scope/Symptoms: configuration missing


TroubleShooting Steps/Resolution:


1694:(error) The [email protected]' 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([email protected]', '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 Thu, 01/15/2009 - 11:04
User Badges:

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 Thu, 01/15/2009 - 11:07
User Badges:
  • Cisco Employee,

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

Actions

This Discussion