Initializing Database Issue

[Ouspensky]

Suddenly out of the blue NT is refusing to start by getting stuck at the Initializing database part

This is what the tracelog says

2010-02-15 11:50:48:578 Creating user defined methods files...
2010-02-15 11:50:48:593 Instantiating serializers...
2010-02-15 11:50:53:468 Registering chart styles...
2010-02-15 11:50:53:625 Registering bars types...
2010-02-15 11:50:54:812 in OnUnhandledApplicationException
2010-02-15 11:50:54:953 ********* exception trapped *********
2010-02-15 11:50:54:953 Unknown
2010-02-15 11:50:54:953 System.Data.OleDb.OleDbException: Unknown
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteScalar()
   at Wilson.ORMapper.Internals.Connection.GetScalarValue(Type entityType, CommandInfo commandInfo, String sqlStatement, Parameter[] parameters)
   at Wilson.ORMapper.ObjectSpace.ExecuteScalar(String sqlStatement)
   at NinjaTrader.Db.Globals.get_Engine()
   at NinjaTrader.Gui.Globals.ApplicationStart()
   at NinjaTrader.Gui.ControlCenterForm.Application_Idle(Object sender, EventArgs e)
   at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FDoIdle(Int32 grfidlef)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
   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.Run()
   at NinjaTrader.NTMain.Main()

Re-installing NT or .NET doesnt seem to work either

[NinjaTrader_Jason]

Hello Ouspensky,

I suggest to use a brand new database and check if the error persists.

Make sure NinjaTrader is closed and go to (My) Documents-->NinjaTrader 6.5-->db and transfer the NinjaTrader.mdb file outside the My Documents-->NinjaTrader 6.5 folder.

Start NinjaTrader (a new database is created automatically) and check if the issue recurs.

The database contains ATM templates, saved chart data and trade history.

[Ouspensky]

Well, earlier I backed up the whole Ninjatrader folder, deleted all and then did a re-install - didn't work .The error happens while the .ldb file is being created and then it disappears.

[NinjaTrader_Kyle]

Hello Ouspensky,

Thank you for your reply and the additional information.

Please delete the .ldb file from the My Documents > NinjaTrader 6.5 > DB folder, then attempt to start NinjaTrader.

[Ouspensky]

hi Kyle

There is actually no ldb file in the folder to delete, the error happens as its getting created.

[NinjaTrader_Kyle]

Hello Ouspensky,

Thank you for your post.

No .ldb file should be created at any point durring start up.

Is Microsoft Access installed on this PC?

[Ouspensky]

hi Kyle

Yes MS Access 2007 is installed.

[NinjaTrader_Jason]

Can you please send me your latest log and trace files to support[at]ninjatrader[dot]com. Please reference this forum thread and put 'Attn Jason' in the subject header.

You can find these files at the following locations.

Start Menu--> My Documents--> NinjaTrader 6.5--> Log--> log.20100215.txt for today. (log.yyyymmdd for any other date)

Start Menu--> My Documents--> NinjaTrader 6.5--> Trace--> trace.20100215.txt for today. (trace.yyyymmdd for any other date)

[Ouspensky]

hi Jason

Just did that as per your instructions.

Regards.

[Ouspensky]

I was trying to track back of any s/w installations I did that lead to the DBException error message and found that I recently installed a time tracking software called Simpelogy which basically measures time taken b/w tasks.Just after installation it gave a error message and wouldn't run so I uninstalled it and later found that it was a very old s/w perhaps incompatible with newer platforms.

Here is the error message and perhaps can be useful in the current situation

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: Unknown
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.ExecuteReader()
   at Simpleology_Wimiki.AlarmTabControl.FillAlarm()
   at Simpleology_Wimiki.AlarmTabControl.DTpicker_ValueChanged(Object sender, EventArgs e)
   at System.Windows.Forms.DateTimePicker.OnValueChanged(EventArgs eventargs)
   at System.Windows.Forms.DateTimePicker.set_Value(DateTime value)
   at Simpleology_Wimiki.AlarmTabControl.AlarmTabControl_Load(Object sender, EventArgs e)
   at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
   at System.Windows.Forms.UserControl.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
   at System.Windows.Forms.TabPage.set_Visible(Boolean value)
   at System.Windows.Forms.TabControl.UpdateTabSelection(Boolean updateFocus)
   at System.Windows.Forms.TabControl.OnHandleCreated(EventArgs e)
   at System.Windows.Forms.Control.WmCreate(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.TabControl.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
simpleology Wimiki
    Assembly Version: 1.0.0.3
    Win32 Version: 1.0.0.3
    CodeBase: file:///D:/Program%20Files/Simpleology/simpleology%20Wimiki/simpleology%20Wimiki.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
SimpleologyTools
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///D:/Program%20Files/Simpleology/simpleology%20Wimiki/SimpleologyTools.DLL
----------------------------------------
System.Web.Services
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
_8pn7brd
    Assembly Version: 1.0.0.3
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[NinjaTrader_Jason]

Hello Ouspensky,

Unfortunately this information does not provide me any information that would be helpful to solve the issue with NinjaTrader.

[Ouspensky]

Well, seems like the only solution is to reinstall Windows. Its a pity that I was going live this week before the issue.

Also if NT7 supports Zenfire with Mirus I can perhaps try it, I heard it does not so that option is an issue.

[NinjaTrader_ChristopherJ]

Hello,

Yes, NinjaTrader 7 supports Mirus/Zen-Fire. I have provided a link below to our Connection Guide that goes over creating an account connection within NinjaTrader.

http://www.ninjatrader.com/webnew/support_ZenFire.htm

[Ouspensky]

Thanks, Thats great news, perhaps I can get away without format and reinstall of Windows hopefully.

Any quick tips to NT7 beta, will take some research on how to go about it, any pointers will help if its not much inconvenience.

Thanks Again.

[NinjaTrader_ChristopherJ]

I suggest visiting our Version 7 Beta section of the NinjaTrader Support Forum which includes a Critical Information and General Questoin area.