ETL Package Problem

I'm going through the Integration tutorial, Lesson 1: Creating a Simple ETL Package. Everything goes fine until I run the package. I get an error about inserting Null in the CurrencyKey field which is set to not null. The flat file looks okay.

Any help would be appreciated.

SSIS package "Lesson 1.dtsx" starting.
Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Extract Sample Currency Data, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Extract Sample Currency Data, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Extract Sample Currency Data, Extract Sample Currency Data [1]: The processing of file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" has started.
Information: 0x400490F4 at Extract Sample Currency Data, Lookup Currency Key [30]: component "Lookup Currency Key" (30) has cached 105 rows.
Information: 0x400490F4 at Extract Sample Currency Data, Lookup Date Key [124]: component "Lookup Date Key" (124) has cached 992 rows.
Information: 0x4004300C at Extract Sample Currency Data, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DE at Extract Sample Currency Data, Extract Sample Currency Data [1]: The total number of data rows processed for file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" is 1097.
Information: 0x402090DF at Extract Sample Currency Data, Sample OLE DB Destination [158]: The final commit for the data insertion has started.
Error: 0xC0202009 at Extract Sample Currency Data, Sample OLE DB Destination [158]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'CurrencyKey', table 'AdventureWorksDW.dbo.FactCurrencyRate'; column does not allow nulls. INSERT fails.".
Information: 0x402090E0 at Extract Sample Currency Data, Sample OLE DB Destination [158]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Extract Sample Currency Data, DTS.Pipeline: The ProcessInput method on component "Sample OLE DB Destination" (158) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Extract Sample Currency Data, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
Information: 0x40043008 at Extract Sample Currency Data, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Extract Sample Currency Data, Extract Sample Currency Data [1]: The processing of file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" has ended.
Information: 0x40043009 at Extract Sample Currency Data, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Extract Sample Currency Data, DTS.Pipeline: "component "Sample OLE DB Destination" (158)" wrote 1097 rows.
Task failed: Extract Sample Currency Data
Warning: 0x80019002 at Lesson 1: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Lesson 1.dtsx" finished: Failure.
The program '[3372] Lesson 1.dtsx: DTS' has exited with code 0 (0x0).

CurrencyKey Column is set to Not Null means, it cannot take Null values.

If I remember right, CurrencyKey Column of the AdventureWorksDW database is a Primary key.

Thanks,

S Suresh

|||Then there is a problem with the tutorial. Do you know how to fix the problem?
|||

Hi kinny_k,

I was just wondering if you ever got an answer to this problem with the SSIS ETL tutorial. I've run into the same issue and I've checked and rechecked my steps and can not see anything wrong.

If you have the solution/workaround I'd appreciate the input!

-mayalu

|||

Did you review if any of the mapping in your destination componnet is missing?

Rafael Salas

|||

I had a problem with this too. It turns out that the Flat File dates are in a MM/DD/YYYY format and since my default is DD/MM/YYYY most dates aren't correctly identified.

To resolve this:

1. In the ‘Flat File Connection Manager’, changed the CurrencyDate DataType to string [DT_STR].

2. In the ‘Data Flow’ diagram, a Warning displays on the ‘Extract Sample Currency Data’ dataflow.Double click to open it. A message is displayed warning that the format has changed, click Yes and when the ‘Flat File Source Editor’ is displayed, click OK to close.

3. In the Date Lookup Transformation Editor, Reference Table tab, select 'Use results of an SQL query' and paste in:

SELECT TimeKey, FullDateAlternateKey,
CAST(CAST(CONVERT(VARCHAR(2), FullDateAlternateKey, 101) AS INT) AS VARCHAR) + '/' +
CAST(CAST(SUBSTRING(CONVERT(VARCHAR(5), FullDateAlternateKey, 101), 4,2) AS INT) AS VARCHAR) + '/' +
CAST(CAST(RIGHT(CONVERT(VARCHAR(10), FullDateAlternateKey, 101),4) AS INT) AS VARCHAR) + ' 0:00' USFormatDate
FROM dbo.DimTime

Check to output looks OK by clicking the preview button.

4. In the Date Lookup Transformation Editor, Columns tab, link the CurrencyDate to the new USFormatDate field.

I'd imagine there's a nicer way of fixing this but I'm not at all familiar with SSIS yet.

|||

Hi Tim,

Thanks for the input. I tried it and all goes well until the last step where I try to map the CurrencyDate to the new USFormatDate field where I get a data type mismatch. I guess there's something else peculiar to my setup.

At least I know where to look closer!

-Elsie

|||

Elsie,

Hum, I think I'd check the first step again. You have to change the flat file Currency Date to be a string otherwise the comparison wont work and you’ll get a type mismatch. Other than that, I'm afraid I don't know.

You could always change the FactCurrencyRate table definition to allow Null in the TimeKey field so you don't get the error. In retrospect I should have done that as it’s a lot quicker to get the lesson working.

Tim

|||It seems that the only solution is to use SSIS in a db instance with English(US) as default language.
At least, for db instances with non-English default languages (I have Russian one) nothing else works
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1566456&SiteID=1&mode=1|||

In both step 9's of the add lookup transformation, be sure to click on the box to select the(CurrencyKey) lookup value. You should have a checkbox before moving on. Then you can pam this lookup to the column in the later step.

Enjoy!

|||I am sure I verifшув that (and everything else) dozens of times,
BTW it does not address the error and the problem (incompatible datetime fields)|||

To get this fully working, following steps are required:

1. In the Sample Flat File Source Data connection manager, change CurrencyDate Data Type to String [DT_STR]

2. In the data flow task editor, double click data Flow souce 'Extract Sample Currency Data' then accept the warning

3. In Look Up Time Key task, under Reference Table tab, choose use Results of an SQL query, then use the following SQL statement, which I modified from an early post,

SELECT TimeKey, FullDateAlternateKey,
CAST(CAST(CONVERT(VARCHAR(2), FullDateAlternateKey, 101) AS INT) AS VARCHAR)+ '/'
+
CAST(CAST(SUBSTRING(CONVERT(VARCHAR(5), FullDateAlternateKey, 101), 4,2) AS INT) AS VARCHAR) + '/' +
CAST(CAST(RIGHT(CONVERT(VARCHAR(10), FullDateAlternateKey, 101),4) AS INT) AS VARCHAR) + ' 00:00:00' USFormatDate
FROM dbo.DimTime

4. In Look Up Time Key task, Link Currency date from Available Input Columns to USFormatDate in Available Look UP Columns.

5. Make sure you link the output of the look up to the destination columns.

Good luck,

Celine

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

|||http://www.codeplex.com/MSFTDBProdSamples

ETL Package Problem

I'm going through the Integration tutorial, Lesson 1: Creating a Simple ETL Package. Everything goes fine until I run the package. I get an error about inserting Null in the CurrencyKey field which is set to not null. The flat file looks okay.

Any help would be appreciated.

SSIS package "Lesson 1.dtsx" starting.
Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Extract Sample Currency Data, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Extract Sample Currency Data, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Extract Sample Currency Data, Extract Sample Currency Data [1]: The processing of file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" has started.
Information: 0x400490F4 at Extract Sample Currency Data, Lookup Currency Key [30]: component "Lookup Currency Key" (30) has cached 105 rows.
Information: 0x400490F4 at Extract Sample Currency Data, Lookup Date Key [124]: component "Lookup Date Key" (124) has cached 992 rows.
Information: 0x4004300C at Extract Sample Currency Data, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DE at Extract Sample Currency Data, Extract Sample Currency Data [1]: The total number of data rows processed for file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" is 1097.
Information: 0x402090DF at Extract Sample Currency Data, Sample OLE DB Destination [158]: The final commit for the data insertion has started.
Error: 0xC0202009 at Extract Sample Currency Data, Sample OLE DB Destination [158]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'CurrencyKey', table 'AdventureWorksDW.dbo.FactCurrencyRate'; column does not allow nulls. INSERT fails.".
Information: 0x402090E0 at Extract Sample Currency Data, Sample OLE DB Destination [158]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Extract Sample Currency Data, DTS.Pipeline: The ProcessInput method on component "Sample OLE DB Destination" (158) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Extract Sample Currency Data, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
Information: 0x40043008 at Extract Sample Currency Data, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Extract Sample Currency Data, Extract Sample Currency Data [1]: The processing of file "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt" has ended.
Information: 0x40043009 at Extract Sample Currency Data, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Extract Sample Currency Data, DTS.Pipeline: "component "Sample OLE DB Destination" (158)" wrote 1097 rows.
Task failed: Extract Sample Currency Data
Warning: 0x80019002 at Lesson 1: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Lesson 1.dtsx" finished: Failure.
The program '[3372] Lesson 1.dtsx: DTS' has exited with code 0 (0x0).

CurrencyKey Column is set to Not Null means, it cannot take Null values.

If I remember right, CurrencyKey Column of the AdventureWorksDW database is a Primary key.

Thanks,

S Suresh

|||Then there is a problem with the tutorial. Do you know how to fix the problem?
|||

Hi kinny_k,

I was just wondering if you ever got an answer to this problem with the SSIS ETL tutorial. I've run into the same issue and I've checked and rechecked my steps and can not see anything wrong.

If you have the solution/workaround I'd appreciate the input!

-mayalu

|||

Did you review if any of the mapping in your destination componnet is missing?

Rafael Salas

|||

I had a problem with this too. It turns out that the Flat File dates are in a MM/DD/YYYY format and since my default is DD/MM/YYYY most dates aren't correctly identified.

To resolve this:

1. In the ‘Flat File Connection Manager’, changed the CurrencyDate DataType to string [DT_STR].

2. In the ‘Data Flow’ diagram, a Warning displays on the ‘Extract Sample Currency Data’ dataflow.Double click to open it. A message is displayed warning that the format has changed, click Yes and when the ‘Flat File Source Editor’ is displayed, click OK to close.

3. In the Date Lookup Transformation Editor, Reference Table tab, select 'Use results of an SQL query' and paste in:

SELECT TimeKey, FullDateAlternateKey,
CAST(CAST(CONVERT(VARCHAR(2), FullDateAlternateKey, 101) AS INT) AS VARCHAR) + '/' +
CAST(CAST(SUBSTRING(CONVERT(VARCHAR(5), FullDateAlternateKey, 101), 4,2) AS INT) AS VARCHAR) + '/' +
CAST(CAST(RIGHT(CONVERT(VARCHAR(10), FullDateAlternateKey, 101),4) AS INT) AS VARCHAR) + ' 0:00' USFormatDate
FROM dbo.DimTime

Check to output looks OK by clicking the preview button.

4. In the Date Lookup Transformation Editor, Columns tab, link the CurrencyDate to the new USFormatDate field.

I'd imagine there's a nicer way of fixing this but I'm not at all familiar with SSIS yet.

|||

Hi Tim,

Thanks for the input. I tried it and all goes well until the last step where I try to map the CurrencyDate to the new USFormatDate field where I get a data type mismatch. I guess there's something else peculiar to my setup.

At least I know where to look closer!

-Elsie

|||

Elsie,

Hum, I think I'd check the first step again. You have to change the flat file Currency Date to be a string otherwise the comparison wont work and you’ll get a type mismatch. Other than that, I'm afraid I don't know.

You could always change the FactCurrencyRate table definition to allow Null in the TimeKey field so you don't get the error. In retrospect I should have done that as it’s a lot quicker to get the lesson working.

Tim

|||It seems that the only solution is to use SSIS in a db instance with English(US) as default language.
At least, for db instances with non-English default languages (I have Russian one) nothing else works
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1566456&SiteID=1&mode=1|||

In both step 9's of the add lookup transformation, be sure to click on the box to select the(CurrencyKey) lookup value. You should have a checkbox before moving on. Then you can pam this lookup to the column in the later step.

Enjoy!

|||I am sure I verifшув that (and everything else) dozens of times,
BTW it does not address the error and the problem (incompatible datetime fields)|||

To get this fully working, following steps are required:

1. In the Sample Flat File Source Data connection manager, change CurrencyDate Data Type to String [DT_STR]

2. In the data flow task editor, double click data Flow souce 'Extract Sample Currency Data' then accept the warning

3. In Look Up Time Key task, under Reference Table tab, choose use Results of an SQL query, then use the following SQL statement, which I modified from an early post,

SELECT TimeKey, FullDateAlternateKey,
CAST(CAST(CONVERT(VARCHAR(2), FullDateAlternateKey, 101) AS INT) AS VARCHAR)+ '/'
+
CAST(CAST(SUBSTRING(CONVERT(VARCHAR(5), FullDateAlternateKey, 101), 4,2) AS INT) AS VARCHAR) + '/' +
CAST(CAST(RIGHT(CONVERT(VARCHAR(10), FullDateAlternateKey, 101),4) AS INT) AS VARCHAR) + ' 00:00:00' USFormatDate
FROM dbo.DimTime

4. In Look Up Time Key task, Link Currency date from Available Input Columns to USFormatDate in Available Look UP Columns.

5. Make sure you link the output of the look up to the destination columns.

Good luck,

Celine

|||

Another solution:

on http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

you find database for case-sensitive collation and case-insensitive collation, a attached the other database and now works.

|||

This link tells that samples download had moved to codeplex

And codeplex has hundreds of samples

Which one?

|||http://www.codeplex.com/MSFTDBProdSamples

ETL Delta Pulling Huge data.. Right approach ?

Hi all,

In an approach of building an ETL tool, we are into a situation wherein, a table has to be loaded on an incremental basis. The first run all the records apporx 100 lacs has to be loaded. From the next run, only the records that got updated since the last run of the package or newly added are to be pulled from the source Database. One idea we had was to have two OLE DB Source components, in one get those records that got updated or was added newly, since we have upddate cols in the DB getting them is fairly simple, in the next OLEDB source load all the records form the Destination, pass it onto a Merge Join then have a Conditional Split down the piple line, and handle the updates cum insert.

Now the question is, how slow the show is gonna be ? Will there be a case that the Source DB returns records pretty fast and Merge Join fails in anticipation of all the records from the destination ?

What might be the ideal way to go about my scenario.. Please advice...

Thanks in advance.

Or may be just use a lookup component to check if there are any updates and redirect the errored rows as New records to the destination. Sounds good ?

|||

MShetty wrote:

Or may be just use a lookup component to check if there are any updates and redirect the errored rows as New records to the destination. Sounds good ?

The lookup component might be the way to go; or at least it has been the most popular approach for most scenarios. However, there has been several interesting discussion around this issue.

If you decide to use lookup transforms; be sure to understand how that component uses memory resources. Also, be aware that lookup transform is case sensitive when 'matching' the columns in the pipeline against the lookup table.

Jamie has interesting article on his blog; also Greg has written about an alternative approach using script component:

http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

Using 2 OLE DB source components and merge join, i think would be slower; but you can test it and gain a better understanding of that.

|||

Rafael Salas wrote:

The lookup component might be the way to go; or at least it has been the most popular approach for most scenarios. However, there has been several interesting discussion around this issue.

If you decide to use lookup transforms; be sure to understand how that component uses memory resources. Also, be aware that lookup transform is case sensitive when 'matching' the columns in the pipeline against the lookup table.

looks the memory usage is going to be an issue in lookup, especially when the record count is pretty huge.

|||

May be is not an issue at all; my advise on that: test it!

make sure you provide a query in the lookup transform with only the columns to be used for the lookup operation, so the resultset is as smallest as possible columns wise.

|||

Rafael Salas wrote:

May be is not an issue at all; my advise on that: test it!

make sure you provide a query in the lookup transform with only the columns to be used for the lookup operation, so the resultset is as smallest as possible columns wise.

I strongly agree. Lookup transform performs very well if you can use it right.

|||I did a testing with about 100 000+ rows in my forum post Merge Join vs. Lookup vs. Custom Script.

This should give you an overview - but please do your own testing before going live as the performance may vary accross configurations|||Thx for all the valuable inputs.. I think Lookup is not a fear, but its the components down the pipeline, OLEDB Command I am worried about,if its going to update lot of rows its going to hit the perfomance big time |||

TheViewMaster wrote:

I did a testing with about 100 000+ rows in my forum post Merge Join vs. Lookup vs. Custom Script.

This should give you an overview - but please do your own testing before going live as the performance may vary accross configurations

Amen to that. its no good asking on here - the only person that can provide a definitive answer is yourself.

-Jamie

|||

MShetty wrote:

Thx for all the valuable inputs.. I think Lookup is not a fear, but its the components down the pipeline, OLEDB Command I am worried about,if its going to update lot of rows its going to hit the perfomance big time

Yup - updating large amount of rows can take forever.
I also came to conclusion that with large number records - OLE DB Command object won't perform well. The solution I use is to load the data which needs to be updated to staging table - and then Execute SQL to update
e.g.
UPDATE Prod_Table
SET Field = a2.Field
FROM Prod_Table a1
JOIN Staging_Table a2 ON a1.PrimaryKey = a2.PrimaryKey|||

TheViewMaster wrote:

MShetty wrote:

Thx for all the valuable inputs.. I think Lookup is not a fear, but its the components down the pipeline, OLEDB Command I am worried about,if its going to update lot of rows its going to hit the perfomance big time

Yup - updating large amount of rows can take forever.
I also came to conclusion that with large number records - OLE DB Command object won't perform well. The solution I use is to load the data which needs to be updated to staging table - and then Execute SQL to update
e.g.
UPDATE Prod_Table
SET Field = a2.Field
FROM Prod_Table a1
JOIN Staging_Table a2 ON a1.PrimaryKey = a2.PrimaryKey

The approach ViewMaster is describing is exactly what I do on such cases. OLE DB commands are simply slow by nature, command gets executed once per every row, so its implementation is just not adecuate for large number of rows. You can use a lookup to separete your inserts from updates and then the insert pipe can go directly to the destination table and the other one to a stage table to be used back in the control flow in a Execute sql task (1 time update).

|||Thx for the inputs... Will defintely post on what was the test results once I test out the packages

ETL : rows with Errors

I'm using a "Execute SQL Task" to run a stored procedure to populate a Fact table in our dimensional datawarehouse. There is one row which violates a foreign key constraint, which causes the entire task to fail so zero rows are loaded. Is there any way to grab the offending row and send it off to some holding ground and go ahead and load the rest of the rows.

I'm using Execute SQL Task mostly because I am very comfortable with writing SQL whereas the rest of SSIS is a bit unfamiliar to me, but I'm guessing that to handle error rows I might have to change to a different kind of task ?

Thanks

Richard

The best way to do this is to use a lookup in the dataflow to determine if the incoming record violates foreign key rules.

As far as your stored procedure goes, head over to the Transact-SQL forum for help with that.

Estimate Snapshow Duration

Dear all,
I am going to set up a snapshot replicate. it will run nightly. The size of
DB is around 2GB, does anyone know how long will it take to completed the
snapshot replication. Is there any way of estimate the duration? Doesn't have
to be very accurate, a rough figure will do.
Thanks,
Jas
Jas,
this is almost impossible, as your network bandwidth at the time of the
replication and the indexes you have on the tables are just two factors
that'll change the result radically. Perhaps you can 'calibrate' the system
yourself in a rough way by replicating a table of 100MB with representative
indexes to a dummy database and then multiplying the result by 20 - just a
finger inthe air, but will give you some idea.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Esql/C calling stored procedure with output parameters

I'm trying to write an esqlc program that will run a stored procedure that returns several output parameters. I haven't been able to find any documentation to date that explains how to run the "EXEC SQL EXECUTE procname" command and specify the output parameters.

My stored procedure "aek_proc1" takes one input parameter (p1 - an 8-character string) and 3 output parameters (p2 - an integer; p3 - an 8-character string, and p4 a 40-character string).

My esqlc program contains the following code.

EXEC SQL BEGIN DECLARE SECTION;
char p1[9];
int p2;
char p3[9];
char p4[41];
WXEC SQL END DECLARE SECTION;

sprintf(&p1[0], "GL");
p2 = 0;
sprintf(&p3[0], "");
sprintf(&p4[0], "");

EXEC SQL EXECUTE aek_proc1 :p1,
:p2 OUTPUT,
:p3 OUTPUT,
:p4 OUTPUT;

I am getting errors at runtime about constants being passed for OUTPUT parameters.

I can run the same stored procedure in Query Analyser and it works beautifully (see below)

declare @.p1 char(8)
declare @.p2 integer
declare @.p3 char(8)
declare @.p4 char(40)

set @.p1 = 'GL'

execute aek_proc1 @.p1, @.p2 output, @.p3 output, @.p4 output

select @.p1 p1, @.p2 p2, @.p3 p3, @.p4 p4

Any idea what I'm doing wrong or how it should be coded?

I'd really appreciate any advice you can offer!!

I've spend hours browsing this newsgroup and found lots of examples of how to do this in VB and from Query Analyser but I can't find any examples for ESQL/C that work.

So, please help!!!

Thanks,

AllanK :rolleyes:Oops.

Don't know why the host variable names got turned into smileys, but that bit should have read...

EXEC SQL EXECUTE aek_proc1 :p1,
:p2 OUTPUT,
:p3 OUTPUT,
:p4 OUTPUT;|||Have you tried to replace : with @.?|||I tried changing the EXEC SQL EXEC command in the ESQL/C program to read...

EXEC SQL EXEC aek_proc1 @.p1, @.p2 OUTPUT, @.p3 OUTPUT, @.p4

after which I got the runtime error...

"0137- Must declare the variable '@.p1'."

I tried adding...

EXEC SQL DECLARE @.p1 char(8);
EXEC SQL DECLARE @.p2 int;
EXEC SQL DECLARE @.p3 char(8);
EXEC SQL DECLARE @.p4 char(40);

EXEC SQL SET @.p1 = 'GL';
EXEC SQL SET @.p2 = 0;
EXEC SQL SET @.p3 = '';
EXEC SQL SET @.p4 = '';

EXEC SQL EXEC aek_proc1 @.p1, @.p2 OUTPUT, @.p3 OUTPUT, @.p4 OUTPUT;

but the error persists.

Any further suggestions?

Thanks,

AllanK

Errors when trying to run SQL

Ok, whenever I try to connect, I get the following Error messages:

"SQL Server Registration failed because of the connection failure displayed below.
SQL Server does not exist or access denied.
ConnectionOpen (Connect())"

"An Error 1069 occured while performing this service operation on the
MSSQLServer Service"

I even went as far as uninstalling and reinstalling, but to no avail. Does anyone have an idea what's causing this? It was working fine and then all the sudden one day I start getting these messages and it won't work.

Thanks!
SmittyYou using sql server security ot trusted connection?

Do you have a dba, or are you it?

Does anyone else have sa priviliges to the box?|||Thanks for replying Brett...

It's my own personal computer at home so I'm the SA and no one else uses it nor has the ability to. It is the 120-day evaluation edition that I got with the text book that I use for school. I don't understand, it worked fine then it didn't... :confused:

Smitty|||You past the 120 days?

I think it messes with the registry...

You can by a full blown version for $49.00

It just can't be used for production systems...

http://www.microsoft.com/sql/howtobuy/development.asp|||I suppose that's most like the case :( Guess I'll need to buy it sooner or later heh..

Thanks Brett,

Smitty|||If its for study purpose then you can uninstall the SQL and remove all registry keys referred to SQL Server, reboot and reinstall Evaluation edition.|||Thank you Satya,

My instructor told me to do the same. :D

errors using BPA

Hello,
I am trying to run the best practices analyzer and am getting some time
out errors. Attached is the log. Any help would be greatly appreciated.
Log:
//--
Best Practice log file created at 12/22/2004 10:46:18 AM
Job name: Test
Log file: c:\program files\microsoft sql server best practices
analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
//--
Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
Getting affinity mask setting... BPAffinityMask.Execute()
Complied ... in BPAffinityMask.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
Preparing rule... Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
Getting 'allow update' information... BPAllowUpdate.Execute()
Complied ... in BPAllowUpdate.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
Getting AUTO_STAT information for each database... BPAutoStats.Execute()
Complied ... in BPAutoStats.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
Preparing rule...
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
Getting objects information
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCur sorForUpdate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursor Usages.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
Preparing rule...
Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
Getting machine name and list of databases ... BpFileCompression.Execute()
Complied ... in BpFileCompression.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
Getting database names ... BPDBBackups.Execute()
Getting readonly state and backup infor for each database ...
BPDBBackups.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
master: Database has been backed up in the specified period.
msdb: Database has been backed up in the specified period.
Complied ... in BPMsMSDBBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
Getting current date ... BPNoLogBackup.Execute()
Getting machine name and server instance ... BPNoLogBackup.Execute()
Getting info from NT Event Log ... BPNoLogBackup.Execute()
Complied ... in BPNoLogBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
Getting databases and SQL option settings... BPDbSQLOptions.Execute()
Partially Complied ... in BPDbSQLOptions.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
Not Complied ... in BpDefaultsRules.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
Getting objects information
...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprec atedSP.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
Getting all DB Names... BPDBFilePlacement.Execute()
Getting file placement information... BPDBFilePlacement.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
Getting objects information
...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNu ll.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
Getting machine and instance name... BPNoLogBackup.Execute()
Getting error log path... BPNoLogBackup.Execute()
Getting log size ... BPNoLogBackup.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
Preparing rule... Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
Getting objects information
...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExp ressionAlias.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
Getting current date ... BPFailedBackupEvent.Execute()
Getting machine name and server instance ... BPFailedBackupEvent.Execute()
Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Getting lightweight pooling setting... BPFibers.Execute()
Complied ... in BPFibers.Execute()
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized
Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
Complied ... in BPFTBackgroundServicesOptimized.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOptimized
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
Getting all databases... BPFTCatalogs.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
Getting all databases... BPFullTextCatPlacement.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacement
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
Getting databases... BPFTChangeTracking.Execute()
Complied ... in BPFTChangeTracking.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
Getting objects information
...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupli cate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
Getting machine name ... BPFTMSSearchLocalSystem.Execute()
Complied ... in BPFTMSSearchLocalSystem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
Getting machine name... BPFTPropertyStore.Execute()
Complied ... in BPFTPropertyStore.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestampColumn
Complied ... in BPFTIndexedTimestampColumn.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTimestampColumn
Preparing rule...
Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
Getting database names ... BPIndexDefrag.Execute()
Complied ... in BPIndexDefrag.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
Getting objects information
...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
Getting objects information
...Microsoft.SqlBpa.Rules.BpInsertColList.BpInser tColList.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
Preparing rule...
Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
Getting config values... BPMaxServerMem.Execute()
Getting all databases & full-text enabled status ...
BPMaxServerMem.Execute()
Not Complied ... in BPMaxServerMem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
Getting objects information
...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAns iOuter.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Not Complied ... in NoPk.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuil tins.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSys Tables.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
Getting objects information
...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrd erByOrdinals.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
Checking db size... BPDBDiskSpace.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
Preparing rule...
Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
Getting 'priority boost' information... BPPriorityBoost.Execute()
Not Complied ... in BPPriorityBoost.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
Getting objects information
...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQual ifiedNames.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
Getting current recovery interval setting... BPRecInterval.Execute()
Complied ... in BPRecInterval.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
Getting readonly state and backup info for each database ...
BPReuseBackupFile.Execute()
Complied ... in BPReuseBackupFile.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
Preparing rule...
Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
Getting database names ... BPRecModelUsage.Execute()
Partially Complied ... in BPRecModelUsage.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
Preparing rule...
Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
Getting current date, machine name, and instance name ...
BPSevereErrorEvent.Execute()
Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
Complied ... in BPSevereErrorEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Getting objects information
...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
Getting config values... BPSetWorkingSetSize.Execute()
Complied ... in BPSetWorkingSetSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Getting objects information
...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.E xecute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
Getting current date, machine name, and instance name ...
BPUnexpectedShutdown.Execute()
Getting startup and shutdown info from NT Event Log ...
BPUnexpectedShutdown.Execute()
Identifying possible undexpected shutdowns ...
BPUnexpectedShutdown.Execute()
Retrieveing possible begin time for unexpected shutdown prior to startup ...
BPUnexpectedShutdown.Execute()
Complied ... in BPUnexpectedShutdown.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfi gure.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpti on.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
Getting objects information
...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
Getting @.@.servername... BPNullServer.Execute()
Complied ... in BPNullServer.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
Complied ... in BPTempDBSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
Getting objects information
...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTabl es.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
Getting objects information
...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoO rderBy.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrig gerNoCount.Execute()
Not Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrig gerResults.Execute()
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
Getting all user objects in master database ... BPUserObjInMaster.Execute()
Not Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
Preparing rule... Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
Partially Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
Preparing rule...
Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
Partial Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
Getting objects information
...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
Getting objects information
...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
Complied ... in BPSysSchemaCheck.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
I have a similar problem. First time (yesterday) BPA worked fine. Today it
cant work.
I just desistaled and instaled again but it doesnt work.
The log
Microsoft.BPA.Server.JobCoordinatorComponent.JobCo ordinatorException:
Execution log not found in the repository
Server stack trace:
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.updateJobStatus(Int32
jobProgress, Status jobStatus, Boolean fExecutionComplete, Boolean
fNoException)
...
Any suggestion?
"jake" <rondican@.hotmail.com> escreveu na mensagem
news:%234np4kR7EHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am trying to run the best practices analyzer and am getting some
time
> out errors. Attached is the log. Any help would be greatly appreciated.
>
>
> Log:
> //--
> Best Practice log file created at 12/22/2004 10:46:18 AM
> Job name: Test
> Log file: c:\program files\microsoft sql server best practices
> analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
> //--
> Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
> Getting affinity mask setting... BPAffinityMask.Execute()
> Complied ... in BPAffinityMask.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
> Preparing rule...
Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
> Getting 'allow update' information... BPAllowUpdate.Execute()
> Complied ... in BPAllowUpdate.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
> Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
> Getting AUTO_STAT information for each database... BPAutoStats.Execute()
> Complied ... in BPAutoStats.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
> Getting objects information
>
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Ex
ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at
>
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execu
te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCurs orForUpdate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorU sages.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
> Getting machine name and list of databases ... BpFileCompression.Execute()
> Complied ... in BpFileCompression.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
> Getting database names ... BPDBBackups.Execute()
> Getting readonly state and backup infor for each database ...
> BPDBBackups.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
> Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
> master: Database has been backed up in the specified period.
> msdb: Database has been backed up in the specified period.
> Complied ... in BPMsMSDBBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
> Getting current date ... BPNoLogBackup.Execute()
> Getting machine name and server instance ... BPNoLogBackup.Execute()
> Getting info from NT Event Log ... BPNoLogBackup.Execute()
> Complied ... in BPNoLogBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
> Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
> Getting databases and SQL option settings... BPDbSQLOptions.Execute()
> Partially Complied ... in BPDbSQLOptions.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
> Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
> Not Complied ... in BpDefaultsRules.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
> Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepreca tedSP.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
> Getting all DB Names... BPDBFilePlacement.Execute()
> Getting file placement information... BPDBFilePlacement.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
> Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNul l.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
> Getting machine and instance name... BPNoLogBackup.Execute()
> Getting error log path... BPNoLogBackup.Execute()
> Getting log size ... BPNoLogBackup.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
> Preparing rule...
Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpr essionAlias.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
> Getting current date ... BPFailedBackupEvent.Execute()
> Getting machine name and server instance ... BPFailedBackupEvent.Execute()
> Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Getting lightweight pooling setting... BPFibers.Execute()
> Complied ... in BPFibers.Execute()
> Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimiz
ed
> Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
> Complied ... in BPFTBackgroundServicesOptimized.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOp
timized
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
> Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
> Getting all databases... BPFTCatalogs.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
> Getting all databases... BPFullTextCatPlacement.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacemen
t
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
> Getting databases... BPFTChangeTracking.Execute()
> Complied ... in BPFTChangeTracking.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
> Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplic ate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
> Getting machine name ... BPFTMSSearchLocalSystem.Execute()
> Complied ... in BPFTMSSearchLocalSystem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
> Getting machine name... BPFTPropertyStore.Execute()
> Complied ... in BPFTPropertyStore.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestamp
Column
> Complied ... in BPFTIndexedTimestampColumn.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTime
stampColumn
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
> Getting database names ... BPIndexDefrag.Execute()
> Complied ... in BPIndexDefrag.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
> Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpInsertColList.BpInsert ColList.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
> Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
> Getting config values... BPMaxServerMem.Execute()
> Getting all databases & full-text enabled status ...
> BPMaxServerMem.Execute()
> Not Complied ... in BPMaxServerMem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
> Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsi Outer.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Not Complied ... in NoPk.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuilt ins.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysT ables.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrde rByOrdinals.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
> Checking db size... BPDBDiskSpace.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
> Getting 'priority boost' information... BPPriorityBoost.Execute()
> Not Complied ... in BPPriorityBoost.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
> Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQuali fiedNames.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
> Getting current recovery interval setting... BPRecInterval.Execute()
> Complied ... in BPRecInterval.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
> Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
> Getting readonly state and backup info for each database ...
> BPReuseBackupFile.Execute()
> Complied ... in BPReuseBackupFile.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
> Getting database names ... BPRecModelUsage.Execute()
> Partially Complied ... in BPRecModelUsage.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
> Getting current date, machine name, and instance name ...
> BPSevereErrorEvent.Execute()
> Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
> Complied ... in BPSevereErrorEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
> Getting config values... BPSetWorkingSetSize.Execute()
> Complied ... in BPSetWorkingSetSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Ex ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
> Getting current date, machine name, and instance name ...
> BPUnexpectedShutdown.Execute()
> Getting startup and shutdown info from NT Event Log ...
> BPUnexpectedShutdown.Execute()
> Identifying possible undexpected shutdowns ...
> BPUnexpectedShutdown.Execute()
> Retrieveing possible begin time for unexpected shutdown prior to startup
...
> BPUnexpectedShutdown.Execute()
> Complied ... in BPUnexpectedShutdown.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfig ure.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOptio n.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
> Getting @.@.servername... BPNullServer.Execute()
> Complied ... in BPNullServer.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
> Complied ... in BPTempDBSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTable s.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOr derBy.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrigg erNoCount.Execute()
> Not Complied ... in
Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults

> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrigg erResults.Execute()
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
> Getting all user objects in master database ...
BPUserObjInMaster.Execute()
> Not Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
> Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
> Partially Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
> Partial Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
> Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
> Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
> Complied ... in BPSysSchemaCheck.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
>
>
|||Hi, Jake
I have the same problem...
Do you found a solution ?
Thanks
Regards
Thierry
Message posted via http://www.sqlmonster.com
|||Hi Thierry,
Are you seeing any timeouts in the log?. Could you explain the sequence of
steps you did to hit this error?.
It would be great if you could post the full log
Thanks
Sethu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Thierry via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:31f24cc7f1a94cb3a1f486af99bfeb9e@.SQLMonster.c om...
> Hi, Jake
> I have the same problem...
> Do you found a solution ?
> Thanks
> Regards
> Thierry
> --
> Message posted via http://www.sqlmonster.com