[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
BUG MySQL_create.sql utf8 schema [SOLVED]  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
wisetex.spw

Newby

Joined: 07/06/2011 22:47:36
Messages: 13
Offline

Hi.
When try to create spagobi repository by MySQL_create.sql in scheme utf8 i get error Error Code: 1071. Specified key was too long; max key length is 767 bytes. The is no problem when schema latin1.

Also the solution of bug is here http://bugs.mysql.com/bug.php?id=4541

Error in table

CREATE TABLE SBI_KPI_PERIODICITY (
ID_KPI_PERIODICITY INT NOT NULL ,
NAME VARCHAR(400) NOT NULL,
MONTHS INT,
DAYS INT,
HOURS INT,
MINUTES INT,
CHRON_STRING VARCHAR(20),
START_DATE TIMESTAMP,
USER_IN VARCHAR(100) NOT NULL,
USER_UP VARCHAR(100),
USER_DE VARCHAR(100),
TIME_IN TIMESTAMP NOT NULL,
TIME_UP TIMESTAMP NULL DEFAULT NULL,
TIME_DE TIMESTAMP NULL DEFAULT NULL,
SBI_VERSION_IN VARCHAR(10),
SBI_VERSION_UP VARCHAR(10),
SBI_VERSION_DE VARCHAR(10),
META_VERSION VARCHAR(100),
ORGANIZATION VARCHAR(20),
UNIQUE XIF1SBI_KPI_PERIODICITY ( NAME ),
PRIMARY KEY ( ID_KPI_PERIODICITY )
) ENGINE = INNODB;

Solution is to change "NAME VARCHAR(400) NOT NULL," to "NAME VARCHAR(255) NOT NULL,".





This message was edited 1 time. Last update was at 27/01/2012 00:25:50

wisetex.spw

Newby

Joined: 07/06/2011 22:47:36
Messages: 13
Offline

post a bug on tracker https://www.spagoworld.org/jira/browse/SPAGOBI-686
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Thank you for reporting this issue :)
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

fixed: https://www.spagoworld.org/jira/browse/SPAGOBI-686

thanks again for the feedback.

aG

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team