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.

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)

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