I have a grid, I am able to view the data in it, and updated the data in it.
when i go to create a new record I get the "error! the requested url returned 500 - internal server error"
This all started happening after switching to a different SQL Server.
Are there certain settings that may have been missed that is causing this error?
Thanks
5 Answers, 1 is accepted


POST http://localhost/Jobs/AjaxGridUpdates 500 (Internal Server Error)
f.support.ajax.f.ajaxTransport.send asset.axd:4
f.extend.ajax asset.axd:4
b.editing.implementation.sendValues asset.axd:62
b.editing.initialize.s.submitChanges asset.axd:62
b.editing.implementation._validateForm.o.settings.submitHandler asset.axd:62
e asset.axd:24
c.extend.validate asset.axd:24
f.event.handle asset.axd:3
f.event.add.i.handle.k asset.axd:2
f.event.trigger asset.axd:3
f.fn.extend.trigger asset.axd:3
e.extend.each asset.axd:2
e.fn.e.each asset.axd:2
f.fn.extend.trigger asset.axd:3
f.each.f.fn.(anonymous function) asset.axd:3
b.editing.implementation._validateForm asset.axd:62
b.editing.initialize.s.submitChanges asset.axd:62
b.editing.initialize.s.hasChanges asset.axd:62
a.telerik.stopAll asset.axd:5
L asset.axd:2
f.event.handle asset.axd:3
f.event.add.i.handle.k
Can you decipher this?
Thanks

Edit: if you want to see the ajax call, look at the xhr

Server Error in '/' Application.
Cannot insert the value NULL into column 'JobId', table 'LineTools.dbo.Jobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Telerik.OpenAccess.RT.sql.SQLException: Cannot insert the value NULL into column 'JobId', table 'LineTools.dbo.Jobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SQLException: Cannot insert the value NULL into column 'JobId', table 'LineTools.dbo.Jobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute() +705
OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute() +156
OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes) +2477
[DataStoreException: Insert of '1832245587-' failed: Telerik.OpenAccess.RT.sql.SQLException: Cannot insert the value NULL into column 'JobId', table 'LineTools.dbo.Jobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
INSERT INTO [Jobs] ([Active], [CustId], [DueDate], [JobNum], [LineCode], [PartId], [PieceQty], [Seq]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
select scope_identity()
(set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: Cannot insert the value NULL into column 'JobId', table 'LineTools.dbo.Jobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)]
OpenAccessRuntime.ExceptionWrapper.Throw() +13
OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.handleException(Exception x) +1350
OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.internalCommit(Boolean phase) +632
OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.commit() +147
Line.Controllers.JobsController.AjaxGridUpdates(IEnumerable`1 inserted, IEnumerable`1 updated, IEnumerable`1 deleted) in C:\Users\aorr\Desktop\LineTools\LineTools\Line\Controllers\JobsController.cs:65
lambda_method(Closure , ControllerBase , Object[] ) +192
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +248
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +125
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +640
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +640
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +312
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +691
System.Web.Mvc.Controller.ExecuteCore() +162
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +305
System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +62
System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +20
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +469
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +375
I think I can figure it out from here.
Thanks
