Loading...
Loading...
Possible data deletion can occur during the reparenting of hr_case to sm_order if the "Opened for" or "Category" fields of the HR Case or Facilities Request tables are customized and the field type is changed. The system does not honor customization during upgrade (reparenting). The same fields are moved to "sm_order" from "hr_case" with base system ("out of box") configuration.
Navigate to System Definition > Plugins. Find and open the record for Human Resources Service Automation: Core. In Related Links, click Activate/Upgrade. Click Activate. Click View Plugin List. Navigate to System Definition > Tables. Find and open the record for HR Case (hr_case). In the Columns section or tab, find the Column label column. Open the record for Opened for. Select a different option in the Type field. Click Update. Open the record for Category. Select a different option in the Type field. Click Update. Upgrade the instance to Fuji or a later version. Navigate to System Definition > Tables. Find and open the record for HR Case (hr_case). Open the record for Opened for or Category. Note that the Type field reverted to the base system setting. Depending on the field type change, there may also be a truncation or complete loss of data. This isue can also be reproduced in the Facilities Service Automation plugin (in Eureka) by making similar field type changes on the Opened for or Category fields on the Facilities Request table and upgrading to a later release.
Back up the contents of the modified field or fields (Opened for and/or Category) into separate, user-defined columns. Reset the field type to the base system field type. Upgrade the instance to a later release. Restore the data from the user-defined columns.
PRB679363
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.