on 11-06-2007 8:37 AM
Hi,
I'm doing client refresh trough export/import.
During the import, after the half way through, it stucks with the below messages
4 ETW000 format : 'P' 'P'
4 ETW000 len : 007 005 (bytes)
4 ETW000 offset : 758 750 (bytes)
4 ETW000 table BKPF: entry in DB is 10 bytes bigger than in file.
4 ETW000 ... ignoring such differences.
3WETW019 No memory for space allocation left ("1673500000").
4 ETW000 twrtab reached memory limit; memory usage 1673000000
4 ETW000 Syslog: k CQ3 : UMGSETTING&
rscpexcc 12
4 ETW000 GetDBMigrateCodePagesLangs uses TCP0D, TCPDB, TCP0C.
Also, the undo segment space usage is very high. It has already reached
close to 7GB.
Found the below sap notes, but are not useful
Note 103562 - R3trans: 'twrtab memory limit reached' then term.
Note 103582 - Doc.: Transfer of R3trans options with tp
Our server is Suse linux 32 bit with sap 640 + oracle 9206
Please advice
Regards
Jagadeesh
I added a 2GB of additional space to rollback segment tablespace, but still fails with the same error. Now there is more that 1.8GB of space free.
I believe it is doing a large delete/insert and commits at the end of the transaction.Otherwese there should be some options available with tp import command to specify the memory and commits.
Your expert advise will be greatly appreciated.
Regards
Jagadeesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Juan,
We have another CRM instance running on the same instance, but it was taken off during the import. Also, i notice a very amount of rollback segment usage during the same process.I almost added around 7GB of space to it, but still it fails. Will adding the additional space to rollback segment will help in this regard as it is almost been used.
Regards
Jagadeesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jagadeesh,
As far as i can see this is related to either space or memory during the import... check that your system has enough resources... if you have a system running during the import it might be better to do it while the system is offline, also double check that you have enough disk space left...
Also, try updating R3trans
Regards
Juan
Please reward with points if helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.