I have seen once there was an issue with a back office pc and it constantly freezing


In the IPSError.log files it showed that pos was failing to read or write packets to sql, to fix I tried a database consistency check and then followed solution 2 and loaded an offline overwrite to the device afterwards


How to complete a database consistency check:


1. Open a SQLcmd window and then Close Suite (including IPSUtil).

2. Type the following commands:

  • DBCC CHECKDB
  • go


Solution 1:

If received packets are still not processing, sales and other data will not be visible in Idealpos, run the below command repeatedly from a SQLCmd line window, it will not show the packet counts being reduced but will remove them one by one:


use ipsterminal
go
SELECT 'ReceivedPacket',count(*) AS 'PacketCount'  FROM ReceivedPacket where Processed = 0 union SELECT 'ReceivedPacketRow',COUNT(*) FROM ReceivedPacketRow where Processed = 0
go


Solution 2:

This will clear packets and should allow pos to function as normal


1. Open a SQLcmd window and then Close Suite (including IPSUtil).
2. Type the following commands:

  • alter database ipsterminal set single_user
  • go
  • dbcc checkdb('ipsterminal',repair_rebuild)
  • go
  • alter database ipsterminal set multi_user
  • go

Note that if a DBCC repair is done to IPSterminal, and Idealpos starts successfully, a check should be made from another terminal to ensure packets can be sent to the repaired terminal. If not, an overwrite or offline overwrite if ipsclient does not open properly should be done from another terminal.