Crystal Reports XI "Accessing Database" not responding
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.
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.
ASKER
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.A
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.A
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
Do the same dates always hang?
Are the others running the same reports?
If so are they using the same report file?
mlmcc
ASKER
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.
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.
ASKER
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.
Are you using a single table or multiple tables?
If multiple how are they joined?
mlmcc
If multiple how are they joined?
mlmcc
ASKER
one table, one command with a left outer join. Command:
SELECT "PEOPLESOFT"."PS_ACCOMPLIS
FROM "PEOPLESOFT"."PS_ACCOMPLIS
WHERE "PEOPLESOFT"."PS_ACCOMPLIS
SELECT "PEOPLESOFT"."PS_ACCOMPLIS
FROM "PEOPLESOFT"."PS_ACCOMPLIS
WHERE "PEOPLESOFT"."PS_ACCOMPLIS
There are only 4 fields how are you adding a 5th one?
mlmcc
mlmcc
ASKER
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.
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
mlmcc
ASKER
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.
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
Have you tried the VERIFY DATABASE option?
If you add just the phone number does it work?
mlmcc
ASKER
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.
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
>>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
ASKER
I can create a report with just phone number (or any other field).
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
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
ASKER
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.
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
XI R2 is just CR XI release 2. It was released for compatibility woth .Net 2.0 and VS2005.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc