Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: something changed and broke script
Started 1 month ago by iGGt
A bit of a strange query this. I have a script that has been running fine for about three months now without any error. But on Friday evening, part of it stopped working. When I looked into it on Monday morning I found I was getting the error: "MSG 298: LEVEL 16: STATE 1: LINE 47: The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error"...
Site: Microsoft TechNet Forums  Microsoft TechNet Forums - site profile
Forum: Getting started with SQL Server  Getting started with SQL Server - forum profile
Total authors: 2 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

TiborK replied 1 month ago
Probably some value in the wa.wty_start_dt column which doesn't look like a string which can be converted to smalldatetime.
Size: 142 bytes
Customize:  Customize "<b>Reply 1</b>: something changed and broke script :: Getting started with SQL Server :: Microsoft TechNet Forums"

iGGt replied 1 month ago
You're quite right. It had a start date of '2207-07-07 00:00:00.000' which it couldn't convert to a smalldatettime data type. Although strangely it was happy enough with '2012-09-12 00:00:00.000'
Size: 221 bytes
Customize:  Customize "<b>Reply 2</b>: something changed and broke script :: Getting started with SQL Server :: Microsoft TechNet Forums"

TiborK replied 1 month ago
'2012-09-12 00:00:00.000' is a valid smalldatetime value - it isn't out-of-range. Year 2207 isn't valid for smalldatetime.
Size: 141 bytes
Customize:  Customize "<b>Reply 3</b>: something changed and broke script :: Getting started with SQL Server :: Microsoft TechNet Forums"

iGGt replied 1 month ago
Yeah, I just looked it up, and Smalldatetimes can't be larger than '2079-06-06' You learn something new every day.
Size: 153 bytes
Customize:  Customize "<b>Reply 4</b>: something changed and broke script :: Getting started with SQL Server :: Microsoft TechNet Forums"

 

Top contributing authors

Name
Posts
iGGt
3
user's latest post:
something changed and broke script
Published (2009-11-10 11:21:00)
A bit of a strange query this. I have a script that has been running fine for about three months now without any error. But on Friday evening, part of it stopped working. When I looked into it on Monday morning I found I was getting the error: &quot;MSG 298: LEVEL 16: STATE 1: LINE 47: The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error&quot; I have found the problem and worked...
TiborK
2
user's latest post:
something changed and broke script
Published (2009-11-10 10:10:00)
'2012-09-12 00:00:00.000' is a valid smalldatetime value - it isn't out-of-range. Year 2207 isn't valid for smalldatetime.

Related threads on "Microsoft TechNet Forums":

Something changed in Microsoft ActiveSync Exchange 2007 -...  Microsoft TechNet Forums - site profile Mobility - forum profile Something changed in Microsoft ActiveSync Exchange 2007 - was working then quit - please help!
Something changed in Microsoft ActiveSync Exchange 2007 - was working then quit - please help!
802.1x dynamic VLAN - user logon script is broken while...  Microsoft TechNet Forums - site profile Network Access Protection - forum profile 802.1x dynamic VLAN - user logon script is broken while client VLAN is changed
802.1x dynamic VLAN - user logon script is broken while client VLAN is changed
Yesterday's update, KB973904 Broke our login script for...  Microsoft TechNet Forums - site profile The Official Scripting Guys Forum! - forum profile Yesterday's update, KB973904 Broke our login script for Outlook signature generation!
Yesterday's update, KB973904 Broke our login script for Outlook signature generation!
Something like substring( ) in script task?  Microsoft TechNet Forums - site profile SQL Server Integration Services - forum profile Something like substring( ) in script task?
Something like substring( ) in script task?
Anybody have a script or something to automatic configure...  Microsoft TechNet Forums - site profile Deploy - forum profile Anybody have a script or something to automatic configure proxy exchange?
Anybody have a script or something to automatic configure proxy exchange?
RDC - something has changed, need help with new settings  Microsoft TechNet Forums - site profile Terminal Services - forum profile RDC - something has changed, need help with new settings
RDC - something has changed, need help with new settings
Powershell script and bat script  Microsoft TechNet Forums - site profile Windows Vista Security - forum profile Powershell script and bat script
Powershell script and bat script
Difference between script task and script component  Microsoft TechNet Forums - site profile SQL Server Integration Services - forum profile Difference between script task and script component
Difference between script task and script component

Related threads on other sites:

@ orbitcast looks like a script issue with your site....  Twitter / nrs - site profile nrs - forum profile @ orbitcast looks like a script issue with your site. MT had some maint last night, maybe something changed? PS I'd love to write for you 9:45 AM Aug 5th from Echofon
@ orbitcast looks like a script issue with your site. MT had some maint last night, maybe something changed? PS I'd love to write for you 9:45 AM Aug 5th from Echofon
Still can't get GMail on my PSP. They changed (broke)...  Twitter / Punterjoe - site profile Joe Plett - forum profile Still can't get GMail on my PSP. They changed (broke) something. -scowl- about 8 hours ago from mobile web
Still can't get GMail on my PSP. They changed (broke) something. -scowl- about 8 hours ago from mobile web
Still can't get GMail on my PSP. They changed (broke)...  Twitter / Punterjoe - site profile Joe Plett - forum profile Still can't get GMail on my PSP. They changed (broke) something. -scowl- 08:29 AM July 31, 2008 from mobile web
Still can't get GMail on my PSP. They changed (broke) something. -scowl- 08:29 AM July 31, 2008 from mobile web
Something changed on Twitter's end today and suddenly...  Twitter / iTweet - site profile iTweet.net - forum profile Something changed on Twitter's end today and suddenly broke all posts from iTweet. I just uploaded a fix and iTweet is BACK, yay! 10:24 PM Dec 23rd, 2008 from iTweet
Something changed on Twitter's end today and suddenly broke all posts from iTweet. I just uploaded a fix and iTweet is BACK, yay! 10:24 PM Dec 23rd, 2008 from iTweet
Désolé pour le spam... j'ai changer le script pour...  ganime - Identi.ca - site profile ganime - forum profile Désolé pour le spam... j'ai changer le script pour identi.ca/twitter ~~ Sorry for the spam, I changed the script for identi.ca/twitter .
Désolé pour le spam... j'ai changer le script pour identi.ca/twitter ~~ Sorry for the spam, I changed the script for identi.ca/twitter .
# Hostgator Network : Has something changed on...  hostgator - Identi.ca - site profile hostgator - forum profile # Hostgator Network : Has something changed on Infinity http://www.hostingcoupons.org/hostgator-network-has-something-changed-on-infinity/ Published about 3 months ago From web
# Hostgator Network : Has something changed on Infinity http://www.hostingcoupons.org/hostgator-network-has-something-changed-on-infinity/ Published about 3 months ago From web
What scene from the old leaked script do you want...  IMDB - Halloween (2007) - site profile Halloween (2007) - forum profile What scene from the old leaked script do you want changed.../ New script
What scene from the old leaked script do you want changed.../ New script
Mounting storage to remote ESX hosts. This is something I...  Twitter / 7_7 - site profile Mark Hughes - forum profile Mounting storage to remote ESX hosts. This is something I should script, but developing a script will take longer than doing it manually. 7:13 PM Oct 26th from web
Mounting storage to remote ESX hosts. This is something I should script, but developing a script will take longer than doing it manually. 7:13 PM Oct 26th from web
Something changed, and i wasn't the one who changed it....  Twitter / annaecraft - site profile annaecraft - forum profile Something changed, and i wasn't the one who changed it. miss you. 4:38 PM Sep 6th from web
Something changed, and i wasn't the one who changed it. miss you. 4:38 PM Sep 6th from web
The dryer broke. Finally, something expensive broke....  Twitter / Danielzilla - site profile Danielzilla - forum profile The dryer broke. Finally, something expensive broke. I've been waiting long enough. 9:42 PM May 9th from web
The dryer broke. Finally, something expensive broke. I've been waiting long enough. 9:42 PM May 9th from web
Thread profile page for "something changed and broke script" on http://social.technet.microsoft.com. This report page is a snippet summary view from a single thread "something changed and broke script", located on the Message Board at http://social.technet.microsoft.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity