concdr.sh conversion/migration failure

Technote (troubleshooting)


Problem(Abstract)

Unable to convert the syscdr database during an upgrade of IDS

Symptom

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.


Cause

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1677281

Modified date:

2014-06-25

Translate my page

Machine Translation

Content navigation