Crystal Crashes while moving tables

[Former Member]

Hello,

I am trying to pull data through a mysql odbc connection to tables that have 1 to 5 million rows. While I am able to successfully pull data from certain tables, Crystal crashes while pulling data from other tables. I am using the latest version of Crystal on Windows 7.

~Fari

[abhilash_kumar · Accepted solution]

Hi Fari,

What is the exact version of Crystal Reports (Help > About)?

Could you write a command object to the same  table and see if that works?

-Abhilash

[Former Member · Accepted solution]

Thank you for your response. I am using version 14.0.2.364RTM. I don't know how to write a command object to the table. The crash normally occurs when trying to move the table from data source to selected tables.

[abhilash_kumar · Accepted solution]

Hi Fari,

Does this happen with a single table or with multiple tables?

What drivers and connectivity type are you using?

This could be a known issue as well; go to File > Options > Database tab > uncheck 'Automatic Smart Linking' and see that helps.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

It happens to both single table and multiple tables. We are using Mysql ODBC connector 32 bit. Are there any maximum number of records that can be pulled using Crystal Reports?

I tried your other suggestion and unfortunately, it still crashed.

~Fari

[former_member11696 · Accepted solution]

Hi Fari,

5 million rows should not be a problem for Crystal.

Try using OLE DB as a test to see if it too crashes the designer.

What version of MySQL are you using?

Don

[Former Member · Accepted solution]

Thanks Don. We tried OLE DB and it still crashed. We are using MySQL version 5.0.

[former_member11696 · Accepted solution]

OK, next is to copy the SQL from the Report and try it in some other ODBC Test tool like ODBCTest or OLEDBTest from Microsoft. This will/may show if it's the Client causing the problem.

Any errors being logged in the Event Viewer? Have you tried using ODBC Trace to see if it catches anything?

Next, you can enable CRLogger.dll in CR to log all of the database API's, but because it's causing a crash it may not capture the cause but worth a try.

Add this:

• To enable database logging add the following to your local System Environment Variables:

             LOGGING_DIR = c:\logging

             LOGGING_ENABLED_ASSERT = 1

             LOGGING_ENABLED_RUNTIME = 30

Create the c:\logging folder also.

to disable logging simply rename crlogger.dll to crlogger.org located in:

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

And be PATIENT, this logging with that amount of data is going to take a long time to complete. but it may happen relatively soon if it GPF's right away. Don't foget to rename the dll to disable logging.

You may want to simply try doing a repair install of CR, make sure you are a local PC admin and have full rights to install software.

Don

[Former Member · Accepted solution]

Thanks Don.

Logging didn't work -- it didn't turn on, after following the instructions but was able to successfully executed a select through the ODBC connector using ODBCView. I could download up to 1 million rows

~Fari

[Former Member · Accepted solution]

Hi,

[Need more Info]

The title of this thread is "Crystal Crashes while moving tables".

and in the description you have mentioned "Crystal crashes while pulling data from other tables".

You have also mentioned that

"The crash normally occurs when trying to move the table from data source to selected tables".

Can you explain or mention the exact stage at which you face a problem.

Is there any important error message shown?

[Supported Connectivity]

In the supported platforms guide for SAP Crystal Reports 2011 SP02, it is mentioned  that MySQL Community Server 5.0 is supported with MySQL Connector/ODBC 5.0. Are you using this version of the driver/connector?

[Probable Reasons]

Sometimes, table names containing special characters is probable cause of a problem in "Database Expert" window, when user is selecting the tables to be used.This can be checked by comparing table names of working and non-working ones.

Depending on the version and driver being used, there may be 'Query timeout' setting in the ODBC DSN OR 'maximum records to fetch' setting in the registry which could be increased to avoid crashing of CR while fetching data.

Thanks,

Prathamesh

[Former Member · Accepted solution]

But maybe it is too much for his computer?

[Former Member · Accepted solution]

Then it should not have worked till 1 million records in the ODBCView and there should not have been any problem while selecting the table to use.

[Former Member · Accepted solution]

Hi Prathamesh,

I am using the 5.0 version. The problem occurs when I move the table I want from database expert to selected tables. When I do that, I get the message below. I am able to pull other tables without any issues.

[former_member11696 · Accepted solution]

Hi Prathamesh,

Not true, you wrote:

"Then it should not have worked till 1 million records in the ODBCView and there should not have been any problem while selecting the table to use."

CR will use the system resources until they are full. There is no way to determine if a query is going to fill up the system resources.

When you connect to the DB right click on the connection and select Options and check off everything except what you are using, Views, Tables, SP's etc... this will lower the ssytem resource CR will use. THen try adding filters to the OWNER and Tables, use the % as a wild card.

Don

[Former Member · Accepted solution]

Thank you Don. I was able to do the first part and it definitely got faster. Could you tell me how to add a filter to the OWNER?

[former_member11696 · Accepted solution]

Just type in the name of the table owner, not sure if Oracle works that way, so then use Table and name your SP.

And try this reg key:

HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions - DoAutoSmartLinking and set it to No

May help also, CR will try to link all tables and all fields.

Don

[Former Member · Accepted solution]

Our system engineer tried all that and it still crashes. Anyone has any other ideas? Getting desperate over here

[former_member11696 · Accepted solution]

Hi Fari,

At this point all I can suggest is you either purchase a support case or if you have a support Contract them create a case in Service Market place and work with an Enigneer here to get logs and drill into more details.

Don

[Former Member · Accepted solution]

Hi Fari,

First check the Windows log files report

Computer Management->System tools-> Event Viewer->Windows logs->Applications

Check the entries in RED Color, in the below window you will get some error report.

Let me know the error message

Try these steps

Clean  the temporary files

clear the files in these locations.

1)Run-> Enter  %temp%

2)Run-> Enter temp

3)Run Disk Cleanup  on C drive select all and  Click "OK".

Now Run the Crystal Report : right-click run as Administrator.

Regards

pardhu

[former_member11696 · Accepted solution]

Try doing a repair install, close everything and be sure to be logged in as the lcoal PC owner with FULL Admin rights to instlal sotware.

Don

[Former Member · Accepted solution]

Sorry for late delay. I tried what you suggested and still crashed.

[Former Member · Accepted solution]

Hi Fari,

Don suggested  one try that one.

Meanwhile check the Windows log files report

Go to Control Panel--> Administrative tools-->

Computer Management->System tools-> Event Viewer->Windows logs->Applications

Check the entries which are in RED Color, select those which are related to Crystal report,

then in the below window you will get some error report.

This message gives you the exact cause of crashing Crystal report application.

try to install in another drive with Don mentioned procedure.