microsoft / microsoft/sql-server-language-extensions

C# Code Extension : Data type not found

Open
#56 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C++
Stars
117
Forks
51
PR merge metrics
No merged PRs in 30d

Description

Following the sample (https://github.com/microsoft/sql-server-language-extensions/tree/main/language-extensions/dotnet-core-CSharp/sample/regex), I am getting the error message below:

Msg 39004, Level 16, State 20, Line 1
A 'dotnet' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004. External script request id is CBDA2919-04A5-44A2-B393-359ED131E3C9.
STDOUT message(s) from external script: 
   at Microsoft.SqlServer.CSharpExtension.Sql.ToManagedDataType(Int16 SQLDataType) in C:\__w\1\s\sql-server-language-extensions\language-extensions\dotnet-core-CSharp\src\managed\utils\Sql.cs:line 106
   at Microsoft.SqlServer.CSharpExtension.CSharpExtension.<>c__DisplayClass10_0.<InitColumn>b__0() in C:\__w\1\s\sql-server-language-extensions\language-extensions\dotnet-core-CSharp\src\managed\CSharpExtension.cs:line 287
   at Microsoft.SqlServer.CSharpExtension.ExceptionUtils.WrapError(Action func) in C:\__w\1\s\sql-server-language-extensions\language-extensions\dotnet-core-CSharp\src\managed\utils\ExceptionUtils.cs:line 35Error: Data type not found.

Any idea?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the regex sample in language-extensions/dotnet-core-CSharp/sample/regex, then inspect language-extensions/dotnet-core-CSharp/src/managed/utils/Sql.cs at the reported line 106 and the callers shown in the stack trace. Done means the sample no longer reports “Data type not found” for its input and the affected SQL type is handled consistently.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.