on 03-26-2010 11:09 AM
Hi Sap-experts!
in our system is a gap btw. transport request XZ1K900500 and XZ1K904000!
the requests seem to be deleted or number range was manipulated!
where can I find these missing records ?
there's no track in table E070/1...
greetings
Andreras
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks like you had an upgrade or created new sandbox or something and the range just got reset. Why is that important? I delete my own transport requests that aren't going beyond the development instance anytime I want.
ok, there was an update (SAP ECC 6.0 Enhancement Package 4) in that time:
and that would explain the reset of the number range?
Andreas
Afaik EhP will not reset the number range.
But there are cases where it is recommended to do so manually. Have a look at SAP note 12799. (Quite old, but still relevant!)
You could compare creation date of transports XZ1K900500 and XZ1K904000.
If they are within a few days, I would bet that someone did reset number range deliberately.
regards
it seems to be that the number range was reset (2 times).
But where can I find a log???
is there any log in OS: /usr/sap/trans/log or somewhere else?
thanks for your help
Edited by: Andreas Mann on Mar 26, 2010 2:19 PM
Nothing that I know of...
As SAP note 12799 says, there is no report nor transaction code for it. It must be done by database tools.
So your best bet will be to ask your database admin about it.
ok Joe,
I've checked change documents to se16n - nothing
and analysed several tables in the same package as e070 - but find nothing!
here are some records (with the gaps) from e070
TRKORR AS4DATE XZ1K900021 2010/01/12 XZ1K900022 2009/09/07 XZ1K900023 2009/07/21 XZ1K900024 2009/07/28 XZ1K928326 2010/01/20 XZ1K928332 2010/01/20 XZ1K928333 2010/01/20 XZ1K935163 2009/07/29 XZ1K935164 2010/01/05 XZ1K935165 2010/01/05
I don't understand the interplay of the as4date??
it remains dubious.
thanks again all and have a nice weekend!
Andreas from germany
Edited by: Andreas Mann on Mar 26, 2010 3:09 PM
Not so much ABAP related, there will be more help in forum Netweaver Adminstrator, I'll ask to have the thread moved there (can't do it myself).
Thomas
Check at the [OS Level|http://www.sap-img.com/basis/where-to-find-deleted-transport-request-logs.htm] if the records were deleted.
Hello,
The only place where you can see if transports were deleted is in the actlog directory of your transport directory : /usr/sap/trans/actlog.
If you delete a transport and all its corresponding entries in SAP you will not find any trace in the E07* tables even no changes or change docs.
Only in the actlog directory you will find a trace per transport request.
If you do not find anything in the actlog directory this means that someone has changed the latest number of your transport requests in table E070L.
PS : I hope subdir actlog exists in /usr/sap/trans because during a standard installation sapinst does not create this directory.
Success.
Wim
Not 100% about this but check in SM20 if someone run report RSWBO301
Read the documentation of RSWBO301 in SE38
Regards
Juan
What about version management table VRSD ?
a®
unfortunately not.
thank you for knowing a new and important table!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.