Hello all Has anyone seen the following error related SQL Re...

[Naeem Sufi 3]

Hello all

Has anyone seen the following error related SQL Repository

[2022-03-02 15:28:35,941] INFO [main:IBFSService] - DB Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

[2022-03-02 15:28:36,238] ERROR [main:ibfssystem] -

[2022-03-02 15:28:36,238] ERROR [main:ibfssystem] - *********************************************

[2022-03-02 15:28:36,238] ERROR [main:ibfssystem] -

[2022-03-02 15:28:36,238] ERROR [main:ibfssystem] - *** Failed to loadCachedInfo Failed to process the database schema changes in the repository DB. ***

java.lang.IllegalStateException: Failed to process the database schema changes in the repository DB.

if you can share what you did to resolve this issue

Thanks

[Ron Moore]

Naeem. A couple of things here. If this is a new install with a new webfocus repository, check that you have entered the jdbc driver for SQL Server in the install script, down to the .jar file. If this is a new install, using an existing webfocus repository from an older version, the install may not be able to make needed changes to the old version repository

[Naeem Sufi 3]

Ron This is a new install New Repository on SQL Server 2019 . SQL driver we have in the folder is mssql-jdbc-8.4.1.jre8 suggested by support team so the issue with the driver was resolved but now we are getting the above mentioned error , have not heard back from support , so just reaching out here if anyone had this issue

Thanks

[Jean-Claude Carriere 3]

naeem.sufi:

 

Failed to loadCachedInfo

 

 

Naaem, Did you check the installation requirements regarding the repository options (page 32 in my manualTIBCO WebFOCUS Installation and Configuration for Windows). Specifically for Microsoft SQLServer the database collation must be set to case sensitive. I have seen that failing to do so causes this this type of error.

[Naeem Sufi 3]

Jean-Claude Yes I had checked that but I ended up reinstalling, it cleared the issue , Thanks