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

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