1797111 - Unable to refresh Crystal Reports based on BEX query after upgrading from BI 4.0 SP02 to SP04 Patch 3

Only existing reports were affected however we could create new reports or if we update the existing reports with the data source and save them we were able to refresh the reports

Refreshing the report from Crystal Reports for Enterprise getting following error message.

Objects unavailable

"The original query could not be mapped exactly to the new data source, because some objects or metadata are missing in the new data source. Verify your new report's query and query filter, as well as any subreport links in your report."

A problem was encountered.

Redesign your query or contact the data source maintainer to solve the problem.

SAP BusinessObjects BI 4.0 SP04 Patch 3

cr fail bw bex query bi40 bi 40 after upgrade , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed