We recently upgraded several servers running Oracle Analytics Server from version 5.5 to version 7.6 and applied the latest patch. However, after the upgrade, we began experiencing some unusual issues.
Prior to the upgrade, certain reports—even those that took up to 3 hours to complete—were executing successfully. After the upgrade, those same long-running reports are now failing after approximately 1 hour, returning the following error:
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLRecoverableException: IO Error: Socket read timed out
In addition, we observed inconsistent behavior with some reports triggered during off-peak hours. For example, a report scheduled at 2:30 AM fails, but if run again at 2:31 AM, it completes successfully.
Is there any official documentation or best practices that outline necessary changes or tuning steps after upgrading to version 7.6? Should we consider modifying queries or adjusting configuration parameters to resolve these issues?
I had attached the report data model validate log with null value also with value to test. Also attached the diagnostic log that report keep failed after upgrade but in Production success.
Production (Version 5.5) - Success
UAT (Version 7.6) - Failed
Thanks.
