elsa-workflows / elsa-workflows/elsa-extensions
Unhandled exception using SQL activities
- Dominant language
- C#
- Stars
- 49
- Forks
- 48
- Avg merge
- 21h 35m
- Merged PRs (30d)
- 20
Description
## Description
I enabled the SQL activities for PostgreSQL and SQL Server.
As soon as I drag & drop the SQL Query activity the following exception is thrown:
> StackTrace:
> at Microsoft.JSInterop.JSRuntime.GetObjectReference(Int64 dotNetObjectId)
> at Microsoft.JSInterop.Infrastructure.DotNetDispatcher.BeginInvokeDotNet(JSRuntime jsRuntime, DotNetInvocationInfo invocationInfo, String argsJson)
> at v.endInvokeDotNetFromJS (https://localhost:60734/_framework/blazor.webassembly.js:1:3158)
> at Object.Qt [as endInvokeDotNetFromJS] (https://localhost:60734/_framework/blazor.webassembly.js:1:56145)
> at https://localhost:60734/_framework/dotnet.runtime.ew19f13umk.js:3:33879
> at Fc (https://localhost:60734/_framework/dotnet.runtime.ew19f13umk.js:3:172343)
> at wasm://wasm/00b5ba72:wasm-function[288]:0x1f1e1
> at wasm://wasm/00b5ba72:wasm-function[219]:0x1c8c7
> at wasm://wasm/00b5ba72:wasm-function[210]:0xea32
> at wasm://wasm/00b5ba72:wasm-function[247]:0x1d442
> at wasm://wasm/00b5ba72:wasm-function[3222]:0xf1178
> at wasm://wasm/00b5ba72:wasm-function[2545]:0xc6ca7
After that, I can configure the activity and publish the workflow, but when I run it I see the message “Successfully started workflow,” yet no workflow appears in the instances list.
## Steps to Reproduce
Download and use solution from [Elsa Server + Studio example](https://github.com/elsa-workflows/elsa-guides/tree/main/src/installation/elsa-server-and-studio).
Configure with the following base packages: Elsa 3.4.2, Elsa.Sql 3.4.2, Elsa.Sql.PostgreSql 3.4.2, Elsa.Sql.SqlServer 3.4.2, Elsa Studio 3.4.0.
Configure code to UseSql:
Run in debug Elsa server
Drag & drop the SQL Query activity => Attached Exception.
## Environment
- **Elsa Package Version**: Elsa 3.4.2, Elsa.Sql 3.4.2, Elsa.Sql.PostgreSql 3.4.2, Elsa.Sql.SqlServer 3.4.2, Elsa Studio 3.4.0 and code from https://github.com/elsa-workflows/elsa-guides branch main.
Created workflow:
[sql-query.json](https://github.com/user-attachments/files/21812291/sql-query.json)
Contributor guide
Assessment
This issue has not been assessed yet.