Stefan Schmidt GiveMePower/Felix Support and Development +49 30 89690350
David Brady wrote:
Stefan -
Did you ever get your issue solved? I'm encountering the exact same issues with the exact same version scenario as you - trying to move data from 7.5.00.08 to 7.5.00.23.
I removed the duplicate DEFAULT from the schema, and like you, it worked fine. Then a tableload dies with:
tableload user data instream file '20050325data' records
// *
// M LOAD TRANSFORMATIONPACKAGE x'02000000261A55F8EC09000074400000B786BF3F2404B797'
// *
// M EXECUTE PACKAGE TO TRANSFORM DATA
// *
// M Number of tables to transform: 33
// *
// E -25281: Syntax error at position 2 (Unexpected token: "GLOBAL").
The records file has:
???"GLOBAL","AGREEMENT","1","?","?","?","?","20050325data0001","FILE","?","RECORDS","ASCII","0","0","0","2048","0","1024"
"GLOBAL","CODETABLE","2","?","?","?","?","20050325data0001","FILE","?","RECORDS","ASCII","0","2048","0","5015","0","3991"
"GLOBAL","DEPARTMENT","3","?","?","?","?","20050325data0001","FILE","?","RECORDS","ASCII","0","5015","0","7063","0","6039"
etc...
Anyone from MaxDB lend a hand?
Thanks, David
Stefan Schmidt wrote:
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?
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
