Lar file import problem

[biswajit sarkar, modificado hace 10 años.]

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, modificado hace 10 años.]

please help anyone...... its urgent

[Kenneth Chang, modificado hace 10 años.]

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, modificado hace 10 años.]

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, modificado hace 10 años.]

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, modificado hace 10 años.]

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, modificado hace 10 años.]

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, modificado hace 10 años.]

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

Thanks in advance