Error "se han encontrado tickets abiertos" en el ACMS

A veces creamos ACMS con backup locales, que contienen tickets abiertos, si metemos un Agora versión 8.5x o superior puede dar este error:

Habría que ejecutar las siguientes consultas:

C:\Users\Administrador>osql -S localhost\agora -U sa

Password:

1> use igtpos

2> go

1> delete from AppliedTicketOffer where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

(0 rows affected)

1> delete from OnlineReservation where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

(0 rows affected)

1> delete from CardTransaction where Id in (select CardTransactionId from DocumentPayment where TicketId in (select Id from Ticket where FrozenDate is null));

2> go

(0 rows affected)

1> delete from DocumentPayment where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

(0 rows affected)

1> delete from TicketLineAddin where TicketLineId in (select Id from TicketLine where TicketId in (select Id from Ticket where FrozenDate is null));

2> go

(6 rows affected)

1> delete from TicketLineRemovedIngredient where TicketLineId in (select Id from TicketLine where TicketId in (select Id from Ticket where FrozenDate is null));

2> go

(0 rows affected)

1> delete from TicketLine where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

(1 row affected)

1> delete from SalesOrderDraft where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

(0 rows affected)

1> delete from DeliveryNoteDraft where TicketId in (select Id from Ticket where FrozenDate is null);

2> go

Un saludo.