Hi Claudia, Claudia Henkel [mailto:[EMAIL PROTECTED] wrote: > > it sounds so easy.... > Hmm, actually it SHOULD be easy ;-)
> For two weeks, I try to transfer data from one > database-server (Version > 7.4.3.10) to another (Version 7.4.3.10 too). > Do you see any chance I could force/urge you to use a Loader of a higher/ the newest version? You don't upgrade the whole database software but only the loader: just replace repmcli with loadercli and lserver with the newer lserver and set the appropriate rights. BTW loadercli and repmcli are the same programs with different names where the first was invented to better reflect the relation to the fact that's one client of the Loader. > Whatever I try, TABLOLOAD stops loading during execution, it > loads just the half of my database. > [snipped step 1 and 2] > 3. Step: Load Data To Destination Database (repmlci) > ================================================ > repmcli -d testDB -u dba,dba -b load.command > > Where load.command looks like this: > > SET MAXERRORCOUNT 20 > // > CATALOGLOAD ALL INSTREAM FILE 'testDB.ddl' > // > TABLELOAD ALL DATA INSTREAM FILE 'testDB.data0001' > > > 4. Result > ================================================ > Tableload loads correctky the first 14 of 31 tables, then it stops. > This is its output to loader.prt: > > TABLELOAD ALL DATA INSTREAM FILE 'testDB.data0001' > // * > // M Number of tables to transform: 31 > // * > // M Number of views to transform: 0 > // * > // M Number of synonyms to transform: 0 > // * > // M CONFIGURE TRANSFORMATIONPACKAGE > // * > // M EXECUTE PACKAGE TO TRANSFORM DATA > // * > // M Number of tables excluded during extract : 0 > // * > // M Number of tables transformed : 14 > // * > // M UNLOAD TRANSFORMATIONPACKAGE > x'02000000BE98B040DD5A000069DC9702AAF0C0A8FFFFFFFF' > // * > // M Releasing user connection (USER: 'DBA'). > How many testDB.data files do you have? Two (testDB.data0000 and testDB.data0001) or more? Could you please send the output of the following select statement (created with sqlstudio or sqlcli) and the content of testDB.data0000: select * from transformationmodel . 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]
