ERROR: Sequence contains no matching element
ddelmoli
Posts: 16
Currently running Program version 3.0.0.763
I've successfully generated the DS2 schema into a scripts folder, with the only non-default option being to ignore schema names.
However, when I now attempt to synchronize the scripts folder with a new, empty schema in the database I'm getting an error when Schema Compare attempts to register the scripts folder as a source. It errors on the CUSTOMERS.sql file saying "Sequence contains no matching element"
23:35:06.142|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidOperationException: Sequence contains no matching element
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
at #QzSc.#1HTc.#ovTc(Table #fvPb)
at #QzSc.#1HTc.#wqg(IFolderSchemaMapper #g33c, SchemaCompareDatabase #RHc, String #iGk)
at Parser.ScriptsFolderPopulator.Populate[#NrPb](Func`3 #50Uc, SchemaObjectCollection`1 #sYrc, String #63Vc, String #vDZb)
at Parser.ScriptsFolderPopulator.#Klh(String #63Vc)
at Parser.ScriptsFolderPopulator.Populate()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabasePopulator.#oZB(IPopulator #CEE, ICollection`1 #Yysc)
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass8.<DoTasks>b__3(Object q)
I've successfully generated the DS2 schema into a scripts folder, with the only non-default option being to ignore schema names.
However, when I now attempt to synchronize the scripts folder with a new, empty schema in the database I'm getting an error when Schema Compare attempts to register the scripts folder as a source. It errors on the CUSTOMERS.sql file saying "Sequence contains no matching element"
23:35:06.142|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidOperationException: Sequence contains no matching element
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
at #QzSc.#1HTc.#ovTc(Table #fvPb)
at #QzSc.#1HTc.#wqg(IFolderSchemaMapper #g33c, SchemaCompareDatabase #RHc, String #iGk)
at Parser.ScriptsFolderPopulator.Populate[#NrPb](Func`3 #50Uc, SchemaObjectCollection`1 #sYrc, String #63Vc, String #vDZb)
at Parser.ScriptsFolderPopulator.#Klh(String #63Vc)
at Parser.ScriptsFolderPopulator.Populate()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabasePopulator.#oZB(IPopulator #CEE, ICollection`1 #Yysc)
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass8.<DoTasks>b__3(Object q)
Comments
Thanks for this. Here is the latest build with this fixed:
http://download.red-gate.com/EAP/Schema ... .0.767.exe
Thanks,
Neil