Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
petar banicevic
HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
May 27, 2008 5:05 PM
Answer

petar banicevic

Rank: Junior Member

Posts: 69

Join Date: May 27, 2008

Recent Posts

QUESTION:

What mean these warnings and can I ignore them?
Can I fix them ???

Thank you

PS:

I created database on db2 with UTF-8 codeset
==================================
(e.g. CREATE DATABASE LPORTAL ON 'C:' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM; )

And when launching portal I get following messages:
==================================
Starting Liferay Enterprise Portal 5.0.1 (Luther / Build 5001 / April 14, 2008)
22:12:56,484 INFO [DynamicDialect:80] Determining dialect for DB2/NT 8
22:12:56,500 INFO [DynamicDialect:106] Using dialect org.hibernate.dialect.DB2Dialect
22:12:58,125 INFO [PortalImpl:184] Portal lib url /C:/Program Files/liferay-portal-tomcat-6.0-5.0.1/webapps/ROOT/WEB-IN
F/lib/portal-impl.jar!/com/liferay/portal/util/PortalImpl.class
22:12:58,125 INFO [PortalImpl:209] Portal lib directory /C:/Program Files/liferay-portal-tomcat-6.0-5.0.1/webapps/ROOT/
WEB-INF/lib/
22:13:02,609 WARN [ReleaseLocalServiceImpl:83] DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.RELEASE_
22:13:02,609 INFO [ReleaseLocalServiceImpl:96] Create tables and populate with default data
22:13:07,281 WARN [DBUtil:365] DB2 SQL error: SQLCODE: -614, SQLSTATE: 54008, SQLERRMC: IX_7020130F
22:13:08,250 INFO [StartupAction:203] Running verification com.liferay.portal.verify.VerifyProcessSuite
22:13:08,250 INFO [VerifyProcessSuite:37] Verifying
22:13:08,250 INFO [VerifyProperties:40] Verifying
22:13:08,250 INFO [VerifyLucene:39] Verifying
22:13:08,250 INFO [VerifyCounter:44] Verifying
22:13:08,265 INFO [VerifyOracle:52] Verifying
22:13:08,281 INFO [VerifyBlogs:42] Verifying
22:13:08,281 INFO [CustomSQLUtil:110] Database name DB2/NT
22:13:08,281 INFO [CustomSQLUtil:119] Detected DB2 with database name DB2/NT
22:13:08,500 INFO [VerifyBookmarks:42] Verifying
22:13:08,515 INFO [VerifyDocumentLibrary:42] Verifying
22:13:08,515 INFO [VerifyGroup:46] Verifying
22:13:08,515 INFO [VerifyImageGallery:42] Verifying
22:13:08,531 INFO [VerifyJournal:57] Verifying
22:13:08,546 INFO [VerifyLayout:43] Verifying
22:13:08,546 INFO [VerifyMessageBoards:42] Verifying
22:13:08,562 INFO [VerifyUser:44] Verifying
22:13:08,562 INFO [VerifyWiki:42] Verifying
22:13:08,578 INFO [StartupAction:210] Finished verification com.liferay.portal.verify.VerifyProcessSuite
22:13:09,125 INFO [HotDeployUtil:76] Initializing hot deploy manager 180619972
22:13:09,125 INFO [ServerDetector:76] Detected server tomcat
22:13:09,375 INFO [AutoDeployDir:76] Auto deploy scanner started for C:\Documents and Settings\Administrator\liferay\de

TWO WARNINGS
==================================
WARN [ReleaseLocalServiceImpl:83] DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.RELEASE_
WARN [DBUtil:365] DB2 SQL error: SQLCODE: -614, SQLSTATE: 54008, SQLERRMC: IX_7020130F

I have googled and have found this description for the first warning:
==================================
"If the userid you are using is db2admin, and you don't supply a high level
qualifier on the table name, the DB2 assumes that DB2ADMIN is the qualifier
(schema) name. You can use the SET SCHEMA statement before hand, use an
alias, or use the a userid with the same name as your schema."

QUESTION
==================================
Does this explanation describe my problem as well ? What can I do?
petar banicevic
RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
July 12, 2008 12:38 PM
Answer

petar banicevic

Rank: Junior Member

Posts: 69

Join Date: May 27, 2008

Recent Posts

When the tables are created using script then this problem is not present. You should not let liferay to create tables.
Namrata Hangal
RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
August 7, 2012 1:43 AM
Answer

Namrata Hangal

Rank: Regular Member

Posts: 161

Join Date: July 26, 2010

Recent Posts

When the tables are created using script then this problem is not present

Where can I find this script?
Boris Yurkevich
RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
October 31, 2012 3:22 AM
Answer

Boris Yurkevich

Rank: New Member

Posts: 8

Join Date: April 20, 2012

Recent Posts

Namrata Hangal,

Are you found the script so far? I'm particularly looking for DB2 10.1 on Windows 7 + Liferay 6 and DB2 10.1 on OS X + Liferay 6.
Hitoshi Ozawa
RE: HELP:DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
November 1, 2012 5:01 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7990

Join Date: March 23, 2010

Recent Posts

Just download liferay's source code. SQL scripts are under the sql directory.