Object reference not set to an instance of an object. in Query disigner

[Former Member]

Using the Bex query desingne we get the following message:

An unhandled exception occured in your application etc

Object reference not set to an instance of an object.

Details are:

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

at com.sap.bi.et.QueryDesigner.QDcElement.Contains(QDbElement iValue)

at com.sap.bi.et.QueryDesigner.QDbElement.WhereUsedAdd(QDbElement iElement)

at com.sap.bi.et.QueryDesigner.QDbStructureMemberFormula.WhereUsedAdd(QDbElement iElement)

at com.sap.bi.et.QueryDesigner.QDbElement.FromUndoTable(RSZ_X_ELTXREF isWhereUsed, QDcElement iElements)

at com.sap.bi.et.QueryDesigner.QDbElement.FromTables(Hashtable iTables, QDcElement iElements)

at com.sap.bi.et.QueryDesigner.QDbElement.Undo(QDbUndoRedoBuffer cUndoBuffer, QDbUndoRedoBuffer& cRedoBuffer)

at com.sap.bi.et.QueryDesigner.QDbCommandEditElement.Undo()

at com.sap.bi.et.QueryDesigner.QDbCommandEditElement.EditFormula(IQDView iSelectedView)

at com.sap.bi.et.QueryDesigner.QDbCommandEditElement.ExecuteCommand()

at com.sap.bi.et.QueryDesigner.QDbCommandBase.Execute()

at com.sap.bi.et.QueryDesigner.QDbCommandManager.CommandExecute(QDbCommandBase iCommand)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.InitialCommandExecute(QDbCommandBase iCommand)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.DoExecuteCommandInternal()

at com.sap.bi.et.QueryDesigner.QDiButtonCommand.Execute()

at com.sap.bi.et.QueryDesigner.QDiButtonCommand.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at Syncfusion.Windows.Forms.ButtonAdv.OnMouseUp(MouseEventArgs e)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[Former Member]

We found that after installing a security patch the file association for excel files was changed from 2003 naar 2000.

Setting the default file association back to Excel 2003 it worked like before.

[Former Member]

Make sure you have all the pre-requisites for the new front end, .NET 1.1 Framework and hot fixes. Also try applying the latest patch for query designer SP 12.

[Former Member]

Thanks for the suggestion Deepu. I looked at the available downloads and saw there was a SP13 available, so I downloaded that and will try this on Monday May 21st.

I will also check the .NET 1.1 framwork and hotfixes.

[Former Member]

We found that after installing a security patch the file association for excel files was changed from 2003 naar 2000.

Setting the default file association back to Excel 2003 it worked like before.