Hi, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > Hi > I'm still in trouble. > Well, lets work on it.
> > All tables to be loaded are empty and the error happens. > But the message below does not say anything about -25602? Is this a new error? Ok, lets do it more generally: the Loader uses a system table called TRANSFORMATIONMODEL to process the data when running CATALOGEXTRACT/CATALOGLOAD or TABLEEXTRACT/TABELLOAD commands. In the version you have this table might not get emptied after a successful run of one of the commands. This leads to the problem of multiply generated CREATE TABLE statements when running CATALOGEXTRACT. I'd suppose to do the following if this is possible for you. How long did it take to TABLEEXTRACT the data? There are more than 10 GB of data, right? In your source system 1. delete all entries in <DBA>.TRANSFORMATIONMODEL (every user should have access to this table granted; done during installation) 2. run CATALOGEXTRACT USER again 3. do point 1. again 4. run TABLEEXTRACT USER again In your target system (am I right that you build the user anew - which means you could drop the user?): 1. delete all entries in <DBA>.TRANSFORMATIONMODEL 2. drop the user <name> 3. run CATALOGLOAD USER with the file created in procedure above 4. do point 1. again 5. run TABLELOAD USER again 6. see what happens and mail me directly Let me know if something is unclear or not understandable. > This is part of loader.prt: > > tableload user data instream file 'prod0001' > // * [snipped some uninteresting Loader output] > // E -25364: Names of table to load (PMCATEGORIES) and > currently processing table in data file (PMTEMPLATES) do not match > // E -25801: Internal error [vls28_TLoad.cpp, 2554, > -25364]; contact technical support > // M UNLOAD TRANSFORMATIONPACKAGE > x'01000000012DF13F6F2600007678437A00017F0000000000' > > There are two files unloaded ---- prod0001 and prod0002. > Is there a file prod, too? I would have expected 2 files named prod and prod0001. [snipped size info of generated files] > By the way, CATALOGEXTRACT USER often produces "CREATE TABLE" > twice for one table. > Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
