Loadercli

Hello,

I am doing a:
CATALOGEXTRACT USER OUTSTREAM FILE 'license_db_schema'
//
TABLEEXTRACT USER DATA OUTSTREAM FILE 'license_db_data' RECORDS

on a 7.5.00.08 server.

Looking at the license_db_schema I get a duplicate DEFAULT specification 
for all key fields with option SERIAL(1) e.g.:

CREATE TABLE "ACTIVATIONS"
(
        "ACTIVATIONID"               Integer    NOT NULL    DEFAULT 
DEFAULT SERIAL (1),
 ...

I am then doing a:
loadercli -d DB -u user,pass -b license_db_schema

on a 7.5.0.23 server, having removed the duplicate DEFAULT from the 
file. This works ok and the schema is created correctly.

Afterwards I try to load the table data again doing:

loadercli -d LICENSE -u dba,felix2003 -b license_db_dataload

with license_db_dataload containing:

TABLELOAD USER DATA
 INSTREAM FILE 'license_db_data' RECORDS

... and the loader crashes with a segmentation fault.

Looking at loader.prt I see:

USE USER "DBA" * SERVERDB "LICENSE"
// *
// M    USER:   'DBA'   on DB:  'LICENSE'       ISOLATION LEVEL: 3
// *
// M    START   20050127        00182549
// *
TABLELOAD USER DATA
 INSTREAM FILE 'license_db_data' RECORDS
// *
// M    LOAD TRANSFORMATIONPACKAGE 
x'010000001D24F941A9440000A76D3E1000027F0000000000'
// *
// M    EXECUTE PACKAGE TO TRANSFORM DATA
// *
// M    Number of tables   to transform: 6
// *
// E -25281:    Syntax error at position 2 (Unexpected token: "DBA"); 
check for typing errors

... when I look in license_db_data0000 I see:

"DBA","ACTIVATIONS","1","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","0","0","334666","0","333642"
"DBA","USER_ROLES","2","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","334666","0","336763","0","335739"
"DBA","PRODUCTS","3","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","336763","0","340375","0","339351"
"DBA","USERS","4","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","340375","0","343038","0","342014"
"DBA","LICENSES","5","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","343038","0","1527003","0","1525979"
"DBA","USERSFORPRODUCTS","6","?","?","?","?","license_db_data0001","FILE","?","RECORDS","ASCII","0","1527003","0","1529335","0","1528311"

Any idea what is going wrong or how I should import/export the data and 
schema?

--
Stefan Schmidt
GiveMePower/Felix Support and Development
+49 30 89690350

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx