Hi again, once again, it's me, and my troubles with the loadercli.
I am using sapdb 7.4.3.27 with a lserver,loadercli v. 7.4.3.31 I got from Hans-Georg Bumes during my last troubles... Task: Migrate data from one User (oikprod) to another (oikotest2). This is how the data is dumped (paths for files may be varying). USE USER "OIKPROD" "*" SERVERDB "TNG1" ON sapdb.tng.de // CATALOGEXTRACT USER OUTSTREAM FILE '/sapdb-prebackup/oikprod/catalog' // TABLEEXTRACT USER DATA OUTSTREAM FILE '/sapdb-prebackup/oikprod/table.' PAGES PACKAGE OUTSTREAM FILE '/sapdb-prebackup/oikprod/table-package.' // Then I change the references to "OIKPROD" to references to "OIKOTEST2" in the files catalog and table.0000, as suggested by Hans-Georg. This is how they are loaded: USE USER "OIKOTEST2" "*" SERVERDB "TNG1" ON sapdb.tng.de // CATALOGLOAD USER INSTREAM FILE '/tmp/imp/catalog' // TABLELOAD USER DATA INSTREAM FILE '/tmp/imp/table.' PAGES PACKAGE OUTSTREAM FILE '/tmp/imp/load-pkg' // This is my loader protocol: // M Loader 7.4.3 Build 031-101-055-005 // * // M Loader instance started at khorne // * // M Starting protocol at 2003112100164837 // * // * // * // M START 20031121 00164837 // * SET // * // M START 20031121 00164837 // * USE USER "OIKOTEST2" * SERVERDB "TNG1" ON sapdb.tng.de // * // M USER: 'OIKOTEST2' on DB: 'TNG1' // * // M START 20031121 00164837 // * CATALOGLOAD USER INSTREAM FILE '/tmp/imp/catalog' // * // M LOAD TRANSFORMATIONPACKAGE x'01000000D533BE3F770A00000D69E07E4399D5B2FFFFFFFF' // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M Number of tables transformed : 56 // * // M Number of views transformed : 6 // * // M Number of synonyms transformed : 0 // * // M UNLOAD TRANSFORMATIONPACKAGE x'01000000D533BE3F770A00000D69E07E4399D5B2FFFFFFFF' // * // M START 20031121 00164837 // * TABLELOAD USER DATA INSTREAM FILE '/tmp/imp/table.' PAGES PACKAGE OUTSTREAM FILE '/tmp/imp/load-pkg' // * // M LOAD TRANSFORMATIONPACKAGE x'02000000D533BE3F770A00000D69E07E4399D5B2FFFFFFFF' // * // M CONFIGURE TRANSFORMATIONPACKAGE // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // M Number of tables to transform: 56 // * // E -25801: Internal error [28_1, 3410, 350]; contact technical support // E -25801: Internal error [28_1, 2974, -25801]; contact technical support // E -25801: Internal error [vls28_TLoad.cpp, 2001, -25801]; contact technical support // M UNLOAD TRANSFORMATIONPACKAGE x'02000000D533BE3F770A00000D69E07E4399D5B2FFFFFFFF' // * The data does not appear to be loaded correctly. Any idea, what the loadercli/lserver wants to tell me? Thanks in Advance, Carsten -- -------------------------------------------------------------------------- Carsten Tolkmit, Geschaeftsfuehrer IT-Solutions | mailto:[EMAIL PROTECTED] TNG - the net generation GmbH | http://www.tng.de Projensdorfer Strasse 324 | Fon: +49 431 7097-470 24106 Kiel, Germany | Fax: +49 431 7097-555 -------------------------------------------------------------------------- -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
