Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.1.0
    • Component/s: SERVER/Database
    • Labels:
      None
    • Environment:
      Windows 7 64 bit, JDK1.6.0_03-b05, PostgreSQL 8.4

      Description

      1) The table SBO_EXT_ROLES has an wrong field name:

      SAVE_INTEGERO_FOLDER
      instead of
      SAVE_INTO_FOLDER

      Extract of the script:
      SAVE_INTEGERO_FOLDER BOOLEAN DEFAULT TRUE,

      2) The table SBI_USER has 3 incompatibles "NOT NULL" constraints on the fields DT_PWD_BEGIN, DT_PWD_END and DT_LAST_ACCESS DATE.

      These 3 fields do not accept NULL value, and an error is raised when launching tomcat

      I see it as a DB Script BUG, but maybe this values should really never be NULL and therfore it's an application BUG

      The error is the following:

      ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « dt_pwd_begin »
      [main] 07 juil. 2011 15:58:30,419 ERROR it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.saveSbiUser:168 - Could not execute JDBC batch update

      See attached file for complete SpagoBI.log

      Extract of the script:
      DT_PWD_BEGIN DATE NOT NULL DEFAULT CURRENT_TIMESTAMP,
      DT_PWD_END DATE NOT NULL DEFAULT CURRENT_TIMESTAMP,
      DT_LAST_ACCESS DATE NOT NULL DEFAULT CURRENT_TIMESTAMP,

        Attachments

          Activity

            People

            • Assignee:
              francesm Monica Franceschini
              Reporter:
              fabrice.nanni.spw Nanni Fabrice
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: