Skip to Content
author's profile photo Former Member
Former Member

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

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)

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2007 at 12:35 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 01:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.