getting 500 on localhost while installing dotcms

[Rohit...@dcplkolkata.com]

Hi All,

I am currently stuck in dotcms installing, I am new to this, Below is the error what I found on dotcms.log ::

[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 have also attached the full log, and also attach the image that gives 500. Please look into it as let me know. Thanks in advance.

[Jason Tesser]

So I think you need to start with a new DB and follow the SQL Server instructions here http://dotcms.com/docs/latest/DatabaseConfiguration

notice the 2 commands to control the transaction isolation 

ALTER DATABASE dotcms SET READ_COMMITTED_SNAPSHOT ON;
GO

ALTER DATABASE dotcms SET ALLOW_SNAPSHOT_ISOLATION ON;
GO

--
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 created new database and also perform the below action and again got the same error. thanks.

[Jason Tesser]

must be something with your db. or the commands r not taking, 

what version r u running? is it in the cloud?

[Rohit...@dcplkolkata.com]

MsSQL 2008 version. It can be possible but I am not sure from where it is happening.

[Rohit...@dcplkolkata.com]

No, it is not in cloud and I am doing it in my local machine dotcms version 3.0.1.