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.
Yes, I verified this.
Scope/Symptoms: configuration missing
1694:(error) The [email protected]' property could not be found in the
To solve this issue follow the steps below:
Check the correct primary server name under following location,
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.