Posted: 10 Oct 2019 14:55 EDT Last activity: 21 Oct 2019 8:53 EDT
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.
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.
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.