Server Error in '/' Application.

Invalid object name 'R_Inventory_byStatus_Detail'.

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: System.Data.OleDb.OleDbException: Invalid object name 'R_Inventory_byStatus_Detail'.

Source Error:


Line 63:    End IF    
Line 64: 
Line 65:     dtProducts = Sql.DataTable("Select R.TransactionLineID As ID, R.ItemID, R.SerialPrefix, R.SerialNumber, ISNULL(Category.Name,'') As CategoryName, ISNULL(Item.WebName, Item.Name) As ItemName, ISNULL(Files.Filename,'') As FileName, ISNULL(Files.ID,0) As FileID, ISNULL(ItemPriceList.Price11,0) As Price, ISNULL(Location.Name,'') AS Location, ISNULL(Item.SubCategoryValue,'') As Collection, ISNULL(Color.Value1,'') As Color, ISNULL(Item.ItemGroupValue,'') As Line, Round(ISNULL(R.CurrentSlabLength,0),0) AS AverageLength, Round(ISNULL(R.CurrentSlabWidth,0), 0) AS AverageWidth, ISNULL(Round(R.AvailableQuantity, 2),0) AS AvailableQty, Item.ProductFormValue As ItemType, Item.SellingUnitsValue As UOM, ISNULL(R.IDOne, R.SerialPrefix) As LOTNO, TransactionLine.Notes From R_Inventory_byStatus_Detail R LEFT OUTER JOIN Item ON Item.ID = R.ItemID LEFT OUTER JOIN ItemPriceList ON ItemPriceList.ItemID = Item.ID LEFT OUTER JOIN Category ON Category.ID = Item.ServiceCategoryID LEFT OUTER JOIN Files ON Files.BarcodeID = R.BarcodeID AND Files.Subsource = 'SLAB' LEFT OUTER JOIN SystemOptions Color ON Color.ID = Item.BaseColors LEFT OUTER JOIN Location ON Location.ID = R.CurrentLocationID LEFT OUTER JOIN TransactionLine ON TransactionLine.ID = R.TransactionLineID And TransactionLine.InventoryCreated = 'on' Where Files.ID IN (SELECT FilesTableID FROM custom_cart WHERE UserID = "& NewUserID &") AND R.CurrentLocationID IN (6,8,9) And R.InventoryStatus = 'Available' ORDER BY R.SerialNumber, Files.UploadedOn DESC")
Line 66: 	If Request("act") = "sendEmail" Then
Line 67:     Dim Body

Source File: D:\WebSites\Live Websites\WebConnects\OpustoneValueVault-Dev\vCart.aspx    Line: 65

Stack Trace:


[OleDbException (0x80040e37): Invalid object name 'R_Inventory_byStatus_Detail'.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1553134
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +323
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +225
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +203
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +143
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +465
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +147
   LibraryDM.Sql.ExecuteDataTable(OleDbConnection connection, String commandText, OleDbTransaction& commandTransaction) +202
   LibraryDM.Sql.DataTable(String commandText) +77
   ASP.vcart_aspx.page_load() in D:\WebSites\Live Websites\WebConnects\OpustoneValueVault-Dev\vCart.aspx:65
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0