You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ctakes.apache.org by Galen Wray <Ga...@manulife.com> on 2018/06/28 13:51:54 UTC
YTex Installation Error for setupAuiFirstWord
Hello,
When running the setup for YTex, I was originally having issues with the GramMatrixExporterImpl, and I have commented out this section in beans-kernel.xml, as I have seen in other posts that this solves this problem. Unfortunately, I now receive the error "com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.umls_aui_fword'". However, the table exists in my database.
There appears to be a solution in https://issues.apache.org/jira/browse/CTAKES-334?attachmentOrder=desc, but I wasn't sure what was fixed and how to implement this as a user. I would be very grateful for any help!
Error Log:
[java] 28 Jun 2018 09:10:25 WARN SqlExceptionHelper - SQL Error: 208, SQLState: S0002
[java] 28 Jun 2018 09:10:25 ERROR SqlExceptionHelper - Invalid object name 'dbo.umls_aui_fword'.
[java] Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not extract ResultSet
[java] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
[java] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
[java] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[java] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[java] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
[java] at org.hibernate.loader.Loader.getResultSet(Loader.java:2040)
[java] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1837)
[java] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816)
[java] at org.hibernate.loader.Loader.doQuery(Loader.java:900)
[java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
[java] at org.hibernate.loader.Loader.doList(Loader.java:2526)
[java] at org.hibernate.loader.Loader.doList(Loader.java:2512)
[java] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2342)
[java] at org.hibernate.loader.Loader.list(Loader.java:2337)
[java] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
[java] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
[java] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
[java] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
[java] at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
[java] at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)
[java] at org.apache.ctakes.ytex.umls.dao.UMLSDaoImpl.getLastAui(UMLSDaoImpl.java:144)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[java] at java.lang.reflect.Method.invoke(Unknown Source)
[java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[java] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
[java] at com.sun.proxy.$Proxy9.getLastAui(Unknown Source)
[java] at org.apache.ctakes.ytex.tools.SetupAuiFirstWord.setupAuiFirstWord(SetupAuiFirstWord.java:202)
[java] at org.apache.ctakes.ytex.tools.SetupAuiFirstWord.main(SetupAuiFirstWord.java:186)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.umls_aui_fword'.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
[java] ... 31 more
Thank you,
Galen Wray
STATEMENT OF CONFIDENTIALITY The information contained in this email message and any attachments may be confidential and legally privileged and is intended for the use of the addressee(s) only. If you are not an intended recipient, please: (1) notify me immediately by replying to this message; (2) do not use, disseminate, distribute or reproduce any part of the message or any attachment; and (3) destroy all copies of this message and any attachments.