Projects being duplicated and permissions being lost

OpenRPA
1

Good afternoon,

I’ve been experiencing an issue recently: I created some projects under the admin user and granted read and invoke permissions to a non-admin user. I have OpenRPA installed on a machine logged in with this non-admin user. From time to time, projects are being duplicated (another project with the same name is created, but I can differentiate it by the user information who created it, as it’s created by the user logged into the machine). Additionally, the user loses permissions on the original project. I tested disabling local caching, but it’s not helping. What could be the issue?

2

I have seem this once becore.
Are hou actively using the impersonation feature?
If so, make aure ‘persist_user_impersonation’ is set to false.
When this is true, impersonation is saved on the user an affects all sessions for that user, when false, it only affect the browser session doing it.

3

I dont know what the impersonation feature is. I just installed the openrpa and enabled is_agent.

4

Ok, that is not the problem then.

Strange. Does the robot see duplicates too, or only the admin?

5

It’s duplicate for both users. The “new” project has the same name and its creator is the user active on that agent. At the same time that user loses the permission from the “original” project.

6

I noticed that even on the occasions when I open OpenRPA and the projects don’t duplicate, several errors are recorded in the log. I also observed that it performs an insertOrUpdateOne… Could it be that the project isn’t duplicating because, for some reason, it didn’t find the shared project?

I can send the log again as soon as the problem happens again.

[15:26:41.408][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:41.401][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:41.400][Error] OpenRPA.Interfaces.SocketException: server error: {"message":"Access denied, no authorization to UpdateOne project Operacoes em Arquivos to database","error":"Access denied, no authorization to UpdateOne project Operacoes em Arquivos to database"}
   at OpenRPA.Net.SocketCommand.<SendMessage>d__24`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at OpenRPA.Net.WebSocketClient.<InsertOrUpdateOne>d__76`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at OpenRPA.LocallyCached.<Save>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at OpenRPA.Project.<Save>d__52.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at OpenRPA.RobotInstance.<LoadServerData>d__72.MoveNext()
[15:26:41.399][Network] Processing message mfauan7mr complete
[15:26:41.398][Network] (1) error RESC: 67127ae0-febc-4d8b-b7dc-e95bb09b7af7/mfauan7mr
[15:26:41.398][Network] Processing message mfauan7mr
[15:26:41.245][Network] Send (1) insertorupdateone / {"w":0,"j":false,"uniqeness":null,"item":{"dependencies":null,"disable_local_caching":false,"save_output":false,"send_output":false,"Filename":"Operacoes_em_Arquivos.rpaproj","_id":"6617d497f6d722dcb87ac43b","_type":"project","name":"Operacoes em Arquivos","_modified":"2024-08-22T15:22:29.976-03:00","_modifiedby":"julio@prestobr.com","_modifiedbyid":"66a11c5ee499ba628c24377f","_created":"2024-07-31T16:44:30.928-03:00","_createdby":"julio@htfapps.com","_createdbyid":"66a11c5ee499ba628c24377f","_acl":[{"deny":null,"rights":65535,"_id":"5a1702fa245d9013697656fb","name":"admins"},{"deny":null,"rights":65523,"_id":"66aa79414a2c314829869fff","name":"Desenvolvedores"},{"deny":null,"rights":65523,"_id":"66acc5de9203e3829b308e05","name":"RAF Contabilidade"},{"deny":null,"rights":65523,"_id":"66ad0a7f9203e3829b308ef2","name":"Herculano"},{"deny":null,"rights":65523,"_id":"66ad0a9d9203e3829b308ef7","name":"Repromaq"}],"_encrypt":null,"_version":185},"collectionname":"openrpa","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:41.245][Network] (1) insertorupdateone SEND: 67127ae0-febc-4d8b-b7dc-e95bb09b7af7
[15:26:41.244][Network] Processing message 7chiy2wce complete
[15:26:41.244][Network] (1) query RESC: 281947df-8117-457a-8e3e-d6e92e1fa474/7chiy2wce
[15:26:41.243][Network] Processing message 7chiy2wce
[15:26:41.091][Network] Send (1) query / {"query":{"_type":"project"},"projection":"{\"_version\": 1}","queryas":null,"top":50,"skip":0,"orderby":null,"collectionname":"openrpa","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:41.091][Network] (1) query SEND: 281947df-8117-457a-8e3e-d6e92e1fa474
[15:26:41.090][Debug] query project versions
[15:26:41.089][Debug] query project versions
[15:26:41.089][Debug] LoadServerData::query project versions
[15:26:41.089][Debug] LoadServerData::begin
[15:26:41.088][Debug] LoadServerData::end
[15:26:41.088][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:41.080][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:41.080][Error] OpenRPA.Interfaces.SocketException: server error: {"message":"Access denied, no authorization to UpdateOne project ControlID to database","error":"Access denied, no authorization to UpdateOne project ControlID to database"}
   at OpenRPA.Net.SocketCommand.<SendMessage>d__24`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at OpenRPA.Net.WebSocketClient.<InsertOrUpdateOne>d__76`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at OpenRPA.LocallyCached.<Save>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at OpenRPA.Project.<Save>d__52.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at OpenRPA.RobotInstance.<LoadServerData>d__72.MoveNext()
[15:26:41.076][Network] Processing message 30429oqzw complete
[15:26:41.076][Network] (1) error RESC: 252562f0-9959-4d24-80b8-f6e499ed02b6/30429oqzw
[15:26:41.075][Network] Processing message 30429oqzw
[15:26:40.924][Network] Send (1) insertorupdateone / {"w":0,"j":false,"uniqeness":null,"item":{"dependencies":null,"disable_local_caching":false,"save_output":false,"send_output":false,"Filename":"ControlID.rpaproj","_id":"6634ca84a752787b8f3d028f","_type":"project","name":"ControlID","_modified":"2024-08-22T15:19:44.338-03:00","_modifiedby":"julio@prestobr.com","_modifiedbyid":"66a11c5ee499ba628c24377f","_created":"2024-07-31T17:07:24.928-03:00","_createdby":"julio@htfapps.com","_createdbyid":"66a11c5ee499ba628c24377f","_acl":[{"deny":null,"rights":65535,"_id":"5a1702fa245d9013697656fb","name":"admins"},{"deny":null,"rights":65523,"_id":"66aa79414a2c314829869fff","name":"Desenvolvedores"},{"deny":null,"rights":65523,"_id":"66ad0a7f9203e3829b308ef2","name":"Herculano"}],"_encrypt":null,"_version":47},"collectionname":"openrpa","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:40.923][Network] (1) insertorupdateone SEND: 252562f0-9959-4d24-80b8-f6e499ed02b6
[15:26:40.905][Network] Processing message 2azjmaxec complete
[15:26:40.905][Network] (1) query RESC: 8af79cff-27c4-471c-8cbd-376b4df82307/2azjmaxec
[15:26:40.904][Network] Processing message 2azjmaxec
[15:26:40.751][Network] Send (1) query / {"query":{"_type":"project"},"projection":"{\"_version\": 1}","queryas":null,"top":50,"skip":0,"orderby":null,"collectionname":"openrpa","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:40.750][Network] (1) query SEND: 8af79cff-27c4-471c-8cbd-376b4df82307
[15:26:40.746][Debug] query project versions
[15:26:40.746][Debug] query project versions
[15:26:40.745][Debug] LoadServerData::query project versions
[15:26:40.745][Debug] LoadServerData::begin
[15:26:40.731][Network] Processing message ocy0f7npt complete
[15:26:40.723][Network] (1) watch RESC: 63632af0-d959-44ba-a5d6-b90127e75d19/ocy0f7npt
[15:26:40.723][Network] Processing message ocy0f7npt
[15:26:40.584][Network] Send (1) watch / {"id":null,"collectionname":"mq","aggregates":["$.[?(@ && @._type == 'workitemqueue')]"],"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:40.583][Network] (1) watch SEND: 63632af0-d959-44ba-a5d6-b90127e75d19
[15:26:40.582][Network] Processing message zhcds16e6 complete
[15:26:40.582][Network] (1) watch RESC: bddea212-7fa2-4690-81b7-deec2ada9524/zhcds16e6
[15:26:40.581][Network] Processing message zhcds16e6
[15:26:40.441][Network] Send (1) watch / {"id":null,"collectionname":"openrpa","aggregates":["$.[?(@ && @._type == 'workflow')]","$.[?(@ && @._type == 'project')]","$.[?(@ && @._type == 'detector')]"],"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:40.441][Network] (1) watch SEND: bddea212-7fa2-4690-81b7-deec2ada9524
[15:26:40.013][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:40.013][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:40.012][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:40.012][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:40.007][Debug] loading detectors
[15:26:40.006][Debug] loading detectors
[15:26:38.692][Debug] Creating main window
[15:26:38.677][Network] Processing message 2mfwhbubx complete
[15:26:38.676][Network] (1) query RESC: bb991a80-248e-44ff-9797-1cd4fb256a04/2mfwhbubx
[15:26:38.676][Network] Processing message 2mfwhbubx
[15:26:38.529][Network] Send (1) query / {"query":{"_id":"5a17f157c4815318c8536c21"},"projection":null,"queryas":null,"top":50,"skip":0,"orderby":null,"collectionname":"users","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:38.528][Network] (1) query SEND: bb991a80-248e-44ff-9797-1cd4fb256a04
[15:26:38.526][Network] Processing message zj9qugbug complete
[15:26:38.525][Network] (1) query RESC: 0f5b32c6-5498-4b30-b2a7-a623e123ce46/zj9qugbug
[15:26:38.525][Network] Processing message zj9qugbug
[15:26:38.377][Network] Send (1) query / {"query":{"_id":"66ad0a7f9203e3829b308ef2"},"projection":null,"queryas":null,"top":50,"skip":0,"orderby":null,"collectionname":"users","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:38.377][Network] (1) query SEND: 0f5b32c6-5498-4b30-b2a7-a623e123ce46
[15:26:38.363][Network] Processing message f0lgsydiu complete
[15:26:38.362][Network] (1) query RESC: f28dd90f-cfdd-47e3-80ff-83c230c52467/f0lgsydiu
[15:26:38.362][Network] Processing message f0lgsydiu
[15:26:38.215][Network] Send (1) query / {"query":{"_id":"5b6ab63c8d4a64b7c47f4a8f"},"projection":null,"queryas":null,"top":50,"skip":0,"orderby":null,"collectionname":"users","result":null,"traceId":"","spanId":"","error":null,"jwt":null}
[15:26:38.215][Network] (1) query SEND: f28dd90f-cfdd-47e3-80ff-83c230c52467
[15:26:38.204][Network] Processing message q7blx44dz complete
[15:26:38.203][Network] (1) registerqueue RESC: a259bfdb-0620-4d6f-878a-15f8689f7e57/q7blx44dz
[15:26:38.203][Network] Processing message q7blx44dz
[15:26:38.043][Network] Send (1) registerqueue / {"queuename":"66bdf5ee470e695cee8f8a80","traceId":"","spanId":"","error":null,"jwt":null}
[15:26:38.043][Network] (1) registerqueue SEND: a259bfdb-0620-4d6f-878a-15f8689f7e57
[15:26:38.042][Debug] Registering queue for robot 66bdf5ee470e695cee8f8a80
[15:26:38.041][Debug] Registering queues
[15:26:38.039][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:38.039][Debug] RobotInstance_WebSocketClient_OnOpen::end 00:00.222
[15:26:38.038][Debug] Connected to wss://openflow.prestobr.com/ as someemail@email.com.br
[15:26:38.038][Debug] Signed in as someemail@email.com.br 00:00.221
[15:26:38.029][Network] Processing message nl1ltbe6s complete
[15:26:38.029][Network] (1) signin RESC: 240964bb-7ee2-48cb-ad4e-b11346ee8fd0/nl1ltbe6s
[15:26:38.027][Network] Processing message nl1ltbe6s
[15:26:37.845][Network] Send (1) signin / {"validate_only":false,"longtoken":false,"username":null,"password":null,"user":null,"websocket_package_size":0,"clientagent":"openrpa","clientversion":"1.4.57","openflow_uniqueid":"","enable_analytics":true,"otel_trace_url":"","otel_metric_url":"","otel_trace_interval":0,"otel_metric_interval":0,"traceId":"","spanId":"","error":null,"jwt":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjp7Il9pZCI6IjY2YmRmNWVlNDcwZTY5NWNlZThmOGE4MCJ9LCJpYXQiOjE3MjQyNTM5NzgsImV4cCI6MTc1NTc4OTk3OH0.-_TMMT7WTg6HC_CmEYqeHaMZrXzJAFOlHdfyhW7GUEY"}
[15:26:37.844][Network] (1) signin SEND: 240964bb-7ee2-48cb-ad4e-b11346ee8fd0
[15:26:37.818][Debug] Signing in with token 00:00.001
[15:26:37.817][Debug] Sign in to wss://openflow.prestobr.com/
[15:26:37.816][Debug] Connected to wss://openflow.prestobr.com/
[15:26:37.816][Debug] RobotInstance_WebSocketClient_OnOpen::begin 00:00.000
[15:26:37.801][Information] Connected to wss://openflow.prestobr.com/
[15:26:37.299][Network] Connecting to wss://openflow.prestobr.com/
[15:26:37.290][Network] Connecting to wss://openflow.prestobr.com/
[15:26:37.288][Debug] Connecting to wss://openflow.prestobr.com/

type or paste code here
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.