Global

If you get an error in syslog about multiple person contacts on a person: SELECT count(*),person_id FROM personinfo.person_contacts GROUP BY 2 HAVING count(*)>1; Delete all except one. ...

From Rad: If  a customer upgrades to 6.2 and configured Mercury MP_1502, they will get data conversion errors in Global. To clear the errors do the following:  Stage: INSERT into stage_live.networknodetype(typeid,name,vendorid,visible)values(3...

lspci -v   look for: 1 PCI bridge: VMware  VGA compatible controller: VMware SVGA II Adapter (prog-if 00 [VGA contr 

Clear s2synch.update_queue if NC stuck "verifying config alignment" Steve S did this at Allina: The two NCs with "verifying config alignment" had credential attributes and access levels in s2synch.update_queue that Global was not pulling from th...

Find API user personid,then: \copy (select p.id, p.text6, p.firstname, p.lastname, s2g.name AS acccesslevel,ptalgh.lastmod FROM person p JOIN s2activity.person_to_accesslevel_group_history ptalgh ON p.id=ptalgh.personid JOIN s2group s2g ON s2g.id=...

Upgrade Netbox to 6.2, get replication error in Global because of missing Honeywell VMS type Add missing VMS type to Global server: stage=> INSERT INTO stage_live.vmstype(vmstypeid,name) VALUES(15,'Honeywell'); Error will clear immediately ...

After upgrading to 6.0, Allina could no longer use the API to get people from the Global partition on that Netbox.  Fixed by running curl " http://localhost/nbws/properties/setbool? propertyName=s2sys.nbapi.nonlocal&value=true&persist=true " The ...

To Send Global Data to the NC: ============================ curl http://localhost/global/synchro/control/refresh/VMB70000001D96D827   To send NC data to Global: ================================== curl http://localhost/nbws/synchro/contro...

If /mnt/store2 runs out of space, you will see "out of space" messages in syslog and may get an error trying to save changes. This should be escalated to Fred, but he likes to see what he did the last time. df -h global=> SELECT schemaname, ind...

global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1; count | encoded_number -------+---------------- 2 | 166772 2 | 166118 2 | 166123 (3 rows) global=> BEGIN; BEGIN global=> delete from personinf...