on 08-08-2011 7:03 PM
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.
I have verified that once the template is created in CRXI, I can open it with CR2011 and add or delete tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Turn off Automatic Smart Linking. Open CR2011, choose File, Options and the Database tab. Then remove the check mark from Automatic Smart Linking.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found this (I hope it displays correctly!):
worked for 2011 trial, but not my 2008. I'm missing Suite 12.0 in my regedit.
HTH
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
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.
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.
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.
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
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
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.