Hi David, Stefan, David Brady [mailto:[EMAIL PROTECTED] 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/[EMAIL PROTECTED]
