EBIFour.com Training Clarify QRGs Fixing Zombie/Orphaned Global Variables
Fixing Zombie/Orphaned Global Variables
1st April 2017
There are times when Cleo Clarify global variables can be duplicated and NOT removed easily from the Clarify Server.
Below we will review the easy way to have them removed from the server.
Connect to Server’s Postgres Server
Clarify users will want to connect to the Clarify’s Postgre server with a SQL client. Instructions on how to connect can be FOUND HERE
Locate GSSV Table
Once GSSV table is located we will want to locate the specific global variable SQL entry
select * from “EBI”.“GSSV” gv
where gv.“GSSVKey” = ‘BPS_Walmart_EDI810’
and gv.“ID” ='abc123ldkfjsdlfkjsldfkj’
After locate the entry for BPS_Walmart_EDI810, we will want to delete it
delete from “EBI”.“GSSV” gv
where gv.“GSSVKey” = 'BPS_Walmart_EDI810’
and gv.“ID” ='abc123ldkfjsdlfkjsldfkj’
By: Sean Hoppe on