• Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.1.0 RC
    • Fix Version/s: None
    • Component/s: SERVER/Database
    • Labels:
    • Environment:
      Win 7 x64, Java 7, Tomcat 7
    • Bug type:
      New bug


      I have defined Impala (CDH 5.2) as Data Source. I have created Dataset to load some values. The preview works fine. However when I go to use this Dataset to create LOV I always get error: "... contact administrator" and the LOV is not created.
      Doing some reverse engineering I saw this part of code in SpagoBIDAO (

      public void loadFromXML(String dataDefinition) throws SourceBeanException {
      if(dataDefinition.indexOf("<ID>")!=-1) {
      int startInd = dataDefinition.indexOf("<ID>");
      int endId = dataDefinition.indexOf("</ID>");
      String dataset = dataDefinition.substring(startInd + 6, endId);
      dataset =dataset.trim();
      if(!dataset.startsWith("<![CDATA[")) {
      dataset = "<![CDATA[" + dataset + "]]>";
      dataDefinition = dataDefinition.substring(0, startInd + 6) + dataset + dataDefinition.substring(endId);

      The LOV cannot get created because I get exception "out of bounds". If you see carefully and as I understand the creator wants to extract the id from <ID> id </ID> and put it inside CDATA, however using the beginning of the <ID> + 6 and then using the beginning of </ID> this will throw exception since the start is bigger than the end. As a solution that I tested and it works (at least for now) is to replace the "6" with 4 (the length of <ID>).


          Issue Links



              • Assignee:
                macortel Marco Cortella
                xyan.spw Hristijan Petreski
              • Votes:
                2 Vote for this issue
                4 Start watching this issue


                • Created: