Question

BIX 7.1.9 - can it drop onto a SQL 2016 database?

We are running Pega BIX version 7.1.9. The source database is the Pega database on SQL Server 2014. The target database is currently SQL Server 2008. This works fine.

The target server is migrating to SQL Server 2016. Can BIX version 7.1.9 drop data onto a SQL Server 2016 database? The Pega Platform Support Guide states that Pega itself must be at least version 7.3 to run on SQL Server 2016. But what about the drop spot for BIX?

We are testing, and getting a generic error that the table doesn't exist on target (it does), and cannot find a way to get any lower-level logging information.

Any help would be greatly appreciated.

Correct Answer
October 21, 2019 - 8:51am

This has been resolved.  We were able to connect and successfully extract by upgrading our JDBC drivers.  However, SQL 2016 is not supported by Pega unless we upgrade to 7.3, which is not possible for us at this time.

Comments

Keep up to date on this post and subscribe to comments

Pega
October 14, 2019 - 1:38am

Hi Patrices,

First try connectivity of the DB ,if the connectivity for the external DB is successful and facing table doesn’t exists error ,then converting name of table, columns with lower case ,as for SQL server this observed.

October 21, 2019 - 8:51am

This has been resolved.  We were able to connect and successfully extract by upgrading our JDBC drivers.  However, SQL 2016 is not supported by Pega unless we upgrade to 7.3, which is not possible for us at this time.