An issue on Software Packages table

Mari2
Kilo Guru

‎05-10-2024 03:32 PM

Hello everyone,

 

I have an issue on Software Packages table.

 

I cannot open any records on the table (cmdb_ci_spkg). When I try to open a record, first it freeze the instance with the message 'Running transactions', and eventually white screen will be displayed. Wen I click ‘New’ button, the same symptom occurs. 

 

Mari2_0-1715379956059.png

Mari2_1-1715380045908.png

And this is a log's screenshot.Mari2_2-1715380250839.png

 

I believe this issue is most likely caused by one of the customizations I created in the past. But I could not find what is causing this issue. I checked ACL, Business rule, and client script, but I could not find anything with ‘cmdb_ci_spkg’ table. Could you please help me to trouble shoot this issue? Thank you!

0 Helpfuls
  • 523 Views
3 REPLIES 3

Community Alums
Not applicable

‎05-11-2024 06:22 AM

Hi @Mari2 ,

 

This looks like a performance Issue on the table.
There could be multiple reasons that could cause this the below are few things that you should consider validating-

First thing-

1. Disable Recent Changes: If there are any recent changes made related to this table, try rolling them back or disabling them temporarily to see if the issue resolves.

2. Test in Another Environment: If possible, validate in another environment where you can compare the performance of the table.

 

Secondly - Check the following 

  • ACLs : Double-check that no ACLs are impacting the cmdb_ci_spkg table. Disable one 
  • Business Rules: Recheck not only the direct cmdb_ci_spkg table but also any parent tables or related tables that could affect its behavior.
  • Client Scripts: Verify again for any scripts that might not directly reference cmdb_ci_spkg but could be impacting it through related tables or inherited scripts.
  • Transaction Logs: System Diagnostics>All Active Transactions : to see if specific transactions are taking unusually long when accessing this table.
  • UI Policies and UI Actions: These can also impact how forms and lists are loaded and might be causing issues.
  • Script Includes: Sometimes, script includes that are called on form load can cause performance issues.

Note: Try disabling BR and ACL one by one and keep checking by loading the table. 

 

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

 

Thanks & Regards,

Sanjay Kumar

0 Helpfuls

Mari2
Kilo Guru
In response to Community Alums

‎05-19-2024 05:46 PM

Hello Sanjay,

 

Thank you so much for your comment. There was no ACL, Business Rules, Client Scripts, UI Policies and UI Actions pointing to cmdb_ci_spkg table. I am the only admin for this instance, and I have never created any Script Include associated with cmdb_ci_spkg table.

 

System logs, which is indicating slow ACLs are always generated every time the issue is created. I disabled those ACLs just in case but still the issue continues. Could you please let me know if there is other suggestions? Thank you very much!

 

Mari2_0-1716165815103.png

 

0 Helpfuls

SK Chand Basha
Giga Sage
In response to Mari2

‎05-19-2024 08:08 PM

Hi @Mari2 

 

Could you please review the OAuth Util script to see if any changes were made, particularly regarding the OAuth refresh token? Previously, there might have been some commented-out code related to this. I noticed that you're not receiving the token as expected.

 

Make sure uncomment the code if it is commented .

 

And Navigate to Email Accounts and test connections.

 

Check this article as well it might be helpful
 
 
Mark it Helpful and Accept Solution!! If this helps you to understand.
 
 
 

 

 

0 Helpfuls