I was looking for the Hall of Shame
-
Three months ago, we launched a new Azure web application for a client. The application generates around 500 records (or one for every employee) in a particular table every workday. In the main processing page, if a daily record already exists for an employee, the record id was passed in with this code:
intRecID = CShort(Request("current_daily_rec_id").ToString)
The application ran just fine until this morning when all hell broke loose! I had it fixed and posted within an hour of the first incident, but only after recording over 240 errors! :sigh:
"Go forth into the source" - Neal Morse
-
Three months ago, we launched a new Azure web application for a client. The application generates around 500 records (or one for every employee) in a particular table every workday. In the main processing page, if a daily record already exists for an employee, the record id was passed in with this code:
intRecID = CShort(Request("current_daily_rec_id").ToString)
The application ran just fine until this morning when all hell broke loose! I had it fixed and posted within an hour of the first incident, but only after recording over 240 errors! :sigh:
"Go forth into the source" - Neal Morse
What happened? An overflow?
What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???
-
What happened? An overflow?
What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???
-
Yep! Average 20 working days a month and a little over 3 months times the 500 records a day comes out to about 32,767 or so...now, I should be good for another 18,000 years or so. :laugh:
"Go forth into the source" - Neal Morse
Oops! :laugh:
What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???
-
What happened? An overflow?
What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???
A similar thing happened quite a few years ago on a system on of our clients had from a different supplier, which was an Access database - they started getting numeric overflow errors and the original supplier wanted lots of time and money to investigate and fix the problem as it was out of paid support. I asked the user if there were 32,767 records in the main table and he was astonished at my correct guess. I changed the autonumber column in the main table from a short integer to a long integer and said that he could buy me a pint on my next site visit. Lots of brownie points were also awarded by the client.
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
Three months ago, we launched a new Azure web application for a client. The application generates around 500 records (or one for every employee) in a particular table every workday. In the main processing page, if a daily record already exists for an employee, the record id was passed in with this code:
intRecID = CShort(Request("current_daily_rec_id").ToString)
The application ran just fine until this morning when all hell broke loose! I had it fixed and posted within an hour of the first incident, but only after recording over 240 errors! :sigh:
"Go forth into the source" - Neal Morse
I had to fix a similar issue back in the 90s, when the table of accounts in our database exceeded the number we could import to an Excel sheet (16384?). :doh:
-
Three months ago, we launched a new Azure web application for a client. The application generates around 500 records (or one for every employee) in a particular table every workday. In the main processing page, if a daily record already exists for an employee, the record id was passed in with this code:
intRecID = CShort(Request("current_daily_rec_id").ToString)
The application ran just fine until this morning when all hell broke loose! I had it fixed and posted within an hour of the first incident, but only after recording over 240 errors! :sigh:
"Go forth into the source" - Neal Morse
-
A similar thing happened quite a few years ago on a system on of our clients had from a different supplier, which was an Access database - they started getting numeric overflow errors and the original supplier wanted lots of time and money to investigate and fix the problem as it was out of paid support. I asked the user if there were 32,767 records in the main table and he was astonished at my correct guess. I changed the autonumber column in the main table from a short integer to a long integer and said that he could buy me a pint on my next site visit. Lots of brownie points were also awarded by the client.
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
:cool:
What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???