Solved

Crystal Reports 11 crw32.exe runtime error

Posted on 2014-04-17
14
1,457 Views
Last Modified: 2014-08-03
Using Crystal Reports 11 to query Progress 10.2b database.  When generating Crystal reports using more than 4 linked tables we receive the crw32.exe runtime error.  When we immediately rerun the same crystal report it works fine.  This occurs on both Windows 7 and Windows XP systems.  This is the 32 bit version of Crystal Reports 11.
0
Comment
Question by:jnelipowitz
  • 7
  • 6
14 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40008617
Is this CR XI R1 or R2?

How are you running the report?

How are you connecting to the database?

What is the error?

Have you looked at the database logs?

The fact it works on the second run indicates it is probably not a Crystal issue but more likely a permissions issue.

mlmcc
0
 

Author Comment

by:jnelipowitz
ID: 40037984
Sorry just noticed the response.

CR XI.

Report is run as a standard Crystal report.

Connected to the database using Progress OpenEdge Wire Protocol Driver ODBC connection


The error is a Runtime Error for crw32.exe.

The server log states:  Disconnecting client 306 of dead server 42.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40038059
Run as a standard report - Is that in the designer or do you have an application that runs it?

CR XI has 2 releases R1 version 11.0 and R2 version 11.5
Which do you use because there are significant differences

mlmcc
0
 

Author Comment

by:jnelipowitz
ID: 40064194
This is version 11.0.   The crw32.exe runtime error occurs in both situations.  Most of our more complex Crystal Reports are run thru the designer.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40064457
You get a crw32.exe error when running from the designer?

CR v11.0 was quickly replaced with release 2 (v11.5)  I would recommend you update to CR XI R2.  It is available here

http://scn.sap.com/community/crystal-reports-for-visual-studio/blog/2011/06/07/where-did-all-the-crystal-reports-xi-r1-and-r2-fixes-go

mlmcc
0
 

Author Comment

by:jnelipowitz
ID: 40081481
I did as instructed and installed the v11.5 and Patch 6.  Appeared to work but now receiving new error messages.  See attached.
CrystalXIError.doc
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 100

Expert Comment

by:mlmcc
ID: 40081529
Did you install SP4 first?

SP6 is only an incremental from SP4 to SP6.  You need to install SP4 first to move from V11.0 to V11.5

mlmcc
0
 

Author Comment

by:jnelipowitz
ID: 40083017
From the link you provided.  The first program installed was Crystal Report XI R2A SP4 Full Build and the second program was the SP6.  So the SP4 was installed first with the full install.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40083459
What happens if you do a VERIFY DATABASE?

Can you build/run reports that use 1 table?
Please verify the new install of CR works with other reports.

mlmcc
0
 

Author Comment

by:jnelipowitz
ID: 40084339
Verify database works fine.

CR with 1, 2, or 3 databases works fine.

I did have to  run a JoinFix for the Registry as I use Left Outer Joins.

When I run report 30 for the first time it runs fine.  If I close crystal and run report 30 again I get the error messages.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40084940
I don't know.  I hate intermittent problems.

I have reports with many more than 4 tables added and they run fine so it isn't the number of tables but something else.

mlmcc
0
 

Accepted Solution

by:
jnelipowitz earned 0 total points
ID: 40226362
Installing SP4 and SP6 only made this situation worse.  I had to uninstall Crystal and install just the 11.0 version again and will live with having to log back into Crystal when the runtime error occurs.  Thanks for all the comments and help with this problem.
0
 

Author Closing Comment

by:jnelipowitz
ID: 40237098
Never solved this problem, just want it closed.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to file 3 67
Salesforce Campaign - 4,500 members 5 64
Scripting vs. Programming languages 25 151
Crystal Reports - How to Set Default Join Type to Left Outer Join 3 35
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now