Is it possible to increase history tab timeouts in the PIM?
When you have a lot of products that tab gets an SQL timeout. I think this is reported several times, but we need a solution now.
It has been working a couple of times, but 99 times out of 100 we get a time out. Projects with less products don’t have this issue.
Litium version: 7.7.1
You can clean older audit logs in the BO Settings => Maintenance settings to get better performance and in older versions this you can do:
Use this query on a local DB first and try out:
DELETE Auditing.AuditTransaction FROM
Auditing.AuditTransaction AT
JOIN
Auditing.AuditTransactionItem ATI
ON
AT.SystemId = ATI.AuditTransactionSystemId
WHERE
AT.TransactionDateTimeUtc < DATEADD(MONTH, -3 , GETDATE())
AND
ATI.EntityType <> 'Litium.Security.AuthenticationService, Litium.Abstractions'
“-3” = Month back in time you want to delete
It will not delete Authentication rows.
Remember to restart the Application pool after.
Yea, there is a setting for that in back office. It’s set to 6 months. But that still causes timeouts. I can ask the customer, but i think they might want to keep some data atleast
system
Closed
September 21, 2021, 1:21pm
4
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.