"The instruction at "......" referenced memory at "......". The memory could not be "read" when trying to open an .rpt file on Production server that was created on development server.

[Former Member]

I've seen similar posts, but the answers don't seem to solve my issue.

I am running Crystal Reports 2008 SP3 on a Windows 2003 server that is also running Bus Objects Enterprise Edge XI 3.1 SP5.  I've had no issue until just recently in which I get an error "The instruction at "......" referenced memory at "......". The memory could not be "read" when I try to open an .rpt file on our Production server that was created in our development environment (separate server - not connected to Production).

When I launch Crystal Reports, I try to open the file.  I get prompted for my Enterprise credentials (we use Business Views to source our reports and us an OLE DB Oracle connection through Business View Manager).  After I provide the credentials, I get the above error and cannot open the new updated report file.  However, if I open the current report file from Enterprise location, I do not get the error. The issue is obviously with the new file, but I do not know what to do to get this to work. 

URGENT help is needed!

Thank you,

Amber

[former_member11696 · Accepted solution]

Hi Amber,

It sounds like you have permission issues connecting to the BOE Server for the BV when opening the report locally. You need to Oracle Client installed so CR can connect to the DB Server. Because the DB connection is now going from your local PC and not the BOE Server.

Also highly recommended that you update CR 2008 Designer to Service Pack 5 so it matches the BOE Version.

Don

[Former Member · Accepted solution]

Thanks, Don.  I've forwarded your response to my SysOps team to see that we have all these apps in place like you've stated.  I'll let you know what they say.

However - just wanted to mention that I am trying to open the report from the actual BOE Server and not my local machine (I am using Remote Desktop to log into the server).  Oracle Client IS installed on there.

The thing that really confuses me is that we upgraded from Crystal Enterprise (and Crystal Reports) v10 back in Dec 2011 to the newer CR 2008 and BOE XI 3.1 ... and we have had no issues.  Recently, we had users that were unable to access the online system when using IE8 and IE9, and we installed the newest SP 5 to resolve the issue.  It seems the issue we are experiencing now has just recently started... could it perhaps be due to the SP install?

Amber

[nikhil_sabnis2 · Accepted solution]

Hi Amber

Can you check for any error shown in the event viewer. Your sys admin should be able to acces it?

Regards

Nikhil Sabnis

[Former Member · Accepted solution]

Hi Don (and everyone else - THANK YOU for the assistance!),

We upgraded the Crystal Reports to SP5 (we thought we had done this, actually) and now everything is working!  Our development server apparently had the SP5 upgrade on it, which is why there were no errors there.  This was a lot of confusion and the fix was quite simple.  Thank you very much for all your assistance!

[vitaly_izmaylov]

There are best practices to move Business View based reports from one environment to another and particularly:

When promoting CR reports from one server to another, always use Import Wizard, Update option, and always select repository objects as well as reports. This way CUID persistance will be maintained and all BV components used by the reports will be migrated correctly.

[nikhil_sabnis2]

Hi Amber

Please check the below points:

- Do you have read/write access to the temp folder in your system?

- Is it happening with this report only? Are you able to open a any other report (not referring to the Business View) saved on your local system?

- Are you able to open any other report from enterprise pointing to some other business view manager?

- If you create a new report referring to the same business view, referred by the report in the problem statement; do you get any error?

- If you create a new business view and then use it in a new report; do u get the same error?

- Are you using an LOV in the report in the problem statement and/or are you using the business view as a data source in the report?

- What happens if you download the report from enterprise server to your local system (not through Crystal Reports) and then try to open the reportin Crystal?

- Additionally, please check for any error logged in the Event view of your system and post here if you can.

- You can also use the CRLogger utility to check for errors. Refer to "SAP Note 1603398 - How To trace Crystal reports 2008 and 2011 using crlogger logs" for more info.

Please let me know.

Regards

Nikhil Sabnis

[Former Member]

Hi Nikhil,

Thanks so much for the assistance.  Here are the answers I have (not all, sorry):

- Do you have read/write access to the temp folder in your system?

I am told my login has admin privileges, but I am not logging in as "admin"

- Is it happening with this report only? Are you able to open a any other report (not referring to the Business View) saved on your local system?

I didn't try this until you mentioned it, and amazingly... NO!  I cannot open (not even run - I can't even open a report) anything local.  So it's not just the updated ones from development.

- Are you able to open any other report from enterprise pointing to some other business view manager?

Yes

- If you create a new report referring to the same business view, referred by the report in the problem statement; do you get any error?

No.  Everything worked fine.

- If you create a new business view and then use it in a new report; do u get the same error?

No.

- Are you using an LOV in the report in the problem statement and/or are you using the business view as a data source in the report?

I'm not using a LOV, but yes - all my reports are sourced from a business view.

- What happens if you download the report from enterprise server to your local system (not through Crystal Reports) and then try to open the reportin Crystal?

When I copied the file from the filestore to a local directory and tried to open it - I got the error.  If I open the report through Crystal Reports after logging in to Enterprise, I CAN open the report.

- Additionally, please check for any error logged in the Event view of your system and post here if you can.

I'm sorry but I do not know what that is. 

I talked with my SysOps guy who sets up access to this server, and he said he is getting the same error on all environments (we have three).  This appears to be a sudden occurrence.  A few months ago we finally upgraded our BOE XI to SP5 - could this be the culprit?

[former_member11696]

Hi Amber,

This is the important part:

"

- What happens if you download the report from enterprise server to your local system (not through Crystal Reports) and then try to open the reportin Crystal?

When I copied the file from the filestore to a local directory and tried to open it - I got the error.  If I open the report through Crystal Reports after logging in to Enterprise, I CAN open the report.

"

This suggests a couple of issues, it could be a firewall issue, some port is not open any more that was.

Or it could be the Oracle Client is now having problems.

Which Oracle Server/Client are you using?

Try a report using ODBC, use oracle ODBC driver or if you ahve downloaded the CR DataDirects Drivers try them. Lets see if it's OLE DB driver issue now or possible the client config or permissions.

Go through the AV and Firewall logs to see if anything is captured when trying to connect.

Don