The article describes the situation of a database breakdown when a dish with a zero code appears in it.
An example of this behavior in a cube report:
Possible reasons:
Lost Communication and Out of Synchronization Between the Directory / Report Server and the SQL Database
Rollback of the directory / report server database to the state when the sold dishes were not yet in the menu of the manager station
The first step is to find out the cause of the error.
Open SQL Server Management Studio and query your database:
select distinct sifr from SESSIONDISHES where SIFR not in (select sifr from MENUITEMS)
The request shows the sold dishes that are not on the menu. In my case, there was one dish.
Next, by searching in the manager's station, check if there are dishes with such identifiers
If there are dishes, then we have case number 1. The problem can be solved by uploading the reference books to the SQL database. Read about it below.
For this:
Go to Tools> Data Export> Export to Another Database
Specify connection parameters, login and password
Check the boxes by default by unchecking the Cumulative data box. If you leave the checkbox, the sales data will be overwritten
Click the Check button and then Ok
Wait for the export to finish.
If after these steps the dish is in the manager station, but is not in the SQL database, create a task for the support service.
If there are no dishes in the manager's room, then case # 2 - the database of the directory / report server was rolled back to the state when these dishes had not yet been created. For correction:
Remember what these dishes are: price, name and other data
Create new dishes in the manager station according to the parameters from the previous paragraph
Execute a query to the SQL database from the field below. One dish - one request. That is, for each dish, make a line with the old and new dish ID
update sessiondishes set sifr = 111111 where sifr = 1000979
where 1000979 is the identifier of the old dish that is absent in the rk7.udb database, and 111111 is the new dish that was created in the manager station.
Ready. Now, cube reports will show the dishes we have created instead of dishes with a zero code.