AW: Loadercli "Unexpected token" - Re: Loadercli

Hi David, Stefan,

David Brady [mailto:maxdb@xxxxxxxxxxx] wrote:
> 
> 
> 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.
> 
Which Loader (version) did you use to do what? The version 7.5.00.08 to
extract the catalog/data and 7.5.00.23 to load the catalog/data?
Would it be possible for you to use the newest Loader for both tasks.

> 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","F
> ILE","?","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?
> 
Would it be possible for one (or both) of you to provide me with
the catalog and the data files to check? I have no idea at the moment
whats going wrong here.
The file you posted the content of is the 'mapping' file. It contains
the information about the position of the data for every single table
in file with extension 0001 (the realdata file). It is UTF8 encoded (the
first 3 question marks) and should not make any problems. Normally.
The Loader uses the content of this file to update a Loader system table
(TRANSFORMATIONMODEL) at the beginning of the load. May be this fails. 
Syntax errors occur only while parsing commands (normally, again) so the
UPDATE command might be wrong built. To check this I need the files if
ever possible.

Sorry for any inconvenience so far.
Regards,
 Steffen
-- 
Steffen Schildberg
MaxDB Team
SAP Labs Berlin 

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