OTM OT Excel SGC Import Task - No Save Button in Industrial Workspace

OP2
Tera Guru

Hello Community, 

I am hoping someone else can help confirm the same issue I am facing in two separate instances of ServiceNow Australia, both Patch 1 and 2 in both Edge and Chrome.

Plugins Required - Operational Technology Manager (Contains required dependency for Service Graph Connector for Excel)

 

Confirm Permissions - Service Graph Connector for Microsoft Excel • Australia Operational Technology Management • Docs | S...

Steps to reproduce issue - If permissions were granted remember to log out and log back in. 

-Navigate to Workspaces > Industrial Workspace > List View > OT Excel - SGC Import Task > All
-Click the New Button

???Do you have a Save button???

 

There use to be a Navigation Menu item for sg-ot excel stagging table but that was removed long ago so you have to access the table via the .list command, you can still get to the sg-ot-excel imports in the Navigation Menu

I can confirm access using ot_excel_staging.list to perform a test upload into the staging table (once the below date formatting is corrected)

 

I can confirm the OOTB OT Excel SGC Templates have formatting errors that did not previously exists with the Date Columns due to initial attempt errors

I can complete the Import to see the Validation State of Pending Validation but the buttons are missing to Perform Validations prior to Scheduling the Import. (Same issue in Default View and Workspace View)  This was also removed as ServiceNow wants you to use the Import Task in the Industrial Workspace but wanted to include this for additional information.

After recreating the issue and testing in my own PDI, I released my Australia build to get an older version for testing and after seeing the waiting list have been attempting to get a new instance through the waiting list or requesting a new Australia build which does not state has a waiting list but is failing  to generate as the older releases are not currently/readily available. 

Is anyone else able to confirm the same issue on Australia Patch 1 and 2 and/or confirm on a non-Australia patch that it is still working as intended.  

I did not find any relevant changes in release notes that would impact this functionality. 

1 ACCEPTED SOLUTION

OP2
Tera Guru

Problem PRB2005251 Created 

ServiceNow engineers investigated and identified PRB2005251, which is due to a missing reference on the sys_ux_form_action_layout_item table

After importing the missing reference record the Save Button shows up and the Import Process can be completed

If you need help manually creating the reference item or capturing xml details for import contact your Support Team for further help

Sample XML to import into the sys_ux_form_action_layout_item table

 

<?xml version="1.0" encoding="UTF-8"?>
<unload unload_date="2026-08-11 21:56:13">
<sys_ux_form_action_layout_item action="INSERT_OR_UPDATE">
<action display_value="Insert">SYSID1HERE</action>
<active>true</active>
<animate_icon>false</animate_icon>
<color>secondary</color>
<description/>
<icon display_value=""/>
<item_type>action</item_type>
<label>Save</label>
<layout_group display_value=""/>
<name>Save</name>
<order>-100</order>
<overflow>false</overflow>
<sys_class_name>sys_ux_form_action_layout_item</sys_class_name>
<sys_created_by>admin</sys_created_by>
<sys_created_on>2024-01-31 16:32:55</sys_created_on>
<sys_id>SYSID2HERE</sys_id>
<sys_mod_count>0</sys_mod_count>
<sys_name>Save</sys_name>
<sys_package display_value="Problem Management for Service Operations Workspace" source="sn_sow_problem">PACKAGEIDHERE</sys_package>
<sys_policy/>
<sys_scope display_value="Problem Management for Service Operations Workspace">PACKAGEIDHERE</sys_scope>
<sys_update_name>sys_ux_form_action_layout_item_SYSID2HERE</sys_update_name>
<sys_updated_by>admin</sys_updated_by>
<sys_updated_on>2024-01-31 16:32:55</sys_updated_on>
<table>global</table>
</sys_ux_form_action_layout_item>
</unload>

Solution Rejected for the moment due to work being deleted by support through a background processing job however the solution for the missing save button tested successfully

View solution in original post

10 REPLIES 10

OP2
Tera Guru

If any ServiceNow Personnel was watching this thread and could contact me for some additional help I would greatly appreciate it!