Hello Iryna,
Thanks for your reply. I do need to store tempPersistentClass as well but the values in this table gets moved to the other tables depending on the API response. The field values will also change depending on whether it's still in the tempPersistentClass table or moved to either Customers or Suppliers table. For example, a status property will have "new" while in tempPersistentClass and has "AA member" in the customer table.
Figured it out. Both the Record and Recordmap classes need to be edited.
I was finally able to resolve my issue. First I used msiexec /x to uninstall each and every product code registry entry. Then I deleted all intersystems folders (some CSP fonts won't allow you to but it's ok), then deleted the registry entries. New install using the command line worked after.
I tried doing that as well. Logged on as a local admin, did add/remove. It looked to work but the bar is also just stuck and I don't see any progress.
Ran command prompt as admin and also logged in as admin on windows. Same results on both instances.
It does work when it's simply RXNORM. We actually resolved this by "manually" resolving the OID in the SDA during retrieval.
Vic,
First of all, thank you for your reply and for that link. I have tried a few things and it ended up that the issue was my private key. The private key was OPENSSH while the requirement was an RSA key. After converting to RSA, the connection went through fine.
For reference, I used the command
ssh-keygen -p -P "old passphrase" -N "new passphrase" -m pem -f path/to/key