Could not start 1529 at all - "Table not found: INSPECTION_RESULTS"

Hello all,
I have downloaded 1529 with tomcat included, unpacked and started runAll.bat,
but it doesn't start at all.
Have you any idea where could be a problem?
I use JDK 1.5.0_05, Windows 2000.

Exception details:
...
ERROR - work.web.context.ContextLoader - Context initialization
failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'buildServer' defined in ServletContext resource [/WEB-INF/buildServerSpr
ing.xml]: Instantiation of bean failed; nested exception is org.springframework.
beans.BeanInstantiationException: Could not instantiate bean class [jetbrains.bu
ildServer.serverSide.impl.BuildServerImpl]: Constructor threw exception; nested
exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versio
ning.ConvertException: java.sql.SQLException: Table not found: INSPECTION_RESULT
S in statement
org.springframework.beans.BeanInstantiationException: Could not instantiate bean
class : Constructor thre
w exception; nested exception is java.lang.RuntimeException: jetbrains.buildServ
er.serverSide.versioning.ConvertException: java.sql.SQLException: Table not foun
d: INSPECTION_RESULTS in statement
java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertE
xception: java.sql.SQLException: Table not found: INSPECTION_RESULTS in statemen
t
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildSer
verImpl.java:123)
...

Thanks in advance,
Pavel

6 comments
Comment actions Permalink

Hello,

We've made a fix for this exception. New jar file which contains the fix is
attached to this letter. Could you please place it over the existing jar
from the ROOT/WEB-INF/lib folder and tell us whether the problem fixed or
not.

--
Pavel Sher

"Pavel Sozonovsky" <sozonovsky@mail.ru> wrote in message
news:26296176.1155894080809.JavaMail.itn@is.intellij.net...

Hello all,
I have downloaded 1529 with tomcat included, unpacked and started
runAll.bat,
but it doesn't start at all.
Have you any idea where could be a problem?
I use JDK 1.5.0_05, Windows 2000.

>

Exception details:
..
ERROR - work.web.context.ContextLoader - Context
initialization
failed
org.springframework.beans.factory.BeanCreationException: Error creating
bean wit
h name 'buildServer' defined in ServletContext resource
[/WEB-INF/buildServerSpr
ing.xml]: Instantiation of bean failed; nested exception is
org.springframework.
beans.BeanInstantiationException: Could not instantiate bean class
[jetbrains.bu
ildServer.serverSide.impl.BuildServerImpl]: Constructor threw exception;
nested
exception is java.lang.RuntimeException:
jetbrains.buildServer.serverSide.versio
ning.ConvertException: java.sql.SQLException: Table not found:
INSPECTION_RESULT
S in statement
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean
class : Constructor
thre
w exception; nested exception is java.lang.RuntimeException:
jetbrains.buildServ
er.serverSide.versioning.ConvertException: java.sql.SQLException: Table
not foun
d: INSPECTION_RESULTS in statement
java.lang.RuntimeException:
jetbrains.buildServer.serverSide.versioning.ConvertE
xception: java.sql.SQLException: Table not found: INSPECTION_RESULTS in
statemen
t
at
jetbrains.buildServer.serverSide.impl.BuildServerImpl.<init>(BuildSer
verImpl.java:123)
..

>

Thanks in advance,
Pavel






Attachment(s):
server.jar
0
Comment actions Permalink

Hello Pavel,

Jar replacement didn't help unfortunately, but it has changed my error log, at least.
New console output looks like following:
...
log4j:WARN Please initialize the log4j system properly.
inspection_results table not exists
ERROR - work.web.context.ContextLoader - Context initialization
failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'buildServer' defined in ServletContext resource [/WEB-INF/buildServerSpr
ing.xml]: Instantiation of bean failed; nested exception is org.springframework.
beans.BeanInstantiationException: Could not instantiate bean class [jetbrains.bu
ildServer.serverSide.impl.BuildServerImpl]: Constructor threw exception; nested
exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versio
ning.ConvertException: java.sql.SQLException: org.apache.commons.dbcp.Delegating
Statement is closed.
org.springframework.beans.BeanInstantiationException: Could not instantiate bean
class : Constructor thre
w exception; nested exception is java.lang.RuntimeException: jetbrains.buildServ
er.serverSide.versioning.ConvertException: java.sql.SQLException: org.apache.com
mons.dbcp.DelegatingStatement is closed.
java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertE
xception: java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is
closed.
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildSer
verImpl.java:123)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
...

Hope it could help you to fix that problem.

Good luck,
Pavel

0
Comment actions Permalink

Hello,

We've made additional changes. Updated jar file which contains the fix is
attached to this letter.
Could you please try again and tell us whether the problem fixed or not.

--
Alexey Gopachenko





Attachment(s):
server.jar
0
Comment actions Permalink

Hello Alexej,

The next exception fragment you could find below:
...
log4j:WARN Please initialize the log4j system properly.
inspection_results table not exists
java.io.FileNotFoundException: D:\Documents and Settings\sozonovsky\.BuildServer
\system\license.keys (The system cannot find the file specified)
ERROR - work.web.context.ContextLoader - Context initialization
failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'notificationTriggersManager' defined in ServletContext resource [/WEB-IN
F/buildServerSpring.xml]: Instantiation of bean failed; nested exception is org.
springframework.beans.BeanInstantiationException: Could not instantiate bean cla
ss : Constructor
threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarExce
ption: ConnectionCallback; bad SQL grammar []; nested exception is java.sql.SQLE
xception: Table not found in statement [SELECT max(TRIGGER_ID) FROM build_trigge
rs_notificators]
org.springframework.beans.BeanInstantiationException: Could not instantiate bean
class : Constru
ctor threw exception; nested exception is org.springframework.jdbc.BadSqlGrammar
Exception: ConnectionCallback; bad SQL grammar []; nested exception is java.sql.
SQLException: Table not found in statement [SELECT max(TRIGGER_ID) FROM build_tr
iggers_notificators]
org.springframework.jdbc.BadSqlGrammarException: ConnectionCallback; bad SQL gra
mmar []; nested exception is java.sql.SQLException: Table not found in statement

java.sql.SQLException: Table not found in statement [SELECT max(TRIGGER_ID) FROM
build_triggers_notificators]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.]]>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delegat
ingConnection.java:185)
...

Am i the only man with this exception? Could you point why me have no success with this builld while other people could at least start it successfully?

Hope this information could help you,
Pavel

0
Comment actions Permalink

Hello,

Indeed, you are the only man reporting such problems and considering the
last exception we can only recommend you to do the clean setup (do not
forget to remove D:\Documents and Settings\sozonovsky\.BuildServer folder).
Please notify us about your progress. Also it will be useful to know whether
you made any changes to default database configuration.
--
Alexey Gopachenko


"Pavel Sozonovsky" <sozonovsky@mail.ru> wrote in message
news:23541385.1155929072897.JavaMail.itn@is.intellij.net...

Hello Alexej,

>

The next exception fragment you could find below:
..
log4j:WARN Please initialize the log4j system properly.
inspection_results table not exists
java.io.FileNotFoundException: D:\Documents and
Settings\sozonovsky\.BuildServer
\system\license.keys (The system cannot find the file specified)
ERROR - work.web.context.ContextLoader - Context
initialization
failed
org.springframework.beans.factory.BeanCreationException: Error creating
bean wit
h name 'notificationTriggersManager' defined in ServletContext resource
[/WEB-IN
F/buildServerSpring.xml]: Instantiation of bean failed; nested exception
is org.
springframework.beans.BeanInstantiationException: Could not instantiate
bean cla
ss :
Constructor
threw exception; nested exception is
org.springframework.jdbc.BadSqlGrammarExce
ption: ConnectionCallback; bad SQL grammar []; nested exception is
java.sql.SQLE
xception: Table not found in statement [SELECT max(TRIGGER_ID) FROM
build_trigge
rs_notificators]
org.springframework.beans.BeanInstantiationException: Could not
instantiate bean
class :
Constru
ctor threw exception; nested exception is
org.springframework.jdbc.BadSqlGrammar
Exception: ConnectionCallback; bad SQL grammar []; nested exception is
java.sql.
SQLException: Table not found in statement [SELECT max(TRIGGER_ID) FROM
build_tr
iggers_notificators]
org.springframework.jdbc.BadSqlGrammarException: ConnectionCallback; bad
SQL gra
mmar []; nested exception is java.sql.SQLException: Table not found in
statement

java.sql.SQLException: Table not found in statement [SELECT
max(TRIGGER_ID) FROM
build_triggers_notificators]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delegat
ingConnection.java:185)
..

>

Am i the only man with this exception? Could you point why me have no
success with this builld while other people could at least start it
successfully?

>

Hope this information could help you,
Pavel



0
Comment actions Permalink

Hello Alexey,

Is seems I'am the only stupid man who didn't try to remove .buildServer folder before installation next version of software.
After .buildServer folder removed, TeamCity started successfully.

Thank you for support,
Pavel

0

Please sign in to leave a comment.