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

[Solved] scope.Transaction.Commit() - More info needed from stacktrace

6 Answers 162 Views

Data Access Free Edition

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

This question is locked. New answers and comments are not allowed.

Delton Phillips asked on 02 Aug 2010, 02:22 AM

Hi,

on committing of two objects i'm getting the following exception and stack trace. Can anyone tell me if it's possible 
to get better data to help trace down the problem? Any clue where I should be looking?

[NullReferenceException: Object reference not set to an instance of an object.]
   OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.insertUnorderedLinkTableRows(OID oid, Object[] inserted, PreparedStatement psins, Boolean batch, String sql) +227
   OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.persistPass2BlockUnordered(PersistGraph graph, Int32 blockStart, Int32 blockEnd, CharBuf s, Connection con, Boolean batchInserts, Boolean batchUpdates) +1475
   OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.persistPass2Block(PersistGraph graph, Int32 blockStart, Int32 blockEnd, CharBuf s, Connection con, Boolean batchInserts, Boolean batchUpdates) +123
   OpenAccessRuntime.Relational.RelationalStorageManager.persistPass2(PersistGraph graph) +649
   OpenAccessRuntime.Relational.RelationalStorageManager.doUpdates(StatesToStore toStore, StateContainer container, Boolean retainValues) +580
   OpenAccessRuntime.Relational.RelationalStorageManager.store(StatesToStore toStore, DeletePacket toDelete, Boolean returnFieldsUpdatedBySM, Int32 storeOption, Boolean evictClasses) +471
 
[DataStoreException: System.NullReferenceException: Object reference not set to an instance of an object.
   at OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.insertUnorderedLinkTableRows(OID oid, Object[] inserted, PreparedStatement psins, Boolean batch, String sql)
   at OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.persistPass2BlockUnordered(PersistGraph graph, Int32 blockStart, Int32 blockEnd, CharBuf s, Connection con, Boolean batchInserts, Boolean batchUpdates)
   at OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.persistPass2Block(PersistGraph graph, Int32 blockStart, Int32 blockEnd, CharBuf s, Connection con, Boolean batchInserts, Boolean batchUpdates)
   at OpenAccessRuntime.Relational.RelationalStorageManager.persistPass2(PersistGraph graph)
   at OpenAccessRuntime.Relational.RelationalStorageManager.doUpdates(StatesToStore toStore, StateContainer container, Boolean retainValues)
   at OpenAccessRuntime.Relational.RelationalStorageManager.store(StatesToStore toStore, DeletePacket toDelete, Boolean returnFieldsUpdatedBySM, Int32 storeOption, Boolean evictClasses) ]
   Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +28
   Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +34
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.handleException(Exception x) +1455
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.internalCommit(Boolean phase) +582
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.commit() +188
   OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.commit() +42
   Telerik.OpenAccess.RT.TransactionImpl.Commit() +115
   SutureMD.Web.Common.AbstractBaseController.OnActionExecuted(ActionExecutedContext filterContext) in C:\ProjectDocs\SutureMD\Solution_May27\SutureMD.Web.Common\AbstractBaseController.cs:174
   System.Web.Mvc.Controller.System.Web.Mvc.IActionFilter.OnActionExecuted(ActionExecutedContext filterContext) +7
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +274
   System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +192
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +314
   System.Web.Mvc.Controller.ExecuteCore() +105
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +39
   System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__4() +34
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +59
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +44
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +7
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8677758
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

6 Answers, 1 is accepted

answered on 05 Jan 2012, 06:31 PM

The only thing I did was delete the database and let open access recreate the schema tables from scratch. It happened after that. If I remember correctly I had this same issue in the same application earlier. The place where I get the error is related to some import functionality that takes data from an excel file and populates dataobjects and saves them using OpenAccess to the database. Earlier I got the same error when I tried to save all of the objects at once. I solved it by saving each object to the database as it was populated and not doing one mass load. But now it appears to have started happening again without any change to that code.

Any thoughts would be greatly appreciated, the stack trace isn't very helpful.

Josh