SAP BASIS USERDETAILS disappeared SP9 & SYNTAX_ERROR in SAP generated code

[Former Member]

Hi everyone,

We are experimenting issues after SP9 upgrade on our development system :

- DO USERDETAILS and AGENT_CONFIG disappeared from the SWCV SAP BASIS 7.10 in SDOE_WB.

They are both flagged as deleted in the standard table SMMW_HDR.

- We have syntax errors in sap generated code :

Classe ZDOECL_009_000_1_BW,Méthode SEND_UPDATE_TO_BACKEND

Between "WITH" and "KEY", "TABLE" is missing be interpreted. Blanks may

be missing. (see HELP COMPUTE).

Is there any chance somebody would have an idea of what we can try?

Thank you

[Former Member]

Copy the MBO_ID for both the DOs and do a search in E071 table with the following filter in SE16:

PGMID = 'R3TR'

OBJECT = 'MMBO'

OBJ_NAME = <MBO_ID>* <- i.e. Object name starts with <MBO_ID>

1. What results do you get?

2. What is the value of OBJFUNC here?

3. What are the values of TRKORR? Look at the Transport Logs of these TRs. Especially the logs in the 'Import' and 'Method Execution' steps.

[Former Member]

Another thing: Get the entries for some other SAP BASIS data object which has not got knocked off in the same table, in the same way. Do the same checks for that as well. Do you find anything different in both these cases?

Typically, the SAP BASIS SWCV doesn't change between SPs. So you probably wouldn't have got any new transports for these objects during your SP9 upgrade.

[Former Member]

Hi Arjun,

First of all thank you for your answer

I looked up in the E017 for the mbo USERDETAILS and here are the results:

TRKORR AS4POS PGMID OBJECT OBJ_NAME LOCKFLAG

SAPKB71001 40273 R3TR MMBO AC0A8B89F4447942B5DFEE753F9420C0S0001 3

SAPKB71002 35509 R3TR MMBO AC0A8B89F4447942B5DFEE753F9420C0S0001 3

SAPKB71003 39410 R3TR MMBO AC0A8B89F4447942B5DFEE753F9420C0BCE0005 3

SAPKB71004 33292 R3TR MMBO AC0A8B89F4447942B5DFEE753F9420C0BCE0005 3

There are no logs for those TR... I guess they where deleted...

In SMMW_HDR in the development system I only have one entry for the USERDETAILS MBO with a status DELETED where as I have two in the quality system, one with the status DELETED ( like in the Dev) and one ACTIVE. Looks like I am missing the version BCE0005 on my Dev... how this could be possible? More important how can I repair that ?

SMMWHDR in DEV:

MBO_ID VERSION ACTIVE SWCV_NAME MBO_NAME

AC0A8B89F4447942B5DFEE753F9420C0 S0001 D 1879EED07B4E11D987C6C81C0A114C15 USERDETAILS

SMMWHDR in QAS:

MBO_ID VERSION ACTIVE SWCV_NAME MBO_NAME

AC0A8B89F4447942B5DFEE753F9420C0 BCE0005 X 1879EED07B4E11D987C6C81C0A114C15 USERDETAILS

AC0A8B89F4447942B5DFEE753F9420C0 S0001 D 1879EED07B4E11D987C6C81C0A114C15 USERDETAILS

Just talk to SAP Support, they are advising to transport DO from QAS to DEV, restore from backup or copy QAS to DEV....

Any other idea?

Thank you very much for your help

[Former Member]

The transports shown correspond to a previous SPs and not SP09. The objects were not changed or deleted by SAP in SP09 (otherwise you would be seeing some relevant entries in E071, and some corresponding logs from your upgrade).

How exactly did you perform the upgrade? Did you do anything out of the ordinary? Did you re-run SDOE_SR after upgrade?

Another thing of interest would be to look in E071 with the following filter:

TRKORR = SAPKB71009

PGMID = 'R3TR'

OBJECT = 'MMBO'

This should show us if any Data Object changes at all were made available with SP09.

Anyway, my feeling is that these entries were not affected by the upgrade, but by something else.

As to how you can get the lost objects back: The best way is to lock the objects from your Q and transport them to your Dev system. The others look too tedious to me.

[Former Member]

So we created a new TR from QAS and export it to the Dev System.

This Solve our problem

Thank you very much for your help