Unable to convert the syscdr database during an upgrade of IDS
When migrating to a newer version of IDS utilizing Enterprise Replication, you run the script:
$INFORMIXDIR/etc/conv/concdr.sh to convert the syscdr database to the newer version, but the script fails with something similar to the following:
Converting 'syscdr' database ...
Conversion Stage:Prepare to do conversion
Conversion Stage:Create XtdAttr Table
Conversion Stage:Drop old tables from syscdr
Conversion Stage:Create New Tables - 11.70
statement (grant select on qod_replication_latency_tab to public)
failed;SQL error:(-302) No GRANT option or illegal
option on multi-table view.;ISAM error:(0) .
'syscdr' conversion failed. For details look in $INFORMIXDIR/etc/concdr.out.
The script failed to correctly build the necessary tables and grant the proper permissions because it was ran as user 'root' instead of user 'informix'.
Resolving the problem
Restore the syscdr database from a successful backup and switch to user informix. With the new server in online mode and all replication stopped, re-run the concdr.sh script as user informix.