Hi I'm still in trouble. >Hi,
>[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: >> >> I'm in trouble. >> I unload data from one SAPDB to another. >> Both of them : >> VERSION 7.4.3.27 >> _UNICODE YES >> DEFAULT_CODE UNICODE >> >> [EMAIL PROTECTED] sapdb]$ loadercli -n 172.20.9.101 -d prod_des >> -u test,test >> Loader Server Protocol File: >> '/home/sapdb/sapdb/indep_data/wrk/loader.prt' >> >> User TEST connected to database PROD_DES on 172.20.9.101. >> loadercli>tableextract user data outstream 'prod' >> OK >> >> --- >> loadercli>exit >> OK >> >> >> [EMAIL PROTECTED] sapdb]$ loadercli -d prod -u prod,prod >> Loader Server Protocol File: >> '/home/sapdb/sapdb/indep_data/wrk/loader.prt' >> >> User PROD connected to database PROD on local host. >> loadercli>tableload user data instream file 'prod0001' >> -25801 >> Internal error [vls28_TLoad.cpp, 2554, -25602]; contact >> technical support >> OK >> >> >> What can I do? >> >Are there tables in db prod belonging to user prod that are >already filled prior to running the TABLELOAD USER command? If so the >TABLELOAD will fail as one of the preconditions for successful >processing TABLELOAD commands is that the tables to load >are empty. >If all tables to be loaded are empty and the error happens anyway >let me know. >BTW the error message is > - in this case a pain in the a... and will be adapted; sorry for > this inconvenience > - not documented (-25602 means table is filled but tried to TABLELOAD) > which is in turn a pain and will be corrected; sorry for this, too> >Regards, > Steffen >-- >Steffen Schildberg >SAP DB Team >SAP Labs Berlin All tables to be loaded are empty and the error happens. This is part of loader.prt: tableload user data instream file 'prod0001' // * // M LOAD TRANSFORMATIONPACKAGE x'01000000012DF13F6F2600007678437A00017F0000000000' // * // M Number of tables to transform: 60 // * // M Number of views to transform: 0 // * // M Number of synonyms to transform: 0 // * // M CONFIGURE TRANSFORMATIONPACKAGE // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // 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. [EMAIL PROTECTED] sapdb]$ ls -s total 10445628 4 delete 4 insert 72 p.cat 4200 prod0001 10441344 prod0002 4 script_example I tried so many times. I succeeded when the file was very small. By the way, CATALOGEXTRACT USER often produces "CREATE TABLE" twice for one table. Thanks.
