AnsweredAssumed Answered

CR stuck at Fulfillment Phase

Question asked by Emre Guloglu on Apr 17, 2019
Latest reply on Apr 23, 2019 by Joanna Yang

Like • Show 2 Likes2
Comment • 5

Hi all,

I've faced with an issue on change requests. Eventhough all items in cr are completed and reflected to target system, the cr does not yield to completed state. Going to demonstrate with an example:

Product Version: 7.0.2 P06

Change request seems it's on Fulfillment Phase

But overall status of cr is %100 and there is no item which is not completed

Eventhough all account changes are verified after collection of application, they still seem to wait for verification.

When an information button is clicked, it points that item is completed.

Kind regards,

Emre

1 person has this question

Outcomes

William May Apr 17, 2019 4:26 PM

Have you verified that the item is marked complete in the DB? For example, if operation was Delete Account, is that account marked deleted on AVUSER.T_AV_ACCOUNTS, or for Remove Approle/Ent from Account, verified on AVUSER.T_AV_EXPLODEDUSERENTITLEMENTS?

Actions

Emre Guloglu @ William May on Apr 18, 2019 1:39 AM

Thanks for reply William, the operation is 'add application role to account' and account-approle relation is inserted to T_AV_EXPLODEDUSERENTITLEMENTS.

Actions

Joanna Yang Apr 18, 2019 9:52 AM

The watch might closed before change request item completed.

Running following query, it should tell you if the watch is closed.

SELECT CHANGE_REQUESTS_ID, TYPE, OPERAND_TYPE, STATE, DERIVED_TYPE, OPERATION, FULL_OPERATION, VALUE_TYPE
FROM T_AV_CHANGE_REQUEST_DETAILS cri
WHERE cri.state IN('WD','PZ','PV')
AND cri.watch_id IN (SELECT ID FROM T_AV_DATAPROCEVENTWATCHES WHERE status ='C');

If the watch is closed, you need to set their satus to Open (Status='O'), then re-run account collector.

Actions

Emre Guloglu @ Joanna Yang on Apr 19, 2019 2:47 AM

According to your query, nothing returns. So, I assume watch is open. Could you please share if there is anything else to check?

Actions

Joanna Yang @ Emre Guloglu on Apr 23, 2019 11:51 AM

That was our problem and once we changed watch to open fixed our problem.

Actions

5 Replies

William May Apr 17, 2019 4:26 PM
Mark Correct
Correct Answer
Have you verified that the item is marked complete in the DB? For example, if operation was Delete Account, is that account marked deleted on AVUSER.T_AV_ACCOUNTS, or for Remove Approle/Ent from Account, verified on AVUSER.T_AV_EXPLODEDUSERENTITLEMENTS?
Like • Show 1 Like1
Actions
- Emre Guloglu @ William May on Apr 18, 2019 1:39 AM
  Mark Correct
  Correct Answer
  Thanks for reply William, the operation is 'add application role to account' and account-approle relation is inserted to T_AV_EXPLODEDUSERENTITLEMENTS.
  Like • Show 0 Likes0
  Actions
Joanna Yang Apr 18, 2019 9:52 AM
Mark Correct
Correct Answer
The watch might closed before change request item completed.

Running following query, it should tell you if the watch is closed.
SELECT CHANGE_REQUESTS_ID, TYPE, OPERAND_TYPE, STATE, DERIVED_TYPE, OPERATION, FULL_OPERATION, VALUE_TYPE
FROM T_AV_CHANGE_REQUEST_DETAILS cri
WHERE cri.state IN('WD','PZ','PV')
AND cri.watch_id IN (SELECT ID FROM T_AV_DATAPROCEVENTWATCHES WHERE status ='C');

If the watch is closed, you need to set their satus to Open (Status='O'), then re-run account collector.
Like • Show 1 Like1
Actions
- Emre Guloglu @ Joanna Yang on Apr 19, 2019 2:47 AM
  Mark Correct
  Correct Answer
  According to your query, nothing returns. So, I assume watch is open. Could you please share if there is anything else to check?
  Like • Show 0 Likes0
  Actions
  - Joanna Yang @ Emre Guloglu on Apr 23, 2019 11:51 AM
    Mark Correct
    Correct Answer
    That was our problem and once we changed watch to open fixed our problem.
    Like • Show 0 Likes0
    Actions

CR stuck at Fulfillment Phase

Outcomes

Related Content

Recommended Content