Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal 2008 Post Reply Post New Topic
Author Message
qtz1906
Newbie
Newbie


Joined: 05 Aug 2011
Online Status: Offline
Posts: 6
Quote qtz1906 Replybullet Topic: Crystal 2008
    Posted: 23 Aug 2011 at 6:37am
I am getting the following message when trying to run a report in Crystal 2008.
 
"failed to retrieve data from the database. details: HY000:[cache ODBC][State : S1000][Native Code 10054][C:\Program Files\Business Objects\Business Objects Enterprise 12.0\win32_x86\crw3] Socket: connection reset by peer (due to timeout or reboot)[Database vendor Code 10054]
 
some reports are able to run and others get the message above.
 
Any suggestions?
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 23 Aug 2011 at 11:10am
What type of database connection are you using?  What type of database are you connecting to?  Do the reports that are failing take a long time to run?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
qtz1906
Newbie
Newbie


Joined: 05 Aug 2011
Online Status: Offline
Posts: 6
Quote qtz1906 Replybullet Posted: 23 Aug 2011 at 11:22am
ODBC connection
cache database
Reports that fail, fail quick!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 24 Aug 2011 at 8:05am
I haven't ever worked with a cache database, but I would check the following in the reports that aren't working:
 
1.  Make sure they're pointing to the same datasource location as the reports that work.
 
2.  Validate that the query that Crystal is running works in the database in a tool outside of Crystal.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
qtz1906
Newbie
Newbie


Joined: 05 Aug 2011
Online Status: Offline
Posts: 6
Quote qtz1906 Replybullet Posted: 24 Aug 2011 at 12:32pm
ok thanks
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.008 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.