#119 migrated the Jtrac from HSQLDB to MSSQL along with the data'
I have migrated the HSQLDB to MSSQL along with old HSQLDB data's. When i try to open the Jtrac link it show me Internal Error.
But it works when we use fresh jtrac with MSSQL. But problem comes when we migrate the old data's to MSSQL.
I found that "Guest Allowed" in space table is Boolean type in HSQLDB, but same is not suppored in MSSQL.
F:\2001042501\UJtrac\ltrac\jtrac>java -Djetty.port=8090 -Djtrac.home=data -Dfile
.encoding=UTF-8 -DSTOP.PORT=8079 -DSTOP.KEY=jtrac -jar start.jar
2009-05-02 11:04:11.394::INFO: Logging to STDERR via org.mortbay.log.StdErrLog
2009-05-02 11:04:11.644::INFO: jetty-6.1.1
2009-05-02 11:04:11.754::INFO: Extract jar:file:/F:/2001042501/UJtrac/ltrac/jtr
ac/jtrac.war!/ to F:\2001042501\UJtrac\ltrac\jtrac\work\Jetty_0_0_0_0_8090_jtrac
.war__jtrac__-zbkvru\webapp
2009-05-02 11:04:28.316:/jtrac:INFO: Set web app root system property: 'jtrac.r
oot' = [F:\2001042501\UJtrac\ltrac\jtrac\work\Jetty_0_0_0_0_8090_jtrac.war__jtra
c__-zbkvru\webapp\]
2009-05-02 11:04:28.363:/jtrac:INFO: Initializing Log4J from [F:\2001042501\UJt
rac\ltrac\jtrac\work\Jetty_0_0_0_0_8090_jtrac.war__jtrac__-zbkvru\webapp\WEB-INF
\log4j.properties]
2009-05-02 11:04:28.691:/jtrac:INFO: Initializing Spring root WebApplicationCon
text
2009-05-02 11:04:29,270 [main] INFO [info.jtrac.config.JtracConfigurer] - found
'jtrac-init.properties' on classpath, processing...
2009-05-02 11:04:29,270 [main] INFO [info.jtrac.config.JtracConfigurer] - locale
s available configured are 'en,de,el,es,es_AR,es_MX,fr,it,ja,nl,pl,pt_BR,ru,zh_C
N,zh_TW'
2009-05-02 11:04:29,270 [main] INFO [info.jtrac.config.JtracConfigurer] - valid
'jtrac.home' property not available in 'jtrac-init.properties', trying system pr
operties.
2009-05-02 11:04:29,270 [main] INFO [info.jtrac.config.JtracConfigurer] - 'jtrac
.home' property initialized from system properties as 'data'
2009-05-02 11:04:29,285 [main] INFO [info.jtrac.config.JtracConfigurer] - direct
ory already exists: 'data'
2009-05-02 11:04:29,285 [main] INFO [info.jtrac.config.JtracConfigurer] - direct
ory already exists: 'data\attachments'
2009-05-02 11:04:29,285 [main] INFO [info.jtrac.config.JtracConfigurer] - direct
ory already exists: 'data\indexes'
2009-05-02 11:04:29,285 [main] INFO [info.jtrac.config.JtracConfigurer] - 'jtrac
.properties' file exists: 'data\jtrac.properties'
2009-05-02 11:04:29,285 [main] INFO [info.jtrac.config.JtracConfigurer] - found
'jtrac-version.properties' on classpath, processing...
2009-05-02 11:04:29,301 [main] INFO [info.jtrac.config.JtracConfigurer] - jtrac.
version = '2.1.0'
2009-05-02 11:04:29,301 [main] INFO [info.jtrac.config.JtracConfigurer] - jtrac.
timestamp = '200803022120'
2009-05-02 11:04:29,301 [main] INFO [info.jtrac.config.JtracConfigurer] - Loadin
g properties file from file [F:\2001042501\UJtrac\ltrac\jtrac\data\jtrac.propert
ies]
2009-05-02 11:04:29,488 [main] INFO [info.jtrac.config.DataSourceFactoryBean] -
Not using embedded HSQLDB or JNDI datasource, switching on Apache DBCP data sour
ce connection pooling
Hibernate: select item0_.id as id0_, item0_.version as version0_, item0_.type as
type0_, item0_.parent_id as parent4_0_, item0_.space_id as space5_0_, item0_.se
quence_num as sequence6_0_, item0_.time_stamp as time7_0_, item0_.planned_effort
as planned8_0_, item0_.logged_by as logged9_0_, item0_.assigned_to as assigned1
0_0_, item0_.summary as summary0_, item0_.detail as detail0_, item0_.status as s
tatus0_, item0_.severity as severity0_, item0_.priority as priority0_, item0_.cu
s_dbl_01 as cus16_0_, item0_.cus_dbl_02 as cus17_0_, item0_.cus_dbl_03 as cus18_
0_, item0_.cus_int_01 as cus19_0_, item0_.cus_int_02 as cus20_0_, item0_.cus_int
_03 as cus21_0_, item0_.cus_int_04 as cus22_0_, item0_.cus_int_05 as cus23_0_, i
tem0_.cus_int_06 as cus24_0_, item0_.cus_int_07 as cus25_0_, item0_.cus_int_08 a
s cus26_0_, item0_.cus_int_09 as cus27_0_, item0_.cus_int_10 as cus28_0_, item0_
.cus_str_01 as cus29_0_, item0_.cus_str_02 as cus30_0_, item0_.cus_str_03 as cus
31_0_, item0_.cus_str_04 as cus32_0_, item0_.cus_str_05 as cus33_0_, item0_.cus_
tim_01 as cus34_0_, item0_.cus_tim_02 as cus35_0_, item0_.cus_tim_03 as cus36_0_
from items item0_ where item0_.id=1
2009-05-02 11:04:32,301 [main] INFO [info.jtrac.hibernate.HibernateJtracDao] - d
atabase schema exists, normal startup
2009-05-02 11:04:32,363 [main] INFO [info.jtrac.JtracImpl] - available locales c
onfigured {en=en - English, de=de - German, el=el - Greek, es=es - Spanish, es_A
R=es_AR - Spanish (Argentina), es_MX=es_MX - Spanish (Mexico), fr=fr - French, i
t=it - Italian, ja=ja - Japanese, nl=nl - Dutch, pl=pl - Polish, pt_BR=pt_BR - P
ortuguese (Brazil), ru=ru - Russian, zh_CN=zh_CN - Chinese (China), zh_TW=zh_TW
- Chinese (Taiwan)}
Hibernate: select this_.param as param12_0_, this_.value as value12_0_ from conf
ig this_
2009-05-02 11:04:32,395 [main] INFO [info.jtrac.mail.MailSender] - initializing
email adapter: host = '69.93.185.18', port = '25', url = 'http://localhost:8090/
jtrac', from = 'JTrac@solverminds.com', prefix = 'TJM'
2009-05-02 11:04:32,426 [main] INFO [info.jtrac.mail.MailSender] - email sender
initialized from config: host = '69.93.185.18', port = '25'
2009-05-02 11:04:32,426 [main] INFO [info.jtrac.JtracImpl] - default locale set
to 'en'
2009-05-02 11:04:32,426 [main] INFO [info.jtrac.JtracImpl] - attachment max size
set to 10 MB
2009-05-02 11:04:32,426 [main] INFO [info.jtrac.JtracImpl] - session timeout set
to 40 minutes
2009-05-02 11:04:32,832 [main] INFO [info.jtrac.wicket.JtracApplication] - casPr
oxyTicketValidator not found in application context, CAS single-sign-on is not b
eing used
2009-05-02 11:04:33.160:/jtrac:INFO: Initializing Spring FrameworkServlet 'jtra
c-api'
2009-05-02 11:04:33.457::INFO: Started SelectChannelConnector @ 0.0.0.0:8090
Hibernate: select space0_.id as id8_0_, metadata1_.id as id10_1_, space0_.versio
n as version8_0_, space0_.type as type8_0_, space0_.prefix_code as prefix4_8_0_,
space0_.name as name8_0_, space0_.description as descript6_8_0_, space0_.guest_
allowed as guest7_8_0_, space0_.metadata_id as metadata8_8_0_, metadata1_.versio
n as version10_1_, metadata1_.type as type10_1_, metadata1_.name as name10_1_, m
etadata1_.description as descript5_10_1_, metadata1_.parent_id as parent6_10_1_,
metadata1_.xml_string as xml7_10_1_ from spaces space0_ inner join metadata met
adata1_ on space0_.metadata_id=metadata1_.id where space0_.guest_allowed=1
Hibernate: select spaceseque0_.id as id9_0_, spaceseque0_.next_seq_num as next2_
9_0_ from space_sequence spaceseque0_ where spaceseque0_.id=?
2009-05-02 11:04:54,442 [btpool0-7] ERROR [org.apache.wicket.RequestCycle] - Exc
eption occurred inside setter of info.jtrac.domain.Metadata.xmlString; nested ex
ception is org.hibernate.PropertyAccessException: Exception occurred inside sett
er of info.jtrac.domain.Metadata.xmlString
org.springframework.orm.hibernate3.HibernateSystemException: Exception occurred
inside setter of info.jtrac.domain.Metadata.xmlString; nested exception is org.h
ibernate.PropertyAccessException: Exception occurred inside setter of info.jtrac
.domain.Metadata.xmlString
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java:659)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:866)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:858)
at info.jtrac.hibernate.HibernateJtracDao.findSpacesWhereGuestAllowed(Hi
bernateJtracDao.java:168)
at info.jtrac.JtracImpl.findSpacesWhereGuestAllowed(JtracImpl.java:567)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:301)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy0.findSpacesWhereGuestAllowed(Unknown Source)
at info.jtrac.wicket.JtracApplication$2.isInstantiationAuthorized(JtracA
pplication.java:154)
at org.apache.wicket.Application$1.onInstantiation(Application.java:276)
at org.apache.wicket.Application.notifyComponentInstantiationListeners(A
pplication.java:973)
at org.apache.wicket.Component.<init>(Component.java:866)
at org.apache.wicket.MarkupContainer.<init>(MarkupContainer.java:104)
at org.apache.wicket.Page.<init>(Page.java:231)
at org.apache.wicket.markup.html.WebPage.<init>(WebPage.java:184)
at info.jtrac.wicket.BasePage.<init>(BasePage.java:78)
at info.jtrac.wicket.DashboardPage.<init>(DashboardPage.java:38)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFacto
ry.java:58)
at org.apache.wicket.request.target.component.BookmarkablePageRequestTar
get.newPage(BookmarkablePageRequestTarget.java:262)
at org.apache.wicket.request.target.component.BookmarkablePageRequestTar
get.getPage(BookmarkablePageRequestTarget.java:283)
at org.apache.wicket.request.target.component.BookmarkablePageRequestTar
get.processEvents(BookmarkablePageRequestTarget.java:210)
at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents
(AbstractRequestCycleProcessor.java:90)
at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j
ava:1166)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:
354)
at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.ja
va:194)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1065)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:75)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1065)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
65)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:185)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
81)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:6
89)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:146)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
39)
at org.mortbay.jetty.Server.handle(Server.java:285)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:45
7)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
nnection.java:751)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
va:329)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
.java:475)
Caused by: org.hibernate.PropertyAccessException: Exception occurred inside sett
er of info.jtrac.domain.Metadata.xmlString
at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPro
pertyAccessor.java:65)
at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(A
bstractEntityTuplizer.java:337)
at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoE
ntityTuplizer.java:200)
at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyVal
ues(AbstractEntityPersister.java:3566)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:
129)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.j
ava:854)
at org.hibernate.loader.Loader.doQuery(Loader.java:729)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate
(HibernateTemplate.java:875)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:373)
... 61 more
Caused by: java.lang.reflect.InvocationTargetException
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.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPro
pertyAccessor.java:42)
... 78 more
Caused by: java.lang.RuntimeException: org.dom4j.DocumentException: Error on lin
e 1 of document : Content is not allowed in prolog. Nested exception: Content i
s not allowed in prolog.
at info.jtrac.util.XmlUtils.parse(XmlUtils.java:75)
at info.jtrac.domain.Metadata.setXmlString(Metadata.java:112)
... 83 more
Caused by: org.dom4j.DocumentException: Error on line 1 of document : Content i
s not allowed in prolog. Nested exception: Content is not allowed in prolog.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.DocumentHelper.parseText(DocumentHelper.java:278)
at info.jtrac.util.XmlUtils.parse(XmlUtils.java:73)
... 84 more
This artifact has been marked as a duplicate of artifact 2785462 with reason:
system submitted twice