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
That looks like a SQL Server error. Have you tried running the SQL generated by OBIEE directly on the SQL Server database?
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
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
