Lar file import problem

[biswajit sarkar，修改在10 年前。]

I am trying to import a lar file in my liferay but i got an exception.....

Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
        at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
        at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
        at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
        at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:50)
        at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:574)
        ... 178 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:119)
        ... 182 more
Caused by: java.sql.BatchUpdateException: Duplicate entry '10180-0-/company' for key 'IX_BC2C4231'
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 188 more

please help its urgent. how can i solve this problem

[biswajit sarkar，修改在10 年前。]

please help anyone...... its urgent

[Kenneth Chang，修改在10 年前。]

It looks like you're trying to import a duplicate value. Can you provide your Liferay version and steps to reproduce from a clean bundle?

[biswajit sarkar，修改在10 年前。]

Kenneth Chang:

It looks like you're trying to import a duplicate value. Can you provide your Liferay version and steps to reproduce from a clean bundle?

i am using liferay 6.1 ga2 . i export a lar file from my dev environment and try to import the lar file in my production environment and not able to import due to this exception.

[Balaji Murugesan，修改在10 年前。]

Hi Biswajit,

If your dev env & prod env are of different editions of Liferay then you might face this issue. i have faced a similar problem when trying to import LAR from my Dev env Community edition to Prod env Enterprise edition of Liferay.

you can try to have a similar duplicate setup in your dev env and test the import functionality.

[biswajit sarkar，修改在10 年前。]

Balaji Murugesan:

Hi Biswajit,

If your dev env & prod env are of different editions of Liferay then you might face this issue. i have faced a similar problem when trying to import LAR from my Dev env Community edition to Prod env Enterprise edition of Liferay.

you can try to have a similar duplicate setup in your dev env and test the import functionality.

our dev and prod env are both using version (6.1 GA2 ).
While importing "lar" file in our prod env our "Data strategy" is " Mirror with overwriting" , then why this problem arise.

[sangeeth k，修改在10 年前。]

hi biswajit,


while importing "lar" file "Data strategy" option is check " Mirror"

I did same for for my production server, am using 6.1 GA2 sucessfully imported webcontents.

[Jacques Traore，修改在10 年前。]

Hi Biswajit,
Did figure out that issue? I am facing the same problem.
If yes, would you please share the solution?

Thanks in advance