If a non-default console port is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, it can cause problems while building dynamic collections in BigSheets.

Technote (FAQ)


Question

If a non-default console port is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, it can cause problems while building dynamic collections in BigSheets.

Cause

During InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, if you change the BigInsights console HTTP port to a non-default port (e.g. 8081), the BigSheets back-end server port and PigServer port will also change from their default values, This, in turn, might create a port conflict that can cause problems while building dynamic collections in BigSheets.

It might result in the following stack trace in bigsheets.log:

2012-04-09 04:27:29,520 ERROR org.apache.m2.webapp.controller.api.command.sheet.SheetEvaluateCommand:
Error evaluating spreadsheet
java.lang.StringIndexOutOfBoundsException
at java.lang.String.substring(String.java:1093)
at org.apache.m2.server.pig.PigLocalClient.createPigResponse(PigLocalClient.java:82)
at org.apache.m2.server.pig.PigLocalClient.request(PigLocalClient.java:68)
at org.apache.m2.model.pig.Executioner.getResultsFromServer(Executioner.java:361)
at org.apache.m2.model.pig.formula.PigEvaluator.getData(PigEvaluator.java:800)
at org.apache.m2.model.formula.SpreadsheetBuilder.getResultSpreadsheet(SpreadsheetBuilder.java:61)
at org.apache.m2.webapp.controller.api.command.sheet.SheetEvaluateCommand.executeImpl(SheetEvaluateCommand.java:75)
at org.apache.m2.webapp.controller.api.command.sheet.SheetEvaluateCommand.execute(SheetEvaluateCommand.java:50)
at org.apache.m2.webapp.controller.api.ExecuteController.exec(ExecuteController.java:69)
at org.apache.m2.webapp.controller.api.ExecuteController.index(ExecuteController.java:23)

Answer

  1. Stop BigSheets.
    $BIGINSIGHTS_HOME/bin/stop.sh sheets
  2. Reset BigSheet's backend server port by setting its value different than PigServer port in $BIGINSIGHTS_HOME/sheets/conf/m2config.ini
    "backEndServerPort": 8090,
    "pigLocalServerPort": 8091,
  3. Restart BigSheets
    $BIGINSIGHTS_HOME/bin/start.sh sheets

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere BigInsights
Install

Software version:

1.3.0

Operating system(s):

Linux Red Hat - xSeries, Linux SUSE - xSeries

Software edition:

Basic Edition, Enterprise Edition

Reference #:

1590964

Modified date:

2012-04-16

Translate my page

Machine Translation

Content navigation