Skip to Content
0
Former Member
Dec 05, 2008 at 07:39 AM

Export/Import from 7.5 to 7.6 and COLUMNCOMPRESSION

86 Views

Hello,

I exported a content server on MaxDB 7.5, Win 32 bit, and am trying to import it to MaxDB 7.6, Win 64 bit, both with loadercli 7.6.

I am getting this error in loader.log:

// E -25345: Definitions of source and target table COMPONENTS0001 do not match;

// length type of column "NAME": source = variable length long, target = variable length

// Make sure that the database parameter COLUMNCOMPRESSION has got the same value in the source and target databases.

// If the source database version is < 7.6 and the target database version is >= 7.6, the parameter COLUMNCOMPRESSION must be set to NO in the target database..

// E -25342: Error restoring table COMPONENTS0001; table exists but source table schema and target table schema are different

However COLUMNCOMPRESSION is set to NO;

I tried restarting the system, I also tried dropping and recreating user SAPR3 in the target system, in order to switch DEFAULTCODE from ASCII to DEFAULT, as in the source system, but the same result.

_UNICODE is YES on both systems.

What could be wrong here?

regards