No SessionId written to my Oracle Database

[valentinepontifex]

BFF version

2.3

.NET version

8

Description

BFF seems to be almost working but the SessionId column is always null even if all the other columns look to be properly filled out. It's an Oracle database and the column was created with the case-sensitive "SessionId" VARCHAR2(200) and is nullable. The session Id is visible in the Blazor cache of the web app that connects to the Duende oauth app.

Reproduction steps

Run my portal against my oauth using my database.

Expected behavior

I expect the SessionId column to magically be populated like all the other columns.

Logs

Duende.Bff.EntityFramework.UserSessionStore
/connect/authorize/callback
Getting user session record from store for sub "[email protected]" sid null

Additional context

No response

[RolandGuijt]

Can you please intercept the SQL query used to insert a new session and post it here?

[valentinepontifex]

Executed DbCommand (13ms) [Parameters=[:p0='C:\mila-ehf\oauth2\trunk\mila.oauth.identityserver' (Size = 200), :p1='2025-03-28T13:04:33.0000000Z' (DbType = DateTime), :p2='2025-03-28T23:04:33.0000000Z' (Nullable = true) (DbType = DateTime), :p3='094CD1FE5063A50A9A0BB1A8CA7062B4A6A5DDDA6829E267DFC97AD76FB8B907' (Nullable = false) (Size = 200), :p4='2025-03-28T13:04:33.0000000Z' (DbType = DateTime), :p5=NULL (Size = 450),

INSERT INTO "UserSessions" ("ApplicationName", "Created", "Expires", "Key", "Renewed", "SessionId", "SubjectId", "Ticket")
VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7)

So it seems the :p5 value isn't there for insertion as SessionId.

[RolandGuijt]

Can you please let us know how you created the database? Did you use migrations?

[valentinepontifex]

The problem was that I thought BFF had to be implemented in the Oauth2 server as well as the Blazor server web portal that used it. Turned out it only needed to be implemented in Blazor. Doing it in both caused a database entry to be written before the session was created.