AW: loader problem... "default definitions differ."

Hi David,

David Brady [mailto:maxdb@xxxxxxxxxxx] 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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx