Unable to create a new project - Could not load file or assembly 'System.Text.Json

Full error: Could not load file or assembly 'System.Text.Json, Version=8.0.0.4, Culture=neutral, 
PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.

No major changes to the VM, that I'm aware of. 
Tagged:

Answers

  • Hey Dan, 

    Apologies for the issues you're experiencing with SQL Data Generator. Could you let me know which authentication method you're using to connect to SQL Server?  SQL Data Generator does not natively support Multi-Factor Authentication (MFA) for SQL Server. This is because MFA typically requires interactive prompts, which are not supported by SQL Data Generator's connection mechanisms. The tool primarily supports SQL Server Authentication and Windows Authentication. 

    Best, 

    Hassan 
    Product Support Engineer
  • Dan_ODan_O Posts: 4 New member
    Hi Hassan, 

    I've been using 'Active Directory universal with MFA' for months now, it hasn't been a problem until I tried it yesterday. I see the MFA prompts and can authenticate properly; I can pick the database I want to use but when I click 'ok' to start the project I get the error. I'm passed the MFA prompts at that point. Side note: I am still able to use this authentication method with the Mulit-Script tool, and SQL Compare. 
  • Hi Dan,

    Thank you for the additional details. Could you please confirm if there have been any changes to your setup. The error message you received points to a potential issue with the .NET assembly on your system. Our application requires .NET Framework version 4.7.2 or later to function correctly, which I assume is in place since there haven't been any major changes reported.

    Additionally, I noticed that there was an update released for SDG to version 4.6.2 yesterday. Can you confirm if this is the version you currently have installed? If not can you let me know which version you have installed? 

  • Dan_ODan_O Posts: 4 New member
    Hassan - I have v4.6.2.5848 installed, I did perform the update yesterday after I was having this issue. I thought the update would fix it, but it did not. I can also confirm the VM has .NET 8.0.3 installed. 
  • Do you know which version you were on yesterday before updating to the most recent one? Version 4.6 is a major release. I’m attaching the link to the latest 4.5 version we have. Could you uninstall 4.6, install 4.5 instead, and let me know if the issue persists with that version? 

    Download SQLDataGenerator_4.5.21.5722.exe
  • Dan_ODan_O Posts: 4 New member
    I uninstalled 4.6 and installed 4.5, unfortunately I'm still seeing an error. 

    IDX12729: Unable to decode the header '[PII of type 'System.String' is hidden. For more details, se... Could not load file or assembly 'System.Text.Json, Version=8.0.0.4, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.
  • jwisejwise Posts: 1 New member
    I have the same issue. basically the tool is useless, and I cannot use. 
  • Hi,

    Could you please try performing a clean install using the steps below to downgrade?

    1. Uninstall SQL Data Generator from the Control Panel.
    2. Ensure that the SQL Data Generator folder is deleted from C:\Program Files (x86)\Red Gate.
    3. Install the prior version of the application: SQLDataGenerator_4.5.21.5722.exe
Sign In or Register to comment.