Error "Inventory Status updated from enterprise server failed" while using Retrieve from Server
*******Internal to CitiXsys*******
Environment:
iVend 6.6 patch 7574 with SAP B1 9.3
Problem Statement:
Getting an error while using Retrieve from Server functionality at Store Server. Whenever trying to view item inventory at Store Management Console using Retrieve from Server, the client was getting the mentioned error message.
"Inventory Status updated from enterprise server failed"
When we checked the Management Console Log file, we found the below error message: -
<Category>ERROR</Category>
<Time>17:02:34</Time>
<Message>Incorrect syntax near '00000'.</Message>
-<ExceptionInfo>
<Type>System.Data.SqlClient.SqlException</Type>
<Message>Incorrect syntax near '00000'.</Message>
We ran the SQL profiler and as per the analysis below query was causing an issue
Update InvInventoryItem Set
AvailableQuantity = 0,00000
,InStockQuantity = 0,00000
,InReturnQuantity = 0,00000
,LostQuantity= 0,00000
,OnLayawayQuantity= 0,00000
,OnOrderQuantity= 0,00000
,OnFulFillmentQuantity= 0,00000
,KitsAvailableToBuild= 0
,AssembliesAvailableToBuild= 0
,InTransitQuantity= 0,00000
,AllocatedQuantity= 0,00000
,ReservedQuantity= 0,00000
,Modified = GetDate()
Where WarehouseKey = '1000000000000001' And ProductKey = '1000000000000001'
Resolution:
Issue reported in 6.6 patch 7574. The issue is reportedly fixed in latest patch available . Ask customer to apply the latest patch
Related Articles
View Inventory error on store "inventory status updated from enterprise server is failed"
Environment: iVend 6.6 with SAP B1 9.2 Problem statement: Inventory status update error Symptoms: Below error is faced while viewing the inventory of a product from the store. Resolution/Work Around: 1. Enable transaction server settings on the ...inventory status updated from enterprise server is failed
Environment: iVend 6.6 Problem Statement: We are getting an error message while click on tab "retrieve from server" under product setting Proposed Solution: Please follow the steps below: i) Enable transaction server settings on enterprise ii) Please ...Steps to enable "Retrieve from Server functionality" at the Store server
Environment: iVend Version: 6.6 Problem Statement: Steps to enable the "Retrieve from Server functionality" button at the Store server. (Path : MC > Operations> Inventory > Select and view Product > View Inventory Button) Or : - Getting below error ...Failed to Retrieve Data Error
Failed to Retrieve Data Error This knowledge base article will assist you with how to retrieve data from the database when it fails to be retrieved automatically. This is a common error that occurs in Crystal Reports. Going through this article, you ...Store MC not showing the inventory of all stores while using retrieve from server option
Product Version: 6.6 Problem Statement: Store Manager Console It is not possible to view the inventory of all stores from a store. Proposed Solution: There is one parameter "InventoryItemReplication" , introduced in iVend 8567 & it helps to minimize ...