If you are upgrading the product from a version earlier
than version 7.5.1.1, you must recreate object relationships in the
MAXRELATIONSHIP table that referenced the PLUSPSERVADDR table.
About this task
You must recreate the object relationships to reference the
SERVICEADDRESS table. If you added or modified any object relationships,
you must review their WHERE clauses. Then, if necessary, use the Database
Configuration application to specify the updated table and column
information.
Procedure
- Run this query:
select * from maxrelationship
where parent='PLUSPSERVADDR' or child='PLUSPSERVADDR' or whereclause
like '%PLUSPSERVADDR%' or whereclause like '%pluspservaddr%';
The results of this query list any customized
entries in the MAXRELATIONSHIP table that reference the PLUSPSERVADDR
table or PLUSPSERVADDR database objects.
- Open the Database Configuration application. For each entry
on the results list, update the MAXRELATIONSHIP row with the same
values that references the SERVICEADDRESS table instead of the PLUSPSERVADRR
table.
What to do next
Restore any modified service address fields that are showing
invalid binding errors.