Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1299
  • Last Modified:

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

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
EENovice
Asked:
EENovice
  • 3
  • 3
1 Solution
 
MIKESoftware Solutions ConsultantCommented:
Can you run the query from SQL Server Management Studio..?

What is the error there?
0
 
mlmccCommented:
What is the error?

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

mlmcc
0
 
EENoviceAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
mlmccCommented:
How are you connecting to the database?  Do you use Windows Authentication?

mlmcc
0
 
EENoviceAuthor Commented:
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
 
mlmccCommented:
Don't know.

mlmcc
0
 
EENoviceAuthor Commented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now