cancel
Showing results for 
Search instead for 
Did you mean: 

CR2011 Crashes when trying to link tables

Former Member
0 Kudos

Every time I create a new report in CR2011 and try to link tables from my iSeries Access ODBC, CR2011 freezes for about 5 seconds and shuts down. I can create new reports using different databases like csv, xlsx, dbf, and mdb and it wont crash. If I use the iSeries ODBC with just 1 table and no linking, it wont crash.

The same ODBC works just fine with CRXI.

I can create a report with CRXI that has linked tables using the iSeries Access ODBC and save it. When I try to open it with CR2011, it works just fine. You can navaigate thru the different tables and modify the report without CR2011 crashing.

Event log:

Faulting application name: crw32.exe, version: 14.0.0.760, time stamp: 0x4d688f61

Faulting module name: ntdll.dll, version: 6.1.7600.16695, time stamp: 0x4cc7ab86

Exception code: 0xc0150014

Fault offset: 0x000845df

Faulting process id: 0x2d0

Faulting application start time: 0x01cc54600afd9a32

Faulting application path: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32.exe

Faulting module path: C:\Windows\SysWOW64\ntdll.dll

Report Id: 81d30c82-c053-11e0-9e8e-70f39514a63b

I am running Windows 7 Professional

Core i5 650 @ 3.20 GHz

8.00 GB RAM

64-bit

I've done a sfc /scannow and no errors are reported.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I have verified that once the template is created in CRXI, I can open it with CR2011 and add or delete tables.

0 Kudos

Hi Reilly,

I had a quick search in Adapt which is our bug tracking program and I did not find one.

Can I ask you to [purchase a support|http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryID=54722300] case and work with a rep to get this issue fixed?

Because it appears to be a bug you will get a refund. By purchasing a case it builds a Business Case to get the issue fixed.

Thank you

Don

vitaly_izmaylov
Employee
Employee
0 Kudos

Jason, I will post the Resolution here (correct me if any steps are no clear):

CRLogger Log files shows:

2011-8-15-12-26-53        4084      .\connect.cpp    2027      SQLDriverConnect succeeded: DSN = ********, User ID = ********, Password = ********  10

2011-8-15-12-27-17        4084      .\odbcerror.cpp                63          Error: message = [IBM][System i Access ODBC Driver]Statement violates access rule: Connection is set to read only., sqlstate = 42000, native code = 30186        1

2011-8-15-12-27-17        4084      .\odbcerror.cpp                63          Error: message = [IBM][System i Access ODBC Driver]Statement violates access rule: Connection is set to read only., sqlstate = 42000, native code = 30186        1

It means  permission issue.

The following registry key resolved 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 64 bit machine

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database

For 32 bit machine

HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.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.

Thanks to Product developers,

Vitaly

Answers (5)

Answers (5)

Former Member
0 Kudos

Turn off Automatic Smart Linking.  Open CR2011, choose File, Options and the Database tab. Then remove the check mark from Automatic Smart Linking.

Former Member
0 Kudos

Same issue here. I have crystal reports XI release 2 version 11.5.12.1838 with latest SP6 installed on my PC. I am facing a very critical issue when creating a new report. The application crashes and closes immediately when going to link tab after adding tables from my ODBC. I uninstalled the program so many times and tried to reinstall it again but with no luck. I googled the issue and tried to apply all found solution but unfortunately unsuccessfully. Please help

Here is the error log:

Problem Event Name: APPCRASH

  Application Name: crw32.exe

  Application Version:  11.5.11.1470

  Application Timestamp:    492e9155

  Fault Module Name:    MFC71U.DLL

  Fault Module Version: 7.10.3077.0

  Fault Module Timestamp:   3e77fc29

  Exception Code:   c0000005

  Exception Offset: 00032e72

  OS Version:   6.1.7601.2.1.0.256.4

  Locale ID:    1033

  Additional Information 1: 1fc1

  Additional Information 2: 1fc163a1c57ae45571bce37d539b233f

  Additional Information 3: 12a3

  Additional Information 4: 12a3f41f6385dcf1330ec81c9df2618c

Former Member
0 Kudos

I found this (I hope it displays correctly!):

http://search.sap.com/notes?id=0001621593&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

worked for 2011 trial, but not my 2008.  I'm missing Suite 12.0 in my regedit.

HTH

vitaly_izmaylov
Employee
Employee
0 Kudos

Thank you, good catch, there is a typo in the registry key name:

currently:

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

 

but should be:

for Crystal Reports 2008 on 64 bit machine

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\Database

for Crystal Reports 2008 on 32 bit machine
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\Database

I will correct the SAP Note

Additionally, recently found the fix is applicable for CR XIR2 as well.

Thanks again for your feedback.

Vitaly

and

Former Member
0 Kudos

I have created this key "HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC\AccessMode" with value of "0x00000000 (0)" as advised but with no success since it still crashes when linking any tables to each other. I have crystal reports XI release 2 version 11.5.12.1838 with latest SP6 installed on my PC running windows 7 - 32 bit.

Former Member
0 Kudos

I have created this key "HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC\AccessMode" with value of "0x00000000 (0)" as advised but with no success since it still crashes when linking any tables to each other. I have crystal reports XI release 2 version 11.5.12.1838 with latest SP6 installed on my PC running windows 7 - 32 bit.

vitaly_izmaylov
Employee
Employee
0 Kudos

Unfortunately we do not support Crystal Reports XI R2 and do not have test system for investigation,

just please make sure:

the registry key path is

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC\

"AccessMode" is a DWORD key

"0x00000000 (0)" is a value of the key

To validate, right click on

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC\

Select Export

Export the key to your desktop

rename the .reg file to .txt

Copy the content of the file here.

Former Member
0 Kudos

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC]
"AccessMode"=dword:00000000

Noting that i am getting this error:

Problem Event Name: APPCRASH

  Application Name: crw32.exe

  Application Version:  11.5.11.1470

  Application Timestamp:    492e9155

  Fault Module Name:    MFC71U.DLL

  Fault Module Version: 7.10.3077.0

  Fault Module Timestamp:   3e77fc29

  Exception Code:   c0000005

  Exception Offset: 00032e72

  OS Version:   6.1.7601.2.1.0.256.4

  Locale ID:    1033

  Additional Information 1: 1fc1

  Additional Information 2: 1fc163a1c57ae45571bce37d539b233f

  Additional Information 3: 12a3

  Additional Information 4: 12a3f41f6385dcf1330ec81c9df2618c

vitaly_izmaylov
Employee
Employee
0 Kudos

Are you sure your DSN configuration on the machine does not have Read-Only settings activated? See the SAP Note.

Former Member
0 Kudos

Below is a screen shot from my ODBC configration page where you can find that i have read/write permissions.

What does the below error refer to ?

Problem Event Name:     APPCRASH

  Application Name:     crw32.exe

  Application Version:     11.5.12.1838

  Application Timestamp:     4b16581e

  Fault Module Name:     MFC71U.DLL

  Fault Module Version:     7.10.3077.0

  Fault Module Timestamp:     3e77fc29

  Exception Code:     c0000005

  Exception Offset:     00032e72

  OS Version:     6.1.7601.2.1.0.256.4

  Locale ID:     1033

  Additional Information 1:     1fc1

  Additional Information 2:     1fc163a1c57ae45571bce37d539b233f

  Additional Information 3:     7ea3

  Additional Information 4:     7ea35a7a822355a5c4419e52bb92f90e

vitaly_izmaylov
Employee
Employee
0 Kudos

I would suggest to do ODBC trace and see if you find an error like:

"Statement violates access rule: Connection is set to read only"

If not, then this is different issue.

Former Member
0 Kudos

I did the ODBC trace as you suggested and below is the log.

Sorry i couldn't go through it since i am not expert in this to find out what is going wrong.

Former Member
0 Kudos

I'm having this same issue with CR 2013. I've added the registry key but it does not seem to help. I've tried everything I can think of but to no avail. Any suggestions?

Former Member
0 Kudos

I am having the same problem, tried the registry entry fix and made no difference.  Apart from the workaround are there any other fixes for this problem>

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

I'd recommend starting by upgrading to the latest SP and Patch and retesting.

this thread is a year old - normally defects like this would be submitted and corrected by primary support.

Regards,

H

Former Member
0 Kudos

Help !!

I am having identical problem with tables linking crashing CR2011. Attempting the "template setup" below does not work. This is the event log data:

Faulting application name: crw32.exe, version: 14.0.2.364, time stamp: 0x4de99eaa

Faulting module name: MFC80U.DLL, version: 8.0.50727.6195, time stamp: 0x4dcdece0

Exception code: 0xc0000005

Fault offset: 0x0005ac0d

Faulting process id: 0x1264

Faulting application start time: 0x01cceb2d466cb7ce

Faulting application path: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32.exe

Faulting module path: C:\windows\WinSxS\x86_microsoft.vc80.mfc_1fc8b3b9a1e18e3b_8.0.50727.6195_none_cbf5e994470a1a8f\MFC80U.DLL

Report Id: 9cacfcf4-5720-11e1-8055-101f744c2b41

Any help will be very much appreciated - this is very frustrating !! Thanks in advance !!

vitaly_izmaylov
Employee
Employee
0 Kudos

I do remember the problem even in CR 2008, and I am searching if it was fixed.

But there is an easy workaround:

Have report with at least two linked tables designed in CR XIR2, save it as a template, then you can open the report in CR 2008, add more tables, remove tables, etc. The problem take place only when the first link added.

Could you please verify if it works for you? I mean add, remove tables.

Vitaly