Could not retrieve the list of values

[former_member197671]

Need some direction.. Universe is created with IDT.. I have created some dynamic date prompts. You can create a webi report fine and use the dynamic dates and return values and refresh and change your values. Then you save the report. You go back into that saved report & modify the report and you get this error "Could not retrieve the list of values"  in the prompt dialog-We are on 4.0 SP7. You can create another report with the same objects and refresh the list of values, You can refresh within IDT as well.

java.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)

  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:333)

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

  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$000(Unknown Source)

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

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

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

  at java.security.AccessControlContext$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.Dialog$1.run(Unknown Source)

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

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

  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:119)

  at com.sap.webi.ui.context.managers.DataManager.resolvePrompts(DataManager.java:1646)

  at com.sap.webi.ui.context.managers.DataManager.resolveParameters(DataManager.java:1480)

  at com.sap.webi.ui.tasks.workflows.ResolveParametersUITask.doneProcess(ResolveParametersUITask.java:104)

  at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:367)

  at javax.swing.SwingWorker$5.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$000(Unknown Source)

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

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

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

  at java.security.AccessControlContext$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.Dialog$1.run(Unknown Source)

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

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

  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:119)

  at com.sap.webi.ui.workbench.datamanager.qpframe.QPFrame.showModal(QPFrame.java:333)

  at com.sap.webi.ui.workbench.datamanager.qpframe.QPFrame.showQueryPanel(QPFrame.java:293)

  at com.sap.webi.ui.context.managers.DataManager.showQueryPanel(DataManager.java:2618)

  at com.sap.webi.ui.context.managers.DataManager.editDataProvider(DataManager.java:467)

  at com.sap.webi.ui.action.data.EditDataProviderAction.onExecute(EditDataProviderAction.java:60)

  at com.sap.webi.ui.action.data.DataProviderAction.onExecute(DataProviderAction.java:57)

  at com.sap.webi.toolkit.ui.action.WebIAction.execute(WebIAction.java:476)

  at com.sap.webi.toolkit.ui.action.WebIAction.actionPerformed(WebIAction.java:448)

  at com.sap.webi.ui.action.type.ContextAction.actionPerformed(ContextAction.java:86)

  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.AWTEventMulticaster.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.Component.dispatchEvent(Unknown Source)

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

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

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

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

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

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

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

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

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

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

  at java.security.AccessControlContext$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: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)

  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:94)

  at com.sap.sl.sdk.services.util.ServerRequestProcessor.processServerRequest(ServerRequestProcessor.java:49)

  at com.sap.sl.sdk.lov.service.processor.DefaultLovProcessor.getIntervals(DefaultLovProcessor.java:191)

  at com.sap.sl.sdk.lov.service.processor.AbstractLovProcessor.getLovIntervals(AbstractLovProcessor.java:78)

  at com.sap.sl.sdk.lov.service.LovServiceImpl.getIntervals(LovServiceImpl.java:177)

  at com.sap.webi.client.toolkit.prompts.LOVHelper.fetchPath(LOVHelper.java:499)

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

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

  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$Worker.runTask(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: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)

  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)

  ... 18 more

Caused by: com.businessobjects.sdk.core.server.ServerException: BOException caught:RESULT=80004005;WHAT=An internal error occured while kc3CoreEngineImpl is calling GetListOfValues

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

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

  ... 19 more

[former_member183330]

If You are using this object as prompt it may occur this type of error I also faced,

When I am having optional prompts in my query for the first time or if I do any changes in existing query If i do not give any input for that prompt the error was coming. After giving some input and after refresh you can remove the prompt value and can run with out giving prompt input. for you also any work around will be there.

In your case what is the data type of your prompt object if it is not date data type make sure it should be date. because if the object data type is date then date eclipse will come when prompted for input.

Thanks,

G Sampath Kumar

[former_member197671]

It's a little more complex than that but nothing real crazy. It's a filter allowing the user to select a date or then select the day before but the objects used are defined as date. I am seeing some odd things where some reports after saved run fine and then some do not. I have opened a ticket.

[former_member183330]

It's better to upgrade to latest version, I think SAP also will suggest the same, because after up gradation I am not getting this kind of errors.

Thanks,

G Sampath Kumar

[Former Member]

Same problem occur in 4.1SP5. Report add filter for prompt list of values and take place "Could not retrieve the list of values".

[Former Member]

HI

  I got the same issue, have you tried to see the values in IDT? This is issue with repository server. This will be sorted out once restart.

[Former Member]

Hi, I did check the value of IDT. Also, I already restart Webi, core server by CMC and reboot OS. The problem still exist.

I just try to following BI Activity Workbook 1: Activity 29 Solution. Please give me any recommendation.

[former_member678295]

Hi Sam,

I'm facing similar issues.How I resolved the same and steps are as follows

1:copy existing report save in different or personal folder.

2:Remover/disable LOV.

3:Restart the CMS

4:Restore the LOV in coped report and save in the correct location(You will be replacing)

Thanks

[Former Member]

Dear Yugandhar,

  It's work. Thanks. This is a work around way to avoid retrieve list of values Error. I was suspected 2 reasons to cause this issues: 1. prompt option. 2. LOV option.  So, the cause is not prompt option. The main cause could be LOV( list of values ).

After disable LOV, Republish universe, reset query filter in report, re-query report, restart server(Core, Webi) from CMC.

I restore LOV option back to universe and republish universe to server.

Run Query again. The report not retrieve list of values.  The error not show up.

I try delete the cause problem dimension(year dim), add others dimension and add  the cause problem dimension to query filter with prompt option back. The error not come up.

Query will not retrieve list of values.

Finally, the report come back normal status.

But. I doubt why only year dim will cause LOV retrieve problem but others dim.

                                                                                                                                              Sam Sheen

[former_member678295]

Hi Sam,

Please try with cascade list of values option.

Thanks,

Yugandhar

[Former Member]

Hi Yugandhar,

   I join 2 queries Year and Quarter

It seem to be OK.