Missing table entry in TADIR

[nanda_kumar21]

Hi,

We have ERP 6.0 EHP 6.

Recently we refreshed our SBX system from our Dev system backup.

Our finance team tried to use the tcode XD01, and they immediately got the below dump:

Our developer further investigated and mentioned that his objects are missing entry in the table TADIR.

Can someone help understand what might have caused this, and how to fix it?

Another thing I noticed is that the total number of entries of the same table do not match between the source and target systems.

We reviewed our refresh procedure, the DB restore did not have issues, the steps we performed didn't have anything to do with this table.

After the refresh, we applied a HR support pack (which is still in "Perform adjustments" state) and kernel upgrade, but I don't think they had anything to do with this issue.

The object exists in the system, however it is missing the entry in the TADIR.

FYI, this is not a local object, this object has been released and being tested in QA.

Also, there is an entry for it in the Source (dev) system, but not in the target system(sbx) after refresh.

thanks

Nanda

[Sriram2009]

Hi Nanda.

After system refresh from QAS to sandbox system post installation activities are completed?

Regards

SS

[hendrikweise]

Dear Nanda,

what Netweaver basis is your system and please give a short overview about how you did the refresh,
e.g. Refresh to an existent target system using R3load based export/import...

Hendrik

[Matt_Fraser]

Hi Nanda,

I added some additional secondary tags to your question ("SL Toolset System Provisioning" and "Software Logistics"), as this is almost certainly related to the system refresh you performed. As others have commented, please provide more details about what method of system copy you used.

Cheers,
Matt

[nanda_kumar21]

We used the database backup/restore method.

There was no error during the DB restore.

I sent the SWPM logs to SAP as well, there were no errors.

We imported only the users back, so there was no other client copy activity.

[nanda_kumar21 · Accepted solution]

I found the root cause for the missing TADIR entries.

One of the export scripts for IDOCS has TADIR table included in it, and we were importing it back as part of post refresh.

Removed the entry to fix the problem.

thanks

Nanda

[hendrikweise]

Hello Nanda,

can you please tell me the incident number? I will have a look into this case.


Hendrik

[nanda_kumar21]

Here you go - *****

I want to add that since we were falling behind a POC project, we are re-refreshing the system again, as I type this.

We are also monitoring the the number of table entries in TADIR as we do each post refresh step.

I'll update if we find anything tangible.

One gripe I have now, is that I used to get mail notifications for the threads I participate/watch (this was default, I didn't have to setup anything). However I didn't receive any mails whatsoever for these many replies.

thanks

Nanda

[Matt_Fraser]

Nanda, you aren't alone in wishing for email notifications, and the community development team are working on that. There is a project in beta right now for this, so hopefully it will be rolled out to everyone soon. There is mention of this as coming soon in the FAQ page about notifications at http://www.sap.com/community/about/support/known-issues.faq.html. You'll also see this as the first item listed for coming soon at https://blogs.sap.com/2016/12/12/2016-wrap-up-looking-forward-to-the-new-year/. It was supposed to have been rolled out by the end of January, so my guess is that it will be pretty soon.

Cheers,
Matt

[hendrikweise]

Nanda,

sorry for my late reaction, I loose track too because of how this works or not works with suitable notification/tracking here. I see you have found the cause and that your incident ******/2017 is in process by Development colleagues.

Hendrik

[ErvinSzolke]

according to point 12 of

https://www.sap.com/community/about/rules-of-engagement.html

I am masking out the references to incident numbers. 😉

[ErvinSzolke]

Hi Hendrik,

please use Direct Messaging (messages.sap.com) for exchanging such information.

Thank you!

Ervin

[JPReyes]

Hi Nanda,

Without knowing what method was used for the refresh we are just speculating.... In a standard backup/restore you should not be missing any entries in any tables, sounds to me like someone is calling a client export/import a refresh which it is wrong.

Regards, JP

[nanda_kumar21]

We used backup/restore, that is why we are flabbergasted because there were no errors in any of the steps.

We sent the logs to SAP as well, and they mentioned that there were no errors in SWPM logs.

thanks

Nanda

[matt]

Try editing/recreating the enhancement.

[Sandra_Rossi]

Probably the backup of the development system was done at a time an object was missing or something like that.

Simply ask your developer to transport missing objects.

[nanda_kumar21]

It was not just 1 entry, nearly 13k entries are missing.