2.0.1 to 2.0.2 migration is failing

Post 2.0.1-2.0.2 migration, I cannot load orders or merchants in the UI. I can log in and see the various processes run via the tomcat logs. Orders seem to process correctly but won't display. I assume because merchants are throwing the exception I have listed below.

2013-02-27 20:03:15,012-535958 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=947d6441-5a51-4d2d-ab45-ecb816a3266b, requestId=78a79bb6-6d18-47a2-8163-f52c74e4686d, locale=en_US, authToken=X2CU34D5NWDJU5DIJCN5PP44WW4QO5DMWMR63RJMJQRAWMFLDUXUEJIBKYPLGIGGM3OOHPHI65X7Z5NK3WR5I5HUBEFGNN46PI7DCTQ5QDDCSIQHX2W6ICME5IIX6JITT5F6C3GZISX7UM7DY25XVNKVPFUK53445SUVM5CA4LH3B5PPVXGUF4OICZXRANB6YGSNXYGE4BKOAKZXF4LT3QOVBU======, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] - query: SELECT *
WHERE (Realm = 'com.reseller2') AND (active = 'true')
ORDER BY displayName ASC, resellerAssignedId ASC
LIMIT 10,1024
2013-02-27 20:03:15,012-535958 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=947d6441-5a51-4d2d-ab45-ecb816a3266b, requestId=78a79bb6-6d18-47a2-8163-f52c74e4686d, locale=en_US, authToken=X2CU34D5NWDJU5DIJCN5PP44WW4QO5DMWMR63RJMJQRAWMFLDUXUEJIBKYPLGIGGM3OOHPHI65X7Z5NK3WR5I5HUBEFGNN46PI7DCTQ5QDDCSIQHX2W6ICME5IIX6JITT5F6C3GZISX7UM7DY25XVNKVPFUK53445SUVM5CA4LH3B5PPVXGUF4OICZXRANB6YGSNXYGE4BKOAKZXF4LT3QOVBU======, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] - paging to offset. current = 0
2013-02-27 20:03:15,014-535960 [http-8080-1] WARN com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager [timezone=UTC, principalId=947d6441-5a51-4d2d-ab45-ecb816a3266b, requestId=78a79bb6-6d18-47a2-8163-f52c74e4686d, locale=en_US, authToken=X2CU34D5NWDJU5DIJCN5PP44WW4QO5DMWMR63RJMJQRAWMFLDUXUEJIBKYPLGIGGM3OOHPHI65X7Z5NK3WR5I5HUBEFGNN46PI7DCTQ5QDDCSIQHX2W6ICME5IIX6JITT5F6C3GZISX7UM7DY25XVNKVPFUK53445SUVM5CA4LH3B5PPVXGUF4OICZXRANB6YGSNXYGE4BKOAKZXF4LT3QOVBU======, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] - Query referenced unknown field 'active'
2013-02-27 20:03:15,018-535964 [http-8080-1] ERROR com.thesearchagency.saas.core.services.merchant.MerchantServiceComponent [timezone=UTC, principalId=947d6441-5a51-4d2d-ab45-ecb816a3266b, requestId=78a79bb6-6d18-47a2-8163-f52c74e4686d, locale=en_US, authToken=X2CU34D5NWDJU5DIJCN5PP44WW4QO5DMWMR63RJMJQRAWMFLDUXUEJIBKYPLGIGGM3OOHPHI65X7Z5NK3WR5I5HUBEFGNN46PI7DCTQ5QDDCSIQHX2W6ICME5IIX6JITT5F6C3GZISX7UM7DY25XVNKVPFUK53445SUVM5CA4LH3B5PPVXGUF4OICZXRANB6YGSNXYGE4BKOAKZXF4LT3QOVBU======, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] - StorageManagerException thrown while searching for merchants using 'WHERE active = 'true' ORDER BY displayName ASC,resellerAssignedId ASC LIMIT 10,0'.
com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INVALID_QUERY_EXCEPTION
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertExpressionToSQL(BaseJDBCStorageManager.java:653) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertExpressionToSQL(BaseJDBCStorageManager.java:573) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertExpressionToSQL(BaseJDBCStorageManager.java:694) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertExpressionToSQL(BaseJDBCStorageManager.java:636) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertExpressionToSQL(BaseJDBCStorageManager.java:694) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.convertQueryToSQL(BaseJDBCStorageManager.java:475) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.createQuerySQL(BaseJDBCStorageManager.java:452) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager.retrieve(SpringJDBCStorageManager.java:1006) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager.query(SpringJDBCStorageManager.java:925) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager.query(SpringJDBCStorageManager.java:217) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager.query(SpringJDBCStorageManager.java:60) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.query(BaseJDBCStorageManager.java:111) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.saas.core.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:163) ~[saas-core-services-merchant-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:330) [MerchantService.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167) [cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94) [cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) [tomcat6-servlet-2.5-api-6.0.24.jar:na]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na]
at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24]
2013-02-27 20:03:15,023-535969 [http-8080-1] WARN com.thesearchagency.sapi.services.merchant.MerchantService [timezone=UTC, principalId=947d6441-5a51-4d2d-ab45-ecb816a3266b, requestId=78a79bb6-6d18-47a2-8163-f52c74e4686d, locale=en_US, authToken=X2CU34D5NWDJU5DIJCN5PP44WW4QO5DMWMR63RJMJQRAWMFLDUXUEJIBKYPLGIGGM3OOHPHI65X7Z5NK3WR5I5HUBEFGNN46PI7DCTQ5QDDCSIQHX2W6ICME5IIX6JITT5F6C3GZISX7UM7DY25XVNKVPFUK53445SUVM5CA4LH3B5PPVXGUF4OICZXRANB6YGSNXYGE4BKOAKZXF4LT3QOVBU======, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] - Error thrown querying for merchants WHERE active = 'true' ORDER BY displayName ASC,resellerAssignedId ASC LIMIT 10,0
com.thesearchagency.saas.core.services.ServiceException: package com.thesearchagency.saas.core.services.merchant.MERCHANT_QUERY_FAILED_EXCEPTION
at com.thesearchagency.saas.core.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:169) ~[saas-core-services-merchant-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:330) ~[MerchantService.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167) [cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94) [cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) [tomcat6-servlet-2.5-api-6.0.24.jar:na]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197) [cxf-rt-transports-http-2.6.2.jar:2.6.2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na]
at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24]
2013-02-27 20:03:15,025-535971 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null
2013-02-27 20:03:15,026-535972 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header
2013-02-27 20:03:15,026-535972 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header
2013-02-27 20:03:15,026-535972 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header
2013-02-27 20:03:15,029-535975 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 14
Response-Code: 500
Content-Type: text/plain
Headers:

{Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], Content-Type=[text/plain], X-AML-API-ID=[78a79bb6-6d18-47a2-8163-f52c74e4686d], Date=[Wed, 27 Feb 2013 20:03:15 GMT]}

Payload: Internal server error