TechNote (Archived)

SQL Server floating point exception causes “Request Not Processed” or "No Server Available" message when accessing meeting rooms

Issue

---

When trying to access a Breeze meeting room URL, a "Request Not Processed" or 'No Server Available" error message is thrown.

The same exception can be seen in the debug.log file that resides at C:\breeze\logs\support\debug.log. (Note: This path assumes that you installed Breeze on the C drive.)

 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver] [SQLServer]A floating point exception occurred in the user process. Current transaction is canceled. 

Reason

---

This floating point exception is caused by a limitation of Microsoft SQL Server, detailed in Microsoft support article 829444.

Solution

---

Shutdown Breeze by stopping the services in Microsoft Computer Management Console:

1. Right-click on My Computer and choose Manage from the menu.
2. Click on the + next to Services and Applications.
3. Select Services.
4. Stop the Macromedia Breeze Application service.
5. Stop the Flash Communication Server service.
6. Stop the Flash Communication Administration Server service.
7. Make a backup of your Breeze database. See TechNote 79895439 for instructions.

If you are running a stand-alone Microsoft SQL Server 2000:

Apply Microsoft SQL Server 2000 Service Pack 4 according to the instructions in the Microsoft support article.

If you are running the Embedded Database Engine:

Download Service Pack 4 for Microsoft SQL Server 2000 Desktop Engine (SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE) from this web page. Follow the instructions for installing the Service Pack included in the download package.

Note: Applying Service Pack 4 for Microsoft SQL Server may change the port for the Embedded Database Engine from 1434 to the default of 1433. You may use the svrnetcn.exe utility provided with the Embedded Database Engine to check the port it is listening on:

1. On the Breeze server, Click Start, and then Run. In the Open box, type svrnetcn.exe, and then click OK.
2. In the SQL Server Network Utility dialog box, click the General tab.
3. In the Enabled Protocols list box, click TCP/IP, and then click Properties.
4. The Default Port shows the port that the Embedded Database Engine is running on. Make sure this value matches the DB_PORT value in the Breeze custom.ini file. (If you change the Default Port value for the Embedded Database Engine, you must restart the MSSQLSERVER service in the Microsoft Computer Management console.)

Restart Breeze by starting the application services in the reverse order:

1. Start the Flash Communication Administration Server service.
2. Start the Flash Communication Server service.
3. Start the Macromedia Breeze Application service.

Search Support

---