while installing dotcms getting only 500 on localhost

[Rohit...@dcplkolkata.com]

Hi All,

I am currently stuck while installing dotCMS. Below is the error that is showing in log ;

[07/01/15 02:45:08:077 IST]  WARN util.JDBCExceptionReporter: SQL Error: 547, SQLState: 23000
[07/01/15 02:45:08:077 IST] ERROR util.JDBCExceptionReporter: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_contentlet_lang". The conflict occurred in database "dotcms", table "dbo.language", column 'id'.
[07/01/15 02:45:08:077 IST] ERROR impl.SessionImpl: Could not synchronize database state with session
[07/01/15 02:45:08:077 IST] ERROR business.HostAPIImpl: Unable to save/update Object to Hibernate Session
com.dotmarketing.exception.DotHibernateException: Unable to save/update Object to Hibernate Session
    at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:476)
    at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.save(ESContentFactoryImpl.java:1349)
    at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.save(ESContentFactoryImpl.java:1335)
    at com.dotmarketing.portlets.contentlet.business.HostAPIImpl.createSystemHost(HostAPIImpl.java:778)
    at com.dotmarketing.portlets.contentlet.business.HostAPIImpl.findSystemHost(HostAPIImpl.java:466)
    at com.dotmarketing.servlets.InitServlet.init(InitServlet.java:220)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1247)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1898)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.dotcms.repackage.net.sf.hibernate.exception.ConstraintViolationException: could not insert: [com.dotmarketing.portlets.contentlet.business.Contentlet#75e36e30-d3a8-468d-ab7c-6de175ebfc3e]
    at com.dotcms.repackage.net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:62)
    at com.dotcms.repackage.net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
    at com.dotcms.repackage.net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)
    at com.dotcms.repackage.net.sf.hibernate.persister.NormalizedEntityPersister.insert(NormalizedEntityPersister.java:464)
    at com.dotcms.repackage.net.sf.hibernate.persister.NormalizedEntityPersister.insert(NormalizedEntityPersister.java:426)
    at com.dotcms.repackage.net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
    at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
    at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
    at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
    at com.dotcms.repackage.net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
    at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:474)
    ... 21 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_contentlet_lang". The conflict occurred in database "dotcms", table "dbo.language", column 'id'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at com.dotcms.repackage.net.sf.hibernate.persister.NormalizedEntityPersister.insert(NormalizedEntityPersister.java:454)
    ... 28 more

I am not sure, why this is coming, I have also attached the full log file, If you required this.

Please let us know as early as possible.

Thanks.

[Jason Tesser]

this appears your are installing into a DB that already had tables or something 

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/d/optout.

[Rohit...@dcplkolkata.com]

Thanks for your response. But I have deleted the database and create a new empty database again got the same error and also get this.
[07/01/15 03:12:09:902 IST] ERROR portal._500_jsp: cms500Page cant display java.lang.IndexOutOfBoundsException: Index: 0, Size: 0