Re: Loadercli "Unexpected token" - Re: Loadercli

Try using DATALOAD/EXTRACT instead of the CATALOG functions. They work 
fine. The downside is that you will have to run a script for each table.


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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx