IBM Support conversion/migration failure

Technote (troubleshooting)


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/ 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 script as user informix.

Document information

More support for: Informix Servers

Software version: 11.5, 11.7, 12.1

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows

Reference #: 1677281

Modified date: 26 June 2014