SAP Knowledge Base Article - Public

1883150 - SAP Crystal Reports 2011 shuts down when linking tables

Symptom

  • Linking tables in the Crystal Reports designer
  • The designer freezes
  • Then shuts down with no error
  • Event log shows the following:

 

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

 

Environment

  • SAP Crystal Reports 2011
  • [IBM][System i Access ODBC Driver
  • Windows 7 Professional

Cause

  • Crystal Reports CRLogger file shows the following: 

Error: message = [IBM][System i Access ODBC Driver]Statement violates access rule: Connection is set to read only., sqlstate = 42000, native code = 30186

  • This indicates permission issues

Resolution

 ***WARNING***:

The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems. Use the Registry Editor at your own risk. Refer to KBA 1323322 for more information. 

  • The "AccessMode" registry key needs to be set as a Reg_DWORD 0x00000000 (0):

 

  1. Open the Registry Editor (Click Start > Run > type regedit > OK)
  2. On a 64 bit OS navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database
  3. On a 32 bit OS navigate to HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database
  4. Right click the Database registry key > select New > Key > name the key ODBC
  5. Right click the ODBC key > select New > DWord value > name it AccessMode
  6. Set the value to default:  0x00000000 (0)
  7. Restart the Crystal Reports

Keywords

CR CR2011 2011 crash expert link , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011