Trouble migrating from H2 to Microsoft SQL

0 votes
asked Apr 20, 2020 by marcus-b-6447 (120 points)
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]

1 Answer

0 votes
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
answered Apr 20, 2020 by brandon-w-8204 (31,870 points)