Identity Reporting Fail To Generate Out-Of-The-Box Report
I have my Identity Reporting to run on Microsoft SQL Server. When I wanted to run the out-of-the-box report, the error "INSTR is not a recognized built-in function name" appear.
After checking, it is due to the INSTR is only supported in Oracle database and it is not for Microsoft SQL Server.
Then, I check my data sources and ensure that the data source I used to generate report is having "MSSQL" as database type. However, I'm still facing the same error. I have checked the report template, it should execute SQL query according to my database type. But it seems like it is not in my case and it keep on executing the Oracle type SQL query.
Anyone encountered the same issue before?