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]
