692182 - Can't load TestCases

Status: RESOLVED FIXED

(Mozilla QA :: Case Conductor-Platform, defect, P1)

Description

[Carl Meyer (:carljm)]

Will paste full error traceback in comment.

Comment 1

[Cameron Dawson [:camd]]

A Pivotal Tracker story has been created for this Bug: http://www.pivotaltracker.com/story/show/19299031

Comment 2

[Cameron Dawson [:camd]]

Carl Meyer added a comment in Pivotal Tracker:   
   
18:31:18,521 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1
Address: /tcm/services/v2/rest/testruns/results
Content-Type: 
Headers: {Authorization=[Basic YWRtaW5AdXRlc3QuY29tOmFkbWlu], host=[localhost:8080], user-agent=[TCMui/0.3], accept-encoding=[gzip, deflate], Content-Type=[null], Accept=[application/json]}
--------------------------------------
18:31:19,032 WARN  [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22
18:31:19,032 ERROR [JDBCExceptionReporter] Unknown column 'testcase0_.externalAuthorEmail' in 'field list'
18:31:19,034 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [com.utest.domain.TestCase#1]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at 
[... trimmed for length ...]
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
	at org.hibernate.loader.Loader.doQuery(Loader.java:697)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
	... 101 more
18:31:19,058 INFO  [PhaseInterceptorChain] Application {http://v2.impl.webservice.utest.com/}ExternalBugWebServiceImpl has thrown exception, unwinding now: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.utest.domain.TestCase#1]
18:31:19,152 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1
Response-Code: 500
Encoding: UTF-8
Content-Type: application/json
Headers: {}
Payload: {"errors":[{"error":"could not load an entity: [com.utest.domain.TestCase#1]"}]}
--------------------------------------

Comment 3

[Cameron Dawson [:camd]]

Carl Meyer added a comment in Pivotal Tracker:   
   
Just realized the summary might be misleading here - this error is not from trying to use the new CSV import features, it's just from trying to query a set of test results. Trying to load a set of test cases gets a similar error "could not execute query".

Comment 4

[Cameron Dawson [:camd]]

Vadim Kisen added a comment in Pivotal Tracker:   
   
You need to run update 26

Comment 5

[Cameron Dawson [:camd]]

Vadim Kisen changed story state to delivered in Pivotal Tracker

Comment 6

[Cameron Dawson [:camd]]

Carl Meyer added a comment in Pivotal Tracker:   
   
Oops, missed that update. Thanks.

Comment 7

[Cameron Dawson [:camd]]

Carl Meyer changed story state to accepted in Pivotal Tracker