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

Mussie · ‎02-14-2017

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

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

Mussie · ‎02-23-2017

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'):

This will take you to Studio

3. Go to File --> Publish

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

5. Follow the progress bar and wait it completes

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

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

8. Click Install and wait till it completes

Thank you,

Mussie

View solution in original post

Chuck Tomasi · ‎02-15-2017

If you go to sys_db_object on the target instance and look at the extension, does it show that your table is extended properly?

Is the Service Order table extensible? (Take a look at the sys_db_object record for sm_order and make sure it is extensible.)

Mussie · ‎02-15-2017

Hi Chuck,

Thanks for the reply. This is what I can see on the target instance:

Mussie

Chuck Tomasi · ‎02-15-2017

Thanks Mussie. Does it look the same on your dev instance? It clearly says that Advancement Request is not extended from sm_order in this screenshot. I'm curious what the original system says.

Mussie · ‎02-15-2017

Hi Chuck,

No, it doesn't hence the issue. Here is how it looks in Dev:

Mussie