Issues on initial install of DCM4CHEE 2.17.1

[Gary Ciser]

Hi,

I'm having some trouble getting the initial build of DCM4CHEE setup. When running the initial test from the command line, I'm receiving the following error :

_____________________________________________________________________________________________

10:02:53,573 ERROR [MainDeployer] Could not create deployment: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/tmp/deploy/tmp8584440473069969182dcm4chee-web-ear-3.0.1-mssql.ear-contents/dcm4chee-web-sar-contentedit-3.0.1.sar
org.jboss.deployment.DeploymentException: - nested throwable: (java.lang.reflect.UndeclaredThrowableException)
at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:196)
at org.jboss.system.ServiceController.install(ServiceController.java:226)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.install(Unknown Source)
at org.jboss.deployment.SARDeployer.create(SARDeployer.java:251)
at org.jboss.deployment.MainDeployer.create(MainDeployer.java:969)
at org.jboss.deployment.MainDeployer.create(MainDeployer.java:959)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:818)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy9.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.UndeclaredThrowableException
at org.jboss.system.ServiceCreator.install(ServiceCreator.java:236)
at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:451)
at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:171)
... 80 more
Caused by: java.lang.NoClassDefFoundError: org/dcm4che2/data/DicomObject
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2357)
at java.lang.Class.getConstructor0(Class.java:2671)
at java.lang.Class.getConstructor(Class.java:1629)
at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:1232)
at org.jboss.mx.server.MBeanServerImpl.instantiate(MBeanServerImpl.java:286)
at org.jboss.system.ServiceCreator.install(ServiceCreator.java:193)
... 82 more
10:02:53,651 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e14e6d97 { url=file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/arr-mssql-ds.xml.origional }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/arr-mssql-ds.xml.origional
altDD: null
lastDeployed: 1355410973635
lastModified: 1355410973635
mbeans:

org.jboss.deployment.DeploymentInfo@2af95b99 { url=file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/pacs-mssql-ds.xml.origional }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/pacs-mssql-ds.xml.origional
altDD: null
lastDeployed: 1355410973635
lastModified: 1355410973635
mbeans:

--- Incompletely deployed packages ---
org.jboss.deployment.DeploymentInfo@5e022ff3 { url=file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/dcm4chee-web-ear-3.0.1-mssql.ear }
deployer: org.jboss.deployment.EARDeployer@18600d6
status: Deployment FAILED reason: - nested throwable: (java.lang.reflect.UndeclaredThrowableException)
state: FAILED
watch: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/dcm4chee-web-ear-3.0.1-mssql.ear
altDD: null
lastDeployed: 1355410973510
lastModified: 1355410971307
mbeans:

org.jboss.deployment.DeploymentInfo@e14e6d97 { url=file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/arr-mssql-ds.xml.origional }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/arr-mssql-ds.xml.origional
altDD: null
lastDeployed: 1355410973635
lastModified: 1355410973635
mbeans:

org.jboss.deployment.DeploymentInfo@2af95b99 { url=file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/pacs-mssql-ds.xml.origional }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/pacs-mssql-ds.xml.origional
altDD: null
lastDeployed: 1355410973635
lastModified: 1355410973635
mbeans:

_____________________________________________________________________________________________

I've verified access to the "C:/apps/dcm4chee-2.17.1-mssql/server/default/tmp/deploy/tmp8584440473069969182dcm4chee-web-ear-3.0.1-mssql.ear-contents/" directory and have confirmed that the "dcm4chee-web-sar-contentedit-3.0.1.sar" file is there. Permissions for the entire "apps" directory and all child directories have also be checked and appear not be the issue,

As I'm new to this application, any suggestions as to what is causing this error would be appreciated.

Thanks,

[rmarino14]

Is you machine name resolvable? Does it have underscores in the name. I remember having an issue like this and it had to do with how I named the machine or couldn't resolve the name.

[Damien Evans]

The location in the tmp directory is simply a temporary place where things get staged as the application starts up.  The actual deployment is within c:\apps\dcm4chee-2.17.1-mssql\server\default\deploy

However, I don't think that's really the problem....  The root of the error is that it couldn't find the DicomObject code/class.  What version of Java are you using to run this?  Also, can you verify that the file c:\apps\dcm4chee-2.17.1-mssql\server\default\lib\dcm4che-core-2.0.25.jar is present?

 -- Damien

[Gary Ciser]

Yes it is resolvable and there is no there are no underscores.in the name.

Thanks for the reply though...

[Alvaro G. [andor]]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Also... stupid question but:

Can you also resolve localhost?
Is the user running the pacs owner of all the files?

El 13/12/12 21:28, Gary Ciser escribi�:

> -- You received this message because you are subscribed to the
> Google Groups "dcm4che" group. To post to this group, send email to
> dcm...@googlegroups.com. To unsubscribe from this group, send
> email to dcm4che+u...@googlegroups.com. Visit this group at
> http://groups.google.com/group/dcm4che?hl=en.
>
>


- --
Alvaro "Andor" Gonzalez
an...@pierdelacabeza.com
GnuPG KeyID 0xa1e486f0
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (Darwin)

iQIcBAEBCAAGBQJQyjrPAAoJEM4lPGyh5IbwdwQQAI2QwB951YaKuUE+pSpmyqZY
K4/S8Mtkut4x6W1QzNzV3Ifq7RzeoxnEwQQbHcrOuh4d3xcWflQLgi47jz+RsY7/
PTj0wrKbGpuJiBN5n+LO+DwUbl13o12k+spvr6/WlqpFH8tXjq620jP2ZqBIXCM4
ynwdgRHn3IqjZzPQvXii02UvGAD65tBNK2Q03RSBqnOPcICQTjEaPd2o0mySuIYd
p3Ji5qoSgWkjSgaNL+gEKKi3EEt6+j1Gbje8l8ROVTbAIw+O7HgouldgHn4H3ooW
vSaMeeLwq1TuG2OSPVIjeS3Oj0BEiETxxGNAbK4xXbVxHwvxUfL2liXzlS//4IRo
DP5AFaQ9KzMdwwtoNWAevutyKUW+LnsCfGaqJVFo8fDANQ/E7VYj97WJKrgPMgQM
wddRnG3viY46X5cUt0fhYDuDQ0MflXwQ8ETTEsC1yK1p8kplj308u3MdUlk1rP1u
TbD0oLf4bq19nMSOqBvtyI/FQz58tBkTba0C9rimx8BUXx24UWJJySDz/1LtywuB
c/D5BvKPxuDpEmv0LKVcaXUF7ED0F9sAd0Ak3CoHObtfQSW1FKQTcZFtxexdG4C0
p3V4zpM6Ums9A87I9IO1Af310P1CO/Yj+54YoqcNqP0YOW2VXcZ1UJkoCo3AFAha
dv5HcEQAfmuF5H0/n5PW
=CMrb
-----END PGP SIGNATURE-----

[Gary Ciser]

Java Version 1.5.0 (build 1.5.0_22-b03)

dcm4che-core-2.0.25.jar is on the system and original file as far as I can see.

C:\apps\dcm4chee-2.17.1-mssql\server\default\conf>dir c:\apps\dcm4chee-2.17.1-mssql\server\default\lib\dcm4che-core-2.0.25.jar
 Volume in drive C has no label.
 Volume Serial Number is 98CA-8D66

 Directory of c:\apps\dcm4chee-2.17.1-mssql\server\default\lib

01/16/2011  10:08 AM           331,892 dcm4che-core-2.0.25.jar
               1 File(s)        331,892 bytes
               0 Dir(s)  24,410,157,056 bytes free

C:\apps\dcm4chee-2.17.1-mssql\server\default\conf>

[Gary Ciser]

Yes,

C:\apps\dcm4chee-2.17.1-mssql\server\default\conf>ping localhos

Pinging XXXXXXXX.XXXX.COM [::1] with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms

Ping statistics for ::1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\apps\dcm4chee-2.17.1-mssql\server\default\conf>

On Thursday, December 13, 2012 3:30:07 PM UTC-5, andor wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Also... stupid question but:

Can you also resolve localhost?
Is the user running the pacs owner of all the files?

El 13/12/12 21:28, Gary Ciser escribi�:

[Damien Evans]

Try it with Java 1.6.  I think that version of dcm4che-core-2.0.26.jar was compiled with Java 1.6.  It's likely failing because of the version mismatch.

 -- Damien

[Damien Evans]

....let me know if you can't use Java 1.6.  I have a Java 1.5 compiled version of the dcm4che libs that I can post for you if necessary.

[Gary Ciser]

On Thursday, December 13, 2012 2:20:22 PM UTC-5, Gary Ciser wrote:

[Gary Ciser]

Damien,

 

Thanks for the help.  I got tied up in other issues and w/ the holidays, & I havent gotten back to try the build w/ Java 1.6 till now.  I've re-installed after moving to 1.6 and have come up with a new issue,

 

Here is the warnings / error information from my most recent error.  Any assistance you (or anyone else following this post) could give would be appreiciated

 

Thanks,

 

11:16:42,900 WARN  [JDBCExceptionReporter] SQL Warning: 195, SQLState: 42000

11:16:42,900 WARN  [JDBCExceptionReporter] Preparing the statement failed: 'last_insert_id' is not a recognized built-in function name.

11:16:42,900 WARN  [JDBCExceptionReporter] SQL Error: 195, SQLState: 42000

11:16:42,900 ERROR [JDBCExceptionReporter] 'last_insert_id' is not a recognized built-in function name.

11:16:42,900 ERROR [ReceiverMDB] Failed processing - <AuditMessage><EventIdentification EventActionCode="E" EventDateTime="2012-12-28T11:15:16.323-05:00" EventOutcomeIndicator="0"><EventID code="110100" codeSystemName="DCM" displayName="Application Acti...

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [org.dcm4chee.arr.entities.AuditRecord]

        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)

        at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:218)

        at org.jboss.ejb3.entity.TransactionScopedEntityManager.persist(TransactionScopedEntityManager.java:182)

        at org.dcm4chee.arr.listeners.mdb.ReceiverMDB.process(ReceiverMDB.java:133)

        at org.dcm4chee.arr.listeners.mdb.ReceiverMDB.onMessage(ReceiverMDB.java:109)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

        at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

        at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)

        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

        at org.jboss.ejb3.mdb.MessagingContainer.localInvoke(MessagingContainer.java:249)

        at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.delivery(MessageInflowLocalProxy.java:268)

        at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.invoke(MessageInflowLocalProxy.java:138)

        at $Proxy337.onMessage(Unknown Source)

        at org.jboss.resource.adapter.jms.inflow.JmsServerSession.onMessage(JmsServerSession.java:178)

        at org.jboss.jms.client.container.ClientConsumer.callOnMessageStatic(ClientConsumer.java:160)

        at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:831)

        at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)

        at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)

        at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170)

        at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:105)

        at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)

        at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)

        at org.jboss.jms.client.JBossSession.run(JBossSession.java:199)

        at org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:237)

        at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)

        at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:275)

        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756)

        at java.lang.Thread.run(Thread.java:662)

Caused by: org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [org.dcm4chee.arr.entities.AuditRecord]

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:69)

        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)

        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)

        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)

        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)

        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)

        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)

        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)

        at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)

        at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)

        at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)

        at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)

        at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)

        at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)

        at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:212)

        ... 39 more

Caused by: java.sql.SQLException: 'last_insert_id' is not a recognized built-in function name.

        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)

        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)

        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:506)

        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:979)

        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)

        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:55)

        ... 53 more

 

[rmarino14]

Was the arrdb created? If so can you access it? Also, you might want to move the *.original files out of C:/apps/dcm4chee-2.17.1-mssql/server/default/deploy/. That would clean up your log files of errors.

On Thursday, December 13, 2012 2:20:22 PM UTC-5, Gary Ciser wrote:

[Damien Evans]

Nice catch on the *.original file failures.  I missed that in my first reading of the original post.  If you have files like that in your deploy directory it will indeed cause problems.  JBoss tries to deploy everything it finds in the deploy directory, and only certain types of files can actually be deployed.  These files/directories also need to conform to standard conventions.  The most common valid deployment file/directory names end in .xml, .ear, .war, .sar, .rar, and .deployer.  If there is a file or directory that does not conform to the relevant J2EE deployment standards or JBoss extensions of those standards, it causes errors.

So, remove the .original files as Bob stated, and try starting it up again.  Post back if you continue to see errors.  Also, as Bob stated, ensure that the arrdb database is created in SQL Server.  I created the following page a long time ago, but it should still be mostly accurate: http://www.dcm4che.org/confluence/display/ee2/Microsoft+SQL+Server  - note the last paragraph which reads:

Create the Audit Record Repository (ARR) artifacts:

You'll need to perform some of the above steps to create the ARR database.

Basically, you need to Create a Login, Create the Database, and Create the User. You do not need to create the schema because the application does that automatically. The relevant information is Login/User: arr, Password: arr, Database: arrdb.

--