Solved

Business Objects Failed to retrieve data from the database. Error in File C:\Windows\Temp

Posted on 2008-10-24
7
1,290 Views
Last Modified: 2013-11-15
This error has already been discussed. It was posted in December '07. In that posting the solution was moving the database from Access to SQL.  I am experiencing this error on a SQL server, it has always been on an SQL server. In addition, it appears to be particular users, not the time of day. One user will  try and fail immediately while another use immediately runs the report from the pc that failed and the report is successful. This has been proven over and over again.  

I will say it is a complex query it is running, but, the suspicious symptom is it is the same three customers who experience the problem no matter what time of day, while all other customers are not reporting problems with the same report. Any help would be appreciated. Thanks
0
Comment
Question by:EENovice
  • 3
  • 3
7 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 22797001
Can you run the query from SQL Server Management Studio..?

What is the error there?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22797142
What is the error?

Do those customers have database permissions?
Do they have permissions to the temp directories?

mlmcc
0
 

Author Comment

by:EENovice
ID: 22797151
I can run the query every single time from SQL Server Management Studio without any errors. I am passing the same parameters the customer would be passing, their user code, their site information and the same time frame for the report and it returns data in 4 seconds.
0
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.

 
LVL 100

Expert Comment

by:mlmcc
ID: 22797212
How are you connecting to the database?  Do you use Windows Authentication?

mlmcc
0
 

Author Comment

by:EENovice
ID: 22797345
We have a single login that belongs to the application. When the app logs in to execute the query or when I log in to test the query in SQL Server Management I use the applications login to eliminate that as a possible problem.

As far as the customers having rights to the temp directory shouldn't be an issue. We have probably 60 customers who run this report and only three have reported a problem. Of the customer we are trouble shooting with we have re-imaged her pc, so the image should have given her the same rights as everyone else.

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22798307
Don't know.

mlmcc
0
 

Accepted Solution

by:
EENovice earned 0 total points
ID: 22871001
Discovered that the user had two user accounts in the application that called the report. When I deleted the inactive user account the report began running without any errors.
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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 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