Russ, It is fixed now. I had exported our local GPC_TERMs table back to our UNMC_TERMS table on babel. That introduced some duplicate entries in our unmc_terms metadata on babel.
We do not need to re-export the GPC_TERMs to babel for our metadata, and all is well now. I fixed my script - re–ran it, and it works once more. Thanks for pointing this out….. Hubert Hickman Systems Sr. Analyst [email protected] (402) 559-4838 From: Russ Waitman <[email protected]<mailto:[email protected]>> Date: Tuesday, May 26, 2015 at 4:17 PM To: Hubert Hickman <[email protected]<mailto:[email protected]>> Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>, Mei Liu <[email protected]<mailto:[email protected]>> Subject: Re: Babel updates Any chance this work may have broke things? Mei is working on a PCORI proposal with faculty here and when she tries to open your demographics folder on babel we get a message: The following error has occurred: Database error On May 26, 2015, at 10:10 AM, Hickman, Hubert B <[email protected]<mailto:[email protected]>> wrote: I’ve finally spent some development/brain cycles working on automating our babel updates here at UNMC. It now takes about 2.5 minutes for our babel update to happen now – using some of the same ideas used to move our Oracle data into Postgresql to construct the new identified warehouse. I have shell access to babel, so I may have some options that other places do not, but I think my code could be used by other sites (or perhaps others have the process well honed already, and I am trailing the pack here). The code exports the metadata, copies it to babel, and generates and executes the update statements for babel’s table_access table. If it is of interest, I’ll put something up on bitbucket or elephant. Hubert Hickman Systems Sr. Analyst [email protected]<mailto:[email protected]> (402) 559-4838 ________________________________ Nebraska Medicine E-mail Confidentiality Disclaimer The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. _______________________________________________ Gpc-dev mailing list [email protected]<mailto:[email protected]> http://listserv.kumc.edu/mailman/listinfo/gpc-dev Russ Waitman, PhD Director of Medical Informatics Assistant Vice Chancellor for Enterprise Analytics Associate Professor, Department of Internal Medicine University of Kansas Medical Center, Kansas City, Kansas 913-945-7087 (office) [email protected]<mailto:[email protected]> http://www.kumc.edu/ea-mi/ http://informatics.kumc.edu<http://informatics.kumc.edu/> http://informatics.gpcnetwork.org – a PCORNet collaborative ________________________________ Nebraska Medicine E-mail Confidentiality Disclaimer The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
