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.
