Database Licensing Error on Maxim Integrated Circuits Site
The following error message came up on the Maxim-IC site while searching for information on a particular Maxim product (the "DS1624" chip, if you look at the SQL code below).
It looks like, unfortunately, the site was only tested at a load of 10 users or fewer. We used the production/live site in a "real world" situation where more than 10 users happened to be accessing the site simultaneously. We weren't one of the lucky first 10 users in, so we, along with the 11th, 12th, 13th, etc. users all received the ugly, ugly error message found below.
Surely the database backing this site should be of the enterprise class, not the 10-user standard edition!
This problem would have been caught in performance, load, stress testing and possibly in functional testing.
Note: we currently aren't fortunate enough to count Maxim as a client (not yet, anyway :-). A Testware employee happened upon this error while using the Maxim site on a hobbyist basis.
Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC SQL Server Driver][SQL Server]Login failed. The maximum simultaneous user count of 10 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version. SQL = "SELECT FAMILIES.FAMILY_NAME as FAMILY_NAME, FAMILIES.FAMILY_SHORT_NAME FROM FAMILIES WHERE FAMILIES.FAMILY_ID IN ( SELECT FAMILY_ID FROM PRODUCTS WHERE PRODUCT_NUMBER IN ('0' ,'DS1624') )" Data Source = "PARAMETRIC_SQL_SERVER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (580:2) to (580:74) in the template file /usr/local/apache/htdocs/quick_view2.cfm. Date/Time: Thu Jul 19 06:23:12 2001 |
Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator).