Current SQL schema version could not be resolved. about dicom-server HOT 8 CLOSED

Are you updating an existing service? If so, what schema version was previously referenced?
Or are you creating a new service?

from dicom-server.

I am running it as a new service, no database exists, so when I run the project it creates db but in further steps it fails.

from dicom-server.

How are you deploying your service? Are you using the ARM template provided?

Can you also check the schema version table on your SQL DB to see what it says there? What versions are listed? Did they fail or succeed to register?

from dicom-server.

Im currently running it locally in dev environment.

tables are not getting created on initial run, only database is created.

some lines from logs.

warn: Microsoft.Health.SqlServer.Features.Schema.SchemaInitializer[0]
      Could not find stored procedure - dbo.SelectCurrentSchemaVersion
info: Microsoft.Health.SqlServer.Features.Schema.SchemaInitializer[0]
      Initial check of schema version is NULL
...
...
...
info: Microsoft.Health.Dicom.Core.Features.Partition.PartitionCache[0]
      Cache miss. Initializing the row.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105]
      Executed action Microsoft.Health.Dicom.Api.Controllers.QueryController.QueryForStudyAsync (Microsoft.Health.Dicom.Api) in 931.399ms
warn: Microsoft.Health.Dicom.Api.Features.Exceptions.ExceptionHandlingMiddleware[0]
      Service exception.
      Microsoft.Health.Dicom.Core.Exceptions.DataStoreNotReadyException: Current SQL schema version could not be resolved.
         at Microsoft.Health.Dicom.SqlServer.Features.Schema.VersionedCache`1.ResolveAsync(CancellationToken cancellationToken) in 

from dicom-server.

may be default stored procedures are not getting created from shared health package and Initial check of schema version is NULL error is coming.

from dicom-server.

Have you been through these instructions if you are running the service locally? https://github.com/microsoft/dicom-server/blob/main/docs/development/setup.md

from dicom-server.

Have you been through these instructions if you are running the service locally? https://github.com/microsoft/dicom-server/blob/main/docs/development/setup.md

Yes, I'm following the guidelines.

from dicom-server.

I have resolved the issue by following steps in SqlServer readme.md file. We can close this issue.

from dicom-server.