Cannot insert a record in a custom table using while the record can be inserted in the parent table

[B_22]

Hello,

I created code that inserts a new record in a custom class. This class is a child class of cmdb_ci. The code looks like this:

        new_si_support_record = new GlideRecord('support_ci');
        new_si_support_record.newRecord();
        new_si_support_record.po_number = "po number";
        new_si_support_record.model_id = cmdb_model_sys_id;
        new_si_support_record.operational_status = 1;
        new_si_support_record.name = "some name";
        new_si_support_record_sys_id = new_si_support_record.insert();

This does not work. When I change the first line to:

        new_si_support_record = new GlideRecord('cmdb_ci');

it does work.

The support_ci table is created in its own application/scope. So I checked the settings for application access on the table and enabled everything to be sure.

But still, I was unable to create a new record in the 'support_ci' table.

Because I am able to insert records into the cmdb_ci table, I assume the code is correct and the 'cross scope privileges' are sufficient.

What could be wrong?

[Ankur Bawiskar]

Hi,

are you inserting/writing script from another scope?

OOB i could not find this table "support_ci". Is the table name correct?

Regards
Ankur

[B_22]

support_ci is a custom table subclassed from cmdb_ci

[Ankur Bawiskar]

Hi,

is the custom table created in global scope?

script is running from which scope?

Regards
Ankur

[Anil Lande]

Hi,

Also check if you have created cross scope access privileges for GlideRecord API's.

 

Thanks,

Anil Lande