Skip to main content

How can we help you?

CGM Knowledge Base

ePrescribing fails with duplicate key violation on MED_StructuredSigComponentHdr.

DevOps_229871 - Prescribing creates a duplicate key violation due to structured sig.sql

PURPOSE:  To provide customers with a script to fix writing prescriptions while using the same sig text for different prescriptions causes an error and medications not to save.

PROBLEM:
  With the CGM eMDs 10.1.3202 service pack, users writing prescriptions and using the same sig text for different prescriptions get an error 
  after sending and medication doesn't save to Current Medications.

SCRIPT DESCRIPTION:
  Prescriptions sig text will be parsed out accurately and saved to Current Medications. 

COMPATIBLE VERSIONS:
  CGM eMDs 10.1.3202

CAN SCRIPT BE RUN WITH USERS LOGGED INTO CGM eMDs?:
  Yes.

INTENDED RECIPIENTS:
  CGM eMDs Support Team and CGM Customer Portal.

STEPS TO RUN: (Contact your clinic's IT Professional if you have questions)
  1. Confirm your Solution Series version
  2. Execute the script.
  3. Validate script executed successfully
  4. Confirm that the identified issue has been resolved

  • Was this article helpful?