I have removed all Lab Key data and java runtime from windows. Reinstall Lab Key package only. Now i got this error:

500: Unexpected server error

A failure occurred during LabKey Server startup.

org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar [SELECT *
FROM (
SELECT
Policies.resourceid AS resourceid,
Policies.resourceclass AS resourceclass,
Policies.container AS container,
Policies.modified AS modified,
NULL AS ResourceId
FROM core.policies Policies ) x

WHERE (resourceid = ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column reference "resourceid" is ambiguous
  Position: 224
       at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:111)
       at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
       at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:38)
       at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:32)
       at org.labkey.api.data.ExecutingSelector$ExecutingResultSetFactory.handleSqlException(ExecutingSelector.java:404)
       at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:240)
       at org.labkey.api.data.BaseSelector.getArrayList(BaseSelector.java:113)
       at org.labkey.api.data.BaseSelector.getObject(BaseSelector.java:153)
       at org.labkey.api.data.TableSelector.getObject(TableSelector.java:228)
       at org.labkey.api.data.TableSelector.getObject(TableSelector.java:195)
       at org.labkey.api.security.SecurityPolicyManager.savePolicy(SecurityPolicyManager.java:107)
       at org.labkey.api.data.ContainerManager.bootstrapContainer(ContainerManager.java:1871)
       at org.labkey.core.CoreModule.bootstrap(CoreModule.java:484)
       at org.labkey.core.CoreModule.afterUpdate(CoreModule.java:464)
       at org.labkey.api.module.ModuleUpgrader.upgrade(ModuleUpgrader.java:60)
       at org.labkey.api.module.ModuleLoader.upgradeCoreModule(ModuleLoader.java:734)
       at org.labkey.api.module.ModuleLoader.doInit(ModuleLoader.java:315)
       at org.labkey.api.module.ModuleLoader.init(ModuleLoader.java:219)
       at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:295)
       at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:422)
       at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:115)
       at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)
       at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
       at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
       at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
       at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
       at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
       at org.apache.catalina.core.StandardService.start(StandardService.java:525)
       at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.postgresql.util.PSQLException: ERROR: column reference "resourceid" is ambiguous
  Position: 224
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.labkey.api.data.dialect.StatementWrapper.executeQuery(StatementWrapper.java:591)
       at org.labkey.api.data.ExecutingSelector$ExecutingResultSetFactory.executeQuery(ExecutingSelector.java:354)
       at org.labkey.api.data.ExecutingSelector$ExecutingResultSetFactory.getResultSet(ExecutingSelector.java:301)
       at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:231)
       ... 39 more

I am sorry that you having a problem getting LabKey Server installed. Can you provide me with more information about your server setup?

1. What version of LabKey are you attempting to install?
2. How did you perform the installation? Was it using the Windows Graphical Installer or are you performing a manual installation?
3. What is your operating system?

Can you also attach the catalina.* and labkey.log log files which are located in the logs directory in the Tomcat Install Directory.

-Brian

Hello there,

1. I am trying to install final version which i downloaded 2 days ago.
2. Trying to install Windows Graphical Installer. Everything is smooth while installing. I also disabled Norton I.S. 2014.
3. Win 7 Home Premium SP1 64bit

I am sorry for the delay in responding to your message. The log files indicate a serious problem occurred during the installation.

I recommend the following:

1. Please send us the install.log file which is located in the LabKey Server Install directory. This file may help us understand what occurred.
2. Uninstall the LabKey Software software using the Programs Control Panel.
3. Delete or rename the LabKey Server Install directory if it still exists after the uninstall.
4. Install the LabKey Server again.


Again, I apologize for the delay in getting back to you.

-Brian

Hey again Brian,

I rolled a fresh format to Windows XP Pro SP3 Eng and tried re-installing Labkey right after updating .Net framework. Everything was smooth :) All working now. I will try same with main computer running on windows server 2012. Thank you for support.