Jennifer_Jinhong_34

Web Service CONN objects disappearing from Jobs after update to 11.2.1

Discussion created by Jennifer_Jinhong_34 on Mar 18, 2016
I ran into a weird behavior after updating my system from 11.2.0 to 11.2.1. When I opened a Web Service job, the CONN object was gone and I wasn't able to see it in the drop down. But the job would still run successfully.

qa9bac2cxcjp.png

It appears to only affect objects created in v10 and upgraded to v11.

I checked the database and found that the 'OH_isTemplate' flag was set in the OH table for the objects. The UI thought these jobs were Template Objects so didn't display them.

When I queried a newly created Web Service CONN object vs an older one I saw the difference:

select oh_client, oh_name, oh_otype, OH_IsTemplate from oh where oh_client=500 and oh_name='CONN.WS.11'
select oh_client, oh_name, oh_otype, OH_IsTemplate from oh where oh_client=500 and oh_name='EMR.CONN.WEST'

tc5sqea7b6hj.png



To remedy the issue, I ran the following 2 SQL Statements.

*** Please make sure to test this thoroughly before running in your Production environment. ***
*** Make sure to exclude Client 0 or the real templates will show up as usable objects ***

update oh set OH_IsTemplate=0 where OH_otype='JOBS' and OH_HostAttrTypeDst='CIT' and oh_client<>0 and OH_IsTemplate=1
update oh set OH_IsTemplate=0 where oh_otype='CONN' and oh_client<>0



After updating the Flag, the CONN object appeared in the job again.

qeuv5bu897eq.png

Outcomes