Hi,

I'm really trying my best to understand how things work. This exception is totally unclear to me. What I've done:

• Created an empty DB called 'KLIBNET2_DO_ReferenceData'
• Changed the UpgradeMode to 'recreate'
• Ran the program with configuration 'KLIBSQLDatabase'
• The Domain.Build(conf) returns a 'SchemaSynchronizationException'

It's just not my weekend ;-)

Regards Paul Sinnema Diartis AG

Here's my App.Config:

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="Xtensive.Storage" type="Xtensive.Storage.Configuration.Elements.ConfigurationSection, Xtensive.Storage" />
  </configSections>

  <Xtensive.Storage>
    <domains>
      <domain name="KLIBSQLDatabase"
              provider="sqlserver"
              upgradeMode="Recreate"
              connectionString="Data Source=DIARTIS-SQL1\SQL2008;Initial Catalog=KLIBNET2_DO_ReferenceData;Persist Security Info=True;User ID=klib;Password=canaansql;MultipleActiveResultSets=True">
        <!--autoValidation="false">-->
        <types>
          <add assembly="KLIBDatabase" />
        </types>
      </domain>
      <!--domain name="Memory" provider="memory" upgradeMode="Default" connectionString="memory://localhost/DetachedMemory">
        <types>
          <add assembly="KLIBDatabase" />
        </types>
      </domain>-->
      <!-- Examples of connectionUrl for other databases:
        <domain name="sqlserver"  upgradeMode="Recreate" connectionUrl="sqlserver://localhost/DO40-Tests">
        <domain name="sqlexpress" upgradeMode="Recreate" connectionUrl="sqlserver://localhost\SQLExpress/DO40-Tests">
        <domain name="pgsql"      upgradeMode="Recreate" connectionUrl="postgresql://do4test:do4testpwd@localhost/do40test?Encoding=ASCII">
        <domain name="oracle"     upgradeMode="Recreate" connectionUrl="oracle://do4test:do4testpwd@localhost/do40test">
        -->
    </domains>
  </Xtensive.Storage>
</configuration>

Here's the Message text from the Exception.

Extracted schema is not compatible with the target schema. Details:
Schema comparison result: TargetIsSuperset
Has unsafe actions: false
Has column type changes: false 
Compatible in ValidateLegacy mode: unknown

Unsafe actions:

Schema hints:

Schema difference:
  "./" != "./" (NodeDifference): Unknown
    +Tables: "./Tables (0)" != "./Tables (3)" (NodeCollectionDifference): 3 change(s)
      "" != "./Tables/Metadata.Assembly" (NodeDifference): Created
        +Columns: "" != "./Tables/Metadata.Assembly/Columns (2)" (NodeCollectionDifference): 2 change(s)
          "" != "./Tables/Metadata.Assembly/Columns/Name" (NodeDifference): Created
            +Type: "" != "Type: String, Length: 1024" (ValueDifference): values differ
          "" != "./Tables/Metadata.Assembly/Columns/Version" (NodeDifference): Created
            +Type: "" != "Type: String?, Length: 64" (ValueDifference): values differ
        +PrimaryIndex: "" != "./Tables/Metadata.Assembly/PrimaryIndex (PK_Assembly)" (NodeDifference): Created
          +IsUnique: "False" != "True" (ValueDifference): values differ
          +KeyColumns: "" != "./Tables/Metadata.Assembly/PrimaryIndex/KeyColumns (1)" (NodeCollectionDifference): 1 change(s)
            "" != "./Tables/Metadata.Assembly/PrimaryIndex/KeyColumns/0" (NodeDifference): Created
              +Direction: "None" != "Positive" (ValueDifference): values differ
              +Value: "" != "./Tables/Metadata.Assembly/Columns/Name" (ValueDifference): values differ
      "" != "./Tables/Metadata.Type" (NodeDifference): Created
        +Columns: "" != "./Tables/Metadata.Type/Columns (2)" (NodeCollectionDifference): 2 change(s)
          "" != "./Tables/Metadata.Type/Columns/Id" (NodeDifference): Created
            +Type: "" != "Type: Int32, Length: null" (ValueDifference): values differ
          "" != "./Tables/Metadata.Type/Columns/Name" (NodeDifference): Created
            +Type: "" != "Type: String?, Length: 1000" (ValueDifference): values differ
        +PrimaryIndex: "" != "./Tables/Metadata.Type/PrimaryIndex (PK_Type)" (NodeDifference): Created
          +IsUnique: "False" != "True" (ValueDifference): values differ
          +KeyColumns: "" != "./Tables/Metadata.Type/PrimaryIndex/KeyColumns (1)" (NodeCollectionDifference): 1 change(s)
            "" != "./Tables/Metadata.Type/PrimaryIndex/KeyColumns/0" (NodeDifference): Created
              +Direction: "None" != "Positive" (ValueDifference): values differ
              +Value: "" != "./Tables/Metadata.Type/Columns/Id" (ValueDifference): values differ
        +SecondaryIndexes: "" != "./Tables/Metadata.Type/SecondaryIndexes (1)" (NodeCollectionDifference): 1 change(s)
          "" != "./Tables/Metadata.Type/SecondaryIndexes/Type.IX_Name" (NodeDifference): Created
            +IsUnique: "False" != "True" (ValueDifference): values differ
            +KeyColumns: "" != "./Tables/Metadata.Type/SecondaryIndexes/Type.IX_Name/KeyColumns (1)" (NodeCollectionDifference): 1 change(s)
              "" != "./Tables/Metadata.Type/SecondaryIndexes/Type.IX_Name/KeyColumns/0" (NodeDifference): Created
                +Direction: "None" != "Positive" (ValueDifference): values differ
                +Value: "" != "./Tables/Metadata.Type/Columns/Name" (ValueDifference): values differ
            +PrimaryKeyColumns: "" != "./Tables/Metadata.Type/SecondaryIndexes/Type.IX_Name/PrimaryKeyColumns (1)" (NodeCollectionDifference): 1 change(s)
              "" != "./Tables/Metadata.Type/SecondaryIndexes/Type.IX_Name/PrimaryKeyColumns/0" (NodeDifference): Created
                +Direction: "None" != "Positive" (ValueDifference): values differ
                +Value: "" != "./Tables/Metadata.Type/Columns/Id" (ValueDifference): values differ
      "" != "./Tables/Metadata.Extension" (NodeDifference): Created
        +Columns: "" != "./Tables/Metadata.Extension/Columns (3)" (NodeCollectionDifference): 3 change(s)
          "" != "./Tables/Metadata.Extension/Columns/Name" (NodeDifference): Created
            +Type: "" != "Type: String, Length: 1024" (ValueDifference): values differ
          "" != "./Tables/Metadata.Extension/Columns/Text" (NodeDifference): Created
            +Type: "" != "Type: String?, Length: null" (ValueDifference): values differ
          "" != "./Tables/Metadata.Extension/Columns/Data" (NodeDifference): Created
            +Type: "" != "Type: Byte[]?, Length: null" (ValueDifference): values differ
        +PrimaryIndex: "" != "./Tables/Metadata.Extension/PrimaryIndex (PK_Extension)" (NodeDifference): Created
          +IsUnique: "False" != "True" (ValueDifference): values differ
          +KeyColumns: "" != "./Tables/Metadata.Extension/PrimaryIndex/KeyColumns (1)" (NodeCollectionDifference): 1 change(s)
            "" != "./Tables/Metadata.Extension/PrimaryIndex/KeyColumns/0" (NodeDifference): Created
              +Direction: "None" != "Positive" (ValueDifference): values differ
              +Value: "" != "./Tables/Metadata.Extension/Columns/Name" (ValueDifference): values differ

Updated at 11.07.2010 11:07:46

Hi,

I just downloaded the DB from my PC at work and now I can open the DB using 'Perform' as UpgradeMode.

The Debugger halt 2 times with something like this:

The assembly with display name 'Xtensive.Storage.Model.XmlSerializers' failed to load in the 'LoadFrom' binding context of the AppDomain with ID 1. The cause of the failure was: System.IO.FileNotFoundException: Could not load file or assembly 'Xtensive.Storage.Model.XmlSerializers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=93a6c53d77a5296c' or one of its dependencies. The system cannot find the file specified.

But the Program continues after these messages:

Regards Paul Sinnema Diartis AG

Updated at 12.07.2010 7:05:36

It's just not my weekend ;-)

Holland lost from Spain too. This was defenitely not my weekend. :(

This thread was imported from our support forum. The original discussion may contain more detailed answer.