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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > Sent: Montag, 6. Februar 2006 15:44 > To: maxdb@lists.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/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
