A correction to my previous email, my MaxDB version is 7.6.0.16 - sorry.
Regarding the first 2 errors in the log, this is the script for the table:
CREATE TABLE "S_APPLICATION"
(
"APP_ID" Integer NOT NULL,
"APP_ALIAS" Varchar (20) ASCII NOT NULL,
"DESCRIPTION" Varchar (80) ASCII NOT NULL,
"PWD_POLICY" Integer NOT NULL,
PRIMARY KEY ("APP_ID")
)
I don't know why the target data type for columns app_alias and
description would be char, as reported by the loadercli.
Regards,
Martin
On 3/8/06, Martin Cordova <[EMAIL PROTECTED]> wrote:
> Hello: I am trying to move a user from my linux instance to my windows
> instance, using maxdb 7.6.0.12 - I receive this error:
>
> User SECURITY connected to database PROD schema SECURITY on local host.
> TABLELOAD USER
> CATALOG INSTREAM 'C:\servers\maxdb\luis-cat.dat'
> DATA INSTREAM 'C:\servers\maxdb\luis-data.dat'
> Error during execution
> -->-25801
> Internal error [vls28_TLoad.cpp, 1450, -25342]; contact technical support
>
> Here is the loadercli log:
>
> // 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 2006030800080425
> // *
> // *
> // *
> // M START 20060308 00080425
> // *
> SET
> // *
> // M START 20060308 00080425
> // *
> USE USER "SECURITY" * SCHEMA SECURITY SERVERDB "PROD"
> // *
> // M USER: 'SECURITY' on DB: 'PROD' ISOLATION LEVEL: 3
> // *
> // M START 20060308 00080425
> // *
> TABLELOAD USER
> CATALOG INSTREAM 'C:\servers\maxdb\luis-cat.dat'
> DATA INSTREAM 'C:\servers\maxdb\luis-data.dat'
> // *
> // M EXECUTE PACKAGE TO TRANSFORM CATALOG
> // *
> // M IMPORT PACKAGE x'0100000049591FFAFC010000CF7700008954CA324DC3F025'
> // *
> // M Number of TABLES transformed : 13
> // *
> // M EXECUTE PACKAGE TO TRANSFORM DATA
> // *
> // M Number of TABLES to transform: 13
> // *
> // E -25345: Schemes of source and target table S_APPLICATION do not
> match; data type of APP_ALIAS: target = char asc, source = varchar
> asc.
> // E -25345: Schemes of source and target table S_APPLICATION do not
> match; data type of DESCRIPTION: target = char asc, source = varchar
> asc.
> // E -25342: Error restoring table S_APPLICATION; 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\luis-cat.dat0001':
> wrong file or device name.
>
> Regarding the last error, in fact I do not have a file named
> luis-cat.dat0001, that file is named luis-cat.dat
>
> Regarding the other errors, I don't understand them, the user name in
> the target instance is identical to the user name in the source
> instance.
>
> I already played with column_compression without results.
>
> Regards,
> Martin
> --
> Dinamica - RADical J2EE framework
> open source, easy and powerful
> http://www.martincordova.com
>
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
