Trouble migrating from H2 to Microsoft SQL

Question

I've loaded the libs as directed in other documentation and FAQs. However when attempting to start the service, it eventually errors out. The qie.log indicates a problem readying the SYS schema.

Caused by: org.h2.jdbc.JdbcSQLException: Schema "SYS" not found; SQL statement:
/* dynamic native SQL query */  SELECT CAST(name AS varchar(512))  FROM sys.indexes  WHERE name = 'idx_message_filter_result_is_match_message_filter_result_id' [90079-174]

Answer 1

It appears you are on the QIE Standard addition. QIE Standard only supports the H2 database.

There is a 90 Enterprise Trial Available on our website that will allow you to use a Microsoft SQL Database as well.

If you are on the Enterprise Addition already email or call us and we will be happy to assist.

Qvera Support
801-335-5101 Option 2 for support
support@qvera.com