web stats
Download | Support | Contact
Mirth Corporation
  • Home
  • Products
    • Mirth Connect
    • Mirth Results
    • Mirth Match
    • Mirth Mail
    • Mirth Care
    • Mirth Appliances
    • Mirth Virtual Appliances
    • Mirth Hosted Appliances
  • Services
    • Support
    • Training
    • Consulting
  • Solutions
    • HIEs
    • Hospitals
    • Clinics
    • Laboratories
    • Radiology
    • Vendors
    • Government
  • Community
    • Forums
    • Wiki
    • Issues
    • Source Code
    • Mirth Exchange
    • IRC
    • FAQs
    • Contribute
    • Registration
    • Downloads
  • Company
    • About
    • Mission and Vision
    • Testimonials
    • News
    • Employment Opportunities
    • Contact

Mirth Project

  • Log In Access more options
    • Online Help
    • GreenHopper Help
    • Agile Answers
    • Use Agile By Default
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What’s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Agile
  • Mirth Connect
  • MIRTH-1120

Bug on upgrade on MS SQL 2005 DB in 1.8.1.4193

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.8.1
  • Fix Version/s: 1.8.1
  • Component/s: Installer
  • Labels:
    None
  • Environment:
    Windows 2008, MS SQL 2005 DB
  • Operating System:
    Windows Server 2003

Description

Misspelling on table in script.

[2009-06-12 10:29:26,613] ERROR (com.webreach.mirth.server.util.DatabaseUtil:135): Error was encountered and ignored while executing statement: ALTER TABLE PREFERNECES ALTER COLUMN VALUE TEXT
java.sql.SQLException: Cannot find the object "PREFERNECES" because it does not exist or you do not have permissions.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
at com.webreach.mirth.server.util.DatabaseUtil.executeScript(DatabaseUtil.java:129)
at com.webreach.mirth.server.controllers.DefaultMigrationController.migrate(DefaultMigrationController.java:323)
at com.webreach.mirth.server.controllers.DefaultMigrationController.migrate(DefaultMigrationController.java:150)
at com.webreach.mirth.server.Mirth.startup(Mirth.java:169)
at com.webreach.mirth.server.Mirth.run(Mirth.java:130)

Activity

  • All
  • Comments
  • Work Log
  • History
  • Activity
  • Source
Hide
Permalink
Jacob Brauer added a comment - 12/Jun/09 10:42 AM
Fixed typos in sql server upgrade scripts.
Show
Jacob Brauer added a comment - 12/Jun/09 10:42 AM Fixed typos in sql server upgrade scripts.

People

  • Assignee:
    Jacob Brauer
    Reporter:
    Wesley Combs
Vote (0)
Watch (0)

Dates

  • Created:
    12/Jun/09 7:39 AM
    Updated:
    10/Nov/10 11:08 AM
    Resolved:
    12/Jun/09 10:42 AM
  • Atlassian JIRA (v5.0.3#729-sha1:bf569e4)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Mirth Corporation. Try JIRA - bug tracking software for your team.