Report issue afer Upgrade

User_MSQS7

Experts,

I am getting below issue after upgrade from obiee 11g to OBIEE 12.2.1.4.0

and we are using windows serer 2016, sql serer 2016

Joel Acha

That looks like a SQL Server error. Have you tried running the SQL generated by OBIEE directly on the SQL Server database?

User_MSQS7

I can see all reports are working fine. Only 2 reports having the same issue. As you requested I placed query in DB please find the below screenshot from sql server

Joel Acha

This is a Database issue it would appear and something that you’d need your DBAs to look at. This looks like a SQL Server DB configuration setting - https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15