on 07-15-2014 4:05 PM
Hello,
We are in the process of upgrading from IQ 12.7 to IQ 15.4(GA) using iqunload 15.4.0.6567( GA) utility
When running iqunload in the reload schema phase we get the following error:
The database reload failed with the following error:
***** SQL error: IQ Internal error. Please report this to Sybase IQ support.
-- (db_table.cxx 2446)
This file contains the statement that caused the schema reload failure.
To complete the schema reload, you need to modify your database to avoid generating the statement below.
Once you have modified your database appropriately, re-run the schema reload process.
NOTE: You may want to generate the schema only for the database being reloaded,
and load this schema into an empty database to check for sql errors:
SET OPTION "CORP_MSTR_DES_VIS"."identity_insert"='CORP_MSTR_DES_VIS.DIM_ITEM_CLASS'
Q: Should we switch off the option identity_insert to public before running the command ?
We tried altering th table ans setting default to null for that column but it failed..
Anyway the table looks like this:
CREATE TABLE "CORP_MSTR_DES_VIS"."DIM_ITEM_CLASS" (
"ITEM_CLASS_CD" varchar(255) NOT NULL
,"ITEM_CLASS_DESC" varchar(50) NOT NULL
,"CRM_ITEM_CLASS_ID" unsigned int NOT NULL DEFAULT autoincrement
Thank you
Regards
JMT
Hi,
We solved setting Identity_insert to ' '; for the users which were owners for the tables with a column with auto increment before running iqunload:
set option <user>.identity_insert=' ';
commit;
Thank you
JM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.