This is a migrated thread and some comments may be shown as answers.

error! the requested url returned 500 - internal server error

5 Answers 639 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Aaron
Top achievements
Rank 1
Aaron asked on 05 Apr 2012, 11:11 PM
I have looked through the forms, but it doesn't appear that anyone else is having this problem.

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

Sort by
0
Accepted
Dadv
Top achievements
Rank 1
answered on 06 Apr 2012, 10:51 AM
Try to see the error message with the developer tools in IE or Chrome (F12 key) in the network tab.
0
Aaron
Top achievements
Rank 1
answered on 06 Apr 2012, 04:53 PM
Using Chrome,

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

0
Accepted
Dadv
Top achievements
Rank 1
answered on 06 Apr 2012, 05:04 PM
?? normally in the Network/Response tabs you should see a Html source code... with the .Net error message (human readable). you took the javascript log screen i think.

Edit: if you want to see the ajax call, look at the xhr
0
Aaron
Top achievements
Rank 1
answered on 06 Apr 2012, 05:05 PM
You are awesome!

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

0
Dadv
Top achievements
Rank 1
answered on 06 Apr 2012, 05:10 PM
I edited my previous post to add the ajax requests
Tags
Grid
Asked by
Aaron
Top achievements
Rank 1
Answers by
Dadv
Top achievements
Rank 1
Aaron
Top achievements
Rank 1
Share this question
or