cancel
Showing results for 
Search instead for 
Did you mean: 

Query Designer not working with Aggregation Levels on BW 7.30

former_member215766
Participant
0 Kudos

Hi,

Every time I try to create a query on top of an Aggregation Level that I created with the new ABAP based RSPLAN transaction.

If somebody can help me out I'd appreciate it.

By the way, we don't have the Java stack, but we are currently using BO4's JVM as we're on ramp up.

This is the error that I get when trying to create the query:

QD Revision 667

ERROR ID: E-ONGUIUNHANDLEDEXCEPTION

And this is the error log:

1:42:13 p.m..319: Info: Query Designer Start. Revision: 667

-


QDbCommandBase::Execute - Standard View

QDbCommandBase::Execute - Table View

QDbCommandBase::Execute - Rows/Columns

QDbCommandBase::Execute - Cells

QDbCommandBase::Execute - Conditions

QDbCommandBase::Execute - Exceptions

QDbCommandBase::Execute - InfoProvider

QDbCommandBase::Execute - Filter

QDbCommandBase::Execute - Documents

QDbCommandBase::Execute - Where-Used List

QDbCommandBase::Execute - Properties

QDbCommandBase::Execute - Properties

QDbCommandBase::Execute - Messages

QDbCommandManager::ItemClickedHandler - Bar clicked: NewQuery

QDbCommandBase::Execute - New...

QDbCommandBase::Execute - Table View

QDbCommandBase::Execute - Rows/Columns

QDbCommandBase::Execute - Cells

QDbCommandBase::Execute - Conditions

QDbCommandBase::Execute - Exceptions

QDbCommandBase::Execute - InfoProvider

QDbCommandBase::Execute - Filter

QDbCommandBase::Execute - Documents

QDbCommandBase::Execute - Where-Used List

QDbCommandBase::Execute - Messages

QDbCommandBase::Execute - Table View

QDbCommandBase::Execute - Cells

QDbCommandBase::Execute - Conditions

QDbCommandBase::Execute - Exceptions

QDbCommandBase::Execute - Rows/Columns

QDbCommandBase::Execute - Filter

QDbCommandBase::Execute - InfoProvider

QDbCommandBase::Execute - Properties

-EXCEPTION-START- 1:42:52 p.m..416: TRACE EXCEPTION ---

Exception Name: TargetInvocationException

Exception Message: Exception has been thrown by the target of an invocation.

Exception at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)

at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)

at com.sap.bi.et.QueryDesigner.QDpPropertyBase.PropertyGet(Object iPropertySource, String iPropertyName)

at com.sap.bi.et.QueryDesigner.QDpPropertyBase.ValueGetDefault(Object iPropertySource)

at com.sap.bi.et.QueryDesigner.QDpPropertyBase.pValueDefault()

at com.sap.bi.et.QueryDesigner.QDpPropertyBase.ValueDefault()

at com.sap.bi.et.QueryDesigner.QDpPropertyBase.ValueResolved()

at com.sap.bi.et.QueryDesigner.QDpPropertyMulti.SetFirstProperty(QDpPropertyBase iProperty)

at com.sap.bi.et.QueryDesigner.QDpPropertyMulti.Add(QDpPropertyBase iProperty)

at com.sap.bi.et.QueryDesigner.QDuPropPageQuery.ToDialog()

at com.sap.bi.et.QueryDesigner.QDuPropPageBase.ToDialogCore()

at com.sap.bi.et.QueryDesigner.QDuPropPageBase.set_CommandContext(QDbCommandContext Value)

at com.sap.bi.et.QueryDesigner.QDuPropPages.EnablePage()

at com.sap.bi.et.QueryDesigner.QDuPropPages.ContextChangedHandler(Object iSender, QDbCommandContext iCommandContext)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.ContextChangedEventHandler.Invoke(Object iSender, QDbCommandContext iCommandContext)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.OnContextChanged(QDbCommandContext iCommandContext)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.CalculateContext(QDcView iViews, QDeAreaType iAreaType)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.CalculateContext(QDbElement iElement)

at com.sap.bi.et.QueryDesigner.QDbCommandPropertiesQuery.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.QDbCommandManager.DoExecuteCommand(QDbCommandBase iCommand)

at com.sap.bi.et.QueryDesigner.QDbCommandManager.ItemClickedHandler(Object sender, BarItemClickedEventArgs args)

at com.sap.bi.et.QueryDesigner.QDdEventDispatcher.MenuItemClickedHandler(Object iSender, BarItemClickedEventArgs iE)

at Syncfusion.Windows.Forms.Tools.XPMenus.BarManager.OnItemClicked(BarItemClickedEventArgs args)

at Syncfusion.Windows.Forms.Tools.XPMenus.BarItem.OnItemClicked(EventArgs args)

at com.sap.bi.et.QueryDesigner.QDiBarItem.OnItemClicked(EventArgs args)

at Syncfusion.Windows.Forms.Tools.XPMenus.BarItem.PerformClick()

at Syncfusion.Windows.Forms.Tools.XPMenus.BarRenderer.OnMouseUp(MouseEventArgs e)

at Syncfusion.Windows.Forms.Tools.XPMenus.BarControlInternal.OnMouseUp(MouseEventArgs e)

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

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

at Syncfusion.Windows.Forms.Tools.XPMenus.BarControlInternal.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)

Full Stack: at com.sap.bi.et.common.appl.Log.Debug.WriteTraceToFile(Level lLevel, String lString, Exception ex)

at com.sap.bi.et.common.appl.Log.Trace.Exception(Exception ex, String iAdditionalInformation)

at com.sap.bi.et.QueryDesigner.QDbApplicationData.OnGuiUnhandledException(Object iSender, ThreadExceptionEventArgs iEventArgs)

at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

at System.Windows.Forms.Control.WndProcException(Exception e)

at System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e)

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

at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

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(Form mainForm)

at com.sap.bi.et.QueryDesigner.QDbApplicationData.Run(Boolean iAsApplication)

at com.sap.bi.et.QueryDesigner.QDbQueryDesigner.Run(Boolean iAsApplication)

at com.sap.bi.et.QueryDesigner.QDStarter.QDStartup.Main()

-EXCEPTION-END----

-CALLING-FROM- 1:42:52 p.m..416: TRACE EXCEPTION ---

at com.sap.bi.et.common.appl.Log.Debug.WriteTraceToFile(Level lLevel, String lString, Exception ex)

at com.sap.bi.et.common.appl.Log.Trace.Exception(Exception ex, String iAdditionalInformation)

at com.sap.bi.et.QueryDesigner.QDbApplicationData.OnGuiUnhandledException(Object iSender, ThreadExceptionEventArgs iEventArgs)

at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

at System.Windows.Forms.Control.WndProcException(Exception e)

at System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e)

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

at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

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(Form mainForm)

at com.sap.bi.et.QueryDesigner.QDbApplicationData.Run(Boolean iAsApplication)

at com.sap.bi.et.QueryDesigner.QDbQueryDesigner.Run(Boolean iAsApplication)

at com.sap.bi.et.QueryDesigner.QDStarter.QDStartup.Main()

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi,

it seems that you are already using the most recent query designer version. Is your SAPGUI also the most recent version? If yes, open a OSS ticket. If not reinstall the SAPGUI and the BEx tools. I am also working with this query desinger version and I don't have this kind of problem.

Regards,

Gregor

former_member215766
Participant
0 Kudos

Well...I found the solution for this problem.

It looks like the infoobject 0REQPLAN wasn't active. I activated it, and it worked.

govind_ramesh
Active Participant
0 Kudos

This did help me solve the Error while creating a Query on The Aggregation Level.