From: dbsupport (dbsupportion.ag)
Date: Mon Feb 06 2006 - 10:27:20 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

after changing COLUMNCOMPRESSION=NO this happend while importing the data:

Error during execution
-->-25010
SQL error 100 = Row not found (error position: 92)

Defined maximum number of errors (1) reached

1 error(s) while processing command file 'imp.cmd'.

protocol:

// *
// M Error at record 246 in infile for table "SYSLOADER"."TRANSFORMATIONMODEL".
// E -25010: SQL error 100 = Row not found (error position: 92)

any new ideas ?

> -----Original Message-----
> From: Bumes, Hans-Georg [mailto:hans-georg.bumessap.com]
> Sent: Monday, February 06, 2006 3:52 PM
> To: dbsupport
> Subject: RE: loadercli 7.6 and 7.5
>
>
> Have a look at following item
> http://lists.mysql.com/maxdb/25954
>
>
> -----Original Message-----
> From: dbsupport [mailto:dbsupportion.ag]
> Sent: Montag, 6. Februar 2006 15:44
> To: maxdblists.mysql.com
> Subject: loadercli 7.6 and 7.5
>
> Hi,
>
> i`ve got some problems moving a schema from a maxdb 7.5 to 7.6.
>
> here ist my unloadfile "exp.cmd" :
>
> TABLEEXTRACT
> USER
> CATALOG OUTSTREAM 'all.sql'
> DATA OUTSTREAM 'all.'
>
> the result of: loadercli -d foodb -u foo,foo -b "exp.cmd"
> reports NO ERROR. everthing looks fine.
>
> but loading the data into a new database with the loadercli show this:
>
> loadercli -d newdb -u newusr,newusr -b "imp.cmd"
>
> TABLELOAD
> USER
> CATALOG INSTREAM 'all.sql'
> DATA INSTREAM 'all.'
> Error during execution
> -->-25801
> Internal error [vls28_TLoad.cpp, 1453, -25342]; contact technical
> support
>
> Defined maximum number of errors (1) reached
>
> message in protocolfile is:
>
> // E -25345: Schemes of source and target table FOOTAB do
> not match;
> different column sorting of source and target table
> / source table columns target table columns
> / ... ...
> / ... ...
> // E -25342: Error restoring table FOOTAB; table exists but source
> table schema and target table schema are different
> // E -25801: Internal error [vls28_TLoad.cpp, 1453,
> -25342]; contact
> technical support
>
> any ideas ?! the structure between source and target is different, but
> why and how to get the right structure !?! any workarounds?
>
> --
> Ingo Trapphagen
> IOn Aktiengesellschaft
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=hans-georg.bumessap.com
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]