Jul 042012

I recently stuffed up a NPC install, so I had to reinstall from scratch. However I neglected to remove the eHealth instance as a data source before I wiped NPC. When I tried to add eHealth as a data source again, I would get this error –
Unable to add eHealth as data souce - associated to another instance

After some searching, I found this command which fixed it for me.
These commands need to be run on the eHealth Host.
*note* If you’re using windows, type in “bash” before you run the command.
$NH_HOME/bin/sys/nhisql "delete from nh_metadata where subject_area='NPC'"