Kendo UI Scheduler: The system encountered an overflow while converting to a date and time format

Working on a project using .NET MVC and the Kendo UI Scheduler, an open-source tool. The goal is to save, read, update, and delete events from the scheduler into the database using JavaScript.

Encountering some challenges in the process - when attempting to save an event to the database, this error occurs: "Failed to load resource: the server responded with a status of 500 (Internal Server Error) : System.Data.SqlServerCe.SqlCeException: An overflow occurred while converting to datetime."

Similarly, when trying to read from the database back into the scheduler, another error arises: "Uncaught TypeError: Cannot call method 'getTimezoneOffset' of null."

Despite searching online for solutions and thoroughly going through the Telerik Kendo UI Scheduler documentation, I am yet to find a resolution. Below is a snippet of the code being used:

MODEL

...

CONTROLLER

...

VIEW

...

If anyone has any insights on how to tackle these errors or has a working example to share, it would be greatly appreciated!

Database:

javascriptasp.net-mvckendo-uikendo-schedulerkendo-ui-mvc

Answer №1

It seems like your C# model is in good shape, but have you confirmed the SQL Types for your Start and End fields in the database? The error could be due to a mismatch between SQLServerCE and the C# view model. According to information from this blog post, the database structure (though for SQL Server 2012) appears as follows:

Answer №2

It appears that removing the following line resolves the issue:

timezone: "Etc/UTC";

The scheduler seems to be affected by this specific line.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Leveraging reframe.js to enhance the functionality of HTML5 video playback

I'm struggling with using the reframe.js plugin on a page that includes HTML5 embedded video. When I try to use my own video file from the same folder, it doesn't work as expected. While everything seems to be working in terms of the page loadin ...

javascriptjqueryhtml

Scroll the content of a div to the bottom using JavaScript

I'm facing a situation with my code: function scrollme(){ dh=document.body.scrollHeight ch=document.body.clientHeight if(dh>ch){ moveme=dh-ch window.scrollTo(0,moveme) } } However, I am looking for a way to make it scroll only within a specific d ...

javascripthtmlscroll

When using React, draggable components with input fields may lose their ability to receive focus when clicking on the input field

<Draggable axis="y" grid={[135,135]} onStop={this.handleStop} defaultPosition={{x: this.props.task.positionX, y: this.props.task.positionY,}}> <div id="edit-task-component"> <form onSubmit={this.handleSubmit} id=" ...

javascriptreactjsdraggable

The code generated by Asto SSR may not be compatible with older iOS versions, causing it to fail to run

I have been running my astro SSR site on Netlify with great success. However, I recently encountered an issue when testing it on older iPhone models like the iPhone 6 and earlier. It seems that all script executions halt, rendering the site non-interactive ...

javascriptsafarisvelteios12astrojs

Toggle checkbox fields based on link or checkbox selection

I need to create a functionality where specific checkbox fields (location fields) are shown or hidden based on the selection of the parent name. For example, if "United States" is selected, all US locations should appear below the United States label. I h ...

javascriptjquery

Sending cookies via POST/GET request with Credentials is not functioning

Greetings, despite the numerous duplicates of this inquiry, my attempt to solve it has been unsuccessful. Therefore, I am initiating a fresh discussion. Aside from utilizing axios, I also experimented with fetch but encountered similar outcomes. On the b ...

javascriptnode.jsexpresscookies

Converting an image to base64 format for storing in localStorage using Javascript

Currently, I am working on code that sets the background-image of a link. This is what I have so far: $("a.link").css("background-image", "url('images/icon.png')"); However, I want to enhance it by storing the image in localStorage: if (!local ...

javascriptjqueryhtmlbase64local-storage

Utilizing ng-repeat, filter, and the uib-popup-datepicker to refine and display specific data within a table column

I'm currently facing a common scenario in my Angular application where I need to filter items from an ng-repeat using an HTML5 input of type 'date' or Angular-UI-Bootstrap's 'uib-popup-datepicker'. Despite extensive research, ...

javascriptangularjshtmldateangular-ui-bootstrap

Tips for displaying a view with data fetched from various sources

I'm currently working on a project using backbone.js and I've encountered an issue with a model that doesn't need to synchronize with the server. This particular model is only meant to fetch user data for initializing other views; it acts as ...

javascriptjqueryajaxbackbone.jsasynchronous

Activate jqGrid's navigation bar save icon when the ondblClickRow event is triggered

After setting the jqGrid row edit on the ondblClickRow event, how can I enable the save icon on the navigation bar when a row is double clicked? ondblClickRow: function (rowid) { jQuery(this).jqGrid('editRow', rowid, true, null, null); ...

javascriptjqueryjqgrid

Tips for executing a .exe file in stealth mode using JavaScript?

I am currently working on the transition of my vb.net application to JavaScript and I am facing a challenge. I need to find a way to execute an .exe file in hidden mode using JS. Below is the snippet from my vb.net code: Dim p As Process = New Pro ...

javascriptnode.jsvb.net

What steps can I take to make sure that a sub component's props are refreshed properly?

I'm encountering an issue with RTK queries in my project. I have a parent component that contains a table component. When a refresh event occurs, such as deleting data, the parent component receives updated data and passes it down to the child compone ...

javascriptreactjsreact-reduxrtk-query

Every time the Select box choice is changed, Jade Pug will undergo a new iteration

Recently, I began using a Pug/Jade template to go through an object of events sent from an express app. Everything is working smoothly, but now I've added a select box with a dropdown populated by venues in the event object. I'm facing a seemingl ...

javascriptnode.jsexpresspug

Upon clicking, the input texts revert to their original default values

I have a form below that is working as intended, except for one issue. When I click the 'Add' link, the texts in all the textboxes revert to their default values, as shown in the images. How can I resolve this problem? Thank you. before click: ...

javascripthtml

Tips on how to modify database records rather than generating new ones

Currently, my team is developing a web application that utilizes wearables to monitor vital parameters. As part of our integration testing, we are using a Fitbit device. The app itself is built with Angular and JavaScript, while the database is hosted on C ...

javascriptangularjscloudantfitbit

What steps can I take to prevent my menu items from overlapping in the mobile navigation menu?

I am currently working on creating a mobile menu, but I'm facing an issue where the menu items overlap when hovered over. Instead, I want the menu items to move downwards when hovered upon to prevent the text from overlapping. Below is the HTML code ...

javascripthtmlcssmobileuinavigationbar

I would appreciate it if someone could clarify how the rendering process occurs in React in this specific scenario

let visitor = 0; function Mug({name}) { visitor = visitor + 1; console.log(name, visitor); return <h2>Coffee mug for visitor #{visitor}</h2>; } return ( <> <Mug name={"A"}/> <Mug name={"B&qu ...

javascriptreactjsrender

Having trouble getting AngularJS ngCloak to function properly?

My post category page is supposed to display a message if there are no posts. However, the HTML appears briefly when the page loads and then hides. I thought using ngCloak would solve this issue, but it doesn't seem to be working for me. Here's t ...

javascripthtmlcssangularjs

Is the dividend value in the lambda expression zero or null?

Utilizing lambda expressions to retrieve data from the list: listDatas.Sum(x => x.a / x.b) However, when some x.b values are zero, I attempted to handle this scenario by excluding data that results in division by zero or null. Additionally, error messa ...

c#.netasp.net-mvcasp.net-coreentity-framework-core

The error message "Attempting to send a message using an undefined 'send' property in the welcomeChannel" is displayed

bot.on('guildMemberAdd', (member) => { console.log(member) const welcomeChannel = member.guild.channels.cache.find(channel => channel.name === 'welcome'); //const channelId = '789052445485563935' // welcome c ...

javascriptnode.jsdiscorddiscord.js