FYI -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 3. August 2005 16:29 To: Bumes, Hans-Georg Subject: RE: Loader Internal error [vls28_TLoad.cpp, 1450, -25342]
Hi Hans-Georg: I used COLUMNCOMPRESSION=NO in both systems (they were set to YES by default), also copied the Loader config file from SRC to TARGET server, then repeated the export/import process and it worked fine. Thanks a lot. Best regards, Martin Cordova > Hi Martin, > > Can you please tell me the version of your source database system? > Please check the database parameter COLUMNCOMPRESSION of your source > system. > If this parameter doesn't exist or is different of the target system > parameter, you have to set > In the target system COLUMNCOMPRESSION to NO or to the value of your > source system. > Drop the 25 empty tables and start the import again. > Please let me know the result. > > Regards > Hans-Georg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 26. Juli 2005 18:13 To: MaxDB MaxDB Subject: Loader Internal error [vls28_TLoad.cpp, 1450, -25342] Hi, I am having trouble trying to import a User's data. I exported it without problem using this script: TABLEEXTRACT USER CATALOG OUTSTREAM 'C:\MAXDB\catalog.dat' DATA OUTSTREAM 'C:\MAXDB\data.dat' It generated the catalog and data files: catalog.dat, data.dat000 and data.dat001 Then tried to import it into another DB instance (same platform and MAXDB version - 7.6.0.10) using this script: TABLELOAD USER CATALOG INSTREAM 'C:\servers\maxdb\catalog.dat' DATA INSTREAM 'C:\servers\maxdb\data.dat' I got this error: User DOCI connected to database PROD schema DOCI on local host. TABLELOAD USER CATALOG INSTREAM 'C:\servers\maxdb\catalog.dat' DATA INSTREAM 'C:\servers\maxdb\data.dat' Error during execution -->-25801 Internal error [vls28_TLoad.cpp, 1450, -25342]; contact technical support 1 error(s) while processing command file 'import-user.txt'. ---> See Loader log file for more information. This is the LOADER.PRT: // M Loader 7.6.00 Build 010-123-096-895 // * // M Module: c:\archivos de programa\sdb\programs\bin\loadercli.exe // * // M Loader instance started at MARTIN for database PROD // * // M Starting protocol at 2005072200113151 // * // * // * // M START 20050722 00113151 // * SET // * // M START 20050722 00113151 // * USE USER "DOCI" * SCHEMA DOCI SERVERDB "PROD" // * // M USER: 'DOCI' on DB: 'PROD' ISOLATION LEVEL: 3 // * // M START 20050722 00113151 // * TABLELOAD USER CATALOG INSTREAM 'C:\servers\maxdb\catalog.dat' DATA INSTREAM 'C:\servers\maxdb\data.dat' // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M IMPORT PACKAGE x'0100000067A2F1F8240F0000C70E000090D31C81410C40AD' // * // M Number of TABLES transformed : 25 // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // M Number of TABLES to transform: 25 // * // E -25345: Schemes of source and target table AUDITLOG do not match; different column sorting of source and target table / source table columns target table columns / AUDITLOG_ID AUDITLOG_ID / EXTRA_INFO EXTRA_INFO / RECORD_ID RECORD_ID / OP_DATE OPERATION / OPERATION TARGET_TABLE / TARGET_TABLE USERLOGIN / USERLOGIN OP_DATE / OP_TIME OP_TIME . // E -25342: Error restoring table AUDITLOG; table exists but source table schema and target table schema are different // E -25801: Internal error [vls28_TLoad.cpp, 1450, -25342]; contact technical support // E -25501: Error opening file 'C:\servers\maxdb\catalog.dat0001': wrong file or device name. I don't know why the order of source and target columns is different. I deleted all rows from this table, and the problem arises again with another table. All the database structure was created, but no data was imported. Any help will be appreciated. Regards, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
