Microsoft Orleans production setup

Thomas Ott 26 Reputation points
2022-12-09T15:51:23.377+00:00

Hello,

I am using the instructions in section "Reliable production deployment using SQL Server" (https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/typical-configurations) in combination with the database creation scripts of https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/adonet-configuration. When I run the application an exception with the message "Not all required queries found. Missing are: CleanupDefunctSiloEntriesKey" is raised. The question now is whether the provided SQL scripts are not up to date or where the error lies.

BR
Thomas

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Ronen Ariely 15,206 Reputation points
    2022-12-09T16:05:41.107+00:00

    Hi,

    "Not all required queries found. Missing are: CleanupDefunctSiloEntriesKey"
    The question now is whether the provided SQL scripts are not up to date or where the error lies.

    You are using the tag sql-server-general but the error is not from the SQL Server but from your application side. You better change the tag of the thread to something which better fit like the language which you are using, or even better might be to ask the question here:

    https://github.com/dotnet/orleans/issues/

    There are multiple discussions there which Google find for me with the same structure of "Not all required queries found. Missing are:"

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Thomas Ott 26 Reputation points
    2022-12-15T12:59:11.76+00:00
    1 person found this answer helpful.

  2. Fabio Silva 1 Reputation point
    2022-12-15T12:34:22.293+00:00

    I'm having the same problem after upgrading to version 7, using Oracle database. I can't find the script to create the query for the CleanupDefunctSiloEntriesKey key.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.