cancel
Showing results for 
Search instead for 
Did you mean: 

Crystall Reports 2011 Crashing HELP PLEASE

Former Member
0 Kudos

HI

Just recently, when ever i create a NEW report, and go to add more then 1 table to my report.

CR Crashes with the "windows message"

“Crystal reports has stopped working.  A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.”

how can i work out what is causing this ? 

its getting very frustrating as i have already lost A LOT work when it crashes.

i am running Windows 7

and the data is on our IBM server and connecting via ODBC connection to a Progress Data base.

any help would be much appreciated

Thanks

Mark


Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Mark,

This is known issue. You may refer to this SAP Note for the resolution:  1621593 - Crystal Reports 2011 crashes when trying to link tables in DB2 iSeries

If you're not able to access the SAP Note; here's what it says:

Cause

ODBC Driver Access permission issue

 

Resolution

The following registry key resolves the problem:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC\
"AccessMode" as a Reg_DWORD 0x00000000 (0)

Here are the steps:

1. Go to Registry Editor (Click Start > Run > type “regedit” > OK)
2. Navigate to :

for Crystal Reports 2011 on 64 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database

for Crystal Reports 2011 on 32 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database

for Crystal Reports 2008 on 64 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite 12.0\Crystal Reports\Database

for Crystal Reports 2008 on 32 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite 12.0\Crystal Reports\Database


3. Right click the “Database” registry key > select New > Key > name the key “ODBC”

4. Right click the “ODBC” key > select New > DWord value > name it “AccessMode

5. Make sure the value is default: 0x00000000 (0)

6. Restart the Crystal Reports and try again

Let me know if this helped!

-Abhilash

Former Member
0 Kudos

HI Abhilash

I have made these changes, but I still have the exact same problem

Can you please advise what else I need to do / try ?

Thanks

Mark

abhilash_kumar
Active Contributor
0 Kudos

Hi Mark,

Most of the CR crashing issues (with IBM Server) reported earlier have been resolved by the above SAP Note.

If this doesn't help, I guess the next best thing would be to create a ticket with SAP Support to further analyze the ODBC log files etc.

-Abhilash

former_member183750
Active Contributor
0 Kudos

Couple of other things to try / look for:

1) Make sure you do not have C:\temp directory - if you do, rename it

2) See if doing a repair will help

3) Final solution would be to uninstall and reinstall

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

Former Member
0 Kudos

HI Abhilash and Ludek

Thanks for your replies


Abhilash,

first off i should mention , that i CANNOT view the SAP note above,  it says the address is not valid or similar , so unfortunatley am unable to read the note in full.

also how can i create a ticket with SAP ? 

i rang the SAP office, and was told to use this forum to fix the problem.

they wanted to charge me to create a ticket,  but i dont feel i should have to pay anything, as we have already paid in full for the software so i am looking for support ?????

Ludek,

i did have a TEMP directory, under C:  , so i renamed it ,  still same issue,

how do i do a repair ?

thanks for your help and assistance

Regards

Mark

abhilash_kumar
Active Contributor
0 Kudos

Hi Mark,

Product License and Maintenance agreements are two different things!

Having a CR License does not make you eligible for Maintenance (support) unfortunately. You need to purchase the Maintenance License separately.

You can still get in touch with SAP Support by creating a "Single Case" here.

Hope this helps!

-Abhilash

former_member183750
Active Contributor
0 Kudos

Below is a copy of the KB:

Symptom

Crystal Reports 2011 crashes when trying to link tables in DB2 iSeries

 

Environment

Crystal Reports 2008

or

Crystal Reports 2011

IBM DB2 AS400 iSeries

 

Reproducing the Issue

  1. Open Crystal Reports Designer 
  2. Establish ODBC database connection 
  3. Add more than one table to the report

 

Cause

ODBC Driver Access permission issue

 

Resolution

The following registry key resolves the problem:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\ODBC\
"AccessMode" as a Reg_DWORD 0x00000000 (0)

Here are the steps:

1. Go to Registry Editor (Click Start > Run > type “regedit” > OK)
2. Navigate to :

for Crystal Reports 2011 on 64 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database

for Crystal Reports 2011 on 32 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database

for Crystal Reports 2008 on 64 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite 12.0\Crystal Reports\Database

for Crystal Reports 2008 on 32 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite 12.0\Crystal Reports\Database


3. Right click the “Database” registry key > select New > Key > name the key “ODBC”
4. Right click the “ODBC” key > select New > DWord value > name it “AccessMode
5. Make sure the value is default: 0x00000000 (0)
6. Restart the Crystal Reports and try again.

Additionally make sure the access granted on all layers including DSN configuration. See the screenshot below:

Re. repair; Control Panel -> Programs and Features (or some such off of the Control Panel - depends on OS).

- Ludek

Former Member
0 Kudos

Hi Ludek

thanks for your help with this,

BUT i am still not working ,

i am not sure where to check the DSN config that you suggested i check , can you please advise where i check this ?

thanks

Mark

Former Member
0 Kudos

Hi,

we had the same issue with Crystal Reports 2008.and it was not related to a DB2 connection for us

We had the issue with a direct oracle and an ODBC connection too.

We tried the c:\temp deletion/renaming too - did not help us.

The only thing that helped was deinstalling the Report designer and then reinstall.

It was on my bosses Laptop, so we did not have that much time to trouble shoot, but what i saw he got a couple of updates in the last week.

After a deinstallation and re-installation everything worked as expected.

regards alex

former_member183750
Active Contributor
0 Kudos

Hello Alexander

Not sure if you're referring to the KBase(?). If you are not sure about how to do this, it will really be best if you find someone who is comfortable working with the registry. Working with registry is tricky and can result in the computer not working at all...

Or, you can obtain phone support at the below link and a support tech will help you out. The link:

http://store.businessobjects.com/store/bobjamer/en_US/pd/productID.98078100?resid=S6I@hgoHAkEAAGsiyV...

One more thing to check; in Windows Explorer, look for C:\windows\temp diretory. If you find it, rename it so c:\Windows\tempX

- Ludek

Former Member
0 Kudos

Hi Ludek,

no i was not referring to the KBase, We just had the same issue this week.

What i wanted to say in my post , i think it is not related to any specific DB connection, because we ran into that issue while we were connecting to a) Oracle and b) to an ODBC connection.

I wanted to point out that we fixed it with a reinstallation.

and i guess it had something to do with the updates that were rolled out to that specific Laptop.

Maybe that led to confusion here.If that is the case i want to apologize for that.

regards alex

former_member183750
Active Contributor
0 Kudos

Hello Alexander

Apologies for confusing the issue and many thanks for your input.

Have a great day,

- Ludek

Answers (0)