Could not find any resources appropriate for the specified culture or the neutral culture.

Hi,

I get the following error message when trying to commit a migration script created manually from a blank script:

Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "RedGate.Database.Migrations.Synchronizer.ErrorStrings.resources" was correctly embedded or linked into assembly "RedGate.Database.Migrations.Synchronizer" at compile time, or that all the satellite assemblies required are loadable and fully signed.

This happens in the "Determining database changes" step of the commit. Committing objects or pre/post deployment scripts works without error. I'm using SQL Source Control 7.0.24.9343.

Any help is greatly appreciated.

Thanks in advance.

Regards
Matthias


Tagged:

Answers

  • Jessica RJessica R Posts: 1,319 Rose Gold 4

    Hi Matthias,

    Thanks for your post and sorry to hear about this issue you're running into!

    Can you please uninstall SQL Source Control, delete C:\Program Files (x86)\Red Gate\SQL Source Control 7 if it still exists, and then install the latest? (you can find the installer on your Redgate portal)

    (Note that currently, the latest official release is still 7.1.5.10110. As of today's latest frequent update though, 7.1.9.10297, the Migrations tab is now disabled and if you still need to use migrations, you can configure them via SQL Change Automation. Projects that already contain migrations will still be able to use them.)

    If the error remains, I am wondering if this error is a red herring for a different problem. Can you please enable verbose logging, reproduce the issue, and then check the log for any other exceptions around the "Could not find any resources appropriate for the specified culture or the neutral culture." error?

    Thank you!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • AMP_DevAMP_Dev Posts: 9 New member
    Hi Jessica,

    unfortunately, that did not work. After uninstalling and installing the latest version (7.1.5.10110) the error remains the same. Also, I tried clearing all personal data under %localappdata%\RedGate\SQL Source Control 7, re-installing and then linking the database again. I set the the log level to All. This is the output at the end of the file when the error occurs:

    12:03:51.490|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.490|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Editor.resources.dll
    12:03:51.490|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.490|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.490|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Editor.resources.dll
    12:03:51.490|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Editor.resources.dll
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Editor.resources.dll
    12:03:51.506|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Editor.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.537|INFO   |stomAssemblyResolver|46 |Loaded assembly NGit, Version=5.0.77.0, Culture=neutral, PublicKeyToken=2a696c5857117d6c from file:///C:/Program Files (x86)/Red Gate/SQL Source Control 7/NGit.DLL/5.0.77
    12:03:51.537|INFO   |stomAssemblyResolver|46 |Loaded assembly Sharpen, Version=5.0.77.0, Culture=neutral, PublicKeyToken=2a696c5857117d6c from file:///C:/Program Files (x86)/Red Gate/SQL Source Control 7/Sharpen.DLL/5.0.77
    12:03:51.553|INFO   |stomAssemblyResolver|46 |Loaded assembly LibGit2Sharp, Version=0.26.0.0, Culture=neutral, PublicKeyToken=7cbde695407f0333 from file:///C:/Program Files (x86)/Red Gate/SQL Source Control 7/LibGit2Sharp.DLL/0.26.1.93
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Helpers.PartialSchemas.resources.dll
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Helpers.PartialSchemas.resources.dll
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.646|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Helpers.PartialSchemas.resources.dll
    12:03:51.662|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.662|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.662|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Helpers.PartialSchemas.resources.dll
    12:03:51.662|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Helpers.PartialSchemas.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Synchronizer.resources.dll
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Synchronizer.resources.dll
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Synchronizer.resources.dll
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Runtime failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.Database.Migrations.Synchronizer.resources.dll
    12:03:51.787|INFO   |stomAssemblyResolver|46 |Failed to load assembly RedGate.Database.Migrations.Synchronizer.resources, Version=66.0.0.0, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.818|WARN   |ProjectGuidRetriever|43 |Failed to load script database information xml. Error was DatabaseInformationNotFound
    12:03:51.818|DEBUG  |WorkspaceLockHandler|43 |Workspace { Type = RedGate.SQLSourceControl.Engine.PersistentWorkspace, Root path = "C:\Users\userxy\AppData\Local\Red Gate\SQL Source Control 7\WorkingBases\iiwzzn21.u1y", Hash code = 8140213 } released read lock
    12:03:51.818|DEBUG  |WorkspaceLockHandler|43 |Workspace { Type = RedGate.SQLSourceControl.Engine.TransientWorkspace, Root path = "C:\Users\userxy\AppData\Local\Red Gate\SQL Source Control 7\Transients\ozgbrd4a.p2r", Hash code = 6322590 } released read lock
    12:03:51.818|DEBUG  |ents.EventAggregator|1  |Sending message RedGate.SQLSourceControl.CommonUI.Events.CommitTaskCompleteEvent to listener RedGate.SQLSourceControl.CommonUI.Controls.EmbeddedProgressPanel.AsyncCommitExitPrompt, Text: SQL Source Control - Operation in Progress
    12:03:51.818|DEBUG  |ents.EventAggregator|1  |Sending message RedGate.SQLSourceControl.CommonUI.Events.CommitTaskCompleteEvent to listener RedGate.SQLSourceControl.CommonUI.Controls.CommitTabAndProgress
    12:03:51.818|DEBUG  |ents.EventAggregator|1  |Sending message RedGate.SQLSourceControl.CommonUI.Events.CommitTaskCompleteEvent to listener RedGate.SQLSourceControl.Extension.CanCloseSsms
    12:03:51.818|INFO   |SourceControlPackage|1  |CommitTaskCompleteEvent recieved
    12:03:51.818|DEBUG  |ents.EventAggregator|1  |Finished sending message RedGate.SQLSourceControl.CommonUI.Events.CommitTaskCompleteEvent[] to all listeners
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Runtime failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.SQLSourceControl.CommonResources.resources.dll
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Runtime failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.SQLSourceControl.CommonResources.resources.dll
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Runtime failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.SQLSourceControl.CommonResources.resources.dll
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Runtime failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 7\RedGate.SQLSourceControl.CommonResources.resources.dll
    12:03:51.834|INFO   |stomAssemblyResolver|1  |Failed to load assembly RedGate.SQLSourceControl.CommonResources.resources, Version=7.1.5.10110, Culture=en, PublicKeyToken=7f465a1c156d4d57
    12:03:53.614|DEBUG  |eClientLoggerAdapter|ent|Sending 3 events:
    [
      {
        "eventType": "migration.script.action",
        "headers": {
          "productId": "sql-source-control",
          "productVersion": "7.1.5.10110",
          "eventUuid": "00d79fee-a036-4393-a3fe-ddd9cfaaa569",
          "usageUserId": "3d2eca14-6074-491b-aede-47e4c5b4e6fd",
          "sessionUuid": "c612298a-6c2a-4ccc-b455-1db6b6665d75",
          "createdTimeUtc": "2020-02-04T11:03:50Z"
        },
        "payload": {
          "action-type": "Commit",
          "target": "Non-empty",
          "change-type": "MigrationScript_New"
        }
      },
      {
        "eventType": "commit.completed",
        "headers": {
          "productId": "sql-source-control",
          "productVersion": "7.1.5.10110",
          "eventUuid": "ec09dfa5-009e-49fb-91d7-b6b687ca2c7f",
          "usageUserId": "3d2eca14-6074-491b-aede-47e4c5b4e6fd",
          "sessionUuid": "c612298a-6c2a-4ccc-b455-1db6b6665d75",
          "createdTimeUtc": "2020-02-04T11:03:51Z"
        },
        "payload": {
          "vcs-type": "TFS",
          "vcs-client-version": "2012",
          "vcs-server-version": "2012+",
          "vcs-protocol": "http"
        }
      },
      {
        "eventType": "commit.timing",
        "headers": {
          "productId": "sql-source-control",
          "productVersion": "7.1.5.10110",
          "eventUuid": "3fde4dbf-39a0-4fda-81ae-0d7e5013c8f4",
          "usageUserId": "3d2eca14-6074-491b-aede-47e4c5b4e6fd",
          "sessionUuid": "c612298a-6c2a-4ccc-b455-1db6b6665d75",
          "createdTimeUtc": "2020-02-04T11:03:51Z"
        },
        "payload": {
          "livedatabase": 4676,
          "transient": 4646,
          "workingbase": 4646,
          "numberofchanges": 14,
          "numberofselectedchanges": 1,
          "elapsedtime": {
            "ticks": 16520460,
            "days": 0,
            "hours": 0,
            "milliseconds": 652,
            "minutes": 0,
            "seconds": 1,
            "totalDays": 1.9120902777777776E-05,
            "totalHours": 0.00045890166666666664,
            "totalMilliseconds": 1652.0460000000001,
            "totalMinutes": 0.027534099999999999,
            "totalSeconds": 1.6520459999999999
          }
        }
      }
    ]
    12:03:54.817|DEBUG  |eClientLoggerAdapter|ent|Sending 1 event:
    [
      {
        "eventType": "commit.completed",
        "headers": {
          "productId": "sql-source-control",
          "productVersion": "7.1.5.10110",
          "eventUuid": "1b55d0f9-6cd1-4055-b775-3ad139502438",
          "usageUserId": "393d1b06-0b78-458a-be57-3cb15c70913b",
          "projectUuid": "",
          "sessionUuid": "7067a054-c218-40a9-8858-1aa7578f53e6",
          "createdTimeUtc": "2020-02-04T11:03:51Z"
        },
        "payload": null
      }
    ]

    Any idea what's wrong? I checked the program files folder and at least the assemblies failing to load are all there?!

    Regards
    Matthias

  • Jessica RJessica R Posts: 1,319 Rose Gold 4

    Hi @AMP_Dev,

    So sorry to hear that hasn't helped!

    I do think the error you're getting is hiding the root issue, which I suspect is related to some data missing from your DeploymentOrder.json file (which controls the order that migrations are deployed in).

    We'll need to get a copy of your Custom Scripts folder to reproduce this and investigate. We've opened a ticket for you (#154437) and I'll reach out to you through the ticket shortly!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.