Unable to modify email properties after Utah upgrade

[Sourabh1]

Dear All,

I would like to request for a help on an issue wherein after Utah upgrade, we as admins are not able to edit or create properties. We are trying to enable the email inbound and outbound properties but it is greyed out. We have not faced this issue in San Diego version.  

I thought if background script will help and wrote the below script to check if I am able to fetch the value

var gr=new GlideRecord('sys_properties');

gr.addQuery('name','glide.email.read.active');

gr.query();

if(gr.next()){

    gs.print(gr.getValue('value'));

}

I get messages like below:

[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]

Request to kindly help.

Thanks

Sourabh Saha

[Sourabh1]

I am successful in changing the value of the property to "true" by running a fix script. It was not working from background script.

But I am still unable to understand why I am being blocked from editing the properties or even creating a new property.

[Ravi Chandra_K]

Hey @Sourabh1 

Did you get chance to check ACLs on property table?

please mark the answer as helpful and correct if your query is resolved.

Kind Regards,

Ravi Chandra

[Community Alums · Accepted solution]

Hi @Sourabh1 ,

Run the below script in your Background script.

var gr = new GlideRecord('sys_properties');
gr.addActiveQuery();
gr.addQuery('name','glide.email.smtp.active');
gr.query();
if (gr.next()) {
gs.print(gr.value);
gr.value = 'true'
gr.update();
gs.print(gr.value);

}

[Sourabh1]

Hi @Community Alums ,

Thank you for your reply. I ran your script. It does the job. 🙂 

When I checked the outbound email property, it is set to true.

I am still unable to understand why I am being blocked to edit or create properties and why I get a result like the one below.

The result that I get when I run the script is below :

*** Script: false
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
Starting cache flush
Flushing cache
Flushing Scoped caches
Loading properties from DB
Cache flush complete
Loading properties from DB
Slow business rule 'Properties change' on sys_properties:<span class = "session-log-bold-text"> glide.email.smtp.active</span>, time was: 0:00:00.344
[0:00:00.008] Domain Tree Load Time
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_data_policy2 restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [global]
[Domain Paths] Query against table sys_flow_record_trigger restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_flow_record_trigger restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
[Domain Paths] Query against table sys_script restricted by domain values [SNOW[864190b96970600010b88f3cdb9a136e], global]
*** Script: true