No records in UWL for mdm

[Former Member]

Hi all,

I have a problem with the UWL for MDM, no records are displayed. I have configured things after all the guides and articles found here on SDN and all connection tests are fine, data is displayed in the iVews. (for Vendors). There are tasks in the MDM system. I have restarted the portal server and all services, cleared the cache etc but without any luck..

Any ideas?

Cheers,

Max

[Former Member]

Updated to latest version of MDM solved the problem.

Cheers,

Max

[Former Member]

Hi,

Max just try this one more document.I am sure this will solve your problem.

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/771f1a61-0e01-0010-daa9-93a52905da09]

Regards,

Jitesh Talreja

[Former Member]

Jitesh,

I have gone through this document and followed the instructions closely but without any success I am afraid..

BR/Max

[Former Member]

Hi Max,

Even i am having the same problem. Actually it was working and showing up worklfow jobs in portal till before applying sp06 patch2. After applying SP06 Patch2 this problem started. I already opened OSS Message on this. STill no response.

if you have overocome this issue, please let me know - i can apply the same.

- Raghavendra

[Former Member]

Hi,

In which MDM version was the UWL working properly?

Michael

[Former Member]

I had UWL working with MDM proerly for both MDM SP05 and MDM SP06 Patch2. However, I have other problems like History of the workflow not getting displayed properly and Next step not showing anything etc... I opened OSS note too. Working with them for some resolution.

Max, If you can post your UWL config file, probably that would help in understanding what the problem is.

Thanks

[Former Member]

Hi,

Looks like this:

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE UWLConfiguration PUBLIC '-//SAP//UWL1.0//EN' 'uwl_configuration.dtd'>

<UWLConfiguration version="1.0">

<ItemTypes>

<ItemType name="uwl.completedtask.mdm.all.SAP_MDM_Repository_Vendors.Vendors" connector="MdmUwlConnector" defaultView="MdmWorkItemsCompletedView" defaultAction="showMdmDetails" executionMode="default">

<Actions>

<Action name="showMdmDetails" groupAction="no" handler="IViewLauncher" returnToDetailViewAllowed="yes" launchInNewWindow="yes">

<Properties>

<Property name="taskId" value="${item.jobId}"/>

<Property name="stepId" value="${item.stepId}"/>

<Property name="userId" value="${item.userNames}"/>

<Property name="workflowTable" value="${item.workflowTable}"/>

<Property name="externalRequestEvent" value="com.sap.pct.mdm.appl.masteriviews.events.externals.ViewTaskRecordsHandler"/>

<Property name="iview" value="pcd:portal_content/net.xx.semc/net.xx.MDM/net.xx.Pages/com.sap.pct.mdm.appl.vendors.search"/>

</Properties>

<Descriptions default="Show Record Details"/>

</Action>

<Action name="showHistory" handler="IViewLauncher" launchInNewWindow="yes" launchNewWindowFeatures="width=557,height=560,resizable=yes,scrollbars=yes,status=yes,toolbar=no,menubar=no,location=no,directories=no">

<Properties>

<Property name="jobId" value="${item.jobId}"/>

<Property name="workflowTable" value="${item.workflowTable}"/>

<Property name="stepId" value="${item.stepId}"/>

<Property name="userId" value="${item.userNames}"/>

<Property name="systemId" value="${item.systemId}"/>

<Property name="iview" value="pcd:portal_content/com.sap.pct/specialist/com.sap.pct.mdm.appl.mdm_550/com.sap.pct.mdm.appl.iviews/com.sap.pct.mdm.appl.workflow.taskhistory"/>

</Properties>

<Descriptions default="History"/>

</Action>

<Action name="createJob" handler="IViewLauncher" launchInNewWindow="yes" launchNewWindowFeatures="width=557,height=560,resizable=yes,scrollbars=yes,status=yes,toolbar=no,menubar=no,location=no,directories=no">

<Properties>

<Property name="iview" value="pcd:portal_content/com.sap.pct/specialist/com.sap.pct.mdm.appl.mdm_550/com.sap.pct.mdm.appl.iviews/com.sap.pct.mdm.appl.workflow.createjob"/>

</Properties>

<Descriptions default="Create Job"/>

</Action>

</Actions>

</ItemType>

<ItemType name="uwl.task.mdm.jobs.SAP_MDM_Repository_Vendors.Vendors" connector="MdmUwlConnector" defaultView="MdmViewJobs" defaultAction="showMdmDetails" executionMode="default">

<Actions>

<Action name="createJob" handler="IViewLauncher" launchInNewWindow="yes" launchNewWindowFeatures="width=557,height=560,resizable=yes,scrollbars=yes,status=yes,toolbar=no,menubar=no,location=no,directories=no">

<Properties>

<Property name="iview" value="pcd:portal_content/com.sap.pct/specialist/com.sap.pct.mdm.appl.mdm_550/com.sap.pct.mdm.appl.iviews/com.sap.pct.mdm.appl.workflow.createjob"/>

</Properties>

<Descriptions default="Create Job"/>

</Action>

</Actions>

</ItemType>

<ItemType name="uwl.task.mdm.tasks.SAP_MDM_Repository_Vendors.Vendors" connector="MdmUwlConnector" defaultView="MdmViewTasks" defaultAction="showMdmDetails" executionMode="default">

<Actions>

<Action name="showMdmDetails" groupAction="no" handler="IViewLauncher" returnToDetailViewAllowed="yes" launchInNewWindow="yes">

<Properties>

<Property name="taskId" value="${item.jobId}"/>

<Property name="stepId" value="${item.stepId}"/>

<Property name="userId" value="${item.userNames}"/>

<Property name="workflowTable" value="${item.workflowTable}"/>

<Property name="externalRequestEvent" value="com.sap.pct.mdm.appl.masteriviews.events.externals.ViewTaskRecordsHandler"/>

<Property name="iview" value="pcd:portal_content/net.xx.semc/net.xx.MDM/net.xx.Pages/com.sap.pct.mdm.appl.vendors.search"/>

</Properties>

<Descriptions default="Show Record Details"/>

</Action>

<Action name="showHistory" handler="IViewLauncher" launchInNewWindow="yes" launchNewWindowFeatures="width=557,height=560,resizable=yes,scrollbars=yes,status=yes,toolbar=no,menubar=no,location=no,directories=no">

<Properties>

<Property name="jobId" value="${item.jobId}"/>

<Property name="workflowTable" value="${item.workflowTable}"/>

<Property name="stepId" value="${item.stepId}"/>

<Property name="userId" value="${item.userNames}"/>

<Property name="systemId" value="${item.systemId}"/>

<Property name="iview" value="pcd:portal_content/com.sap.pct/specialist/com.sap.pct.mdm.appl.mdm_550/com.sap.pct.mdm.appl.iviews/com.sap.pct.mdm.appl.workflow.taskhistory"/>

</Properties>

<Descriptions default="History"/>

</Action>

<Action name="createJob" handler="IViewLauncher" launchInNewWindow="yes" launchNewWindowFeatures="width=557,height=560,resizable=yes,scrollbars=yes,status=yes,toolbar=no,menubar=no,location=no,directories=no">

<Properties>

<Property name="iview" value="pcd:portal_content/com.sap.pct/specialist/com.sap.pct.mdm.appl.mdm_550/com.sap.pct.mdm.appl.iviews/com.sap.pct.mdm.appl.workflow.createjob"/>

</Properties>

<Descriptions default="Create Job"/>

</Action>

</Actions>

</ItemType>

</ItemTypes>

<Views>

<View name="MdmViewJobs" selectionMode="SINGLESELECT" width="98%" supportedItemTypes="uwl.task.mdm.jobs" columnOrder="mdmStatus, priority, subject, jobId, userNames, dueDate, creatorId, createdDate" sortby="priority:descend, dueDate:ascend, createdDate:descend" tableDesign="STANDARD" visibleRowCount="10" headerVisible="yes" queryRange="undefined" tableNavigationFooterVisible="yes" tableNavigationType="CUSTOMNAV" actionRef="" refresh="300" dueDateSevere="86400000" dueDateWarning="259200000" emphasizedItems="unread" displayOnlyDefinedAttributes="yes" dynamicCreationAllowed="yes" actionPosition="top">

<Descriptions default="My Open MDM Jobs"/>

<DisplayAttributes>

<DisplayAttribute name="workflowTable" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Workflow Table">

<ShortDescriptions>

<Description Language="en" Description="Workflow Table"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="userNames" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="User Names">

<ShortDescriptions>

<Description Language="en" Description="User Names"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="mdmStatus" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="MDM Status">

<ShortDescriptions>

<Description Language="en" Description="MDM Status"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="jobId" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Job ID">

<ShortDescriptions>

<Description Language="en" Description="Job ID"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

</DisplayAttributes>

<Actions>

<Action reference="refresh"/>

<Action reference="defaultGlobalWizard"/>

<Action reference="addToNavigation"/>

<Action reference="removeFromNavigation"/>

<Action reference="personalize"/>

</Actions>

</View>

<View name="MdmViewTasks" selectionMode="SINGLESELECT" width="98%" supportedItemTypes="uwl.task.mdm.tasks" columnOrder="mdmStatus, priority, subject, jobId, userNames, dueDate, creatorId, createdDate" sortby="priority:descend, dueDate:ascend, createdDate:descend" tableDesign="STANDARD" visibleRowCount="10" headerVisible="yes" queryRange="undefined" tableNavigationFooterVisible="yes" tableNavigationType="CUSTOMNAV" actionRef="" refresh="300" dueDateSevere="86400000" dueDateWarning="259200000" emphasizedItems="unread" displayOnlyDefinedAttributes="yes" dynamicCreationAllowed="yes" actionPosition="top">

<Descriptions default="My Open MDM Tasks"/>

<DisplayAttributes>

<DisplayAttribute name="workflowTable" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Workflow Table">

<ShortDescriptions>

<Description Language="en" Description="Workflow Table"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="userNames" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="User Names">

<ShortDescriptions>

<Description Language="en" Description="User Names"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="mdmStatus" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="MDM Status">

<ShortDescriptions>

<Description Language="en" Description="MDM Status"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="stepId" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Step ID">

<ShortDescriptions>

<Description Language="en" Description="Step ID"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="jobId" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Job ID">

<ShortDescriptions>

<Description Language="en" Description="Job ID"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="stepName" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Step Name">

<ShortDescriptions>

<Description Language="en" Description="Step Name"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

</DisplayAttributes>

<Actions>

<Action reference="refresh"/>

<Action reference="defaultGlobalWizard"/>

<Action reference="addToNavigation"/>

<Action reference="removeFromNavigation"/>

<Action reference="personalize"/>

</Actions>

</View>

<View name="MdmWorkItemsCompletedView" selectionMode="SINGLESELECT" width="98%" supportedItemTypes="uwl.completedtask.mdm.all" columnOrder="subject, jobId, userNames, creatorId, createdDate, status" sortby="creatorId:ascend, createdDate:descend" tableDesign="STANDARD" visibleRowCount="10" headerVisible="yes" queryRange="undefined" tableNavigationFooterVisible="yes" tableNavigationType="CUSTOMNAV" actionRef="" refresh="-1" dueDateSevere="0" dueDateWarning="0" emphasizedItems="unread" displayOnlyDefinedAttributes="yes" dynamicCreationAllowed="yes" actionPosition="top">

<Descriptions default="Completed MDM Tasks"/>

<DisplayAttributes>

<DisplayAttribute name="workflowTable" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Workflow Table">

<ShortDescriptions>

<Description Language="en" Description="Workflow Table"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="userNames" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="User Names">

<ShortDescriptions>

<Description Language="en" Description="User Names"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

<DisplayAttribute name="jobId" type="string" width="10" sortable="yes" format="default" hAlign="LEFT" vAlign="BASELINE" maxTextWidth="0" headerVisible="yes">

<Descriptions default="Step Name">

<ShortDescriptions>

<Description Language="en" Description="Job ID"/>

</ShortDescriptions>

</Descriptions>

</DisplayAttribute>

</DisplayAttributes>

<Actions>

<Action reference="refresh"/>

<Action reference="defaultGlobalWizard"/>

<Action reference="addToNavigation"/>

<Action reference="removeFromNavigation"/>

<Action reference="personalize"/>

</Actions>

</View>

</Views>

</UWLConfiguration>

[Former Member]

Any ideas anyone?

Cheers,

Max

[Former Member]

Hi Max,

Specify the table name under the Tables with Workflows property of the MDM System.

I had a same issue but now its working fine.

Hope it Helps

Regards,

Jitesh Talreja

[Former Member]

Thanks Jadeja!!

It's surprise why SAP guys are not able to tell this, Its been a 1 month old my oss message for this issue. They are doing what not. hmm

anyhow, i am going to give the table name, can you please confirm me whether it should be all uppercase or lowercase for the table name?

Once again thanks for your helpful answer.

Thanks,

Raghavendra

[Former Member]

Hi,

I hope you are addressing me only. THANKS Jadeja.

Well you should pass the table name as it appears in the repository.

E.g. Products of type main table then in the Tables with Workflow field enter in the same way i.e. Products.

Hope it helps

Regards,

Jitesh Talreja

[Former Member]

Thanks Jitesh!! My Problem solved!! Thanks a lot.

Btw, How did you come to know about this new property in the MDM system. I dont understand why SAP doesnt communicate this kind of important changes in there release notes. This property wasnt there till SP6 Patch 1.

Thanks Jitesh!!

- Raags

[Former Member]

Hi,

We have the same problem. We are not able to send the record to the next step. The history button is only working for the first step in the process.

Do you have any solution?

BR

Michael

[nitin_mahajan2]

Jitesh i need some help urgently, i have posted another message on UWL, can you se into that.

i am having following problems

cannot see Next button,

when i click the item, it says the message processed, but in case of errors, it doesnt show me error/warning.

i want to configure a page where i can show the record details along with the workflow line item, i tried using the guidelines in the document, not working.

Kindly assist.

[Former Member]

Hello Experts,

Even we have the same problem,not able to send record to next step.On click of Next step it opens up Next step iview(com.sap.pct.mdm.appl.workflow.nextstep under specialist folder) with message as

"Job ID'1111' step ID'12' subject"Review Request by Approver".We are on MDM5.5 SP06 latest patch.

Thanks in advance

Suresh

[Former Member]

Hi Max,

Login into the portal using the Workflow's Owner login credentials i.e. through User Mapping

Hope this will solve your problem.

Regards,

Jitesh Talreja

Edited by: Jitesh Talreja on Apr 3, 2008 2:54 PM

[Former Member]

Thanks,

I already do that unfortunately..

BR/Max