BC14 RTC Service crash casually

DavideRota95
DavideRota95 Member Posts: 5
in NAV Three Tier
Hi all,
i need some advice from you regarding a particular situation we are in.

Client - BC14 with RTC services (no web client)

Until recently everything was fine, but for a few months now the service crashes sometimes casually, throwing all users out of production. Then the other services also crash in turn.

Initially we had found some problem in some partner procedure that caused the crash of the service and we solved it, but now it happens randomly.

We are talking about a single production service to which about 50 users connect and two other production services, one dedicated to the job queue and one dedicated to a NavUserPassword user to exploit it with some external integrations.

I am asking for some advice on where and what to check.

Thanks so much to anyone who gives us a hand
Davide

Answers

  • DavideRota95
    DavideRota95 Member Posts: 5
    Some of the strange log in the event viewer is for example:
    "Message Duplicate key insertion in table 2000000041 Identification fields: TableNo,No."
  • Developer101
    Developer101 Member Posts: 569
    Compile all objects
    Run Table Sync
    Restart Nav Services
    United Kingdom
  • vaprog
    vaprog Member Posts: 1,162
    ... and make sure no-one and nothing other than the BC services modifies data in the BC database, except possibly for dedicated staging tables specifically created for that very purpose.

Categories