StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » BO mapper and missing entries in dbo.DTEproject_item_exceptions

BO mapper and missing entries in dbo.DTEproject_item_exceptions

Peter Jones — Mon, 21 Sep 2009 08:22:18 GMT

Hi,

I changed multiple tables (removed 60% of columns) and remapped them. I then restored the database and got my columns back. I remapped the tables against the restored database however most of our columns are mapped as 'use nullable generic' so I thought I would make the change directly in the dbo.DTEproject_item_exceptions table however the columns I deleted are no longer in that table.

I take it that dbo.DTEproject_item_exceptions only contains columns that have been customised and remapping the BO didn't recreate them because they haven't been customised yet. Is there any way, other than using the bo mapper manually, to add my missing columns to dbo.DTEproject_item_exceptions table and set them all to 'use nullable generic'?

Cheers, Peter

RE: BO mapper and missing entries in dbo.DTEproject_item_exceptions

Trent L. Taylor — Mon, 21 Sep 2009 08:22:18 GMT

Glad you got it going ;)

RE: BO mapper and missing entries in dbo.DTEproject_item_exceptions

Peter Jones — Sun, 20 Sep 2009 18:01:10 GMT

Hi Trent,

This started happening well be I even knew this table existed however I followed the path of nonstandard projects in our solution and have deleted one that contained misc stuff such as a pdf reader and izarc plus I deleted the installation projects and the mapper didn't error out. I can now change my mappings and add back these projects later.

BTW I did notice that Timestamps is not in your list of data types. We always set ours to Return alternate > Nothing.

Anyway up and going now - thanks for the feedback.

Cheers, Peter

RE: BO mapper and missing entries in dbo.DTEproject_item_exceptions

Trent L. Taylor — Sun, 20 Sep 2009 17:34:49 GMT

It looks like this is happening when it is attempting to fill the projects. Have you been manually updating the StrataFrame DTE tables? There could be stray record or two if this is the case. Also, if you do this for a new project, to confirm, it doesn't fail. Correct?

RE: BO mapper and missing entries in dbo.DTEproject_item_exceptions

Peter Jones — Sun, 20 Sep 2009 17:32:40 GMT

Hi Trent,

Yes, we get the following error after clicking the Wizard and while 'populating tree view' is displayed. Given that no other users have reported this issue we presumed it had something to do with a project in our environment. When this first occured we had mapped 95% of all our BO's and we simply managed all the rest without the Wizard. If we could somehow map all our columns to "use nullable generic" that would be a great help.

At the moment I'm trying to nut out what project is causing the exception.

Cheers, Peter

NullReferenceException
Object reference not set to an instance of an object.

Source : MicroFour StrataFrame AddIns

Stack Trace:
at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ(ᜑ A_0)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ()
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.ᜃ()

RE: BO mapper and missing entries in dbo.DTEproject_item_exceptions

Trent L. Taylor — Sun, 20 Sep 2009 10:27:29 GMT

Well, just to make sure that I understand, is there any reason that the Customize Wizard will not work for you? That is the purpose of the wizard is to set these types of things in mass.