Tribune

Home » Liferay Portal » English » 3. Development

Vista Combinata Vista Piatta Vista ad Albero
Discussioni [ Precedente | Successivo ]
toggle
Shruti Halgekar
create-db2 in liferay is not working properly for the DB2
15 giugno 2012 6.06
Risposta

Shruti Halgekar

Punteggio: New Member

Messaggi: 7

Data di Iscrizione: 28 maggio 2012

Messaggi recenti

Hi,
I am facing issue while creating database in liferay 6.1.
The error is coming while creating table "QUARTZ_FIRED_TRIGGERS " because its using "smallint NULL" in the script.

ERROR ::::
14:41:21,943 INFO 14:41:21,943 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,;URRENT smallint NULL;<references_spec>, DRIVER=3.50.152: create table QUARTZ_FIRED_TRIGGERS ( SCHED_NAME varchar(120) not null, ENTRY_ID varchar(95) not null, TRIGGER_NAME varchar(200) not null, TRIGGER_GROUP varchar(200) not null, INSTANCE_NAME varchar(200) not null, FIRED_TIME bigint not null, PRIORITY integer not null, STATE varchar(16) not null, JOB_NAME varchar(200), JOB_GROUP varchar(200), IS_NONCONCURRENT smallint NULL, REQUESTS_RECOVERY smallint NULL, primary key (SCHED_NAME, ENTRY_ID));
14:41:27,333 INFO 14:41:27,333 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_BE3835E5 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
14:41:28,193 INFO 14:41:28,193 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_4BD722BM on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_GROUP);
14:41:29,021 INFO 14:41:29,021 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_204D31E8 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, INSTANCE_NAME);
14:41:29,849 INFO 14:41:29,849 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_339E078M on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, INSTANCE_NAME, REQUESTS_RECOVERY);
14:41:30,662 INFO 14:41:30,662 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_5005E3AF on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_NAME, JOB_GROUP);
14:41:31,505 INFO 14:41:31,505 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.QUARTZ_FIRED_TRIGGERS, DRIVER=3.50.152: create index IX_BC2F03B0 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_GROUP);
14:41:38,084 INFO Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / January 6, 2012)
14:41:40,396 INFO 14:41:40,396 ERROR [JDBCExceptionReporter:75] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.LOCK_, DRIVER=3.50.152
14:41:40,396 INFO 14:41:40,396 ERROR [JDBCExceptionReporter:75] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;LIFERAY.LOCK_, DRIVER=3.50.152
14:41:42,271 INFO 14:41:42,271 WARN [ReleaseLocalServiceImpl:140] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.RELEASE_, DRIVER=3.50.152
14:41:42,271 INFO 14:41:42,271 INFO [ReleaseLocalServiceImpl:84] Create tables and populate with default data
14:47:25,900 INFO 14:47:25,900 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=IX_7020130F, DRIVER=3.50.152: create index IX_7020130F on SCProductVersion (directDownloadURL);
14:47:49,901 INFO 14:47:49,901 WARN [BaseDB:382] DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=IX_89509087, DRIVER=3.50.152: create index IX_89509087 on User_ (companyId, openId);
14:48:06,010 INFO 14:48:06,010 INFO [BaseDB:406] Database supports case sensitive queries

Can anybody please let me know what is solution for this, Is there anything that we have to add in portal-ext.properties?
Antônio Junior
RE: create-db2 in liferay is not working properly for the DB2
15 giugno 2012 6.51
Risposta

Antônio Junior

LIFERAY STAFF

Punteggio: Junior Member

Messaggi: 63

Data di Iscrizione: 5 luglio 2011

Messaggi recenti

Ensure that you created the database with PAGESIZE 8192 (or 8K).
I already got this error because of this.
Shruti Halgekar
RE: create-db2 in liferay is not working properly for the DB2
19 giugno 2012 23.11
Risposta

Shruti Halgekar

Punteggio: New Member

Messaggi: 7

Data di Iscrizione: 28 maggio 2012

Messaggi recenti

Thank you very much for the reply...............

Can you please let me know how to increase PAGESIZE?
Is there a way, where we can define PAGESIZE in portal-ext.properties file?
So that when liferay get started, liferay's schema and tables tablespace size set to 8K?
Frank Pientka
RE: create-db2 in liferay is not working properly for the DB2
20 giugno 2012 1.45
Risposta

Frank Pientka

Punteggio: New Member

Messaggi: 14

Data di Iscrizione: 12 ottobre 2008

Messaggi recenti

The pagesize for the table space USERSPACE1 is ONLY created at the creationtime oft the database, so:
drop database lportal;
create database lportal pagesize 8192;

pagesize specifies the page size of the default buffer pool along with the initial table spaces (SYSCATSPACE, TEMPSPACE1, USERSPACE1) when the database is created. This also represents the default page size for all future CREATE BUFFERPOOL and CREATE TABLESPACE statements. The valid values for integer without the suffix K are 4 096, 8 192, 16 384, or 32 768. The valid values for integer with the suffix K are 4, 8, 16, or 32.