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

Program error when refreshing Webi Report based on BW query

Hello,

I am using BW7.40 SP5. I am trying to run WEBI reports based on the BeX query. Unfortunately when I am trying to retrive hierarchy data at the selection screen I receive error.

BO 4.1 SP7 patch 5 HF2. The error receive when I push the button refresh

<ERROR COMPONENT="WIS" ERRORCODE="0" ERRORTYPE="SUPERVISOR" MESSAGE="Termination message sent &amp;#10;ABEND RS_EXCEPTION (000): Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI is not compatible, for the purposes of assignment, with target type&amp;#10; MSGV1: Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI&amp;#10; MSGV2: is not compatible, for the purposes of assignment,&amp;#10; MSGV3: with target type" PREFIX="ERR">

<DEBUGINFO BORESULT="" FILENAME="kc3dsdsl_server.cpp" LINEPOSITION="2182" MODULENAME="C3_DSDSL_SERVER"/>

<REQUESTINFO COMMANDID="0" COMMANDNAME="Add DP" DPID="" DPLONGNAME="" DPNAME=""/>

|fa489582-f618-6dc4-1806-f80b8df022e9|2016 09 06 15:02:06:002|+0200|Error| |>>|E| |WebIRichClient|11988|15240|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|S1-IN0DJ-AZ13:11988:343.657:2|Webi SDK.CorbaServerImpl.doProcess()|S1-IN0DJ-AZ13:11988:343.657:2|WebIRichClient.getSessionInfosEx|localhost:11988:15240.1046:1|Cukv6fk65Eq3rnx41gXOhLA14f|||||||||||**ERROR:C3_DPManager:No DP found : [kc3cdbdpmanager.cpp;314]

kc3CoreEngineImpl.cpp:10522:long __thiscall IECore::kc3CoreEngineImpl::int_GetListOfValues(struct IECore::ic3LovManager::dgLOVObject &,class ibo_ptr<struct ic3DataProvider> &,const class ucs2string &,enum IECore::kc3CoreEngineImpl::tag_LovState,bool,bool,bool,const char *,class std::basic_ostream<char,struct std::char_traits<char> > &,const class ucs2string &,const class std::vector<struct RESTRICTIONPATH,class std::allocator<struct RESTRICTIONPATH> > *): TraceLog message 345

Can someone advise me what can raise the error and how can I solve the issue?

The hierarchy does not have default value.

thenk you in advance for your feedback

BO_ERR01.jpg (46.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2016 at 11:37 AM

    Hello,

    we have found the resolution of the error. It can be solved by implementing SAP note 1923043 - RSBOLAP: Exception

    The issue is linked to BW7.4 SP005

    Regards

    Piotr

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2016 at 03:19 PM

    is your query running in BEx analyzer or RSRT?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2016 at 05:28 PM

    Hi,

    Either you dont have access to that object or need necessary roles to run this report.

    Did you tried running the same object in BEx Analyzer?.

    Thanks,

    Jothi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      no issue on this report at BEx and RSRT.

      The same user is able to run reports at RSRT and can not display hierarchy variables at WEBI via BICS connection.

      Is there any general settings which I can validate? The issue is linked not only to this single report. Also at other reports where I am using hierarchy variables at filter section I have th esame issue.

      This is linked to new installation of BO

      Thanks,

      Piotr

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2016 at 07:16 AM

    Hi,

    I think below documents will help you.

    BI4 SP4: List Of Values not getting displayed (... | SCN

    Regards,
    Mithun.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      unfortunately it does not solve my issue

      I do not have any issue to display from BEx LOV which is based on standard variable

      when I am trying to set value on the hierarchy variable I have error

      the BEx query has 4 filters 2 standard variable and 2 hierarchy variables

      java.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Termination message sent &#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable Fiscal Year&#10; MSGV1: Fiscal Year&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ABEND RS_EXCEPTION (000): Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI is not compatible, for the purposes of assignment, with target type&#10; MSGV1: Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI&#10; MSGV2: is not compatible, for the purposes of assignment,&#10; MSGV3: with target type

      at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

      at java.util.concurrent.FutureTask.get(Unknown Source)

      at javax.swing.SwingWorker.get(Unknown Source)

      at com.sap.webi.qp.lovprompt.LOVTable.endFetch(LOVTable.java:323)

      at com.sap.webi.qp.lovprompt.LOVTable.propertyChange(LOVTable.java:511)

      at java.beans.PropertyChangeSupport.fire(Unknown Source)

      at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)

      at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport.firePropertyChange(Unknown Source)

      at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport$1.run(Unknown Source)

      at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

      at sun.swing.AccumulativeRunnable.run(Unknown Source)

      at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

      at javax.swing.Timer.fireActionPerformed(Unknown Source)

      at javax.swing.Timer$DoPostEvent.run(Unknown Source)

      at java.awt.event.InvocationEvent.dispatch(Unknown Source)

      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

      at java.awt.EventQueue.access$200(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue.dispatchEvent(Unknown Source)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.WaitDispatchSupport$2.run(Unknown Source)

      at java.awt.WaitDispatchSupport$4.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.awt.WaitDispatchSupport.enter(Unknown Source)

      at java.awt.Dialog.show(Unknown Source)

      at com.jidesoft.dialog.StandardDialog.show(Unknown Source)

      at java.awt.Component.show(Unknown Source)

      at java.awt.Component.setVisible(Unknown Source)

      at java.awt.Window.setVisible(Unknown Source)

      at java.awt.Dialog.setVisible(Unknown Source)

      at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:128)

      at com.sap.webi.ui.keydates.SapVariableRendererPanel.showLov(DefaultParameterItem.java:243)

      at com.sap.webi.ui.keydates.SapVariableRendererPanel.access$000(DefaultParameterItem.java:132)

      at com.sap.webi.ui.keydates.SapVariableRendererPanel$1.actionPerformed(DefaultParameterItem.java:162)

      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

      at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

      at java.awt.Component.processMouseEvent(Unknown Source)

      at javax.swing.JComponent.processMouseEvent(Unknown Source)

      at java.awt.Component.processEvent(Unknown Source)

      at java.awt.Container.processEvent(Unknown Source)

      at java.awt.Component.dispatchEventImpl(Unknown Source)

      at java.awt.Container.dispatchEventImpl(Unknown Source)

      at java.awt.Component.dispatchEvent(Unknown Source)

      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

      at java.awt.Container.dispatchEventImpl(Unknown Source)

      at java.awt.Window.dispatchEventImpl(Unknown Source)

      at java.awt.Component.dispatchEvent(Unknown Source)

      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

      at java.awt.EventQueue.access$200(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue$4.run(Unknown Source)

      at java.awt.EventQueue$4.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue.dispatchEvent(Unknown Source)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.WaitDispatchSupport$2.run(Unknown Source)

      at java.awt.event.InvocationEvent.dispatch(Unknown Source)

      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

      at java.awt.EventQueue.access$200(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue.dispatchEvent(Unknown Source)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

      at java.awt.EventDispatchThread.run(Unknown Source)

      Caused by: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Termination message sent &#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable Fiscal Year&#10; MSGV1: Fiscal Year&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ABEND RS_EXCEPTION (000): Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI is not compatible, for the purposes of assignment, with target type&#10; MSGV1: Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI&#10; MSGV2: is not compatible, for the purposes of assignment,&#10; MSGV3: with target type

      at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)

      at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)

      at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:127)

      at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:178)

      at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)

      at com.businessobjects.sdk.core.server.internal.InstanceServer.process(InstanceServer.java:96)

      at com.sap.sl.sdk.parameter.service.processor.AbstractParameterProcessor.provideAnswersForContextOrNonContextParameters(AbstractParameterProcessor.java:152)

      at com.sap.sl.sdk.parameter.service.processor.AbstractParameterProcessor.provideAnswers(AbstractParameterProcessor.java:113)

      at com.sap.sl.sdk.parameter.service.ParameterServiceImpl.provideAnswers(ParameterServiceImpl.java:66)

      at com.sap.webi.client.toolkit.prompts.LOVHelper.provideAnswers(LOVHelper.java:210)

      at com.sap.webi.client.toolkit.prompts.LOVHelper.update(LOVHelper.java:510)

      at com.sap.webi.qp.lovprompt.RefreshLovWorker.doInBackground(RefreshLovWorker.java:49)

      at com.sap.webi.qp.lovprompt.RefreshLovWorker.doInBackground(RefreshLovWorker.java:13)

      at javax.swing.SwingWorker$1.call(Unknown Source)

      at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at javax.swing.SwingWorker.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

      Caused by: com.businessobjects.sdk.core.server.ServerException: Termination message sent &#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable Fiscal Year&#10; MSGV1: Fiscal Year&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ERROR BRAIN (629): Specify a value for variable Responsible Cost Center&#10; MSGV1: Responsible Cost Center&#13;&#10;ERROR BRAIN (629): Specify a value for variable Work Breakdown Structure&#10; MSGV1: Work Breakdown Structure&#13;&#10;ERROR BRAIN (629): Specify a value for variable To Period&#10; MSGV1: To Period&#13;&#10;ABEND RS_EXCEPTION (000): Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI is not compatible, for the purposes of assignment, with target type&#10; MSGV1: Source type \CLASS=CL_RSBOLAP_VARIABLE_CHARACTERI&#10; MSGV2: is not compatible, for the purposes of assignment,&#10; MSGV3: with target type

      at com.businessobjects.sdk.core.server.common.CommonRequestHandler.newServerException(CommonRequestHandler.java:260)

      at com.businessobjects.sdk.core.server.common.CommonRequestHandler.createAllServerExceptions(CommonRequestHandler.java:238)

      at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:121)

      ... 17 more

      LOV_1.jpg (39.8 kB)
      LOV_2.jpg (48.5 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2016 at 09:23 AM

    My issue is very similar to sap notes 1770643 and 1797705

    but both those issue are linked to older version of BO.

    I have at my server 4.1 SP07. To be honest I have not tested this functionality with SP02.

    Piotr


    LOV_3.jpg (31.6 kB)
    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.