gerickecook

JTX 9.3.1 and compatibility with replicas (disconnected editing)

Discussion created by gerickecook on Jul 19, 2010
Latest reply on Sep 17, 2014 by milesee
Our plan is to use JTX to manage a large editing project, some of which requires physical validation from a remote office. I successfully set up JTX for ArcGIS 9.3.1 for a SQLserver enterprise SDE geodatabase and finally got a workflow with all the custom steps/notifications/etc that I wanted working (after some permissions issues).  Good so far.

Now comes the fun part. I set up a personal SDE geodatabase on the same machine, registered the JTX tables for versioning, and created a replica from enterprise to personal SDE. The thought here was that the remote user could "check in" his laptop to the network, synch the two databases, and then work on some jobs from his replica database while disconnected from the network. We know that there would be some challenges in having the database connections pointing to his replicated database on the laptop, as well as potential hassle of JTX tables updating during the sync process (especially from two different database connections).

After creating the DB replica to personal SDE, I tried setting up a JTX database connection from ArcCatalog (and also from Post-Install and the Config Manager) with no success. I can create the initial database connection but when trying to create the data workspace I got the following error:

Objects in this class cannot be updated outside an edit session [GwssVersion.DBO.JTX_DATABASES]


After a few more attempts, I finally realized that my JTX installation was then hosed. I cannot view open jobs in the JTX Application without getting this new error:

External component has thrown an exception


and the same "cannot be updated outside an edit session" for the job_types table if I try to copy an existing job type from the enterprise data connection (that was formerly working). So I feel like my JTX application is now corrupted and I would have to delete the tables and rebuild everything from scratch again.

So here is my question.... Does JTX actually support disconnected editing in a replicated environment? What workarounds would have to be employed to make this happen? And I know that this is supposed to "be easier" in ArcGIS 10 but our agency is a long way from implementing the next version (we're typically a year behind).

Outcomes