Error processing command:DfIOException:: THREAD: http-8080-6; MSG: [DM_SESSION_E_RPC_ERROR]error: "
I have tried to fix an issue wrt the workfow workqueue I have been in the final verge of finishing the acquired-assigned work-items tasks in the mv_ais_location_coding_queue from the taskspace app, through legacy prod DA DQL/API
To fix the AIS-app check in case failed issue.
Also, the first thing we he showed me was accessing AIS via TaskSpace via this link:
We logged in using the admin account to our docbase.
Selecting the Queue Management tab then the All Work Queues from the drop down on the far right, we double-clicked the mv_ais_manual_location_queue.
In the new list we first selected Items per Page from 10 to 100 and did a sort by selecting the Status column to bubble up all Assigned items, did CNTRL-A (select all) then using the mouse, chose the button on the right and selected unassign from the popup menu.
We received an error which is indicative that the when the system was updating workflow or queue items, the process did not complete (please don’t actually try to reset the status).
As a result, though the items are listed as being assigned, they are not actually assigned.
Step 1 I have Built a Dynamic DQL statement that selects the impacted objects …. Dynamic SQL is basically command text or string combined with the data you are selecting to form a command in the result set.
**Notice the predicate clause only selects Location Coding workflows and activities with a r_runtime_state = 1 *** My counts match the total records that they state are assigned.
select 'complete,c,' + wi.r_object_id from dm_workflow w, dmi_workitem wi, dm_activity ac where w.r_object_id = wi.r_workflow_id and wi.r_act_def_id = ac.r_object_id and wi.r_workflow_id in (select r_object_id from dm_workflow) and w.object_name like 'Loc%' and wi.r_runtime_state =1
The above Dynamic statement when dumped out to a text file produces the results in the attached file complete.txt, this is what is ran in step 2
Step 2 I have Run the dynamic command. This command is complete,c, which completes the selected work items that are currently acquired.
I have used DA & Documentum Server Manager IAPI to execute this command,
However I’m encountering the error “Error processing command:DfIOException:: THREAD: http-8080-6; MSG: [DM_SESSION_E_RPC_ERROR]error: "Server communication failure"; ERRORCODE: 100; NEXT: null”
I have even tried to execute this API command through IAPI on Documentum Server Manager Console on Legacy Prod CS but encountered the same and [DM_SESSION_Ideadlock_retry]:Retrying Server Operation following a DBMS Deadlock Error
com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient Deadlock reported by server connection = 0102134180fe40.
DCTM_GURU kindly throw some light to fix this high impack prod issue.
Appreciate your timely response.
Thanks & Warm Regards,