Trouble with iqunload and identity columns

[jmtorres]

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

[jmtorres · Accepted solution]

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

[tayeb_hadjou · Accepted solution]

Hi Jose-Miguel,

This is CR#698374 (Iqunload fails with Invalid table name t1 specified for option 'identity_insert') fixed in upper ESDs.

You are running 15.4 GA. I'd advise install ESD#4 which includes many fixes and enhancements.

Regards,

Tayeb

[jmtorres · Accepted solution]

Thank you Tayeb

Regards

JM