New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
OrleansQuery not exists #8962
Comments
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'OrleansQuery'. "Npgsql.PostgresException (0x80004005): 42P01: "orleansquery" relation does not exist" (translated error message) |
builder.Host.UseOrleans(static siloBuilder => |
PackageReference Include="Microsoft.AspNetCore.OpenApi" Version="8.0.3" My packages |
You need to run the setup scripts on the database, to create the table and stored procedures used. https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/adonet-configuration |
I ran that scripts and they are not working |
Pleas, First read and then answer |
You might want to look at that again, because the main script creates the OrleansQuery table. https://github.com/dotnet/orleans/blob/main/src/AdoNet/Shared/PostgreSQL-Main.sql#L34 |
Thanks! |
I attempted to integrate ADO.net into a project that included MSSQL and PostgreSQL. I got the same error as OrleansQuery does not exist; I saw sql scripts that are in here:
https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/adonet-configuration
and I notice SQL scripts have no OrleansQuery table for MS SQL and Postgres. I can't find on the internet how to solve it.
I also tried to run scripts manually and got the same error.
The text was updated successfully, but these errors were encountered: