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,
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,