Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Export/Import from 7.5 to 7.6 and COLUMNCOMPRESSION

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question