Creating a Report Model locks up or get a Timeout message out when getting counts

When creating new Report Models in VS2005, the Report Model Wizard gets to the point where it is states that it is "Calculating column uniqueness" and it either gets locked up there or we get a message stating that the query timed out and it shows this huge query where it is counting a bunch of records from one of the tables from the Data Source View. I need to figure out how to get around this problem and move forward with creating models.

The actual error message states:

An error occurred while executing a command.
Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT
      COUNT([Computed_DryHoleCost]),
      COUNT(DISTINCT [Computed_DryHoleCost]),
      COUNT([Computed_WellworkCost]),
      COUNT(DISTINCT [Computed_WellworkCost]),
      COUNT([Computed_TotalCost]),
      COUNT(DISTINCT [Computed_TotalCost]),
      COUNT([Computed_CompletionCost]),
      COUNT(DISTINCT [Computed_CompletionCost]),
      COUNT([Computed_FinalDrillingCosts]),
      COUNT(DISTINCT [Computed_FinalDrillingCosts]),
      COUNT([Computed_FinalSuspendedCosts]),
      COUNT(DISTINCT [Computed_FinalSuspendedCosts]),
      COUNT([Computed_TotalActualCosts]),
      COUNT(DISTINCT [Computed_TotalActualCosts]),
      COUNT([Computed_ActualDrillingCosts]),
      COUNT(DISTINCT [Computed_ActualDrillingCosts]),
      COUNT([Computed_ActualCompletionCosts]),
      COUNT(DISTINCT [Computed_ActualCompletionCosts]),
      COUNT([Computed_ActualWellworkCosts]),
      COUNT(DISTINCT [Computed_ActualWellworkCosts]),
      COUNT([Computed_FinalWellworkCosts]),
      COUNT(DISTINCT [Computed_FinalWellworkCosts]),
      COUNT([Computed_FinalCompletionCosts]),
      COUNT(DISTINCT [Computed_FinalCompletionCosts])
FROM [dbo].[AFE] t
LVL 2
bbaldwinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
James MurrellConnect With a Mentor Product SpecialistCommented:
just seen this @ http://www.windows-tech.info/15/b8b48048e18d376e.php
try with this code before your query

Code Snippet

Your Query
go
dump tran "You database" with no_log
0
 
bbaldwinAuthor Commented:
I looked for a timeout parameter but cannot find one. Someone had suggested that it was in the Data Source but I could not find it there. When you create a Model - you just 1. Create the Data Source. 2. Create the Data Source View which is just like creating a view in SQL. and the 3. Create the Model and don't see any timeout parameters to set.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
James MurrellProduct SpecialistCommented:
on server

In the Management Studio, from the Tools menu > select Options, then click "Designers". There is an option called "Override connection string time-out value for table designer updates:"  In the "Transaction time-out after:" box, you will see the magic 30 seconds.
0
 
bbaldwinAuthor Commented:
I found an option there in the Business Intelligence Designers (only there if you install SQL tools) and there was a timeout setting of 15. I raised it to 600 and am trying again. It takes a long timeout for the other one to timeout. I am interested to see how long this takes.
0
 
bbaldwinAuthor Commented:
Unfortunately, this did not help. Suggestions?
0
 
bbaldwinAuthor Commented:
The database does not have a log since we have it set to "Simple".
0
 
bbaldwinAuthor Commented:
We just started creating the models against a database with a small number of records and everything started working. I will give you the points for trying. Thanks!
0
 
bbaldwinAuthor Commented:
We ultimately just ran the model against a database with a small number of records and everything started to work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.