Skip to Content
0
Apr 14, 2010 at 12:10 PM

Loader doesn't import it's own exports, shows -5004 POS(228) Missing const

92 Views

While trying to use loader to export and import I found an issue with one of our test instances. The export is done with

EXPORT DB CATALOG OUTSTREAM 'invocadb_ddl.catalog' DATA OUTSTREAM 'invocadb_pages.data'

now importing it into an empty instance I do

IMPORT DB CATALOG INSTREAM 'invocadb_ddl.catalog' DATA INSTREAM 'invocadb_pages.data'

and it shows this in it's log:

IMPORT DB CATALOG INSTREAM 'invocadb_ddl.catalog' DATA INSTREAM 'invocadb_pages.data'
// *
// M    Execute   PACKAGE  to transform  unlocked CATALOG 
// *
CREATE TABLE "IMAGES"
(
"IMAGEID"  Fixed (19,0)  NOT NULL  DEFAULT                    0,
"IMAGETYPE"  Integer  NOT NULL  DEFAULT           0,
"NAME"  Varchar (64) ASCII  NOT NULL  DEFAULT '0',
"IMAGE"  Blob  NOT NULL  DEFAULT  ,
CONSTRAINT SYSPRIMARYKEY PRIMARY KEY("IMAGEID")
)
// *
// E -25392:    '[SAP AG][LIBSDBOD SO][MaxDB] General error;-5004 POS(228) Missing constant'
// M    Loader    7.7.07   Build 016-121-231-153

What's wrong here? I understand it's the IMAGE Blob which shows a DEFAULT but no value. Is this a bug in the loader or did I miss something?

Thanks,

Simon