Workflow scripts is not updating the states in CMDB table

[Avee90]

Hello Folks,

         I've an sc task in workflow for a catalog item. In the SC task there will some fields will be populate like  Assigned to, Location, Serial Number, Install state and Hardware state to fill by the SC assignee and after closing the sc task, based on the serial number given by the assignee It should update the Assigned to, Location, install state and Hardware state in Hardware field. I wrote a run script to update those fields in CMDB_ci_hardware table. The assigned to and location fields are updating but Install state and hardware fields are not updating in Hardware table.

Install state and Hardware state choice fields are getting CMDB_CI table in Hardware table and I've created same choices with values from CMDB table in the catalog variables

But still not updating the install state and hardware state thru the script. can you anyone please help me out.

[Brad Bowman]

Two suspect areas to check: First make sure the select box variables values exactly match the field values on the hardware table - so 1 for install_status = installed and 'installed' for hardware_status = installed.  Next, try adding a Timer activity for 10 seconds just prior to the Run Script activity.  This will ensure that the script is run using the System user with Admin access, rather than the user that closed the Catalog Task who may not have access to update all of the fields.