Forums de discussion

  1. Accueil
  2. Portal
  3. DB2 SQL error during upgrade from 5.2.2 to 5.2.3

DB2 SQL error during upgrade from 5.2.2 to 5.2.3

Artur Korol, modifié il y a 14 années.

DB2 SQL error during upgrade from 5.2.2 to 5.2.3

Junior Member Publications: 96 Date d'inscription: 02/03/09 Publications récentes
Hi,

Following errors are in catalina.out during Liferay 5.2.3 first start. Is it serious ? Liferay seems to work ..but ..

Here are my logs:
=======================================
14:53:39,918 INFO [PortalImpl:252] Portal lib directory /opt/3wiek-liferay/tomcat-5.5.27/webapps/ROOT/WEB-INF/lib/
14:53:48,994 INFO [DBUtil:119] Using dialect com.liferay.portal.dao.orm.hibernate.DB2Dialect
14:53:49,109 INFO [ServerDetector:104] Detected server tomcat
Starting Liferay Portal Standard Edition 5.2.3 (Augustine / Build 5203 / May 20, 2009)
14:53:50,735 WARN [ReleaseLocalServiceImpl:247] DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: TESTSTRING
14:53:51,232 INFO [DBUtil:498] Database supports case sensitive queries
14:53:51,241 INFO [UpgradeProcess_5_2_3:58] Upgrading
14:53:52,545 WARN [DBUtil:474] DB2 SQL error: SQLCODE: -408, SQLSTATE: 42821, SQLERRMC: NAME: update Group_ set name = classPK where classPK > 0 and name = '';
14:53:56,557 INFO [UpgradeBookmarks:47] Upgrading
14:53:56,561 INFO [UpgradeCalendar:42] Upgrading
14:53:56,563 INFO [UpgradeDocumentLibrary:59] Upgrading
14:53:56,627 INFO [UpgradeGroup:42] Upgrading
14:53:56,686 INFO [UpgradeImageGallery:44] Upgrading
14:53:56,703 INFO [UpgradeLayout:47] Upgrading
14:53:56,708 INFO [UpgradeMessageBoards:46] Upgrading
14:53:56,803 INFO [UpgradeResource:42] Upgrading
14:53:56,805 INFO [UpgradeResourceCode:42] Upgrading
14:53:56,806 INFO [UpgradeRole:42] Upgrading
14:53:56,819 INFO [UpgradeSoftwareCatalog:42] Upgrading
14:53:56,821 INFO [UpgradeTags:48] Upgrading
14:53:57,068 INFO [UpgradeUser:47] Upgrading
14:53:57,640 INFO [UpgradeWiki:47] Upgrading
14:53:57,666 INFO [UpgradeDuplicates:55] Upgrading
14:53:57,666 INFO [UpgradeDuplicates:358] Checking for duplicate data from AnnouncementsDelivery for unique index (userId, type_)
14:53:57,676 INFO [UpgradeDuplicates:358] Checking for duplicate data from AnnouncementsFlag for unique index (userId, entryId, value)
14:53:57,678 INFO [UpgradeDuplicates:358] Checking for duplicate data from BlogsStatsUser for unique index (groupId, userId)
14:53:57,680 INFO [UpgradeDuplicates:358] Checking for duplicate data from Country for unique index (name)
14:53:57,689 INFO [UpgradeDuplicates:358] Checking for duplicate data from Country for unique index (a2)
14:53:57,694 INFO [UpgradeDuplicates:358] Checking for duplicate data from Country for unique index (a3)
14:53:57,700 INFO [UpgradeDuplicates:358] Checking for duplicate data from DLFileRank for unique index (companyId, userId, folderId, name)
14:53:57,702 INFO [UpgradeDuplicates:358] Checking for duplicate data from DLFileVersion for unique index (folderId, name, version)
14:53:57,704 INFO [UpgradeDuplicates:358] Checking for duplicate data from DLFolder for unique index (groupId, parentFolderId, name)
14:53:57,706 INFO [UpgradeDuplicates:358] Checking for duplicate data from ExpandoTable for unique index (companyId, classNameId, name)
14:53:57,708 INFO [UpgradeDuplicates:358] Checking for duplicate data from ExpandoRow for unique index (tableId, classPK)
14:53:57,711 INFO [UpgradeDuplicates:358] Checking for duplicate data from ExpandoColumn for unique index (tableId, name)
14:53:57,713 INFO [UpgradeDuplicates:358] Checking for duplicate data from ExpandoValue for unique index (columnId, rowId_)
14:53:57,716 INFO [UpgradeDuplicates:358] Checking for duplicate data from ExpandoValue for unique index (tableId, columnId, classPK)
14:53:57,718 INFO [UpgradeDuplicates:358] Checking for duplicate data from IGFolder for unique index (groupId, parentFolderId, name)
14:53:57,720 INFO [UpgradeDuplicates:358] Checking for duplicate data from Layout for unique index (groupId, privateLayout, friendlyURL)
14:53:57,727 INFO [UpgradeDuplicates:358] Checking for duplicate data from Layout for unique index (groupId, privateLayout, layoutId)
14:53:57,730 INFO [UpgradeDuplicates:358] Checking for duplicate data from MBBan for unique index (groupId, banUserId)
14:53:57,733 INFO [UpgradeDuplicates:358] Checking for duplicate data from MBDiscussion for unique index (classNameId, classPK)
14:53:57,737 INFO [UpgradeDuplicates:494] Resolving duplicate data from MBDiscussion with primary keys 12431 and 12430
14:53:57,747 INFO [UpgradeDuplicates:358] Checking for duplicate data from MBDiscussion for unique index (threadId)
14:53:57,749 INFO [UpgradeDuplicates:358] Checking for duplicate data from MBMessageFlag for unique index (userId, messageId, flag)
14:53:57,751 INFO [UpgradeDuplicates:358] Checking for duplicate data from MBStatsUser for unique index (groupId, userId)
14:53:57,753 INFO [UpgradeDuplicates:358] Checking for duplicate data from Permission_ for unique index (actionId, resourceId)
14:53:57,808 INFO [UpgradeDuplicates:358] Checking for duplicate data from PollsVote for unique index (questionId, userId)
14:53:57,811 INFO [UpgradeDuplicates:358] Checking for duplicate data from PortletPreferences for unique index (ownerId, ownerType, plid, portletId)
14:53:57,827 INFO [UpgradeDuplicates:358] Checking for duplicate data from RatingsEntry for unique index (userId, classNameId, classPK)
14:53:57,829 INFO [UpgradeDuplicates:358] Checking for duplicate data from RatingsStats for unique index (classNameId, classPK)
14:53:57,831 INFO [UpgradeDuplicates:358] Checking for duplicate data from Resource_ for unique index (codeId, primKey)
14:53:57,846 INFO [UpgradeDuplicates:358] Checking for duplicate data from ResourceCode for unique index (companyId, name, scope)
14:53:57,856 INFO [UpgradeDuplicates:358] Checking for duplicate data from SocialActivity for unique index (groupId, userId, createDate, classNameId, classPK, type_, receiverUserId)
14:53:57,874 INFO [UpgradeDuplicates:358] Checking for duplicate data from SocialRelation for unique index (userId1, userId2, type_)
14:53:57,877 INFO [UpgradeDuplicates:358] Checking for duplicate data from SocialRequest for unique index (userId, classNameId, classPK, type_, receiverUserId)
14:53:57,880 INFO [UpgradeDuplicates:358] Checking for duplicate data from Subscription for unique index (companyId, classNameId, classPK)
14:53:58,116 INFO [VerifyProcessSuite:37] Verifying
14:53:58,117 INFO [VerifyProperties:39] Verifying
14:53:58,117 INFO [VerifyLucene:39] Verifying
14:53:58,118 INFO [VerifyMySQL:44] Verifying
14:53:58,118 INFO [VerifyCounter:43] Verifying
14:53:58,136 INFO [VerifyUUID:51] Verifying
14:53:58,150 INFO [VerifyBlogs:41] Verifying
14:53:58,232 INFO [VerifyBookmarks:41] Verifying
14:53:58,236 INFO [VerifyDocumentLibrary:41] Verifying
14:53:58,241 INFO [VerifyGroup:45] Verifying
14:53:58,245 INFO [VerifyImageGallery:41] Verifying
14:53:58,250 INFO [VerifyJournal:56] Verifying
14:54:00,381 INFO [VerifyLayout:42] Verifying
14:54:00,385 INFO [VerifyMessageBoards:41] Verifying
14:54:00,390 INFO [VerifyOrganization:43] Verifying
14:54:00,404 INFO [VerifySocial:45] Verifying
14:54:00,405 INFO [VerifyWiki:41] Verifying
14:54:00,410 INFO [StartupHelper:194] Adding indexes
14:54:00,412 INFO [StartupHelper:220] create index IX_93D5AD4E on Address (companyId);
14:54:00,442 INFO [StartupHelper:220] create index IX_ABD7DAC0 on Address (companyId, classNameId);
14:54:00,454 INFO [StartupHelper:220] create index IX_71CB1123 on Address (companyId, classNameId, classPK);
14:54:00,466 INFO [StartupHelper:220] create index IX_923BD178 on Address (companyId, classNameId, classPK, mailing);
14:54:00,486 INFO [StartupHelper:220] create index IX_9226DBB4 on Address (companyId, classNameId, classPK, primary_);
14:54:00,498 INFO [StartupHelper:220] create index IX_5BC8B0D4 on Address (userId);
14:54:00,518 INFO [StartupHelper:220] create index IX_6EDB9600 on AnnouncementsDelivery (userId);
14:54:00,530 INFO [StartupHelper:220] create unique index IX_BA4413D5 on AnnouncementsDelivery (userId, type_);
14:54:00,532 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_BA4413D5;INDEX
14:54:00,532 INFO [StartupHelper:220] create index IX_A6EF0B81 on AnnouncementsEntry (classNameId, classPK);
14:54:00,542 INFO [StartupHelper:220] create index IX_14F06A6B on AnnouncementsEntry (classNameId, classPK, alert);
14:54:00,562 INFO [StartupHelper:220] create index IX_D49C2E66 on AnnouncementsEntry (userId);
14:54:00,574 INFO [StartupHelper:220] create index IX_1AFBDE08 on AnnouncementsEntry (uuid_);
14:54:00,594 INFO [StartupHelper:220] create index IX_9C7EB9F on AnnouncementsFlag (entryId);
14:54:00,606 INFO [StartupHelper:220] create unique index IX_4539A99C on AnnouncementsFlag (userId, entryId, value);
14:54:00,607 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_4539A99C;INDEX
14:54:00,608 INFO [StartupHelper:220] create index IX_72EF6041 on BlogsEntry (companyId);
14:54:00,618 INFO [StartupHelper:220] create index IX_E0D90212 on BlogsEntry (companyId, displayDate, draft);
14:54:00,638 INFO [StartupHelper:220] create index IX_81A50303 on BlogsEntry (groupId);
14:54:00,650 INFO [StartupHelper:220] create index IX_DA53AFD4 on BlogsEntry (groupId, displayDate, draft);
14:54:00,671 INFO [StartupHelper:220] create unique index IX_DB780A20 on BlogsEntry (groupId, urlTitle);
14:54:00,672 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_DB780A20;INDEX
14:54:00,672 INFO [StartupHelper:220] create index IX_C07CA83D on BlogsEntry (groupId, userId);
14:54:00,683 INFO [StartupHelper:220] create index IX_B88E740E on BlogsEntry (groupId, userId, displayDate, draft);
14:54:00,703 INFO [StartupHelper:220] create index IX_69157A4D on BlogsEntry (uuid_);
14:54:00,715 INFO [StartupHelper:220] create unique index IX_1B1040FD on BlogsEntry (uuid_, groupId);
14:54:00,716 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_1B1040FD;INDEX
14:54:00,717 INFO [StartupHelper:220] create index IX_90CDA39A on BlogsStatsUser (companyId, entryCount);
14:54:00,727 INFO [StartupHelper:220] create index IX_43840EEB on BlogsStatsUser (groupId);
14:54:00,739 INFO [StartupHelper:220] create index IX_28C78D5C on BlogsStatsUser (groupId, entryCount);
14:54:00,751 INFO [StartupHelper:220] create unique index IX_82254C25 on BlogsStatsUser (groupId, userId);
14:54:00,752 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_82254C25;INDEX
14:54:00,753 INFO [StartupHelper:220] create index IX_BB51F1D9 on BlogsStatsUser (userId);
14:54:00,763 INFO [StartupHelper:220] create index IX_443BDC38 on BookmarksEntry (folderId);
14:54:00,775 INFO [StartupHelper:220] create index IX_E52FF7EF on BookmarksEntry (groupId);
14:54:00,808 INFO [StartupHelper:220] create index IX_E2E9F129 on BookmarksEntry (groupId, userId);
14:54:00,828 INFO [StartupHelper:220] create index IX_B670BA39 on BookmarksEntry (uuid_);
14:54:00,847 INFO [StartupHelper:220] create unique index IX_EAA02A91 on BookmarksEntry (uuid_, groupId);
14:54:00,872 INFO [StartupHelper:220] create index IX_2ABA25D7 on BookmarksFolder (companyId);
14:54:00,891 INFO [StartupHelper:220] create index IX_7F703619 on BookmarksFolder (groupId);
14:54:00,903 INFO [StartupHelper:220] create index IX_967799C0 on BookmarksFolder (groupId, parentFolderId);
14:54:00,915 INFO [StartupHelper:220] create index IX_451E7AE3 on BookmarksFolder (uuid_);
14:54:00,927 INFO [StartupHelper:220] create unique index IX_DC2F8927 on BookmarksFolder (uuid_, groupId);
14:54:00,928 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_DC2F8927;INDEX
14:54:00,929 INFO [StartupHelper:220] create unique index IX_E7B95510 on BrowserTracker (userId);
14:54:00,948 INFO [StartupHelper:220] create index IX_D6FD9496 on CalEvent (companyId);
14:54:00,996 INFO [StartupHelper:220] create index IX_12EE4898 on CalEvent (groupId);
14:54:01,019 INFO [StartupHelper:220] create index IX_4FDDD2BF on CalEvent (groupId, repeating);
14:54:01,031 INFO [StartupHelper:220] create index IX_FCD7C63D on CalEvent (groupId, type_);
14:54:01,043 INFO [StartupHelper:220] create index IX_F6006202 on CalEvent (remindBy);
14:54:01,064 INFO [StartupHelper:220] create index IX_C1AD2122 on CalEvent (uuid_);
14:54:01,087 INFO [StartupHelper:220] create unique index IX_5CCE79C8 on CalEvent (uuid_, groupId);
14:54:01,088 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_5CCE79C8;INDEX
14:54:01,089 INFO [StartupHelper:220] create unique index IX_B27A301F on ClassName_ (value);
14:54:01,090 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_B27A301F;INDEX
14:54:01,090 INFO [StartupHelper:220] create index IX_38EFE3FD on Company (logoId);
14:54:01,107 INFO [StartupHelper:220] create index IX_12566EC2 on Company (mx);
14:54:01,119 INFO [StartupHelper:220] create index IX_35E3E7C6 on Company (system);
14:54:01,156 INFO [StartupHelper:220] create unique index IX_975996C0 on Company (virtualHost);
14:54:01,158 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_975996C0;INDEX
14:54:01,158 INFO [StartupHelper:220] create unique index IX_EC00543C on Company (webId);
14:54:01,159 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_EC00543C;INDEX
14:54:01,159 INFO [StartupHelper:220] create index IX_66D496A3 on Contact_ (companyId);
14:54:01,179 INFO [StartupHelper:220] create unique index IX_717B97E1 on Country (a2);
14:54:01,180 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_717B97E1;INDEX
14:54:01,181 INFO [StartupHelper:220] create unique index IX_717B9BA2 on Country (a3);
14:54:01,182 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_717B9BA2;INDEX
14:54:01,182 INFO [StartupHelper:220] create index IX_25D734CD on Country (active_);
14:54:01,191 INFO [StartupHelper:220] create unique index IX_19DA007B on Country (name);
14:54:01,193 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_19DA007B;INDEX
14:54:01,193 INFO [StartupHelper:220] create index IX_4CB1B2B4 on DLFileEntry (companyId);
14:54:01,212 INFO [StartupHelper:220] create index IX_24A846D1 on DLFileEntry (folderId);
14:54:01,224 INFO [StartupHelper:220] create unique index IX_8F6C75D0 on DLFileEntry (folderId, name);
14:54:01,225 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_8F6C75D0;INDEX
14:54:01,225 INFO [StartupHelper:220] create index IX_A9951F17 on DLFileEntry (folderId, title);
14:54:01,244 INFO [StartupHelper:220] create index IX_F4AF5636 on DLFileEntry (groupId);
14:54:01,265 INFO [StartupHelper:220] create index IX_43261870 on DLFileEntry (groupId, userId);
14:54:01,297 INFO [StartupHelper:220] create index IX_64F0FE40 on DLFileEntry (uuid_);
14:54:01,320 INFO [StartupHelper:220] create unique index IX_BC2E7E6A on DLFileEntry (uuid_, groupId);
14:54:01,349 INFO [StartupHelper:220] create unique index IX_CE705D48 on DLFileRank (companyId, userId, folderId, name);
14:54:01,350 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_CE705D48;INDEX
14:54:01,350 INFO [StartupHelper:220] create index IX_40B56512 on DLFileRank (folderId, name);
14:54:01,371 INFO [StartupHelper:220] create index IX_BAFB116E on DLFileRank (groupId, userId);
14:54:01,393 INFO [StartupHelper:220] create index IX_EED06670 on DLFileRank (userId);
14:54:01,415 INFO [StartupHelper:220] create index IX_E56EC6AD on DLFileShortcut (folderId);
14:54:01,428 INFO [StartupHelper:220] create index IX_CA2708A2 on DLFileShortcut (toFolderId, toName);
14:54:01,440 INFO [StartupHelper:220] create index IX_4831EBE4 on DLFileShortcut (uuid_);
14:54:01,452 INFO [StartupHelper:220] create unique index IX_FDB4A946 on DLFileShortcut (uuid_, groupId);
14:54:01,485 INFO [StartupHelper:220] create index IX_9CD91DB6 on DLFileVersion (folderId, name);
14:54:01,507 INFO [StartupHelper:220] create unique index IX_6C5E6512 on DLFileVersion (folderId, name, version);
14:54:01,509 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_6C5E6512;INDEX
14:54:01,509 INFO [StartupHelper:220] create index IX_A74DB14C on DLFolder (companyId);
14:54:01,524 INFO [StartupHelper:220] create index IX_F2EA1ACE on DLFolder (groupId);
14:54:01,544 INFO [StartupHelper:220] create index IX_49C37475 on DLFolder (groupId, parentFolderId);
14:54:01,556 INFO [StartupHelper:220] create unique index IX_902FD874 on DLFolder (groupId, parentFolderId, name);
14:54:01,557 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_902FD874;INDEX
14:54:01,557 INFO [StartupHelper:220] create index IX_51556082 on DLFolder (parentFolderId, name);
14:54:01,576 INFO [StartupHelper:220] create index IX_CBC408D8 on DLFolder (uuid_);
14:54:01,588 INFO [StartupHelper:220] create unique index IX_3CC1DED2 on DLFolder (uuid_, groupId);
14:54:01,589 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_3CC1DED2;INDEX
14:54:01,590 INFO [StartupHelper:220] create index IX_1BB072CA on EmailAddress (companyId);
14:54:01,600 INFO [StartupHelper:220] create index IX_49D2DEC4 on EmailAddress (companyId, classNameId);
14:54:01,612 INFO [StartupHelper:220] create index IX_551A519F on EmailAddress (companyId, classNameId, classPK);
14:54:01,624 INFO [StartupHelper:220] create index IX_2A2CB130 on EmailAddress (companyId, classNameId, classPK, primary_);
14:54:01,636 INFO [StartupHelper:220] create index IX_7B43CD8 on EmailAddress (userId);
14:54:01,648 INFO [StartupHelper:220] create index IX_A8C0CBE8 on ExpandoColumn (tableId);
14:54:01,660 INFO [StartupHelper:220] create unique index IX_FEFC8DA7 on ExpandoColumn (tableId, name);
14:54:01,661 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_FEFC8DA7;INDEX
14:54:01,661 INFO [StartupHelper:220] create index IX_D3F5D7AE on ExpandoRow (tableId);
14:54:01,676 INFO [StartupHelper:220] create unique index IX_81EFBFF5 on ExpandoRow (tableId, classPK);
14:54:01,677 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_81EFBFF5;INDEX
14:54:01,678 INFO [StartupHelper:220] create index IX_B5AE8A85 on ExpandoTable (companyId, classNameId);
14:54:01,688 INFO [StartupHelper:220] create unique index IX_37562284 on ExpandoTable (companyId, classNameId, name);
14:54:01,689 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_37562284;INDEX
14:54:01,689 INFO [StartupHelper:220] create index IX_B29FEF17 on ExpandoValue (classNameId, classPK);
14:54:01,704 INFO [StartupHelper:220] create index IX_F7DD0987 on ExpandoValue (columnId);
14:54:01,716 INFO [StartupHelper:220] create unique index IX_9DDD21E5 on ExpandoValue (columnId, rowId_);
14:54:01,717 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_9DDD21E5;INDEX
14:54:01,718 INFO [StartupHelper:220] create index IX_9112A7A0 on ExpandoValue (rowId_);
14:54:01,728 INFO [StartupHelper:220] create index IX_F0566A77 on ExpandoValue (tableId);
14:54:01,740 INFO [StartupHelper:220] create index IX_1BD3F4C on ExpandoValue (tableId, classPK);
14:54:01,761 INFO [StartupHelper:220] create index IX_CA9AFB7C on ExpandoValue (tableId, columnId);
14:54:01,801 INFO [StartupHelper:220] create unique index IX_D27B03E7 on ExpandoValue (tableId, columnId, classPK);
14:54:01,833 INFO [StartupHelper:220] create index IX_B71E92D5 on ExpandoValue (tableId, rowId_);
14:54:01,856 INFO [StartupHelper:220] create unique index IX_D0D5E397 on Group_ (companyId, classNameId, classPK);
14:54:01,857 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_D0D5E397;INDEX
14:54:01,858 INFO [StartupHelper:220] create unique index IX_5DE0BE11 on Group_ (companyId, classNameId, liveGroupId, name);
14:54:01,862 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -603, SQLSTATE: 23515, SQLERRMC: null
14:54:01,862 INFO [StartupHelper:220] create unique index IX_5BDDB872 on Group_ (companyId, friendlyURL);
14:54:01,863 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_5BDDB872;INDEX
14:54:01,864 INFO [StartupHelper:220] create unique index IX_BBCA55B on Group_ (companyId, liveGroupId, name);
14:54:01,872 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -603, SQLSTATE: 23515, SQLERRMC: null
14:54:01,873 INFO [StartupHelper:220] create unique index IX_5AA68501 on Group_ (companyId, name);
14:54:01,874 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_5AA68501;INDEX
14:54:01,874 INFO [StartupHelper:220] create index IX_16218A38 on Group_ (liveGroupId);
14:54:01,888 INFO [StartupHelper:220] create index IX_7B590A7A on Group_ (type_, active_);
14:54:01,921 INFO [StartupHelper:220] create index IX_75267DCA on Groups_Orgs (groupId);
14:54:01,953 INFO [StartupHelper:220] create index IX_6BBB7682 on Groups_Orgs (organizationId);
14:54:02,013 INFO [StartupHelper:220] create index IX_C48736B on Groups_Permissions (groupId);
14:54:02,057 INFO [StartupHelper:220] create index IX_EC97689D on Groups_Permissions (permissionId);
14:54:02,084 INFO [StartupHelper:220] create index IX_84471FD2 on Groups_Roles (groupId);
14:54:02,112 INFO [StartupHelper:220] create index IX_3103EF3D on Groups_Roles (roleId);
14:54:02,149 INFO [StartupHelper:220] create index IX_31FB749A on Groups_UserGroups (groupId);
14:54:02,155 INFO [StartupHelper:220] create index IX_3B69160F on Groups_UserGroups (userGroupId);
14:54:02,160 INFO [StartupHelper:220] create index IX_60214CF6 on IGFolder (companyId);
14:54:02,162 INFO [StartupHelper:220] create index IX_206498F8 on IGFolder (groupId);
14:54:02,166 INFO [StartupHelper:220] create index IX_1A605E9F on IGFolder (groupId, parentFolderId);
14:54:02,168 INFO [StartupHelper:220] create unique index IX_9BBAFB1E on IGFolder (groupId, parentFolderId, name);
14:54:02,170 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_9BBAFB1E;INDEX
14:54:02,170 INFO [StartupHelper:220] create index IX_F73C0982 on IGFolder (uuid_);
14:54:02,188 INFO [StartupHelper:220] create unique index IX_B10EFD68 on IGFolder (uuid_, groupId);
14:54:02,189 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_B10EFD68;INDEX
14:54:02,190 INFO [StartupHelper:220] create index IX_E597322D on IGImage (custom1ImageId);
14:54:02,212 INFO [StartupHelper:220] create index IX_D9E0A34C on IGImage (custom2ImageId);
14:54:02,224 INFO [StartupHelper:220] create index IX_4438CA80 on IGImage (folderId);
14:54:02,237 INFO [StartupHelper:220] create index IX_BCB13A3F on IGImage (folderId, name);
14:54:02,249 INFO [StartupHelper:220] create index IX_63820A7 on IGImage (groupId);
14:54:02,277 INFO [StartupHelper:220] create index IX_BE79E1E1 on IGImage (groupId, userId);
14:54:02,306 INFO [StartupHelper:220] create index IX_64F0B572 on IGImage (largeImageId);
14:54:02,329 INFO [StartupHelper:220] create index IX_D3D32126 on IGImage (smallImageId);
14:54:02,341 INFO [StartupHelper:220] create index IX_265BB0F1 on IGImage (uuid_);
14:54:02,353 INFO [StartupHelper:220] create unique index IX_E97342D9 on IGImage (uuid_, groupId);
14:54:02,394 INFO [StartupHelper:220] create index IX_6A925A4D on Image (size_);
14:54:02,413 INFO [StartupHelper:220] create index IX_DFF98523 on JournalArticle (companyId);
14:54:02,477 INFO [StartupHelper:220] create index IX_9356F865 on JournalArticle (groupId);
14:54:02,489 INFO [StartupHelper:220] create index IX_68C0F69C on JournalArticle (groupId, articleId);
14:54:02,553 INFO [StartupHelper:220] create index IX_8DBF1387 on JournalArticle (groupId, articleId, approved);
14:54:02,617 INFO [StartupHelper:220] create unique index IX_85C52EEC on JournalArticle (groupId, articleId, version);
14:54:02,619 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_85C52EEC;INDEX
14:54:02,619 INFO [StartupHelper:220] create index IX_2E207659 on JournalArticle (groupId, structureId);
14:54:02,629 INFO [StartupHelper:220] create index IX_8DEAE14E on JournalArticle (groupId, templateId);
14:54:02,642 INFO [StartupHelper:220] create index IX_22882D02 on JournalArticle (groupId, urlTitle);
14:54:02,675 INFO [StartupHelper:220] create index IX_76186981 on JournalArticle (resourcePrimKey, approved);
14:54:02,746 INFO [StartupHelper:220] create index IX_EF9B7028 on JournalArticle (smallImageId);
14:54:02,814 INFO [StartupHelper:220] create index IX_F029602F on JournalArticle (uuid_);
14:54:02,878 INFO [StartupHelper:220] create unique index IX_3463D95B on JournalArticle (uuid_, groupId);
14:54:02,879 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_3463D95B;INDEX
14:54:02,880 INFO [StartupHelper:220] create index IX_3B51BB68 on JournalArticleImage (groupId);
14:54:02,890 INFO [StartupHelper:220] create index IX_158B526F on JournalArticleImage (groupId, articleId, version);
14:54:02,902 INFO [StartupHelper:220] create unique index IX_103D6207 on JournalArticleImage (groupId, articleId, version, elInstanceId, elName, languageId);
14:54:02,903 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_103D6207;INDEX
14:54:02,904 INFO [StartupHelper:220] create index IX_D4121315 on JournalArticleImage (tempImage);
14:54:02,914 INFO [StartupHelper:220] create index IX_F8433677 on JournalArticleResource (groupId);
14:54:02,926 INFO [StartupHelper:220] create unique index IX_88DF994A on JournalArticleResource (groupId, articleId);
14:54:02,927 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_88DF994A;INDEX
14:54:02,927 INFO [StartupHelper:220] create index IX_6838E427 on JournalContentSearch (groupId, articleId);
14:54:03,006 INFO [StartupHelper:220] create index IX_20962903 on JournalContentSearch (groupId, privateLayout);
14:54:03,018 INFO [StartupHelper:220] create index IX_7CC7D73E on JournalContentSearch (groupId, privateLayout, articleId);
14:54:03,030 INFO [StartupHelper:220] create index IX_B3B318DC on JournalContentSearch (groupId, privateLayout, layoutId);
14:54:03,042 INFO [StartupHelper:220] create index IX_7ACC74C9 on JournalContentSearch (groupId, privateLayout, layoutId, portletId);
14:54:03,054 INFO [StartupHelper:220] create unique index IX_C3AA93B8 on JournalContentSearch (groupId, privateLayout, layoutId, portletId, articleId);
14:54:03,056 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_C3AA93B8;INDEX
14:54:03,056 INFO [StartupHelper:220] create index IX_35A2DB2F on JournalFeed (groupId);
14:54:03,066 INFO [StartupHelper:220] create unique index IX_65576CBC on JournalFeed (groupId, feedId);
14:54:03,068 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_65576CBC;INDEX
14:54:03,068 INFO [StartupHelper:220] create index IX_50C36D79 on JournalFeed (uuid_);
14:54:03,078 INFO [StartupHelper:220] create unique index IX_39031F51 on JournalFeed (uuid_, groupId);
14:54:03,080 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_39031F51;INDEX
14:54:03,080 INFO [StartupHelper:220] create index IX_B97F5608 on JournalStructure (groupId);
14:54:03,090 INFO [StartupHelper:220] create index IX_CA0BD48C on JournalStructure (groupId, parentStructureId);
14:54:03,110 INFO [StartupHelper:220] create unique index IX_AB6E9996 on JournalStructure (groupId, structureId);
14:54:03,112 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_AB6E9996;INDEX
14:54:03,112 INFO [StartupHelper:220] create index IX_8831E4FC on JournalStructure (structureId);
14:54:03,130 INFO [StartupHelper:220] create index IX_6702CA92 on JournalStructure (uuid_);
14:54:03,142 INFO [StartupHelper:220] create unique index IX_42E86E58 on JournalStructure (uuid_, groupId);
14:54:03,144 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_42E86E58;INDEX
14:54:03,144 INFO [StartupHelper:220] create index IX_77923653 on JournalTemplate (groupId);
14:54:03,155 INFO [StartupHelper:220] create index IX_1701CB2B on JournalTemplate (groupId, structureId);
14:54:03,167 INFO [StartupHelper:220] create unique index IX_E802AA3C on JournalTemplate (groupId, templateId);
14:54:03,168 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_E802AA3C;INDEX
14:54:03,168 INFO [StartupHelper:220] create index IX_25FFB6FA on JournalTemplate (smallImageId);
14:54:03,179 INFO [StartupHelper:220] create index IX_1B12CA20 on JournalTemplate (templateId);
14:54:03,191 INFO [StartupHelper:220] create index IX_2857419D on JournalTemplate (uuid_);
14:54:03,203 INFO [StartupHelper:220] create unique index IX_62D1B3AD on JournalTemplate (uuid_, groupId);
14:54:03,204 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_62D1B3AD;INDEX
14:54:03,204 INFO [StartupHelper:220] create index IX_C7FBC998 on Layout (companyId);
14:54:03,215 INFO [StartupHelper:220] create index IX_FAD05595 on Layout (dlFolderId);
14:54:03,235 INFO [StartupHelper:220] create index IX_C099D61A on Layout (groupId);
14:54:03,247 INFO [StartupHelper:220] create index IX_705F5AA3 on Layout (groupId, privateLayout);
14:54:03,267 INFO [StartupHelper:220] create unique index IX_BC2C4231 on Layout (groupId, privateLayout, friendlyURL);
14:54:03,269 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_BC2C4231;INDEX
14:54:03,269 INFO [StartupHelper:220] create unique index IX_7162C27C on Layout (groupId, privateLayout, layoutId);
14:54:03,270 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_7162C27C;INDEX
14:54:03,270 INFO [StartupHelper:220] create index IX_6DE88B06 on Layout (groupId, privateLayout, parentLayoutId);
14:54:03,283 INFO [StartupHelper:220] create index IX_1A1B61D2 on Layout (groupId, privateLayout, type_);
14:54:03,303 INFO [StartupHelper:220] create index IX_23922F7D on Layout (iconImageId);
14:54:03,316 INFO [StartupHelper:220] create index IX_A40B8BEC on LayoutSet (groupId);
14:54:03,328 INFO [StartupHelper:220] create unique index IX_48550691 on LayoutSet (groupId, privateLayout);
14:54:03,329 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_48550691;INDEX
14:54:03,329 INFO [StartupHelper:220] create index IX_5ABC2905 on LayoutSet (virtualHost);
14:54:03,340 INFO [StartupHelper:220] create index IX_2932DD37 on ListType (type_);
14:54:03,352 INFO [StartupHelper:220] create index IX_69951A25 on MBBan (banUserId);
14:54:03,364 INFO [StartupHelper:220] create index IX_5C3FF12A on MBBan (groupId);
14:54:03,376 INFO [StartupHelper:220] create unique index IX_8ABC4E3B on MBBan (groupId, banUserId);
14:54:03,377 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_8ABC4E3B;INDEX
14:54:03,378 INFO [StartupHelper:220] create index IX_48814BBA on MBBan (userId);
14:54:03,388 INFO [StartupHelper:220] create index IX_BC735DCF on MBCategory (companyId);
14:54:03,400 INFO [StartupHelper:220] create index IX_BB870C11 on MBCategory (groupId);
14:54:03,420 INFO [StartupHelper:220] create index IX_ED292508 on MBCategory (groupId, parentCategoryId);
14:54:03,432 INFO [StartupHelper:220] create index IX_C2626EDB on MBCategory (uuid_);
14:54:03,452 INFO [StartupHelper:220] create unique index IX_F7D28C2F on MBCategory (uuid_, groupId);
14:54:03,454 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_F7D28C2F;INDEX
14:54:03,454 INFO [StartupHelper:220] create index IX_79D0120B on MBDiscussion (classNameId);
14:54:03,464 INFO [StartupHelper:220] create unique index IX_33A4DE38 on MBDiscussion (classNameId, classPK);
14:54:03,465 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_33A4DE38;INDEX
14:54:03,465 INFO [StartupHelper:220] create unique index IX_B5CA2DC on MBDiscussion (threadId);
14:54:03,467 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_B5CA2DC;INDEX
14:54:03,467 INFO [StartupHelper:220] create index IX_BFEB984F on MBMailingList (active_);
14:54:03,484 INFO [StartupHelper:220] create unique index IX_ADA16FE7 on MBMailingList (categoryId);
14:54:03,486 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_ADA16FE7;INDEX
14:54:03,486 INFO [StartupHelper:220] create index IX_4115EC7A on MBMailingList (uuid_);
14:54:03,496 INFO [StartupHelper:220] create unique index IX_E858F170 on MBMailingList (uuid_, groupId);
14:54:03,498 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_E858F170;INDEX
14:54:03,498 INFO [StartupHelper:220] create index IX_3C865EE5 on MBMessage (categoryId);
14:54:03,508 INFO [StartupHelper:220] create index IX_138C7F1E on MBMessage (categoryId, threadId);
14:54:03,528 INFO [StartupHelper:220] create index IX_51A8D44D on MBMessage (classNameId, classPK);
14:54:03,550 INFO [StartupHelper:220] create index IX_B1432D30 on MBMessage (companyId);
14:54:03,568 INFO [StartupHelper:220] create index IX_5B153FB2 on MBMessage (groupId);
14:54:03,590 INFO [StartupHelper:220] create index IX_8EB8C5EC on MBMessage (groupId, userId);
14:54:03,618 INFO [StartupHelper:220] create index IX_75B95071 on MBMessage (threadId);
14:54:03,640 INFO [StartupHelper:220] create index IX_A7038CD7 on MBMessage (threadId, parentMessageId);
14:54:03,661 INFO [StartupHelper:220] create index IX_C57B16BC on MBMessage (uuid_);
14:54:03,673 INFO [StartupHelper:220] create unique index IX_8D12316E on MBMessage (uuid_, groupId);
14:54:03,706 INFO [StartupHelper:220] create index IX_D180D4AE on MBMessageFlag (messageId);
14:54:03,708 INFO [StartupHelper:220] create index IX_A6973A8E on MBMessageFlag (messageId, flag);
14:54:03,737 INFO [StartupHelper:220] create index IX_C1C9A8FD on MBMessageFlag (threadId);
14:54:03,770 INFO [StartupHelper:220] create index IX_3CFD579D on MBMessageFlag (threadId, flag);
14:54:03,794 INFO [StartupHelper:220] create index IX_7B2917BE on MBMessageFlag (userId);
14:54:03,829 INFO [StartupHelper:220] create unique index IX_E9EB6194 on MBMessageFlag (userId, messageId, flag);
14:54:03,830 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_E9EB6194;INDEX
14:54:03,830 INFO [StartupHelper:220] create index IX_2EA537D7 on MBMessageFlag (userId, threadId, flag);
14:54:03,850 INFO [StartupHelper:220] create index IX_A00A898F on MBStatsUser (groupId);
14:54:03,881 INFO [StartupHelper:220] create index IX_FAB5A88B on MBStatsUser (groupId, messageCount);
14:54:03,893 INFO [StartupHelper:220] create unique index IX_9168E2C9 on MBStatsUser (groupId, userId);
14:54:03,894 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_9168E2C9;INDEX
14:54:03,894 INFO [StartupHelper:220] create index IX_847F92B5 on MBStatsUser (userId);
14:54:03,905 INFO [StartupHelper:220] create index IX_CB854772 on MBThread (categoryId);
14:54:03,917 INFO [StartupHelper:220] create index IX_19D8B60A on MBThread (categoryId, lastPostDate);
14:54:03,938 INFO [StartupHelper:220] create index IX_95C0EA45 on MBThread (groupId);
14:54:03,962 INFO [StartupHelper:220] create index IX_8A1CC4B on MembershipRequest (groupId);
14:54:03,989 INFO [StartupHelper:220] create index IX_C28C72EC on MembershipRequest (groupId, statusId);
14:54:04,001 INFO [StartupHelper:220] create index IX_66D70879 on MembershipRequest (userId);
14:54:04,013 INFO [StartupHelper:220] create index IX_A425F71A on OrgGroupPermission (groupId);
14:54:04,033 INFO [StartupHelper:220] create index IX_6C53DA4E on OrgGroupPermission (permissionId);
14:54:04,044 INFO [StartupHelper:220] create index IX_4A527DD3 on OrgGroupRole (groupId);
14:54:04,064 INFO [StartupHelper:220] create index IX_AB044D1C on OrgGroupRole (roleId);
14:54:04,076 INFO [StartupHelper:220] create index IX_6AF0D434 on OrgLabor (organizationId);
14:54:04,100 INFO [StartupHelper:220] create index IX_834BCEB6 on Organization_ (companyId);
14:54:04,113 INFO [StartupHelper:220] create unique index IX_E301BDF5 on Organization_ (companyId, name);
14:54:04,114 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_E301BDF5;INDEX
14:54:04,114 INFO [StartupHelper:220] create index IX_418E4522 on Organization_ (companyId, parentOrganizationId);
14:54:04,133 INFO [StartupHelper:220] create index IX_2C1142E on PasswordPolicy (companyId, defaultPolicy);
14:54:04,145 INFO [StartupHelper:220] create unique index IX_3FBFA9F4 on PasswordPolicy (companyId, name);
14:54:04,146 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_3FBFA9F4;INDEX
14:54:04,146 INFO [StartupHelper:220] create index IX_C3A17327 on PasswordPolicyRel (classNameId, classPK);
14:54:04,156 INFO [StartupHelper:220] create index IX_ED7CF243 on PasswordPolicyRel (passwordPolicyId, classNameId, classPK);
14:54:04,168 INFO [StartupHelper:220] create index IX_326F75BD on PasswordTracker (userId);
14:54:04,180 INFO [StartupHelper:220] create unique index IX_4D19C2B8 on Permission_ (actionId, resourceId);
14:54:04,182 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_4D19C2B8;INDEX
14:54:04,182 INFO [StartupHelper:220] create index IX_F090C113 on Permission_ (resourceId);
14:54:04,197 INFO [StartupHelper:220] create index IX_9F704A14 on Phone (companyId);
14:54:04,209 INFO [StartupHelper:220] create index IX_A2E4AFBA on Phone (companyId, classNameId);
14:54:04,221 INFO [StartupHelper:220] create index IX_9A53569 on Phone (companyId, classNameId, classPK);
14:54:04,229 INFO [StartupHelper:220] create index IX_812CE07A on Phone (companyId, classNameId, classPK, primary_);
14:54:04,241 INFO [StartupHelper:220] create index IX_F202B9CE on Phone (userId);
14:54:04,253 INFO [StartupHelper:220] create index IX_B9746445 on PluginSetting (companyId);
14:54:04,265 INFO [StartupHelper:220] create unique index IX_7171B2E8 on PluginSetting (companyId, pluginId, pluginType);
14:54:04,266 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_7171B2E8;INDEX
14:54:04,266 INFO [StartupHelper:220] create index IX_EC370F10 on PollsChoice (questionId);
14:54:04,281 INFO [StartupHelper:220] create unique index IX_D76DD2CF on PollsChoice (questionId, name);
14:54:04,282 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_D76DD2CF;INDEX
14:54:04,283 INFO [StartupHelper:220] create index IX_6660B399 on PollsChoice (uuid_);
14:54:04,293 INFO [StartupHelper:220] create index IX_9FF342EA on PollsQuestion (groupId);
14:54:04,305 INFO [StartupHelper:220] create index IX_51F087F4 on PollsQuestion (uuid_);
14:54:04,317 INFO [StartupHelper:220] create unique index IX_F3C9F36 on PollsQuestion (uuid_, groupId);
14:54:04,318 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_F3C9F36;INDEX
14:54:04,319 INFO [StartupHelper:220] create index IX_D5DF7B54 on PollsVote (choiceId);
14:54:04,329 INFO [StartupHelper:220] create index IX_12112599 on PollsVote (questionId);
14:54:04,341 INFO [StartupHelper:220] create unique index IX_1BBFD4D3 on PollsVote (questionId, userId);
14:54:04,343 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_1BBFD4D3;INDEX
14:54:04,343 INFO [StartupHelper:220] create index IX_80CC9508 on Portlet (companyId);
14:54:04,353 INFO [StartupHelper:220] create unique index IX_12B5E51D on Portlet (companyId, portletId);
14:54:04,354 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_12B5E51D;INDEX
14:54:04,354 INFO [StartupHelper:220] create index IX_96BDD537 on PortletItem (groupId, classNameId);
14:54:04,389 INFO [StartupHelper:220] create index IX_D699243F on PortletItem (groupId, name, portletId, classNameId);
14:54:04,401 INFO [StartupHelper:220] create index IX_2C61314E on PortletItem (groupId, portletId);
14:54:04,413 INFO [StartupHelper:220] create index IX_E922D6C0 on PortletItem (groupId, portletId, classNameId);
14:54:04,425 INFO [StartupHelper:220] create index IX_8E71167F on PortletItem (groupId, portletId, classNameId, name);
14:54:04,437 INFO [StartupHelper:220] create index IX_33B8CE8D on PortletItem (groupId, portletId, name);
14:54:04,449 INFO [StartupHelper:220] create index IX_E4F13E6E on PortletPreferences (ownerId, ownerType, plid);
14:54:04,461 INFO [StartupHelper:220] create unique index IX_C7057FF7 on PortletPreferences (ownerId, ownerType, plid, portletId);
14:54:04,463 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_C7057FF7;INDEX
14:54:04,463 INFO [StartupHelper:220] create index IX_F15C1C4F on PortletPreferences (plid);
14:54:04,473 INFO [StartupHelper:220] create index IX_D340DB76 on PortletPreferences (plid, portletId);
14:54:04,485 INFO [StartupHelper:220] create index IX_16184D57 on RatingsEntry (classNameId, classPK);
14:54:04,497 INFO [StartupHelper:220] create unique index IX_B47E3C11 on RatingsEntry (userId, classNameId, classPK);
14:54:04,499 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_B47E3C11;INDEX
14:54:04,499 INFO [StartupHelper:220] create unique index IX_A6E99284 on RatingsStats (classNameId, classPK);
14:54:04,500 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_A6E99284;INDEX
14:54:04,500 INFO [StartupHelper:220] create index IX_2D9A426F on Region (active_);
14:54:04,514 INFO [StartupHelper:220] create index IX_16D87CA7 on Region (countryId);
14:54:04,526 INFO [StartupHelper:220] create index IX_11FB3E42 on Region (countryId, active_);
14:54:04,538 INFO [StartupHelper:220] create index IX_81F2DB09 on ResourceAction (name);
14:54:04,558 INFO [StartupHelper:220] create unique index IX_EDB9986E on ResourceAction (name, actionId);
14:54:04,594 INFO [StartupHelper:220] create index IX_717FDD47 on ResourceCode (companyId);
14:54:04,617 INFO [StartupHelper:220] create unique index IX_A32C097E on ResourceCode (companyId, name, scope);
14:54:04,619 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_A32C097E;INDEX
14:54:04,619 INFO [StartupHelper:220] create index IX_AACAFF40 on ResourceCode (name);
14:54:04,634 INFO [StartupHelper:220] create index IX_60B99860 on ResourcePermission (companyId, name, scope);
14:54:04,655 INFO [StartupHelper:220] create index IX_2200AA69 on ResourcePermission (companyId, name, scope, primKey);
14:54:04,686 INFO [StartupHelper:220] create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
14:54:04,730 INFO [StartupHelper:220] create index IX_A37A0588 on ResourcePermission (roleId);
14:54:04,774 INFO [StartupHelper:220] create index IX_2578FBD3 on Resource_ (codeId);
14:54:04,797 INFO [StartupHelper:220] create unique index IX_67DE7856 on Resource_ (codeId, primKey);
14:54:04,798 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_67DE7856;INDEX
14:54:04,799 INFO [StartupHelper:220] create index IX_449A10B9 on Role_ (companyId);
14:54:04,813 INFO [StartupHelper:220] create unique index IX_A88E424E on Role_ (companyId, classNameId, classPK);
14:54:04,815 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_A88E424E;INDEX
14:54:04,815 INFO [StartupHelper:220] create unique index IX_EBC931B8 on Role_ (companyId, name);
14:54:04,816 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_EBC931B8;INDEX
14:54:04,816 INFO [StartupHelper:220] create index IX_CBE204 on Role_ (type_, subtype);
14:54:04,842 INFO [StartupHelper:220] create index IX_7A3619C6 on Roles_Permissions (permissionId);
14:54:04,844 INFO [StartupHelper:220] create index IX_E04E486D on Roles_Permissions (roleId);
14:54:04,902 INFO [StartupHelper:220] create index IX_3BB93ECA on SCFrameworkVersi_SCProductVers (frameworkVersionId);
14:54:04,946 INFO [StartupHelper:220] create index IX_E8D33FF9 on SCFrameworkVersi_SCProductVers (productVersionId);
14:54:04,982 INFO [StartupHelper:220] create index IX_C98C0D78 on SCFrameworkVersion (companyId);
14:54:04,984 INFO [StartupHelper:220] create index IX_272991FA on SCFrameworkVersion (groupId);
14:54:05,013 INFO [StartupHelper:220] create index IX_6E1764F on SCFrameworkVersion (groupId, active_);
14:54:05,025 INFO [StartupHelper:220] create index IX_1C841592 on SCLicense (active_);
14:54:05,037 INFO [StartupHelper:220] create index IX_5327BB79 on SCLicense (active_, recommended);
14:54:05,049 INFO [StartupHelper:220] create index IX_27006638 on SCLicenses_SCProductEntries (licenseId);
14:54:05,070 INFO [StartupHelper:220] create index IX_D7710A66 on SCLicenses_SCProductEntries (productEntryId);
14:54:05,114 INFO [StartupHelper:220] create index IX_5D25244F on SCProductEntry (companyId);
14:54:05,141 INFO [StartupHelper:220] create index IX_72F87291 on SCProductEntry (groupId);
14:54:05,153 INFO [StartupHelper:220] create index IX_98E6A9CB on SCProductEntry (groupId, userId);
14:54:05,165 INFO [StartupHelper:220] create index IX_7311E812 on SCProductEntry (repoGroupId, repoArtifactId);
14:54:05,177 INFO [StartupHelper:220] create index IX_AE8224CC on SCProductScreenshot (fullImageId);
14:54:05,189 INFO [StartupHelper:220] create index IX_467956FD on SCProductScreenshot (productEntryId);
14:54:05,201 INFO [StartupHelper:220] create index IX_DA913A55 on SCProductScreenshot (productEntryId, priority);
14:54:05,213 INFO [StartupHelper:220] create index IX_6C572DAC on SCProductScreenshot (thumbnailId);
14:54:05,225 INFO [StartupHelper:220] create index IX_7020130F on SCProductVersion (directDownloadURL);
14:54:05,226 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -614, SQLSTATE: 54008, SQLERRMC: IX_7020130F
14:54:05,227 INFO [StartupHelper:220] create index IX_8377A211 on SCProductVersion (productEntryId);
14:54:05,237 INFO [StartupHelper:220] create index IX_7338606F on ServiceComponent (buildNamespace);
14:54:05,249 INFO [StartupHelper:220] create unique index IX_4F0315B8 on ServiceComponent (buildNamespace, buildNumber);
14:54:05,250 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_4F0315B8;INDEX
14:54:05,251 INFO [StartupHelper:220] create index IX_DA5F4359 on Shard (classNameId, classPK);
14:54:05,274 INFO [StartupHelper:220] create index IX_941BA8C3 on Shard (name);
14:54:05,306 INFO [StartupHelper:220] create index IX_C28B41DC on ShoppingCart (groupId);
14:54:05,329 INFO [StartupHelper:220] create unique index IX_FC46FE16 on ShoppingCart (groupId, userId);
14:54:05,330 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_FC46FE16;INDEX
14:54:05,331 INFO [StartupHelper:220] create index IX_54101CC8 on ShoppingCart (userId);
14:54:05,345 INFO [StartupHelper:220] create index IX_5F615D3E on ShoppingCategory (groupId);
14:54:05,357 INFO [StartupHelper:220] create index IX_1E6464F5 on ShoppingCategory (groupId, parentCategoryId);
14:54:05,369 INFO [StartupHelper:220] create unique index IX_DC60CFAE on ShoppingCoupon (code_);
14:54:05,371 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_DC60CFAE;INDEX
14:54:05,371 INFO [StartupHelper:220] create index IX_3251AF16 on ShoppingCoupon (groupId);
14:54:05,381 INFO [StartupHelper:220] create index IX_C8EACF2E on ShoppingItem (categoryId);
14:54:05,393 INFO [StartupHelper:220] create unique index IX_1C717CA6 on ShoppingItem (companyId, sku);
14:54:05,395 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_1C717CA6;INDEX
14:54:05,395 INFO [StartupHelper:220] create index IX_903DC750 on ShoppingItem (largeImageId);
14:54:05,405 INFO [StartupHelper:220] create index IX_D217AB30 on ShoppingItem (mediumImageId);
14:54:05,425 INFO [StartupHelper:220] create index IX_FF203304 on ShoppingItem (smallImageId);
14:54:05,437 INFO [StartupHelper:220] create index IX_6D5F9B87 on ShoppingItemField (itemId);
14:54:05,457 INFO [StartupHelper:220] create index IX_EA6FD516 on ShoppingItemPrice (itemId);
14:54:05,469 INFO [StartupHelper:220] create index IX_1D15553E on ShoppingOrder (groupId);
14:54:05,489 INFO [StartupHelper:220] create index IX_119B5630 on ShoppingOrder (groupId, userId, ppPaymentStatus);
14:54:05,502 INFO [StartupHelper:220] create unique index IX_D7D6E87A on ShoppingOrder (number_);
14:54:05,503 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_D7D6E87A;INDEX
14:54:05,503 INFO [StartupHelper:220] create index IX_F474FD89 on ShoppingOrder (ppTxnId);
14:54:05,514 INFO [StartupHelper:220] create index IX_B5F82C7A on ShoppingOrderItem (orderId);
14:54:05,526 INFO [StartupHelper:220] create index IX_82E39A0C on SocialActivity (classNameId);
14:54:05,538 INFO [StartupHelper:220] create index IX_A853C757 on SocialActivity (classNameId, classPK);
14:54:05,608 INFO [StartupHelper:220] create index IX_64B1BC66 on SocialActivity (companyId);
14:54:05,632 INFO [StartupHelper:220] create index IX_2A2468 on SocialActivity (groupId);
14:54:05,644 INFO [StartupHelper:220] create unique index IX_8F32DEC9 on SocialActivity (groupId, userId, createDate, classNameId, classPK, type_, receiverUserId);
14:54:05,646 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_8F32DEC9;INDEX
14:54:05,646 INFO [StartupHelper:220] create index IX_1271F25F on SocialActivity (mirrorActivityId);
14:54:05,660 INFO [StartupHelper:220] create index IX_1F00C374 on SocialActivity (mirrorActivityId, classNameId, classPK);
14:54:05,672 INFO [StartupHelper:220] create index IX_121CA3CB on SocialActivity (receiverUserId);
14:54:05,684 INFO [StartupHelper:220] create index IX_3504B8BC on SocialActivity (userId);
14:54:05,696 INFO [StartupHelper:220] create index IX_61171E99 on SocialRelation (companyId);
14:54:05,708 INFO [StartupHelper:220] create index IX_95135D1C on SocialRelation (companyId, type_);
14:54:05,720 INFO [StartupHelper:220] create index IX_C31A64C6 on SocialRelation (type_);
14:54:05,740 INFO [StartupHelper:220] create index IX_5A40CDCC on SocialRelation (userId1);
14:54:05,753 INFO [StartupHelper:220] create index IX_4B52BE89 on SocialRelation (userId1, type_);
14:54:05,773 INFO [StartupHelper:220] create unique index IX_12A92145 on SocialRelation (userId1, userId2, type_);
14:54:05,774 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_12A92145;INDEX
14:54:05,774 INFO [StartupHelper:220] create index IX_5A40D18D on SocialRelation (userId2);
14:54:05,785 INFO [StartupHelper:220] create index IX_3F9C2FA8 on SocialRelation (userId2, type_);
14:54:05,805 INFO [StartupHelper:220] create index IX_F0CA24A5 on SocialRelation (uuid_);
14:54:05,817 INFO [StartupHelper:220] create index IX_D3425487 on SocialRequest (classNameId, classPK, type_, receiverUserId, status);
14:54:05,859 INFO [StartupHelper:220] create index IX_A90FE5A0 on SocialRequest (companyId);
14:54:06,259 INFO [StartupHelper:220] create index IX_32292ED1 on SocialRequest (receiverUserId);
14:54:06,272 INFO [StartupHelper:220] create index IX_D9380CB7 on SocialRequest (receiverUserId, status);
14:54:06,283 INFO [StartupHelper:220] create index IX_80F7A9C2 on SocialRequest (userId);
14:54:06,308 INFO [StartupHelper:220] create unique index IX_36A90CA7 on SocialRequest (userId, classNameId, classPK, type_, receiverUserId);
14:54:06,309 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_36A90CA7;INDEX
14:54:06,309 INFO [StartupHelper:220] create index IX_CC86A444 on SocialRequest (userId, classNameId, classPK, type_, status);
14:54:06,320 INFO [StartupHelper:220] create index IX_AB5906A8 on SocialRequest (userId, status);
14:54:06,378 INFO [StartupHelper:220] create index IX_49D5872C on SocialRequest (uuid_);
14:54:06,404 INFO [StartupHelper:220] create unique index IX_4F973EFE on SocialRequest (uuid_, groupId);
14:54:06,405 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_4F973EFE;INDEX
14:54:06,405 INFO [StartupHelper:220] create index IX_786D171A on Subscription (companyId, classNameId, classPK);
14:54:06,436 INFO [StartupHelper:220] create unique index IX_2E1A92D4 on Subscription (companyId, userId, classNameId, classPK);
14:54:06,437 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_2E1A92D4;INDEX
14:54:06,438 INFO [StartupHelper:220] create index IX_54243AFD on Subscription (userId);
14:54:06,448 INFO [StartupHelper:220] create index IX_E8F34171 on Subscription (userId, classNameId);
14:54:06,469 INFO [StartupHelper:220] create unique index IX_1AB6D6D2 on TagsAsset (classNameId, classPK);
14:54:06,470 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_1AB6D6D2;INDEX
14:54:06,471 INFO [StartupHelper:220] create index IX_AB3D8BCB on TagsAsset (companyId);
14:54:06,492 INFO [StartupHelper:220] create index IX_B22F3A1 on TagsAssets_TagsEntries (assetId);
14:54:06,521 INFO [StartupHelper:220] create index IX_A02A8023 on TagsAssets_TagsEntries (entryId);
14:54:06,526 INFO [StartupHelper:220] create index IX_EE55ED49 on TagsEntry (parentEntryId, vocabularyId);
14:54:06,560 INFO [StartupHelper:220] create index IX_28E8954 on TagsEntry (vocabularyId);
14:54:06,572 INFO [StartupHelper:220] create index IX_C134234 on TagsProperty (companyId);
14:54:06,601 INFO [StartupHelper:220] create index IX_EB974D08 on TagsProperty (companyId, key_);
14:54:06,625 INFO [StartupHelper:220] create index IX_5200A629 on TagsProperty (entryId);
14:54:06,656 INFO [StartupHelper:220] create unique index IX_F505253D on TagsProperty (entryId, key_);
14:54:06,680 INFO [StartupHelper:220] create index IX_E0D51848 on TagsVocabulary (companyId, folksonomy);
14:54:06,720 INFO [StartupHelper:220] create index IX_9F26308A on TagsVocabulary (groupId, folksonomy);
14:54:06,732 INFO [StartupHelper:220] create unique index IX_F9E51044 on TagsVocabulary (groupId, name);
14:54:06,733 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_F9E51044;INDEX
14:54:06,733 INFO [StartupHelper:220] create unique index IX_181A4A1B on TasksProposal (classNameId, classPK);
14:54:06,735 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_181A4A1B;INDEX
14:54:06,735 INFO [StartupHelper:220] create index IX_7FB27324 on TasksProposal (groupId);
14:54:06,752 INFO [StartupHelper:220] create index IX_6EEC675E on TasksProposal (groupId, userId);
14:54:06,764 INFO [StartupHelper:220] create index IX_4D0C7F8D on TasksReview (proposalId);
14:54:06,784 INFO [StartupHelper:220] create index IX_70AFEA01 on TasksReview (proposalId, stage);
14:54:06,796 INFO [StartupHelper:220] create index IX_1894B29A on TasksReview (proposalId, stage, completed);
14:54:06,808 INFO [StartupHelper:220] create index IX_41AFC20C on TasksReview (proposalId, stage, completed, rejected);
14:54:06,820 INFO [StartupHelper:220] create index IX_36F512E6 on TasksReview (userId);
14:54:06,832 INFO [StartupHelper:220] create unique index IX_5C6BE4C7 on TasksReview (userId, proposalId);
14:54:06,833 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_5C6BE4C7;INDEX
14:54:06,834 INFO [StartupHelper:220] create index IX_524FEFCE on UserGroup (companyId);
14:54:06,844 INFO [StartupHelper:220] create unique index IX_23EAD0D on UserGroup (companyId, name);
14:54:06,845 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_23EAD0D;INDEX
14:54:06,845 INFO [StartupHelper:220] create index IX_69771487 on UserGroup (companyId, parentUserGroupId);
14:54:06,908 INFO [StartupHelper:220] create index IX_1B988D7A on UserGroupRole (groupId);
14:54:06,928 INFO [StartupHelper:220] create index IX_871412DF on UserGroupRole (groupId, roleId);
14:54:06,940 INFO [StartupHelper:220] create index IX_887A2C95 on UserGroupRole (roleId);
14:54:06,952 INFO [StartupHelper:220] create index IX_887BE56A on UserGroupRole (userId);
14:54:06,964 INFO [StartupHelper:220] create index IX_4D040680 on UserGroupRole (userId, groupId);
14:54:06,976 INFO [StartupHelper:220] create unique index IX_41A32E0D on UserIdMapper (type_, externalUserId);
14:54:06,977 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_41A32E0D;INDEX
14:54:06,978 INFO [StartupHelper:220] create index IX_E60EA987 on UserIdMapper (userId);
14:54:06,996 INFO [StartupHelper:220] create unique index IX_D1C44A6E on UserIdMapper (userId, type_);
14:54:06,997 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_D1C44A6E;INDEX
14:54:06,997 INFO [StartupHelper:220] create index IX_29BA1CF5 on UserTracker (companyId);
14:54:07,009 INFO [StartupHelper:220] create index IX_46B0AE8E on UserTracker (sessionId);
14:54:07,020 INFO [StartupHelper:220] create index IX_E4EFBA8D on UserTracker (userId);
14:54:07,032 INFO [StartupHelper:220] create index IX_14D8BCC0 on UserTrackerPath (userTrackerId);
14:54:07,064 INFO [StartupHelper:220] create index IX_3A1E834E on User_ (companyId);
14:54:07,080 INFO [StartupHelper:220] create index IX_6EF03E4E on User_ (companyId, defaultUser);
14:54:07,092 INFO [StartupHelper:220] create unique index IX_615E9F7A on User_ (companyId, emailAddress);
14:54:07,094 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_615E9F7A;INDEX
14:54:07,094 INFO [StartupHelper:220] create unique index IX_C5806019 on User_ (companyId, screenName);
14:54:07,095 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_C5806019;INDEX
14:54:07,095 INFO [StartupHelper:220] create unique index IX_9782AD88 on User_ (companyId, userId);
14:54:07,097 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_9782AD88;INDEX
14:54:07,097 INFO [StartupHelper:220] create unique index IX_5ADBE171 on User_ (contactId);
14:54:07,098 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_5ADBE171;INDEX
14:54:07,098 INFO [StartupHelper:220] create index IX_762F63C6 on User_ (emailAddress);
14:54:07,113 INFO [StartupHelper:220] create index IX_A9ED7DD3 on User_ (openId);
14:54:07,114 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -614, SQLSTATE: 54008, SQLERRMC: IX_A9ED7DD3
14:54:07,114 INFO [StartupHelper:220] create index IX_A18034A4 on User_ (portraitId);
14:54:07,124 INFO [StartupHelper:220] create index IX_E0422BDA on User_ (uuid_);
14:54:07,137 INFO [StartupHelper:220] create index IX_C4F9E699 on Users_Groups (groupId);
14:54:07,157 INFO [StartupHelper:220] create index IX_F10B6C6B on Users_Groups (userId);
14:54:07,201 INFO [StartupHelper:220] create index IX_7EF4EC0E on Users_Orgs (organizationId);
14:54:07,233 INFO [StartupHelper:220] create index IX_FB646CA6 on Users_Orgs (userId);
14:54:07,270 INFO [StartupHelper:220] create index IX_8AE58A91 on Users_Permissions (permissionId);
14:54:07,272 INFO [StartupHelper:220] create index IX_C26AA64D on Users_Permissions (userId);
14:54:07,309 INFO [StartupHelper:220] create index IX_C19E5F31 on Users_Roles (roleId);
14:54:07,341 INFO [StartupHelper:220] create index IX_C1A01806 on Users_Roles (userId);
14:54:07,365 INFO [StartupHelper:220] create index IX_66FF2503 on Users_UserGroups (userGroupId);
14:54:07,371 INFO [StartupHelper:220] create index IX_BE8102D6 on Users_UserGroups (userId);
14:54:07,376 INFO [StartupHelper:220] create unique index IX_97DFA146 on WebDAVProps (classNameId, classPK);
14:54:07,378 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_97DFA146;INDEX
14:54:07,378 INFO [StartupHelper:220] create index IX_96F07007 on Website (companyId);
14:54:07,381 INFO [StartupHelper:220] create index IX_4F0F0CA7 on Website (companyId, classNameId);
14:54:07,383 INFO [StartupHelper:220] create index IX_F960131C on Website (companyId, classNameId, classPK);
14:54:07,386 INFO [StartupHelper:220] create index IX_1AA07A6D on Website (companyId, classNameId, classPK, primary_);
14:54:07,409 INFO [StartupHelper:220] create index IX_F75690BB on Website (userId);
14:54:07,429 INFO [StartupHelper:220] create index IX_5D6FE3F0 on WikiNode (companyId);
14:54:07,441 INFO [StartupHelper:220] create index IX_B480A672 on WikiNode (groupId);
14:54:07,453 INFO [StartupHelper:220] create unique index IX_920CD8B1 on WikiNode (groupId, name);
14:54:07,454 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_920CD8B1;INDEX
14:54:07,454 INFO [StartupHelper:220] create index IX_6C112D7C on WikiNode (uuid_);
14:54:07,473 INFO [StartupHelper:220] create unique index IX_7609B2AE on WikiNode (uuid_, groupId);
14:54:07,474 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_7609B2AE;INDEX
14:54:07,474 INFO [StartupHelper:220] create index IX_A2001730 on WikiPage (format);
14:54:07,485 INFO [StartupHelper:220] create index IX_C8A9C476 on WikiPage (nodeId);
14:54:07,497 INFO [StartupHelper:220] create index IX_E7F635CA on WikiPage (nodeId, head);
14:54:07,509 INFO [StartupHelper:220] create index IX_65E84AF4 on WikiPage (nodeId, head, parentTitle);
14:54:07,529 INFO [StartupHelper:220] create index IX_46EEF3C8 on WikiPage (nodeId, parentTitle);
14:54:07,549 INFO [StartupHelper:220] create index IX_1ECC7656 on WikiPage (nodeId, redirectTitle);
14:54:07,569 INFO [StartupHelper:220] create index IX_997EEDD2 on WikiPage (nodeId, title);
14:54:07,589 INFO [StartupHelper:220] create index IX_E745EA26 on WikiPage (nodeId, title, head);
14:54:07,609 INFO [StartupHelper:220] create unique index IX_3D4AF476 on WikiPage (nodeId, title, version);
14:54:07,611 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_3D4AF476;INDEX
14:54:07,611 INFO [StartupHelper:220] create index IX_9C0E478F on WikiPage (uuid_);
14:54:07,626 INFO [StartupHelper:220] create unique index IX_899D3DFB on WikiPage (uuid_, groupId);
14:54:07,659 INFO [StartupHelper:220] create unique index IX_21277664 on WikiPageResource (nodeId, title);
14:54:07,660 WARN [StartupHelper:229] DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: DB2ADMIN.IX_21277664;INDEX
14:54:11,254 INFO [HotDeployUtil:64] Initializing hot deploy manager 22263326
Artur Korol, modifié il y a 14 années.

RE: DB2 SQL error during upgrade from 5.2.2 to 5.2.3

Junior Member Publications: 96 Date d'inscription: 02/03/09 Publications récentes
ANOTHER DB2 ERORS while exetuting "Data migration" in 5.2.3

14:19:47,258 FATAL [ConvertPermissionAlgorithm:131] com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -119, SQLSTATE: 42803, SQLERRMC: CODEID
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -119, SQLSTATE: 42803, SQLERRMC: CODEID
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.d(hh.java:1650)
at com.ibm.db2.jcc.b.hh.a(hh.java:1219)
at com.ibm.db2.jcc.c.db.g(db.java:139)
at com.ibm.db2.jcc.c.db.a(db.java:39)
at com.ibm.db2.jcc.c.t.a(t.java:34)
at com.ibm.db2.jcc.c.sb.f(sb.java:142)
at com.ibm.db2.jcc.b.hh.n(hh.java:1190)
at com.ibm.db2.jcc.b.ih.eb(ih.java:1997)
at com.ibm.db2.jcc.b.ih.d(ih.java:2439)
at com.ibm.db2.jcc.b.ih.V(ih.java:492)
at com.ibm.db2.jcc.b.ih.executeQuery(ih.java:475)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)