sql server - Select query produces SqlDateTime overflow on valid dates -

-

i have problem: on simple select select * table sqldatetime overflow error randomly returned (few times works ok after error returned; after again works few times , after error returned again) - error occurs on same row (while using same connection) - if open , close mgmt studio, error occurs on different row.

exact error message is:

an error occured while executing batch. error message is: sqldatetime overflow. must between 1/1/1753 12:00:00 , 12/31/9999 11:59:59 pm.

table has 3 datetime columns:

  • dtcolumn1 - can null, without default value
  • dtcolumn2 - must not null, default value ('1800-01-01')
  • dtcolumn3 - can null, without default value

values in 3 datetime columns fine (null or inside of allowed interval).

table has other columns of varchar , other types. more select query fail more if add order 1 of 3 datetime columns (empiricaly tested).

collation of database slovenian_ci_ai.

what causing error (as said - datetime values seem ok)?

thank in advance!

edit 1 (2016-05-09): forgot mention previously: error happens in sql mgmt studio , code (using linq sql).

edit 2 (2016-05-10): seems there different problem - on every table more let's 10000 records throws silly error. on other table throws:

an error occurred while executing batch. error message is: internal connection fatal error.`

it disconnects me database (in bottom status row says disconnected). sql server installed on remote server inside of local network.

our admin found out, problem dne lightweight filter. if monster disabled works supposed (no random disconnects strange errors).

you can disable if go control panel / network , sharing center / change addapter settings. right click on network device , select properties. deselect dne lightweight filter.

link server fault, posted question when started believe network related problem.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more