Monday, March 17, 2008

Fixing Objects Stuck in the Wrong State

This post was removed at TRIRIGA's request.  Please email me if you need additional information.  
at

1 comment:

  1. AnonymousSeptember 30, 2015 at 2:51 AM

    Hi Rob,

    I'm facing an issue where a lease record is stuck in 'Review in Progress' status and there are no action buttons on the record.

    I followed the below steps in Test environment to change the status to Active.

    1. select spec_id, spec_name,object_state from ibs_spec where spec_id =12019454;

    2. Once I confirmed the lease record to be modified by its spec_id, I ran the below query to update the object_state to triIssued.

    update IBS_SPEC set OBJECT_STATE = 'triIssued' where spec_id = 12019454;

    3. I again checked on front end to make sure that changes are reflected. But no luck!

    Can you please let me know if there is any alternative way for this?

    ReplyDelete

Note: Only a member of this blog may post a comment.