topic JTX/WMX - Error - Solution - Could not load data from data source. in ArcGIS Workflow Manager Questions https://community.esri.com/t5/arcgis-workflow-manager-questions/jtx-wmx-error-solution-could-not-load-data-from/m-p/133444#M276 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS Desktop 10 SP2</SPAN><BR /><SPAN>Military overlay editor 10 SP2 </SPAN><BR /><SPAN>Military Analyst 10 SP2</SPAN><BR /><SPAN>Production Mapping 10 SP2/Patch1</SPAN><BR /><SPAN>Data Reviewer 10 SP2/Patch1</SPAN><BR /><SPAN>Defense Mapping 10 SP2/Patch 1</SPAN><BR /><SPAN>Workflow Manager 10 SP2</SPAN><BR /><SPAN>Task Assistant Manager 10 SP1</SPAN><BR /><BR /><SPAN>Database: Oracle 11g R2</SPAN><BR /><SPAN>Server: Windows Server 2008 R2</SPAN><BR /><BR /><SPAN>Problem: Cannot open attribute table (from job in jtx/wmx).&nbsp; Cannot reconcile version (from job in jtx/wmx).&nbsp; Cannot delete user from (jtx/wmx) Workflow Manager Administrator or (jtx/wmx) workspace in ArcCatalog.</SPAN><BR /><BR /><SPAN>Below is an example of the issue.</SPAN><BR /><BR /><SPAN>Ex. Problem</SPAN><BR /><BR /><SPAN>(ADDING JTX/WMX USERS)</SPAN><BR /><BR /><SPAN>Add User A</SPAN><BR /><SPAN>Add User B (corrupt) (user will not be able to open attribute table/reconcile)</SPAN><BR /><SPAN>Add User C</SPAN><BR /><SPAN>Add User D</SPAN><BR /><SPAN>Add User E</SPAN><BR /><BR /><SPAN>Test</SPAN><BR /><BR /><SPAN>Try to delete user B (corrupt) in workflow manager administrator or arccatalog.</SPAN><BR /><BR /><SPAN>Result</SPAN><BR /><BR /><SPAN>CANNOT delete user B (corrupt) in workflow manager administrator or arccatalog. User persists.</SPAN><BR /><SPAN>________________</SPAN><BR /><SPAN>________________</SPAN><BR /><BR /><SPAN>Solution to delete corrupt user (User B)</SPAN><BR /><BR /><SPAN>Remove users in the opposite order they were added.</SPAN><BR /><BR /><SPAN>Delete User E (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><SPAN>Delete User D (Close workspace in&nbsp; Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><SPAN>Delete User C (Close workspace in&nbsp; Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><BR /><SPAN>Delete User B (corrupt) (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted) - Corrupt user will now be deleted</SPAN><BR /><SPAN>_________________</SPAN><BR /><BR /><SPAN>This problem has persisted through all JTX/WMX versions including Workflow Manager 10 SP2.&nbsp; Also leaves remnants in JTX tables. </SPAN><BR /><BR /><SPAN>NOTES: No idea what corrupts the user.</SPAN></BODY></HTML> Wed, 19 Oct 2011 18:57:00 GMT CraigMark 2011-10-19T18:57:00Z JTX/WMX - Error - Solution - Could not load data from data source. https://community.esri.com/t5/arcgis-workflow-manager-questions/jtx-wmx-error-solution-could-not-load-data-from/m-p/133444#M276 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS Desktop 10 SP2</SPAN><BR /><SPAN>Military overlay editor 10 SP2 </SPAN><BR /><SPAN>Military Analyst 10 SP2</SPAN><BR /><SPAN>Production Mapping 10 SP2/Patch1</SPAN><BR /><SPAN>Data Reviewer 10 SP2/Patch1</SPAN><BR /><SPAN>Defense Mapping 10 SP2/Patch 1</SPAN><BR /><SPAN>Workflow Manager 10 SP2</SPAN><BR /><SPAN>Task Assistant Manager 10 SP1</SPAN><BR /><BR /><SPAN>Database: Oracle 11g R2</SPAN><BR /><SPAN>Server: Windows Server 2008 R2</SPAN><BR /><BR /><SPAN>Problem: Cannot open attribute table (from job in jtx/wmx).&nbsp; Cannot reconcile version (from job in jtx/wmx).&nbsp; Cannot delete user from (jtx/wmx) Workflow Manager Administrator or (jtx/wmx) workspace in ArcCatalog.</SPAN><BR /><BR /><SPAN>Below is an example of the issue.</SPAN><BR /><BR /><SPAN>Ex. Problem</SPAN><BR /><BR /><SPAN>(ADDING JTX/WMX USERS)</SPAN><BR /><BR /><SPAN>Add User A</SPAN><BR /><SPAN>Add User B (corrupt) (user will not be able to open attribute table/reconcile)</SPAN><BR /><SPAN>Add User C</SPAN><BR /><SPAN>Add User D</SPAN><BR /><SPAN>Add User E</SPAN><BR /><BR /><SPAN>Test</SPAN><BR /><BR /><SPAN>Try to delete user B (corrupt) in workflow manager administrator or arccatalog.</SPAN><BR /><BR /><SPAN>Result</SPAN><BR /><BR /><SPAN>CANNOT delete user B (corrupt) in workflow manager administrator or arccatalog. User persists.</SPAN><BR /><SPAN>________________</SPAN><BR /><SPAN>________________</SPAN><BR /><BR /><SPAN>Solution to delete corrupt user (User B)</SPAN><BR /><BR /><SPAN>Remove users in the opposite order they were added.</SPAN><BR /><BR /><SPAN>Delete User E (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><SPAN>Delete User D (Close workspace in&nbsp; Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><SPAN>Delete User C (Close workspace in&nbsp; Catalog or workflow manager administrator - Reopen to verify user is deleted)</SPAN><BR /><BR /><SPAN>Delete User B (corrupt) (Close workspace in Catalog or workflow manager administrator - Reopen to verify user is deleted) - Corrupt user will now be deleted</SPAN><BR /><SPAN>_________________</SPAN><BR /><BR /><SPAN>This problem has persisted through all JTX/WMX versions including Workflow Manager 10 SP2.&nbsp; Also leaves remnants in JTX tables. </SPAN><BR /><BR /><SPAN>NOTES: No idea what corrupts the user.</SPAN></BODY></HTML> Wed, 19 Oct 2011 18:57:00 GMT https://community.esri.com/t5/arcgis-workflow-manager-questions/jtx-wmx-error-solution-could-not-load-data-from/m-p/133444#M276 CraigMark 2011-10-19T18:57:00Z Re: JTX/WMX - Error - Solution - Could not load data from data source. https://community.esri.com/t5/arcgis-workflow-manager-questions/jtx-wmx-error-solution-could-not-load-data-from/m-p/133445#M277 <HTML><HEAD></HEAD><BODY><SPAN>Hi Craig,</SPAN><BR /><BR /><SPAN>Thank you for reporting this issue, it is a bug in the application and it seems to be resolved at service pack 3 of ArcGIS Workflow Manager. </SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Tope</SPAN></BODY></HTML> Wed, 26 Oct 2011 20:48:45 GMT https://community.esri.com/t5/arcgis-workflow-manager-questions/jtx-wmx-error-solution-could-not-load-data-from/m-p/133445#M277 TopeBello 2011-10-26T20:48:45Z