![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: DB not opening - SQL error Topic Summary: SQL error in opening SA DB Created On: 27-Aug-2007 20:54 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
We are running SA v10.4. Just recently when I go to open our encyclopeida, the following message is displayed in the lower left status bar "The requested SQL action has timed out. Retrying 5 of -1." The number five iterates....starts at 1 and goes to 9.
Help? |
|
![]() |
|
![]() |
|
We are running SA v10.7
Most users seem to be getting the same message. Even remember getting the same message years ago and yet can find no information on the cause. Help? Any one out there? |
|
![]() |
|
![]() |
|
The DBA admin said: - No locks - No pressure on server - CPU usage is low - Current activity is low Telelogic advised that a possible cause is some one running a large report or a closed diagram is held as open (not closed properly). Get all users to log off and then temporarily take the database offline. This fixed it in our case. |
|
![]() |
|
![]() |
|
oh dear!
![]() ![]() ![]() Not again. Had to take the database offline 3 times in 2 days. The last time even took the catalog offline. Those already logged on were unable to save their work. Enough to infuriate some users and ruin my day. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.