10/07/2025Rick Hansen
																	
							
							
								 If you are adding a new controller to Global and it's stuck initializing, the partitions have come across to the NC but not the Global System Administrator user, and the data conflicts messages never came up in Global, check the NC database:   s2syn...							
						 
											
														
							
								10/07/2025Rick Hansen
																	
							
							
								
 Try to resynch in Global to an NC, or even save a person to the NC and get:  error operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.  If the...							
						 
											
														
							
								09/19/2025Rick Hansen
																	
							
							
								 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.  ...							
						 
											
														
							
								09/09/2025Rick Hansen
																	
							
							
								
  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...							
						 
											
														
							
								08/28/2025Rick Hansen
																	
							
							
								
  lspci -v   look for: 1 PCI bridge: VMware  VGA compatible controller: VMware SVGA II Adapter (prog-if 00 [VGA contr  							
						 
											
														
							
								08/26/2025Rick Hansen
																	
							
							
								
 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...							
						 
											
														
							
								08/21/2025Rick Hansen
																	
							
							
								 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=...							
						 
											
														
							
								06/13/2025Rick Hansen
																	
							
							
								 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 ...							
						 
											
														
							
								05/13/2025Rick Hansen
																	
							
							
								 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 ...							
						 
											
														
							
								04/17/2025Rick Hansen
																	
							
							
								
  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...