locked
Error RRS feed

  • Question

  • I get the error  "Invalid object name 'dbo.GetGLFoodCostOperations" during a table command pattern SaveChanges with a deployed release configuration. This works on my local machine with the debug configuration. GetGLFoodCostOperation is the ApplicationData name of the command table. The error:shows a plural table name in the dbo schema. Does anyone see what needs to be done? Here is the table and the full error is below that. Thank you.

    [Microsoft.LightSwitch.DataService][Application:Information][LightSwitchServiceApplication.ApplicationData:SaveChanges] DataProvider Submit Request    1 inserted entities

    Added: LightSwitchApplication.GetGLFoodCostOperation(0)(Key: Id=0)(Properties: Id=0 | PeriodYear=2015 | PeriodNumber=5 | ReturnCode=0 | STATUS=0 | CreatedBy=***** | Created=6/19/2015 8:47:22 PM +00:00 | ModifiedBy=**** | Modified=6/19/2015 8:47:22 PM +00:00 | RowVersion=<null>)
    0.029124 0.000264 
    Microsoft.LightSwitch.DataService [Microsoft.LightSwitch.DataService][Application:Error][LightSwitchServiceApplication.ApplicationData:SaveChanges] An exception has occurred:  
    Microsoft.LightSwitch.DataServiceOperationException: An error occurred while updating the entries. See the inner exception for details. ---> 
    System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> 
    System.Data.SqlClient.SqlException: Invalid object name 'dbo.GetGLFoodCostOperations'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
    at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
    --- End of inner exception stack trace ---
    at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
    at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataProvider.LinqToEntitiesDataProvider`1.SubmitCore(IEnumerable`1 changes)
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataProvider.DataProvider.Submit(IEnumerable`1 changes)
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataServiceImplementation`1.PerformPersistCore(IEnumerable`1 eventsChangeSetItems)
    at Microsoft.LightSwitch.Threading.DualDispatcherObject.Mutate(IDispatcher logicDispatcher, MutatorHost host, Action mutator)
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataServiceImplementation`1.Microsoft.LightSwitch.ServerGenerated.Implementation.IServerDataServiceImplementationCore.Submit()
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataService`1.<>c__DisplayClasse.<Microsoft.LightSwitch.ServerGenerated.Implementation.IODataService.SaveChanges>b__c()
    at Microsoft.LightSwitch.ServerGenerated.Implementation.DataServiceImplementation`1.InvokeOperationCore[T](String operationName, Object[] args, Boolean invokedFromODataClient, Func`1 invokeOperation, Action catchCallback, Action`2 serializeCustomExceptionInfo)
    --- End of inner exception stack trace --- 



    Scott Mitchell

    Friday, June 19, 2015 10:31 PM

Answers

All replies