create-db2 in liferay is not working properly for the DB2

[11年前 に Shruti Halgekar によって更新されました。]

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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / January 6, 2012)
14:41:40,396 INFO [STDOUT] 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 [STDOUT] 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 [STDOUT] 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 [STDOUT] 14:41:42,271 INFO [ReleaseLocalServiceImpl:84] Create tables and populate with default data
14:47:25,900 INFO [STDOUT] 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 [STDOUT] 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 [STDOUT] 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?

[11年前 に Antônio Junior によって更新されました。]

Ensure that you created the database with PAGESIZE 8192 (or 8K).
I already got this error because of this.

[11年前 に Shruti Halgekar によって更新されました。]

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?

[11年前 に Frank Pientka によって更新されました。]

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.