[LPS-36159] create-db2.sql resulting an error - Liferay Issues

XML

Word

Printable

Details

Type: Bug
Status: Closed
Resolution: Fixed
Affects Version/s: 6.1.1 CE GA2
Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M4
Component/s: Environments, Environments > Databases
Labels:
None
Environment:
Linux x86_64 (CentOS 5.9 final)
DB2 v10

Description

create-db2.sql downloadable from http://sourceforge.net/projects/lportal/files/Liferay%20Portal/6.1.1%20GA2/liferay-portal-sql-6.1.1-ce-ga2-20120731132656558.zip/download

results an unique constraint violation

create unique index IX_CED31606 on Layout (uuid_, groupId)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0603N A unique index cannot be created because the table contains data
that would result in duplicate index entries. SQLSTATE=23515

Attachments

Issue Links

is related to

LPS-31315 Site template with added webcontent of global scope draws error when creating new organization with Create Site checked

Closed

Activity

People

Assignee:

Laszlo Csontos (Inactive)

Reporter:

Michal Fleischhans (Inactive)

Participants of an Issue:

Laszlo Csontos, Michal Fleischhans

Recent user:

Esther Sanz

Votes:

0 Vote for this issue

Watchers:

0 Start watching this issue

Dates

Created:

11/Jun/13 2:08 AM

Updated:

19/Mar/14 6:56 AM

Resolved:

25/Jun/13 4:29 PM

Days since last comment:

6 years, 36 weeks, 3 days ago

Packages

Version	Package
6.1.30 EE GA3
6.2.0 CE M4