Upgrade from 8.5.497 to 9.4.348 results in Schema specified is not valid errors
Posted: Wed 17 Oct 2018 22:26
We recently upgraded from 8.5.497 to 9.4.348 and now we are getting Schema specified is not valid errors like the one below. Did something change in how the metadata is embedded in the assembly? We are using EF4 and believe we have updated all references correctly, but clearly something is not quite right.
Desc: System.Data.MetadataException: Schema specified is not valid. Errors:
Afm.ssdl(782,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(783,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(794,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(795,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(796,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(797,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(798,6) : error 0040: The Type VARCHAR2
.
.
.
Afm.ssdl(12923,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
at System.Data.Metadata.Edm.StoreItemCollection.Loader.ThrowOnNonWarningErrors()
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths)
at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction)
at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths)
at System.Data.Metadata.Edm.MetadataCache.StoreMetadataEntry.LoadStoreCollection(EdmItemCollection edmItemCollection, MetadataArtifactLoader loader)
at System.Data.Metadata.Edm.MetadataCache.StoreItemCollectionLoader.LoadItemCollection(StoreMetadataEntry entry)
at System.Data.Metadata.Edm.MetadataCache.LoadItemCollection[T](IItemCollectionLoader`1 itemCollectionLoader, T entry)
at System.Data.Metadata.Edm.MetadataCache.GetOrCreateStoreAndMappingItemCollections(String cacheKey, MetadataArtifactLoader loader, EdmItemCollection edmItemCollection, Object& entryToken)
at System.Data.EntityClient.EntityConnection.LoadStoreItemCollections(MetadataWorkspace workspace, DbConnection storeConnection, DbProviderFactory factory, DbConnectionOptions connectionOptions, EdmItemCollection edmItemCollection, MetadataArtifactLoader artifactLoader)
at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)
at System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection newConnection, DbConnection originalConnection, Boolean closeOriginalConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()
at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Avista.Afm.Data.CiPremDataService.GetAddressUnitTypes() in c:\Dev\AFM\DevartAndOffice\AFM\Data\Core\CiPremDataService.cs:line 681
at Avista.Afm.Coordinator.FrmLocateViaCSSAddr..ctor() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\frmLocateViaCSSAddr.cs:line 93
at Avista.Afm.Coordinator.Coordinator.RegisterLocators() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 1986
at Avista.Afm.Coordinator.Coordinator.BeginSession() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 6622
at Avista.Afm.Coordinator.Coordinator.NewOrOpenSession(ISessionObject tempSession, Boolean dontPromptJustSave) in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 5622
Desc: System.Data.MetadataException: Schema specified is not valid. Errors:
Afm.ssdl(782,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(783,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(794,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(795,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(796,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(797,6) : error 0040: The Type DATE is not qualified with a namespace or alias. Only primitive types can be used without qualification.
Afm.ssdl(798,6) : error 0040: The Type VARCHAR2
.
.
.
Afm.ssdl(12923,6) : error 0040: The Type VARCHAR2 is not qualified with a namespace or alias. Only primitive types can be used without qualification.
at System.Data.Metadata.Edm.StoreItemCollection.Loader.ThrowOnNonWarningErrors()
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths)
at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction)
at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths)
at System.Data.Metadata.Edm.MetadataCache.StoreMetadataEntry.LoadStoreCollection(EdmItemCollection edmItemCollection, MetadataArtifactLoader loader)
at System.Data.Metadata.Edm.MetadataCache.StoreItemCollectionLoader.LoadItemCollection(StoreMetadataEntry entry)
at System.Data.Metadata.Edm.MetadataCache.LoadItemCollection[T](IItemCollectionLoader`1 itemCollectionLoader, T entry)
at System.Data.Metadata.Edm.MetadataCache.GetOrCreateStoreAndMappingItemCollections(String cacheKey, MetadataArtifactLoader loader, EdmItemCollection edmItemCollection, Object& entryToken)
at System.Data.EntityClient.EntityConnection.LoadStoreItemCollections(MetadataWorkspace workspace, DbConnection storeConnection, DbProviderFactory factory, DbConnectionOptions connectionOptions, EdmItemCollection edmItemCollection, MetadataArtifactLoader artifactLoader)
at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)
at System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection newConnection, DbConnection originalConnection, Boolean closeOriginalConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()
at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Avista.Afm.Data.CiPremDataService.GetAddressUnitTypes() in c:\Dev\AFM\DevartAndOffice\AFM\Data\Core\CiPremDataService.cs:line 681
at Avista.Afm.Coordinator.FrmLocateViaCSSAddr..ctor() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\frmLocateViaCSSAddr.cs:line 93
at Avista.Afm.Coordinator.Coordinator.RegisterLocators() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 1986
at Avista.Afm.Coordinator.Coordinator.BeginSession() in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 6622
at Avista.Afm.Coordinator.Coordinator.NewOrOpenSession(ISessionObject tempSession, Boolean dontPromptJustSave) in c:\Dev\AFM\DevartAndOffice\AFM\Common\Coordinator\Coordinator.cs:line 5622