Skip to content

Recommendation: Training failed when choosing "timestamp" column as "Label" for SQL Server data. #2504

@v-Hailishi

Description

@v-Hailishi

System Information (please complete the following information):
Windows OS: Windows-11-Enterprise-21H2
ML.Net Model Builder 2022: 17.14.3.2312001 (Main Build)
Microsoft Visual Studio Enterprise: 2022(17.4.5)
.Net: 6.0

Describe the bug

  • On which step of the process did you run into an issue:
    Training failed when choosing "timestamp" column as "Label" for SQL Server data.

Data Source
https://testpass.blob.core.windows.net/test-pass-data/iris.mdf

To Reproduce
Steps to reproduce the behavior:

  1. Select Create a new project from the Visual Studio 2022 start window.
  2. Choose the C# Console App (.NET Core6.0) project template.
  3. Add model builder by right click on the project.
  4. Select Recommendation scenario.
  5. On Data page, select the SQL Server data source, then choose "timestamp" column to predict(Label), choose "userId" as User column, choose "movieId" as Item column.
  6. On the Train page, you will see that training fail with error "Splitter/consolidator worker encountered exception while consuming source data".

Expected behavior
Training successful.

Screenshot
image
image

Additional context:

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions