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

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.

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.ᜃ()

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?

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

Glad you got it going