Table is not extending from Service Order (sm_order), unable to publish application using an update set

Mussie
ServiceNow Employee
ServiceNow Employee

Hi Guys,

I have created an application using application template of Advanced Service Management (Applications —> New —> Start from a template —> Advanced Service Management) and this is working as expected. However, when I publish the application into an update set (Applications --> Publish to an update set) and commit this update set in another instance, I realized that this request table which was supposed to be extended from sm_order have only 7 fields. Please check the below screenshots:

Request table in the source instance

find_real_file.png

Request table in the source instance

find_real_file.png

I checked the following:

- Checked the number of application files in both the source and target instances. They aren't drastically different (574 files in source, 483 files in target)

- Checked the update set logs, there are no errors

Is there anything else I need to do? This is the third time I am trying and getting the same result.

Mussie

1 ACCEPTED SOLUTION

Mussie
ServiceNow Employee
ServiceNow Employee

Publishing the application to the repository have resolved my issue. For the benefit of others, I will least the steps I followed:



1. Go to System Applications--> Applications



2. Click Edit beside the application you want to publish (in my case 'Advancement'):


find_real_file.png




This will take you to Studio



3. Go to File --> Publish


find_real_file.png




4. Change the version to higher than the previous one (if published before), enter the Dev Notes if required the click Submit


find_real_file.png




5. Follow the progress bar and wait it completes


find_real_file.png


6. Once completed successfully, you should see the below page:


find_real_file.png



7. On the target instance, go to System Applications --> Applications --> Downloads tab



find_real_file.png



8. Click Install and wait till it completes



find_real_file.png


Thank you,


Mussie


View solution in original post

11 REPLIES 11

Mussie
ServiceNow Employee
ServiceNow Employee

One thing I forgot to mention is for a published application to be shared among instances, the below sys_properties value needs to be the same across all instances:


glide.appcreator.company.code


Mussie


d-L-b
Kilo Contributor

Since the "sm_order" table is part of the plugin "Service Management Core" (com.snc.service_management.core) and not installed by default in new instances (e.g. Madrid), maybe it was missing in your target instance? With application deployment the plugin and needed extended tables may be installed also in the new instance.