elsa-workflows / elsa-workflows/elsa-extensions

Unhandled exception using SQL activities

Open
#79 6 comments 0 reactions 1 assignee Claimed by @KnibbsyMan View on GitHub
bug triaged
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:

Image

> 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:
Image
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.