Xtraction is not showing the right status from some Catalog's requests

Document ID : KB000112700
Last Modified Date : 06/09/2018
Show Technical Document Details
Issue:
Xtraction report is showing a status from a Service Catalog request called "unknown (1022)" instead of the right status showed in Catalog's console "Request Opened"
Environment:
Service Catalog 17.1
Cause:
Status has not been added to the data model being used in Xtraction.
Resolution:
1. Take a backup of the datamodel.dat file being used

2. Open the datamodel.dat being used using Data Model Editor > Expand CA Service Catalog > Click View > go to Edit in the toolbar > Find > Search for: THEN 'Fulfillment Cancelled' (or the status name of your locale language) > Double click on "STATUS"

3. Go to Expression > click on the ellipsis button > You will see something like (take a copy of the original text):

CASE REQUEST.STATUS WHEN 0 THEN 'Deleted' WHEN 1 THEN 'Pending' WHEN 2 THEN 'Completed' WHEN 3 THEN 'Pending Cancellation' WHEN 4 THEN 'Cancelled' WHEN 5 THEN 'Inactive Don''t Cancel' WHEN 6 THEN 'Pending Resource Assignment' WHEN 7 THEN 'Resource Assigned' WHEN 100 THEN 'Not Submitted' WHEN 101 THEN 'Not Submitted - Cart' WHEN 102 THEN 'Not Submitted - Pending Approval' WHEN 103 THEN 'Not Submitted - Rejected' WHEN 104 THEN 'Not Submitted - Approved' WHEN 200 THEN 'Submitted' WHEN 201 THEN 'Re-Submitted' WHEN 400 THEN 'Pending Approval' WHEN 600 THEN 'Rejected' WHEN 800 THEN 'Approved' WHEN 801 THEN 'Approval Not Needed' WHEN 999 THEN 'Approval Done' WHEN 1000 THEN 'Pending Fulfillment' WHEN 1001 THEN 'Check Availability' WHEN 1002 THEN 'Filled From Inventory' WHEN 1003 THEN 'Not Filled From Inventory' WHEN 1004 THEN 'Ordered' WHEN 1005 THEN 'Backordered' WHEN 1006 THEN 'Shipped' WHEN 1007 THEN 'Received' WHEN 1008 THEN 'Order Cancelled' WHEN 1012 THEN 'Pending Procurement' WHEN 1013 THEN 'USD Change Order Opened' WHEN 1014 THEN 'Notified Facilities' WHEN 1015 THEN 'Notified IT Services' WHEN 1016 THEN 'Being Staged' WHEN 1017 THEN 'Staged' WHEN 1018 THEN 'Being Configured' WHEN 1019 THEN 'Configured' WHEN 1020 THEN 'USD Request Opened' WHEN 1999 THEN 'Fulfillment Cancelled' WHEN 2000 THEN 'Fulfilled' ELSE 'Unknown (' + CAST(REQUEST.STATUS AS VARCHAR(10)) + ')' END

Add a WHEN 1022 THEN 'Request Opened' before the ELSE

CASE REQUEST.STATUS WHEN 0 THEN 'Deleted' WHEN 1 THEN 'Pending' WHEN 2 THEN 'Completed' WHEN 3 THEN 'Pending Cancellation' WHEN 4 THEN 'Cancelled' WHEN 5 THEN 'Inactive Don''t Cancel' WHEN 6 THEN 'Pending Resource Assignment' WHEN 7 THEN 'Resource Assigned' WHEN 100 THEN 'Not Submitted' WHEN 101 THEN 'Not Submitted - Cart' WHEN 102 THEN 'Not Submitted - Pending Approval' WHEN 103 THEN 'Not Submitted - Rejected' WHEN 104 THEN 'Not Submitted - Approved' WHEN 200 THEN 'Submitted' WHEN 201 THEN 'Re-Submitted' WHEN 400 THEN 'Pending Approval' WHEN 600 THEN 'Rejected' WHEN 800 THEN 'Approved' WHEN 801 THEN 'Approval Not Needed' WHEN 999 THEN 'Approval Done' WHEN 1000 THEN 'Pending Fulfillment' WHEN 1001 THEN 'Check Availability' WHEN 1002 THEN 'Filled From Inventory' WHEN 1003 THEN 'Not Filled From Inventory' WHEN 1004 THEN 'Ordered' WHEN 1005 THEN 'Backordered' WHEN 1006 THEN 'Shipped' WHEN 1007 THEN 'Received' WHEN 1008 THEN 'Order Cancelled' WHEN 1012 THEN 'Pending Procurement' WHEN 1013 THEN 'USD Change Order Opened' WHEN 1014 THEN 'Notified Facilities' WHEN 1015 THEN 'Notified IT Services' WHEN 1016 THEN 'Being Staged' WHEN 1017 THEN 'Staged' WHEN 1018 THEN 'Being Configured' WHEN 1019 THEN 'Configured' WHEN 1020 THEN 'USD Request Opened' WHEN 1999 THEN 'Fulfillment Cancelled' WHEN 2000 THEN 'Fulfilled' WHEN 1022 THEN 'Request Opened' ELSE 'Unknown (' + CAST(REQUEST.STATUS AS VARCHAR(10)) + ')' END

4. Save Changes in data model editor.

5. Refresh and try to drag and drop a record list.