Hi David, David Brady [mailto:[EMAIL PROTECTED] wrote: > On our production server, I created an extract of a user's data: > > loadercli>tableextract user data outstream file > 'backup02_25_05_1109318700.data' > > On my local box, I created a new user and reran my sql script > to create the same tables for this user. I then attempted to use > loader to insert the data... > > loadercli>tableload user data instream file > 'backup02_25_05_1109318700.data' > -25801 > Internal error [vls28_TLoad.cpp, 1566, -25342]; contact > technical support > OK > > Log says: > > tableload user data instream file 'backup02_25_05_1109318700.data' > ... > // E -25345: Schemes of source and target table AGREEMENT do not > match; default definitions differ. > // E -25342: Error restoring table AGREEMENT; table exists > but source table schema and target table schema are different > // E -25801: Internal error [vls28_TLoad.cpp, 1566, > -25342]; contact technical support > > Comparing the table definitions on the two boxes show the AGREEMENT > table to be absolutely the same. > Well, how big is the table AGREEMENT? Would it be possible for you to extract this single table and send me directly the data file (if it isn't confidential and not too big) and the sql command you used to create this table on your local box? If yes you should issue the following command (btw what version do you use):
tableextract table AGREEMENT data outstream file 'agreement.data' The comparison routine for default definitions is a simple string comparison. So the Loader could even stop if the count of blanks is not the same in both definitions or they are different in new lines. It wasn't an issue so far but may be we should think about it again. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
