Portal check out record does not check in when MDM workflow is active

[former_member283645]

Hi Experts,

We are using portal as front end for the MDM material creation/update.

when a user tries to edit a material via portal, the record is checked out in mdm and once the record update is done and submitted that particular record will be checked in. this is normal process and automatic in nature till date.

However, we have created a simple workflow in mdm, we havent checked out records in start step of workflow.

So it normally executes without check out /in via MDM Workflow.

workflow triggerring action = record import, record update, record add.

when i edit the material vai data manager WF triggers fine and all is well.

However when i edit the material via portal, record is checked out (which is normal) and once record is submitted, the workflow in mdm is triggered successfully.

Workflow ends with all necessary syndication's and validations and ends successfully, But after this the record still remains as checked out? ???

ideally as mentioned above (in bold) once the user completes editing the record and submits it, the record should be checked in, but this is not happening!!!

Please let me know why is this happening.

Please help.

Regards

Eva

[Former Member]

Hi Eva,

Please confirm if Portal users have the rights highlighted in the attachment.

Also,it is always easier to understand the issue if you mention product service pack details.

Thanks,
Ravi

[former_member283645]

Hi Ravi,

Portal is Connected to MDM using Admin user (has full access).

we are using MDM 7.1 SP08 patch 196

am i missing something?

Regards

Eva

[Former Member]

HI Eva,

Please check who is the owner of the Workflow in Workflow properties.Try setting it as Launcher.

Thanks,

Ravi

[former_member283645]

hi,

i did try with launcher, but it did not work.

I tried with Admin aswell, but it did not work.

Regards

Eva

[Former Member]

Hi Eva,

Try to get Trace details on Webserver section.Kindly check what is the exact error which is being logged.Please refer to the attached snapshot for this.

Thanks,

Ravi

[former_member283645]

Hi Ravi,

Can you please let me know how can i access the path that is mentioned in the screen shot?

i cannot see this in console!

Also, do you want me to monitor when a material is updated and when it gets struck?

Regards

Eva

[Former Member]

Hi Eva,

Yes,you got it right.Once we know the exact issue we can either solve the problem or know what to report.

This is a server level setting and the below snapshot shows that on right clicking over server node and you can select "Trace Setting".However you will have to feed in Server password to edit this.Please monitor the system behavior and take a dump of logs so that exact error can be noted.

Thanks,

Ravi

[former_member283645]

Hi,

i selected 'Program Flow' for Web server under trace settings at server level.

Can you please let me know where exactly i will have to Monitor to see whats going on!!

Regards

Eva

[Former Member]

Hi Eva,

Kindly do the following -

->Please run a complete cycle.

->Note the users involved.

->Note the time at which checkin was tried.

->Download the MDS log.

->Open it in Excel,filter by repository and user.

->Check for entry for this CheckIn attempt.

Let me know if you face any difficulty doing this.

Thanks,

Ravi

[former_member283645]

Hi,

I checked the Log files in Log folder, MDS_Log@@....csv.

However i can only see error at one place .. ''Informational only: this is not an error. Notify SAP Support with this log entry: Context = MDSExportServer@GenerateSynRemoteKeys''

Apart from this there is no clue found.

Regards

Eva

[former_member283645]

Hi,

Sorry How do you download the MDS log file ?

Regards

Eva

[Former Member]

Hi Eva,

You can get it from Console under logs section.On right clicking on upper right side of pane you get an option to save it.

Select the log in appropriate time range.

answer to what to look for is in the below snapshot -

Check for this entry in Column H.Please share your findings.

Thanks,
Ravi

[former_member283645]

hi,

in the column h i haven't found any 'error' or authorization content.

Looks ok to me, but don't understand why the portal is not auto-checking-in the record once the workflow completes execution.

Regards

Eva

[Former Member]

Hi,

Entries starting with Webserver will tell you what portal is doing.

Observe this and find the message in Col D.

Thanks,
Ravi

[former_member283645]

Hi,

I was not able to see any error message over there.

I think i have to work with a portal consultant and ask him to check from his end!

Regards

Eva

[Former Member]

Hi Eva,

That is useful.

Analyzing this issue I came across SAP note 1740194-Record remains in exclusive lock after workflow is completed.This was an issue observed in SAP MDM 7.1 SP08.

It gives a workaround -

The workaround is:

The owner of updating has to click on the modified record in Data Manager after workflow completed. The original modified record will be unlocked.

Ofcourse,resolution would require an upgrade.

Thanks,

Ravi

[former_member283645]

Thanks ravi for the Info.

Sap note that you mentioned describes that WF is trying to check in the record but it does not happen and this issue is fixed by upgrading to new patch or sp09.

However my case is  bit different.

I haven't mentioned any check-in or check out in workflow.

when the record is edited in portal, record in data manager can be seen as checked out. when user submits the change and workflow is triggered and completed but the record never gets checked in!!

If i mention check in/out in wf,  then in portal, user is not able to edit the record in first instance, it throws a huge java code error. if i remove check in/out in wf, the user is able to edit and submit records in portal. but the problem as mentioned above checkin does not happen automatically.

Please suggest.

we are in 7.1 sp08 196.

Regards

Eva.

[Former Member]

Hi Eva,

It seems this can be a bug.Please refer to SAP Note 1629361.

It says -

Symptom

The checkout status for records assigned to a workflow job is not
refreshed automatically after user accepts the job in the Data Manager.
The status is updated only after 'Refresh' option is selected, or
re-selecting the workflow job.

Thanks,

Ravi

[former_member283645]

Thanks ravi,

it says ..

The issue was fixed in the following code lines and versions:

-   MDM 7.1 SP06 - Patch38 (Build 7.1.06.254) - change list #99009

-   MDM 7.1 SP07 - Patch20 (Build 7.1.07.247) - change list #99006

-   MDM 7.1 SP08 - Patch01 (Build 7.1.08.199) - change list #98886

- MDM 7.1 SP09 - change list #98885

But we are using MDM 7.1 SP08 patch 196

so should be fixed already..

not sure if this will fix if we upgrade as per 1740194

Regards

Eva

[Former Member]

Hi Eva,

Please raise a ticket with SAP describing the above issue.

Kindly share your findings.

Thanks,

Ravi