cmarkjr

JTX/WMX - Error - Solution - Could not load data from data source.

Discussion created by cmarkjr on Oct 19, 2011
Latest reply on Oct 26, 2011 by tbello-esristaff
ArcGIS Desktop 10 SP2
Military overlay editor 10 SP2
Military Analyst 10 SP2
Production Mapping 10 SP2/Patch1
Data Reviewer 10 SP2/Patch1
Defense Mapping 10 SP2/Patch 1
Workflow Manager 10 SP2
Task Assistant Manager 10 SP1

Database: Oracle 11g R2
Server: Windows Server 2008 R2

Problem: Cannot open attribute table (from job in jtx/wmx).  Cannot reconcile version (from job in jtx/wmx).  Cannot delete user from (jtx/wmx) Workflow Manager Administrator or (jtx/wmx) workspace in ArcCatalog.

Below is an example of the issue.

Ex. Problem

(ADDING JTX/WMX USERS)

Add User A
Add User B (corrupt) (user will not be able to open attribute table/reconcile)
Add User C
Add User D
Add User E

Test

Try to delete user B (corrupt) in workflow manager administrator or arccatalog.

Result

CANNOT delete user B (corrupt) in workflow manager administrator or arccatalog. User persists.
________________
________________

Solution to delete corrupt user (User B)

Remove users in the opposite order they were added.

Delete User E (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted)
Delete User D (Close workspace in  Catalog or workflow manager administrator - Reopen to verify user is deleted)
Delete User C (Close workspace in  Catalog or workflow manager administrator - Reopen to verify user is deleted)

Delete User B (corrupt) (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted) - Corrupt user will now be deleted
_________________

This problem has persisted through all JTX/WMX versions including Workflow Manager 10 SP2.  Also leaves remnants in JTX tables.

NOTES: No idea what corrupts the user.

Outcomes