'key contains unsortable types' when importing client?

[former_member504446]

Hello gurus,

while doing a client copy, during the import for some tables we get the message:

'full scan in 4134406 entries because binary search is not possible for this table because key contains unsortable types, this may result in loss of performance'

In deed, the performance while writing those tables is REALLY bad.

Does anyone know what exactly might be wrong with those tables (all of them are Z-tables)?

We checked the export-logs, too and for those tables there are entries like

'3WETW000 scrap char 0x00 found in ZTABLE04.TXZ01, it will be coerced to ' ' automatically'

Could this have anything to do with the low performance at import?

Thanks

Alicia

[former_member504446]

Ok, thank you to both of you.

We will try this next time.

Regards

Alicia

[Former Member]

Turning off DB archive log before client copy (and turning on after) is another thing you should consider doing. I had DB errors once when i forgot to do this, but when turning this off and had no errors.

[former_member128291]

Hi Alicia,

This issue is usually caused by bad Oracle (DB) performance.

Before Client Copy SAP strongly recommends to update the ORA statistics

and optimize the DB performance.

It is also recommended to delete the target client before starting

the import of the source client.

Kindly also check that you are using the latest kernel, specially the latest patch level of tp and R3trans.

This small bit of recommendation should help you out.

Regards,

Abhishek

[former_member452752]

Hello,

Same issue here.

During a client-copy we get this message :

"ETW000 full scan in 3389873 entries because binary search is not possible for this table because key contains unsortable types, this may result in loss of performance".

Thanks for help !