RS01015: Rule Designer processes empty lines of Excel sheet when creating a domain

Operational Decision Manager V8.0.1 Download Document
WebSphere Operational Decision Management V7.5.0.3 Fix Pack

APAR status

• Closed as fixed if next.

Error description

• Error Description:
  The error "At least one value in the Excel file is empty or
  contains space characters." can show even if the Excel sheet is
  neither empty nor contains spaces, and was filled properly
  according to the documentation.
  This occurs if empty lines have been modified before.
  Updating an existing domain with such file fails as well and
  shows the following error in the Eclipse log:
  !MESSAGE GBRSB0024E : Unexpected exception in BOM plugins.
  !STACK 0
  java.lang.NullPointerException
  at
  ilog.rules.shared.util.IlrExcelHelper.GetStringCellValue(Unknown
  Source)
  at
  ilog.rules.shared.bom.IlrAbstractExcelDomainProvider.getValues(U
  nknown Source)
  at
  ilog.rules.vocabulary.model.bom.IlrBOMDomainUpdater.update(Unkno
  wn Source)
  at
  ilog.rules.studio.model.bom.util.IlrBOMUtil.updateDynamicDomain(
  Unknown Source)
  at
  ilog.rules.studio.bom.editor.pages.parts.domains.IlrEnumeratedDo
  mainEditor.handleSynchronizeStaticReferencesLinkActivated(Unknow
  n Source)
  at
  ilog.rules.studio.bom.editor.pages.parts.domains.IlrEnumeratedDo
  mainEditor$3.linkActivated(Unknown Source)
  at
  org.eclipse.ui.forms.widgets.FormText.activateLink(FormText.java
  :1552)
  at
  org.eclipse.ui.forms.widgets.FormText.handleMouseClick(FormText.
  java:1355)
  at
  org.eclipse.ui.forms.widgets.FormText.access$16(FormText.java:13
  26)
  at
  org.eclipse.ui.forms.widgets.FormText$6.mouseUp(FormText.java:44
  8)
  at
  org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.
  java:213)
  at
  org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
  at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
  at
  org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4
  066)
  at
  org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:365
  7)
  at
  org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:26
  40)
  at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
  at
  org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
  at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
  at
  org.eclipse.core.databinding.observable.Realm.runWithDefault(Rea
  lm.java:332)
  at
  org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbenc
  h.java:664)
  at
  org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:
  149)
  at
  org.eclipse.ui.internal.ide.application.IDEApplication.start(IDE
  Application.java:115)
  at
  org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseApp
  Handle.java:196)
  at
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.run
  Application(EclipseAppLauncher.java:110)
  at
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.sta
  rt(EclipseAppLauncher.java:79)
  at
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStart
  er.java:369)
  at
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStart
  er.java:179)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:60)
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:37)
  at java.lang.reflect.Method.invoke(Method.java:611)
  at
  org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)
  at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
  at org.eclipse.equinox.launcher.Main.run(Main.java:1408)
  

Local fix

• Local Fix:
  Delete all lines below the table containing data : select all
  lines/cells, de-select the rows with data, then delete
  selection.
  

Problem summary

• Fix will be available in the next service packs for 7.5 and 8.0.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R750 PSY

     UP

• R800 PSY

     UP