This is likely dated material as I haven't had the chance to work with IPCelerate based solutions in years, but the following just helped me out of a jam. The issue was communication between a Status Solutions TAP paging interface, the IPCelerate IPSession server and ultimately Cisco 7925 handsets was delayed.
1. Open up Windows Service and stop the following services:
Apache Tomcat Tomcat5
Nipa
Nipads
2. Open command prompt and type osql -E
3. Then type the following commands
1> use nipa
2> backup log NIPA TO DISK ='NUL'
3> go
Note: This may take a few minutes before you receive a message similar to this:
Processed 33136 pages for database 'NIPA', file 'NIPA_log' on file 1.
BACKUP LOG successfully processed 33136 pages in 3.697 seconds (73.423 MB/sec).
4. Once you see this message type in the following.
1> dbcc loginfo(nipa)
2> go
This will display a long list and the far left column is where you will either see 0 or 2.
Example of 2: 2 5570560 224526336 200
0 64 1960000000961100001
Example of 0: 0 5570560 224526336 200
0 64 1960000000961100001
5. After running this wait about 5 minutes and then type exit to logout of the SQL.
6. Go to Windows Services and stop the MSSQLSERVER service.
7. Wait about 2 minutes and then Start the MSSQLSERVER service
8. repeat steps 2 through 4
9. No wait is needed this time, begin typing the following:
1> dbcc shrinkfile (NIPA_log,10)
2> go
Note: You should get the following message below with no errors.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
5 2 1303 128 1296 128
(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
!
! 1> dbcc shrinkfile (NIPA_log,10)
! 2> go
! Msg 8985, Level 16, State 1, Server IPCELERATE1, Line 1
! Could not locate file 'NIPA_log' in sysfiles.
! DBCC execution completed. If DBCC printed error messages, contact your system
! administrator.
10. Verify the NIAP_log.LDF file under C:\Program Files\Microsoft SQL Server\MSSQL\Data is rougly 10MB, if not repeat step 9 again.
11. Type the following to exit SQL:
1> exit
12. Start the following services in this order:
Apache Tomcat Tomcat5
Nipa
Nipads
No comments:
Post a Comment