Hi,

great. It is available, a project converter. Makes some tasks much easier.

But I have a problem with the tool. It actually converts my SQL project to an Oracle 10g. No problem so far. When I try to update the catalog of the converted project, I'm able to connect to the Oracle DB, select the schema. After retrieving the schema following exception is thrown:

Exception message: An exception occured

Exception type: NullReferenceException

Stack trace:

-----[Core exception]--------------------
   bei SD.LLBLGen.Pro.Gui.UserControls.InheritanceHierarchyViewer.RemoveShape(EntityShape shape)
   bei SD.LLBLGen.Pro.Gui.UserControls.InheritanceHierarchyViewer.Entity_EntityMarkedForDeletion(Object sender, EventArgs e)
   bei System.EventHandler.Invoke(Object sender, EventArgs e)
   bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.MarkEntityDefinitionAsDeleted()
   bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityContainer.Remove(EntityDefinition definitionToRemove)
   bei SD.LLBLGen.Pro.ApplicationCore.CatalogRefresher.MigrateEntities()
   bei SD.LLBLGen.Pro.ApplicationCore.CatalogRefresher.MigrateProjectToNewCatalog(Boolean isUnattended, SelectTargetsForOrphanedElementsCallBack targetSelectCallBack)
   bei SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshCatalogs(Boolean unattended, Hashtable catalogsToRefresh)
   bei SD.LLBLGen.Pro.Gui.Forms.MainWindow.OnProjectExplorerCatalogRefreshClicked(Object sender, CatalogRefreshEventArgs e)
   bei SD.LLBLGen.Pro.Gui.Forms.ProjectExplorer._menuItemCatalogRefresh_Click(Object sender, EventArgs e)
   bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   bei System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   bei System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   bei System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   bei System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   bei System.Windows.Forms.Control.WndProc(Message& m)
   bei System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   bei System.Windows.Forms.ToolStrip.WndProc(Message& m)
   bei System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Any luck to get this fixed?

Many thanks and regards

Christoph

Hmm, that looks like a GUI error, not something to do with the actual project.

Does this occur every time or just when you have opened a given entity in the designer and refresh the catalog? It might be that the project isn't correctly converted which causes this.

Everytime I tried.

Just after the refresh of the schema. I'm not able to select an entity. It happens before the window of the project changes and migrations appears.

Christoph

ChBaeumer wrote:

Everytime I tried.

Just after the refresh of the schema. I'm not able to select an entity. It happens before the window of the project changes and migrations appears.

Christoph

I know when it happens, I want to know if you have had any entity open in the editor, because the exception is inside the hierarchy viewer.

No,

just loaded the project. And then I try to update the schema.

I just see that the stack trace is not the same. The previous one is shown when at least one entity is opened in the editor. The new one is shown when no entity is opened in the editor

-----[Core exception]-------------------- bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.OnSubTypeChanged(EntityDefinition subtype, ObjectChangeType typeOfChange) bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.OnSubTypeChanged(EntityDefinition subtype, ObjectChangeType typeOfChange) bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.MarkEntityDefinitionAsChangedToSuperType(ObjectChangeType typeOfChange) bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.MarkEntityDefinitionAsChanged(ObjectChangeType typeOfChange) bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.OnRelatedEntityMarkedForDeletion(Object sender, EventArgs e) bei System.EventHandler.Invoke(Object sender, EventArgs e) bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityDefinition.MarkEntityDefinitionAsDeleted() bei SD.LLBLGen.Pro.ApplicationCore.Entities.EntityContainer.Remove(EntityDefinition definitionToRemove) bei SD.LLBLGen.Pro.ApplicationCore.CatalogRefresher.MigrateEntities() bei SD.LLBLGen.Pro.ApplicationCore.CatalogRefresher.MigrateProjectToNewCatalog(Boolean isUnattended, SelectTargetsForOrphanedElementsCallBack targetSelectCallBack) bei SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshCatalogs(Boolean unattended, Hashtable catalogsToRefresh) bei SD.LLBLGen.Pro.Gui.Forms.MainWindow.OnProjectExplorerCatalogRefreshClicked(Object sender, CatalogRefreshEventArgs e) bei SD.LLBLGen.Pro.Gui.Forms.ProjectExplorer._menuItemCatalogRefresh_Click(Object sender, EventArgs e) bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) bei System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) bei System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) bei System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) bei System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) bei System.Windows.Forms.Control.WndProc(Message& m) bei System.Windows.Forms.ScrollableControl.WndProc(Message& m) bei System.Windows.Forms.ToolStrip.WndProc(Message& m) bei System.Windows.Forms.ToolStripDropDown.WndProc(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Ok. Just to be clear, a refresh of the original project on the original database works ok. ?

Also, as apparently entities are going to be deleted for some reason, by the refresh, what exactly has changed in the DB schema?

This is very important, as the supertype of a subtype entity is gone while that was unexpected. How did you create the Oracle schema? With the DDL templates?

Hmm,

the schema for both dbs are (or better should be) the same.

The refresh of the original project works as expected. I double checked the schemas of both database servers. I just created a fresh project from the oracle server. It looks the same to me, just like the converted

Should or could I send you the ddl-scripts and the project files for debugging purposes?

I need: - the original project (lgp) - the oracle DDL sql.

That way, I can create a conversion with the converter, and refresh it with the oracle DDL. If you've created the Oracle DDL from the converted project, you can just sent me the .lgp file

Mail to: support AT llblgen.com

Send

ChBaeumer wrote:

Send

received WIll have a look.