User Answers

How about adding an SQL method to one of the classes being joined? The method would call %SYSTEM.Util's "CreateGUID" method and the field associated with that method would be included in the join.


Hi Alex,

What happens if you call %BuildIndices for the "descriptionIndex" of Utility.contactTypes class after adding those 2 entries in DataSetup? I had an issue with a index "Find" call that went away after %BuildIndices on the index. Of course, I wouldn't expect that we'd need to build indices after each time we create a new object, so what I (and maybe we) found is a bug?

More investigation/diagnosis is needed for what I found; thought I'd bring it up in case it was related to what you found.


Thank for posting,


My apologies, I realize that I answered the wrong question. 

When we created a system from a backup and wanted the new instance to have a different instanceGUID from the original system, we used the following command to give a copy of the system a new instanceGUID:

%SYS>s ^SYS("INSTANCEGUID")=##class(%SYSTEM.Util).CreateGUID()




The system that I work on used to use InterSystems' Object Synchronization feature quite heavily to keep multiple servers around the world in sync. There was one main server with about 5 "satellite" servers. The InstanceGUID of the main server was used to support Object Synchronization. When we had to clone the main server, in order to maintain proper syncing with the "satellite" servers, we reset the cloned instance with the instance GUID of the original system.

To quote a colleague at ISC:


Thank you Evgeny; I was looking for something that was built into Atelier, but this Cache Web Terminal looks like a tool I can use too.

Hi Nicole,

This is perfect! Thank you. The step I was missing was finding/including the Caché JDBC driver jar files. I've got it up and running and all looks good.

Thanks again for the prompt reply.