web stats
Invalid object name 'PREFERENCES' - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2011, 02:17 PM
TSmithTRA TSmithTRA is offline
OBX.2 Kenobi
 
Join Date: Nov 2009
Location: Winston-Salem, NC
Posts: 79
TSmithTRA is on a distinguished road
Default Invalid object name 'PREFERENCES'

Has anyone seen this error before or know how to correct it?

[2011-04-04 17:10:21,806] WARN (org.mortbay.jetty.context./:589): /users:
com.webreach.mirth.server.controllers.ControllerEx ception: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in sqlserver2005/sqlserver2005-user.xml.
--- The error occurred while applying a parameter map.
--- Check the User.getUserPreferences-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Invalid object name 'PREFERENCES'.
Caused by: java.sql.SQLException: Invalid object name 'PREFERENCES'.
at com.webreach.mirth.server.controllers.DefaultUserC ontroller.getUserPreferences(DefaultUserController .java:201)
at com.webreach.mirth.server.servlets.UserServlet.doP ost(UserServlet.java:95)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)Caused by: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in sqlserver2005/sqlserver2005-user.xml.
--- The error occurred while applying a parameter map.
--- Check the User.getUserPreferences-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Invalid object name 'PREFERENCES'.
Caused by: java.sql.SQLException: Invalid object name 'PREFERENCES'.
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForList(SqlMapClientImpl.java:95)
at com.webreach.mirth.server.controllers.DefaultUserC ontroller.getUserPreferences(DefaultUserController .java:192)
... 15 moreCaused by: java.sql.SQLException: Invalid object name 'PREFERENCES'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.ex ecute(JtdsPreparedStatement.java:475)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteQuery(GeneralStatement.java:20 5)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:173)
... 21 more
__________________
Tom Smith
IT Director
Triad Radiology Associates
Reply With Quote
Reply

Tags
preferences

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 12:36 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation