Crystal Reports XI "Accessing Database" not responding

livets
livets used Ask the Experts™
on
My Crystal Reports are "Not Responding" with the status in the left corner as "Accessing Database".  At one time all of my reports ran with consistency.   Now they run and sometimes the don't with this problem.  Other CR users do not have this problem (identical installations), so it is localized on my PC.  I am using up-do-date XP Pro.

I am using CR XI Pro, with Oracle native.  My report has 20 simple fields.  I have one date parameter.  Other reports are just simple listings with 5 or so fields.

If you look at the task manager, you see crw32 with 0 cpu, no network activity.  I have let the "accessing database" message sit for an hour.  No network activity.

I can cancel the job by clicking the X at the top of the CR window.  I get the error window which only says crw32.exe appver 11.0.0.1.1282 modname hungapp.

I have tried uninstalling CR, using Oracle (11g) ODBC.  Copied the rpt file.  Recreated the rpt file.  I even wiped my HD and reinstalled OS.  I have checked/reseated my network connections and card.

Still can't figure this out.

Help would be much appreciated.



Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Is the database perhaps busy and the tale you are trying to use locked?

mlmcc

Author

Commented:
Others users/pcs are able to run the same reports at any time, including immediately prior and after my attempts.  I am trying very early in the morning and late at night, well after peak hours on the database and my network.  The report does not use a big table or retrieve more than 450 records.

I do not know what a "tale" is.   Would you fill me in on that or did you mean table.  If you meant table, the particular table would only be used by my two users and I.  I do not see us running/connecting to these tables simultaneously. And, my users do not have a problem running these reports.  It must be something on my machine.

Another note:  I can consistently get one report to hang on a particular date.   Ie-run for 2009-10-16 runs OK.  2009-10-15 HANGS.  Both fields are date fields being compared as date fields.  Ahhh...more reports with DATE fields are hanging.   Maybe something with the dates?{PS_SU_VET_EMPL_VW.ACTION_DT} >= {?From Date}

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Yes tale should have been table.  My b sometimes fails to work.

Do the same dates always hang?

Are the others running the same reports?
If so are they using the same report file?

mlmcc
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Author

Commented:
It hangs consistently on the same dates.  Like 2009-10-15 or 2009-10-12 but the 19th or the 16th work.

Others are using the same report using the same rpt files.

At this time, I am trying to recreate the rpt, field by field, to see what happens when I add the date filter, then each field.   This has to be a date thing.

Author

Commented:
No it does not seem to be a date thing.  I have take out the date fields and filters.  I have added fields one by one into the report.  For some reason, when I get to the 5th field....It hangs.  I have changed fields, so one time I add home phone, the next time I add department, the next street address and they hang.  
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you using a single table or multiple tables?

If multiple how are they joined?

mlmcc

Author

Commented:
one table, one command with a left outer join.  Command:
SELECT "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."ACCOMPLISHMENT", "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."EXPIRATN_DT", "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."EMPLID", "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."LICENSE_NBR"
FROM "PEOPLESOFT"."PS_ACCOMPLISHMENTS"
WHERE "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."ACCOMPLISHMENT" = 'LPN' or "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."ACCOMPLISHMENT" = 'CNNT' or "PEOPLESOFT"."PS_ACCOMPLISHMENTS"."ACCOMPLISHMENT" ='REG NRS'


Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
There are only 4 fields how are you adding a 5th one?

mlmcc

Author

Commented:
Dragging from the Field Explorer over to the Design tab.  As soon as I go to the Preview tab, it hangs.  New info-I have now updated to XI R2 and still get the same.   So I have a user on XI and 10 that have the same problem.  I have some other CR users that are on this version and are the local network with the Oracle, they do not have this problem.  I am on another subnet, but my firewall is totally open to the network where Oracle resides.   Nothing has changed on my network.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
So if you use that SQL ( i don't see a join) you get a problem when you drag a field onto the report a second time?

mlmcc

Author

Commented:
Let's take a step back.  I have created a simple report with one table for troubleshooting purposes.  I add 5 fields (name, address, city, state, zip) to the report and can preview without a problem.  When I add a 6th field (phone), the report hangs with "accessing database" in the lower left.  Doesn't matter what the 6th field is, recreated issue with any field.  New info - I am able to log into sqlplus and run a select on the same table using same fields without a problem.  And, adding 6th or more fields is not a problem.  So this is something in CR.  My DBadmin is now telling me that when I am successful with 5 fields, he can see my process in oracle.  When I am unsucessfull with 6 fields, my process disappears.  Same simple one table, 5 field report.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Did you simply select the table when you created the report?

Have you tried the VERIFY DATABASE option?

If you add just the phone number does it work?

mlmcc

Author

Commented:
Verify Database has been run, "database is up to date".   You must remove one or more of the fields, then add another field like phone number (or pick any other fields) to be displayed.  I am not being confused by page width, there is plenty of physical space for these fields to print in the detail section.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What does this comment mean?

>>You must remove one or more of the fields, then add another field like phone number (or pick any other fields) to be displayed.

Are you accessing the table directly?

Can you create a report with just the phone number?

mlmcc

Author

Commented:
I can create a report with just phone number (or any other field).
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I t doesn't make sense.

What database driver are you using?

Can other users build reports with more than 5 fields?

Can you do that on their machine?  Logged in as them?

Do they have trouble on your machine?  Logged in as you?

It sounds like there is a problem on your machine ut I don't have a clue what it might be.

mlmcc

Author

Commented:
After calling Bus. Obj. for support, found out that I needed to upgrade my XI to XI R2.  XI is not supported (?), R2 is.  Still had the problem. It looks like this might be a Cisco issue with RTSP bug(?).   An "all hands on deck" approach has my networking looking into my problem more deeply.   I am going to close this out.   Thank you very much for your help.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you doing this inside an application or in the Crystal designer?

XI R2 is just CR XI release 2.  It was released for compatibility woth .Net 2.0 and VS2005.

mlmcc
Commented:
This is a problem with Cisco ASA RTSP & SQLNET inspection.  These items are by default turned on.  RTSP error messages where being received. Cisco instructed to turn both OFF.  The same reports work now.  

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial