Problem Note 58939: The error "ORA-00060: deadlock detected while waiting for resource" might occur in SAS® Pack Optimization
 |  |  |  |  |
In Size Profiling, you might experience slow response times and the following error might occur in the middle-tier log:
[tomcat-http--29-2345] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00060: deadlock detected while waiting for resource
[tomcat-http--29-2345] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
. . .more message lines. . .
This issue is likely to occur when there are many projects using store grouping rules.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.41 | 9.3 TS1M2 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 3.2_M4 | 3.41 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Linux for x64 | 3.2_M4 | 3.41 | 9.3 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#58939A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#58939A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#58939| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2016-09-28 09:01:46 |
| Date Created: | 2016-09-07 13:52:31 |