Aptean Pivotal CRM 5.9 and 6.6 - Common error when calling Pivotal API Tester

Aptean Pivotal CRM 5.9 and 6.6 - Common error when call Pivotal API Tester 

Nghia Song

Tel - WhatsApp: +84967324794

Email: songnghia.uit@gmail.com 

We got an error when calling the Pivotal API tester.

 

 

 

=> Maybe conflict in query 

 

==> Abby clear the query

 

 

After that, we got another error

 

 

 

Try to call query and I think we have deadlock

 

 

 

Abby do some  query to check deadlock

 

SELECT resource_type, resource_associated_entity_id,

request_status, request_mode,request_session_id,

resource_description, o.object_id, o.name, o.type_desc

FROM sys.dm_tran_locks l, sys.objects o

WHERE l.resource_associated_entity_id = o.object_id

and resource_database_id = DB_ID()

 

 

And then kill query

 

=> Now, it is okay