KPI in SQL 2005

Hello,
I search informations or a tutoriel to carry out a KPI (Key Performance
Indicator) in Analysis Services 2005.
Can you help me.
Thanks!!
NicoHi
Look in SQL 2005 Beta 2 books online. Asking this question in the betagroups
for 2005 will also help.
"pralnico" wrote:

> Hello,
> I search informations or a tutoriel to carry out a KPI (Key Performance
> Indicator) in Analysis Services 2005.
> Can you help me.
> Thanks!!
> Nicosql

KPI in SQL 2005

Hello,
I search informations or a tutoriel to carry out a KPI (Key Performance
Indicator) in Analysis Services 2005.
Can you help me.
Thanks!!
Nico
Hi
Look in SQL 2005 Beta 2 books online. Asking this question in the betagroups
for 2005 will also help.
"pralnico" wrote:

> Hello,
> I search informations or a tutoriel to carry out a KPI (Key Performance
> Indicator) in Analysis Services 2005.
> Can you help me.
> Thanks!!
> Nico

KPI in SQL 2005

Hello,
I search informations or a tutoriel to carry out a KPI (Key Performance
Indicator) in Analysis Services 2005.
Can you help me.
Thanks!!
NicoHi
Look in SQL 2005 Beta 2 books online. Asking this question in the betagroups
for 2005 will also help.
"pralnico" wrote:
> Hello,
> I search informations or a tutoriel to carry out a KPI (Key Performance
> Indicator) in Analysis Services 2005.
> Can you help me.
> Thanks!!
> Nico

Keys, foreign key?

I need to know if this is required? I have products, with the help of their business account numbers, are naturally categorized numerically. I want to create a product category table and a product account table.

Example :
tbProductCategories
TypeCode | Description
1000 | Cups
2000 | Plates

tbProductAccounts
Account | Description
1001 | Mug
1002 | Glass
2001 | Plate
2002 | Saucer

With the above tables (which are made up :) ), would you include
a foreign key in tbProductAccounts indicating the type code?

What would the stored proc look like without it?

Create Procedure usp_GetProductAccounts

@.iTypeCode int

AS

SELECT tbProductAccounts.Account,
tbProductAccounts.Description
FROM tbProductAccounts
WHERE tbProductAccounts.Account - iTypeCode > 0 AND < 999

Would this work? Or should the foriegn key always be included?

Mike BIn my opinion, you should always, always, always include the foreign key. What happens when someday the boss demands a part number of "clyde" for a cup with a clydesdale on it because he promised it to a vendor?

-PatP|||Originally posted by Pat Phelan
In my opinion, you should always, always, always include the foreign key. What happens when someday the boss demands a part number of "clyde" for a cup with a clydesdale on it because he promised it to a vendor?

-PatP
Then that would not be clyde, but possibly 1010?

lol, I understand what you are saying. I think I knew that already, especially after I placed the table in the diagram an noticed there was no "true" relationship!

Thanks
Mike B|||Another reason to keep the foriegn key I guess is also to ensure data entegrity without having to add constraints in the stored proc or elsewhere.

Mike B|||another reason to support foreign keys is the benefit of merge joins in multi-table queries.
when you have to sorted columns in two tables and they are the columns in the join predicate
(on c.col1 = p.col2)
SQL Server will perform a merge join.
this is one of the fastest join processes available.
to encourage this you should always create non-clustered indexes on your foreign key columns.

{BOOKS ONLINE}Understanding Merge Joins

just another angle on this question seein' as all of the good points were taken.

KeyColumns Collection Order

When a key collection is set for the Keycolumns property, the DataItem Collection Editor has up and down buttons to order the individual keys. For example, for month in a date hierarchy I have a key collection of MonthNumber then Year. Changing it to Year then Month number doesn't seem to affect anything other than the way the hiearchy is referenced in MDX.

Does the order of the keys in the collection matter to AS?

What would you expect the order keys in the DataItem to affect? Order of the members in the attribute?

For time dimension you can try and use the OrderBy or OrderByAttribute to order memebers.

See how Date dimension in AdventureWorks sample database is built.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

That's just it...I don't expect that it would change anything. The key collection, naming property, order, and value are all set appropriately. Everthing seems to be working fine. Moving one before the other seems to have no effect.

However, I've learned just enough about AS to know that not everything is documented nor are the effects of seemingly trivial settings like this. I just don't want this to come back and bite me later.

Thanks for your reply Edward.

key/value pair table update query

I'm working with a table that I've created called Config which contains key/value pairs used to get and set site-wide settings. I'm now trying to create a web form which updates the table but I'm not sure how to create the most effective UPDATE query.

Table of course takes this form key | value
----------
config_setting1 | value1
config_setting2 | value2

I'm working with a System.Collections.Specialized.StringDictionary Class object which contains all of the pairs from my webform... anybody have a creative way to build an UPDATE string using this object?

Thanks for any help and suggestions,
ecolner@.yahoo.comI suggest you to create static method to your database class that updates the configuration. The idea is simple.

1) Create parameterized SqlCommand for updates (update conf set value=@.value where setting=@.setting).
2) Start database transaction.
3) Iterate through you string dictionary and on every turn evaluate @.value and @.setting parameters again and then execute the command.
4) If there is errors then roll back database changes, otherwise commit the changes
5) Dispose the update command

Key/Index Questions

I have some simple questions about database design in MSSQL2005. My background
is primarily writing code, but I do understand databases, however I'm (fairly)
new to MSSQL.
My database is to be a single primary table (we`ll call it P) with other tables
(say, about 10-15) being related like this: P <-->> X
Every table has an Identity column which is also the defined Primary Key for
that table.
It's possible that Table P could have up to a million rows, and each Table X
could have up to between 3-10 rows each related to a single row in Table P.
It's a simple database really, but could get large in scope.
My question has to do with Keys and Indexes on these tables, and I guess I'm
having difficulty (in MSSQL terms) understanding what is a "rule" of the
database and what is a "part" of the database. I'm confused when declaring a
KEY (CONSTRAINT) - does that actually creates a "key/index"?
It seems when I declare a Primary Key constraint, then an Index gets created
automatically. But I'm not sure about declaring a Foreign Key on a child table
- does that create an Index or not?
I also want to design it best for performance too<g>. Each and every row will
be INSERTed and/or UPDATEd individually and very few (if any) DELETES will take
place.
Do I absolutely need to specify a FOREIGN KEY on every child table? My
understanding is that if I do have a FOREGN KEY, then any UPDATE on a child row
will cause a referential check to be made on the parent...maybe causing a
performance issue if the tables were large. Will the database perform well, evn
if I do not specify Foreign Keys?
Whether or not, I specify FOREIGN KEYS on tables X, do I need INDEXes on the
columns that relate to the parent table P? I am pretty sure I do, especially if
I execute a SELECT statement like this:
SELECT columns FROM TableX where FK_Column = 'value'
Thanks BrianBrian, see inline
Brian Staff wrote:
> I have some simple questions about database design in MSSQL2005. My background
> is primarily writing code, but I do understand databases, however I'm (fairly)
> new to MSSQL.
> My database is to be a single primary table (we`ll call it P) with other tables
> (say, about 10-15) being related like this: P <-->> X
> Every table has an Identity column which is also the defined Primary Key for
> that table.
Yuck. Different people have different opinions about this. My opinion is
that an Identity column should not be added out of convention. IMO, it
should be added if no other (proper) key is available, which is highly
unlikely to be the case for all your 10-15 tables...
> It's possible that Table P could have up to a million rows, and each Table X
> could have up to between 3-10 rows each related to a single row in Table P.
> It's a simple database really, but could get large in scope.
> My question has to do with Keys and Indexes on these tables, and I guess I'm
> having difficulty (in MSSQL terms) understanding what is a "rule" of the
> database and what is a "part" of the database. I'm confused when declaring a
> KEY (CONSTRAINT) - does that actually creates a "key/index"?
A "rule" is a type of generic check constraint that can be tagged to any
table. Rules are deprecated and in my experience nobody uses them
(because they are a hassle). Best to forget about them.
I have no idea what "part" refers to. I don't think there is an MSSQL
concept called "part".
> It seems when I declare a Primary Key constraint, then an Index gets created
> automatically. But I'm not sure about declaring a Foreign Key on a child table
> - does that create an Index or not?
Only a Primary Key constraint and a Unique constraint will automatically
create a corresponding (unique) index. If you want your Foreign Key
indexed, then you have to add such an index yourself.
> I also want to design it best for performance too<g>. Each and every row will
> be INSERTed and/or UPDATEd individually and very few (if any) DELETES will take
> place.
> Do I absolutely need to specify a FOREIGN KEY on every child table?
I don't know. If you want to ensure data integrity, then you need it. If
you don't care, or think all data modifications will be done through
your application, and you handle the data integrity in your application,
then you can choose to omit the foreign key constraint - at your own
risk.
> My
> understanding is that if I do have a FOREGN KEY, then any UPDATE on a child row
> will cause a referential check to be made on the parent...
Correct.
> maybe causing a performance issue if the tables were large.
Possible, but unlikely. Although you will see more reads (and therefore
potential I/O) and more locking/blocking.
> Will the database perform well, evn if I do not specify Foreign Keys?
Foreign Keys are not primarily for performance. In most cases they don't
help SELECT performance, but they never hinder either. They mostly
affect the performance of data modifications (negatively).
> Whether or not, I specify FOREIGN KEYS on tables X, do I need INDEXes on the
> columns that relate to the parent table P? I am pretty sure I do, especially if
> I execute a SELECT statement like this:
> SELECT columns FROM TableX where FK_Column = 'value'
If this FK_Column is not the first column of the Primary Key, then such
a query would definitely benefit from an index.
Also, such an index helps if you have the Foreign Key in place, and you
delete a row from the referenced table (in your case table P).
HTH,
Gert-Jan
> Thanks Brian
>|||Nice reply Gert-Jan, after reading yours, I deleted mine.
One note: DOUBLE & TRIPLE YUCK on making all PK's IDENTITY.
Besides what Gert-Jan said (which I agree with), if you ever decide to use
Distributed Partition Views across multiple nodes of a cluster, you won't be
able to select all relevant data in a select from a single server - and
performance will suck.
The only time I even consider IDENTITY for a PK on something other than a
parent table is when I'm getting into many part compound PK's - and even
then I look real hard for something better.
Jay
PS. Sorry, pet peeve.
"Gert-Jan Strik" <sorry@.toomuchspamalready.nl> wrote in message
news:46C9ECDD.A2606551@.toomuchspamalready.nl...
> Brian, see inline
> Brian Staff wrote:
>> I have some simple questions about database design in MSSQL2005. My
>> background
>> is primarily writing code, but I do understand databases, however I'm
>> (fairly)
>> new to MSSQL.
>> My database is to be a single primary table (we`ll call it P) with other
>> tables
>> (say, about 10-15) being related like this: P <-->> X
>> Every table has an Identity column which is also the defined Primary Key
>> for
>> that table.
> Yuck. Different people have different opinions about this. My opinion is
> that an Identity column should not be added out of convention. IMO, it
> should be added if no other (proper) key is available, which is highly
> unlikely to be the case for all your 10-15 tables...
>> It's possible that Table P could have up to a million rows, and each
>> Table X
>> could have up to between 3-10 rows each related to a single row in Table
>> P.
>> It's a simple database really, but could get large in scope.
>> My question has to do with Keys and Indexes on these tables, and I guess
>> I'm
>> having difficulty (in MSSQL terms) understanding what is a "rule" of the
>> database and what is a "part" of the database. I'm confused when
>> declaring a
>> KEY (CONSTRAINT) - does that actually creates a "key/index"?
> A "rule" is a type of generic check constraint that can be tagged to any
> table. Rules are deprecated and in my experience nobody uses them
> (because they are a hassle). Best to forget about them.
> I have no idea what "part" refers to. I don't think there is an MSSQL
> concept called "part".
>> It seems when I declare a Primary Key constraint, then an Index gets
>> created
>> automatically. But I'm not sure about declaring a Foreign Key on a child
>> table
>> - does that create an Index or not?
> Only a Primary Key constraint and a Unique constraint will automatically
> create a corresponding (unique) index. If you want your Foreign Key
> indexed, then you have to add such an index yourself.
>> I also want to design it best for performance too<g>. Each and every row
>> will
>> be INSERTed and/or UPDATEd individually and very few (if any) DELETES
>> will take
>> place.
>> Do I absolutely need to specify a FOREIGN KEY on every child table?
> I don't know. If you want to ensure data integrity, then you need it. If
> you don't care, or think all data modifications will be done through
> your application, and you handle the data integrity in your application,
> then you can choose to omit the foreign key constraint - at your own
> risk.
>> My
>> understanding is that if I do have a FOREGN KEY, then any UPDATE on a
>> child row
>> will cause a referential check to be made on the parent...
> Correct.
>> maybe causing a performance issue if the tables were large.
> Possible, but unlikely. Although you will see more reads (and therefore
> potential I/O) and more locking/blocking.
>> Will the database perform well, evn if I do not specify Foreign Keys?
> Foreign Keys are not primarily for performance. In most cases they don't
> help SELECT performance, but they never hinder either. They mostly
> affect the performance of data modifications (negatively).
>> Whether or not, I specify FOREIGN KEYS on tables X, do I need INDEXes on
>> the
>> columns that relate to the parent table P? I am pretty sure I do,
>> especially if
>> I execute a SELECT statement like this:
>> SELECT columns FROM TableX where FK_Column = 'value'
> If this FK_Column is not the first column of the Primary Key, then such
> a query would definitely benefit from an index.
> Also, such an index helps if you have the Foreign Key in place, and you
> delete a row from the referenced table (in your case table P).
> HTH,
> Gert-Jan
>> Thanks Brian|||> Yuck. Different people have different opinions about this. My opinion is
> that an Identity column should not be added out of convention. IMO, it
> should be added if no other (proper) key is available, which is highly
> unlikely to be the case for all your 10-15 tables...
Hmmm! I see your YUCK was "raised"...twice by Jay
That's taken the wind out of my sails. I thought I was doing well in my design
especially with that part<g>. My theory on Primary Keys is that they should be
preferably be one column and numeric, since searching by alpha and/or multiple
columns would undoubtedly be slower.
Obviously a PK needs to be unique, so I'll re-examine all of the child tables
again, but I have to say that advice does not sit well with my understanding of how
databases work. One question...why is having the identity column be the PK such a
bad idea? - apart from just "yuck!"
BTW - thanks on all of the other advice - that helps a lot.
Brian|||Brian Staff wrote:
> > Yuck. Different people have different opinions about this. My opinion is
> > that an Identity column should not be added out of convention. IMO, it
> > should be added if no other (proper) key is available, which is highly
> > unlikely to be the case for all your 10-15 tables...
> Hmmm! I see your YUCK was "raised"...twice by Jay
> That's taken the wind out of my sails. I thought I was doing well in my design
> especially with that part<g>. My theory on Primary Keys is that they should be
> preferably be one column and numeric, since searching by alpha and/or multiple
> columns would undoubtedly be slower.
> Obviously a PK needs to be unique, so I'll re-examine all of the child tables
> again, but I have to say that advice does not sit well with my understanding of how
> databases work. One question...why is having the identity column be the PK such a
> bad idea? - apart from just "yuck!"
> BTW - thanks on all of the other advice - that helps a lot.
> Brian
There are reasons why many (including me) prefer a natural key over a
surrogate key. IMO, an Identity is a good choice for a surrogate key. If
you google natural vs surrogate key you will probably find a whole lot
of information on that debate.
So I am not saying that having an Identity column as the Primary Key is
not bad per se. However, a table with a foreign key very often has the
meaning of a relation table. If you take the classic example of the
table that describes which book was written by which author. This table
would have a foreign key to the Authors table, and a foreign key to the
Books table. You want the combination of author-book to be unique, so
what simpler choice that to make (author, book) the primary key of this
table? No need to add a surrogate key, very useful index on the primary
key, no need to add another constraint to make the combination
author-book unique, etc.
Now you might argue that in the example above, the primary key of the
BookAuthors table might have been an Identity column and that that key
is narrower and therefore better for performance. But in practice that
is not the case. Because you would join to this table most of the time
(or rather: almost all of the time), and the join requires access to
either/both column author_id and/or book_id. In this example, the
Identity primary key would only perform better if you were to query the
exact Primary Key value.
So if you are going to join a lot of your 10-15 tables to your table P,
then the choice of your primary key and/or the indexes on your foreign
keys is very important.
Gert-Jan|||Gert-Jan,
Thanks for your explanation. I will look carefully at my table data and
re-evaluate the PK choice.
Brian|||> There are reasons why many (including me) prefer a natural key over a
> surrogate key. IMO, an Identity is a good choice for a surrogate key. If
> you google natural vs surrogate key you will probably find a whole lot
> of information on that debate.
> So I am not saying that having an Identity column as the Primary Key is
> not bad per se. However, a table with a foreign key very often has the
> meaning of a relation table. If you take the classic example of the
> table that describes which book was written by which author. This table
> would have a foreign key to the Authors table, and a foreign key to the
> Books table. You want the combination of author-book to be unique, so
> what simpler choice that to make (author, book) the primary key of this
> table? No need to add a surrogate key, very useful index on the primary
> key, no need to add another constraint to make the combination
> author-book unique, etc.
> Now you might argue that in the example above, the primary key of the
> BookAuthors table might have been an Identity column and that that key
> is narrower and therefore better for performance. But in practice that
> is not the case. Because you would join to this table most of the time
> (or rather: almost all of the time), and the join requires access to
> either/both column author_id and/or book_id. In this example, the
> Identity primary key would only perform better if you were to query the
> exact Primary Key value.
> So if you are going to join a lot of your 10-15 tables to your table P,
> then the choice of your primary key and/or the indexes on your foreign
> keys is very important.
> Gert-Jan
My primary objection is that an IDENTITY PK usually does not describe the
data in the column, that function is taken up by indexes and non-identifying
FK's. In Gert-Jan's example a row in BookAuthors is described by the
combination of book_id and author_id, not some arbitrary IDENTITY column.
This BTW, is in large part, the definition of 3NF.
For a good description on database normilaztion:
http://www.datamodel.org/NormalizationRules.html
Jay|||This model that I was working on, as well as another one that I work
on daily, are the reasons that I have come to be wary of the surrogate
key.
create table dbo.items (
item_num varchar(16) not null,
item_desc varchar(32) not null,
constraint pk_items
primary key(item_num),
constraint u_nc_item_desc
unique(item_desc))
create table dbo.customers (
cust_name varchar(32) not null,
constraint pk_customers
primary key(cust_name))
create table dbo.cust_items (
cust_item_num varchar(16) not null,
cust_name varchar(32) not null,
constraint pk_cust_items
primary key(cust_item_num, cust_name),
constraint fk_cust_items_customers
foreign key(cust_name)
references customers(cust_name)
on update cascade)
create table dbo.cust_item_cross_ref (
cust_item_num varchar(16) not null,
cust_name varchar(32) not null,
item_num varchar(16) not null,
constraint pk_cust_item_cross_ref
primary key(cust_name, cust_item_num),
constraint u_nc_item_customer
unique(cust_name, item_num),
constraint fk_cust_item_cross_ref_items
foreign key(item_num)
references dbo.items(item_num)
on update cascade,
constraint fk_cust_item_cross_ref_cust_items
foreign key(cust_item_num, cust_name)
references dbo.cust_items(cust_item_num, cust_name)
on update cascade)
The cust_item_cross_ref table was the source of my difficulty.
The business rules surrounding this table are simply this:
1. Each of our items can be referenced by a customer once.
- covered by u_nc_item_customer
2. Each customer_item can be referenced once.
- covered by pk_cust_item_cross_ref
3. Each item can be referenced to multiple customer_items
If I had used a surrogate key in the cust_items table then I would
have a very interesting time in trying to enforce my business rules at
the cross_ref table. Example below:
create table dbo.cust_items_id (
cust_item_id int identity(1,1),
cust_item_num varchar(16) not null,
cust_name varchar(32) not null,
constraint pk_cust_items
primary key (cust_item_id),
constraint nk_cust_items
primary key(cust_item_num, cust_name),
constraint fk_cust_items_customers
foreign key(cust_name)
references dbo.customers(cust_name)
on update cascade)
create table dbo.cust_item_cross_ref_id (
cust_item_id int not null,
item_num varchar(16) not null,
constraint pk_cust_item_cross_ref
primary key(cust_item_id),
constraint fk_cust_item_cross_ref_items
foreign key(item_num)
references dbo.items(item_num)
on update cascade,
constraint fk_cust_item_cross_ref_cust_items
foreign key(cust_item_id)
references dbo.cust_items(cust_item_id)
on update cascade)
This does not allow me to enforce my second requirement. See the
sample data.
insert into items (item_num, item_desc) values ('Item A', 'Item A')
insert into items (item_num, item_desc) values ('Item B', 'Item B')
insert into customers (cust_name) values ('Cust A')
insert into cust_items (cust_item_num, cust_name) values ('AA', 'Cust
A')
insert into cust_items (cust_item_num, cust_name) values ('AB', 'Cust
A')
insert into cust_items_id (cust_item_num, cust_name) values ('AA',
'Cust A') -- id = 1
insert into cust_items_id (cust_item_num, cust_name) values ('AB',
'Cust A') -- id = 2
In this example I have two items and one customer who has two items.
Both methods prevent me from assigning a customer item to two of my
items. That rule is well enforced. However, in the surrogate key
method, I cannot enforce the other rule. I can freely assign 'Item A'
to cust_id = 1 and to cust_id = 2.
The method that I came up with to solve the problem was either a
trigger (bad...) or to create an indexed view.
create view dbo.bandaid_view with schemabinding
as
select
ci.cust_name,
cr.item_num
from
dbo.cust_item_cross_ref_id as cr
inner join dbo.cust_items_id as ci
on cr.cust_item_id = ci.cust_item_id
go
create unique clustered index u_bandaid on dbo.bandaid_view(cust_name,
item_num)
That solution worked, and would could be used in future. Since I'm
not sold on the performance issue of natural keys vs surrogate keys,
I'll have to stick with the natural keys for now. That may change in
the future, but it will stay this way for now.
Cheers,
Jason Lepack
On Aug 20, 9:34 pm, "JayKon" <s...@.nospam.org> wrote:
> > There are reasons why many (including me) prefer a natural key over a
> > surrogate key. IMO, an Identity is a good choice for a surrogate key. If
> > you google natural vs surrogate key you will probably find a whole lot
> > of information on that debate.
> > So I am not saying that having an Identity column as the Primary Key is
> > not bad per se. However, a table with a foreign key very often has the
> > meaning of a relation table. If you take the classic example of the
> > table that describes which book was written by which author. This table
> > would have a foreign key to the Authors table, and a foreign key to the
> > Books table. You want the combination of author-book to be unique, so
> > what simpler choice that to make (author, book) the primary key of this
> > table? No need to add a surrogate key, very useful index on the primary
> > key, no need to add another constraint to make the combination
> > author-book unique, etc.
> > Now you might argue that in the example above, the primary key of the
> > BookAuthors table might have been an Identity column and that that key
> > is narrower and therefore better for performance. But in practice that
> > is not the case. Because you would join to this table most of the time
> > (or rather: almost all of the time), and the join requires access to
> > either/both column author_id and/or book_id. In this example, the
> > Identity primary key would only perform better if you were to query the
> > exact Primary Key value.
> > So if you are going to join a lot of your 10-15 tables to your table P,
> > then the choice of your primary key and/or the indexes on your foreign
> > keys is very important.
> > Gert-Jan
> My primary objection is that an IDENTITY PK usually does not describe the
> data in the column, that function is taken up by indexes and non-identifying
> FK's. In Gert-Jan's example a row in BookAuthors is described by the
> combination of book_id and author_id, not some arbitrary IDENTITY column.
> This BTW, is in large part, the definition of 3NF.
> For a good description on database normilaztion:
> http://www.datamodel.org/NormalizationRules.html
> Jay- Hide quoted text -
> - Show quoted text -

Key word "Like"

Can anyone find what is wrong with this? I think I am using the keyword "Like" correctly. I am trying to enforce some rules by doing this this way. No obvious typos or syntax errors are jumping out at me.

CREATE DATABASE VetClinic

ON

(NAME='VetClinic',

FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\data\VetClinic.mdf',

SIZE = 100MB,

MAXSIZE = 500MB,

FILEGROWTH = 10MB)

LOG ON

(NAME = 'VetClinicLog',

FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\data\VetClinic.ldf',

SIZE = 5MB,

MAXSIZE = 25MB,

FILEGROWTH = 5MB)

GO

CREATE TABLE Customers

(

CustID int IDENTITY NOT NULL PRIMARY KEY,

FirstName varchar(15) NOT NULL,

LastName varchar(15) NOT NULL,

StreetAddress varchar(25) NOT NULL,

City varchar(20) NOT NULL,

CustState char(2) NOT NULL,

Zip varchar(10) NOT NULL,

Phone1 char(13) NOT NULL

LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]",

Phone2 char(13) NULL

LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]",

Email varchar(30) NULL,

DateInSystem smalldatetime NOT NULL

DEFAULT GETDATE()

)

GO

CREATE TABLE PetDetails

(

PetID int IDENTITY NOT NULL PRIMARY KEY,

CustID int NOT NULL

FOREIGN KEY REFERENCES Customers(CustID),

PetName varchar(20) NOT NULL,

BreedID int NOT NULL,

Gender char(1) NOT NULL

LIKE "m" OR "f",

Weight decimal NOT NULL,

DOB smalldatetime NULL,

DateFixed smalldatetime NULL,

DateLastSeen smalldatetime NULL,

VetLastSeen int NULL

)

GO

CREATE TABLE Employees

(

EmpID int IDENTITY NOT NULL PRIMARY KEY,

PositionID int NOT NULL

FOREIGN KEY REFERENCES Positions(PositionID),

FirstName varchar(15) NOT NULL,

LastName varchar(15) NOT NULL,

SSN char(11) NOT NULL

LIKE "[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]",

StreetAddress varchar(25) NOT NULL,

City varchar(20) NOT NULL,

CustState char(2) NOT NULL,

Zip varchar(10) NOT NULL,

Phone1 char(13) NOT NULL

LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]",

Phone2 char(13) NULL

LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]",

Email varchar(30) NULL,

DateInSystem smalldatetime NOT NULL

DEFAULT GETDATE(),

HireDate smalldatetime NOT NULL,

TerminationDate smalldatetime NOT NULL,

PaySatus char(6) NOT NULL

LIKE "hourly" OR "salary",

PayAmount money NOT NULL

)

GO

CREATE TABLE Appointment

(

ApptID int IDENTITY NOT NULL PRIMARY KEY,

EmpID int NOT NULL,

ApptDate smalldatetime NOT NULL,

ApptTime smalldatetime NOT NULL,

PetID int NOT NULL,

CustID int NOT NULL,

)

GO

CREATE TABLE PetProcedures

(

ProcedureID int IDENTITY NOT NULL PRIMARY KEY,

ProcedureDescrip varchar(20) NOT NULL,

Cost money NOT NULL

)

GO

CREATE TABLE Breed

(

BreedID int IDENTITY NOT NULL PRIMARY KEY,

BreedName varchar(20) NOT NULL

)

GO

CREATE TABLE Prescriptions

(

PrescriptionID int IDENTITY NOT NULL PRIMARY KEY,

PetID int NOT NULL,

MedID int NOT NULL,

EmpID int NOT NULL,

DatePrescribed smalldatetime NOT NULL

)

GO

CREATE TABLE Medications

(

MedID int IDENTITY NOT NULL PRIMARY KEY,

MedName varchar(30) NOT NULL,

MedType varchar(20) NOT NULL,

Dosage varchar(20) NULL,

Frequency varchar(10) NOT NULL

LIKE "daily", "weekly", "monthly" OR "annually"

)

GO

CREATE TABLE Positions

(

PositionID int IDENTITY NOT NULL PRIMARY KEY,

PositionName varchar(20) NOT NULL

LIKE "vet", "tech", "front desk" OR "office manager"

)

- --

Here are the errors that I got

Msg 156, Level 15, State 1, Line 12

Incorrect syntax near the keyword 'LIKE'.

Msg 156, Level 15, State 1, Line 10

Incorrect syntax near the keyword 'LIKE'.

Msg 156, Level 15, State 1, Line 10

Incorrect syntax near the keyword 'LIKE'.

Msg 156, Level 15, State 1, Line 9

Incorrect syntax near the keyword 'LIKE'.

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'LIKE'.

I will fix the first table, you can do the rest...

Code Snippet

CREATE TABLE Customers

(

CustID int IDENTITY NOT NULL PRIMARY KEY,

FirstName varchar(15) NOT NULL,

LastName varchar(15) NOT NULL,

StreetAddress varchar(25) NOT NULL,

City varchar(20) NOT NULL,

CustState char(2) NOT NULL,

Zip varchar(10) NOT NULL,

Phone1 char(13) NOT NULL

constraint chk1 CHECK (Phone1 LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]"),

Phone2 char(13) NULL

constraint chk2 CHECK (Phone2 LIKE "([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]"),

Email varchar(30) NULL,

DateInSystem smalldatetime NOT NULL

DEFAULT GETDATE()

)

key violation, general sql error, connectin busy with another hstmt

We are getting this error periodically in a large app we are converting
from Access to SQL Server 2000. It uses BDE and ODBC for data access
and TTable/TQuery as well as TwwTable/TwwQuery components (from
woll2woll) under Delphi 6. It appears to happen when we are executing
TQuery.Open.
From what I've read, this is caused by ODBC not completing a result set
before processing another request. Which might be caused by having
queries run in multiple threads, but this is not the case."Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:%23OgCxf7FGHA.1396@.TK2MSFTNGP11.phx.gbl...
> We are getting this error periodically in a large app we are
> converting
> from Access to SQL Server 2000. It uses BDE and ODBC for data
> access
> and TTable/TQuery as well as TwwTable/TwwQuery components (from
> woll2woll) under Delphi 6. It appears to happen when we are
> executing
> TQuery.Open.
> From what I've read, this is caused by ODBC not completing a
> result set
> before processing another request. Which might be caused by
> having
> queries run in multiple threads, but this is not the case.
Basically, you can't have two open (SELECT) statements on the
same connection. For example,
Open query 1
Get some info from a record
Use that to set params in query 2
Open query 2 -- This will fail
This assumes both statements are attached to the same hDBC. It
is a result of using a client-side cursor for the hStmt's.
You'll have to use server-side cursors for the statements to make
this work. See MSDN.
This is one way to force a server-side cursor:
SQLSetStmtAttr( m_hStmt, SQL_ATTR_CURSOR_SCROLLABLE,
(SQLPOINTER) SQL_SCROLLABLE, 0 );
Good luck,
- Arnie|||So you can never have 2 open queries? I do that all the time, in one
thread. Maybe I'm not understanding. For example, this code works
fine, which creates 101 open queries:
--
procedure TForm1.ManyQueriesClick(Sender: TObject);
var qs : array[0..100] of TQuery ;
var q : Tquery;
var i : Integer;
begin
for i := 0 to 100 do begin
qs[i] := TQuery.Create(self);
q := qs[i];
q.databasename := 'WM';
q.SQL.Clear;
q.SQL.Add('SELECT * FROM CUSTOMERFIELDS');
statusbar1.SimpleText := 'Query ' + IntToStr(i);
q.active := true;
end;
for i := 0 to 100 do
qs[i].Free;
end;|||Arnie wrote:

> "Doug Stephens" <dougstephens@.rogers.com> wrote in message
> news:%23OgCxf7FGHA.1396@.TK2MSFTNGP11.phx.gbl...
> Basically, you can't have two open (SELECT) statements on the same
> connection. For example,
> Open query 1
> Get some info from a record
> Use that to set params in query 2
> Open query 2 -- This will fail
> This assumes both statements are attached to the same hDBC. It is a
> result of using a client-side cursor for the hStmt's. You'll have to
> use server-side cursors for the statements to make this work. See
> MSDN.
> This is one way to force a server-side cursor:
> SQLSetStmtAttr( m_hStmt, SQL_ATTR_CURSOR_SCROLLABLE, (SQLPOINTER)
> SQL_SCROLLABLE, 0 );
>
> Good luck,
> - Arnie
How can I run SQLSetStmtAttr from Delphi?|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:uVMztRHGGHA.2012@.TK2MSFTNGP14.phx.gbl...
> How can I run SQLSetStmtAttr from Delphi?
You can't. It's an ODBC statement. The equivalent in Delphi
would be CursorLocation := clUseServer for TADO components.
Sorry, but I've totally forgotten about the BDE. It may use
server-side cursors by default.
The problem occurs in ODBC when nesting queries that use the same
connection handle. Open q1, read some field values, use these to
set params in q2 and then open q2. This last open will cause the
error. In theory, SQL Server 2005 has 'fixed' this 'feature',
though I haven't tried it yet.
- Arnie|||I found a way to call this function in ODBC32.DLL from Delphi but what
is the hstmt?|||We have same problem with 2005.|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:e3UtnUqGGHA.2000@.TK2MSFTNGP15.phx.gbl...
> We have same problem with 2005.
What DB objects are you using with 2005?
- Arnie|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:OfWhHUqGGHA.2000@.TK2MSFTNGP15.phx.gbl...
>I found a way to call this function in ODBC32.DLL from Delphi
>but what
> is the hstmt?
As far as I know, you'd have to be using ODBC directly rather
than the BDE. hStmt is the ODBC statement handle.
- Arnie|||Uh, tables and indexes. No stored procs. Is that what you mean?

key violation, general sql error, connectin busy with another hstmt

We are getting this error periodically in a large app we are converting
from Access to SQL Server 2000. It uses BDE and ODBC for data access
and TTable/TQuery as well as TwwTable/TwwQuery components (from
woll2woll) under Delphi 6. It appears to happen when we are executing
TQuery.Open.
From what I've read, this is caused by ODBC not completing a result set
before processing another request. Which might be caused by having
queries run in multiple threads, but this is not the case.
"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:%23OgCxf7FGHA.1396@.TK2MSFTNGP11.phx.gbl...
> We are getting this error periodically in a large app we are
> converting
> from Access to SQL Server 2000. It uses BDE and ODBC for data
> access
> and TTable/TQuery as well as TwwTable/TwwQuery components (from
> woll2woll) under Delphi 6. It appears to happen when we are
> executing
> TQuery.Open.
> From what I've read, this is caused by ODBC not completing a
> result set
> before processing another request. Which might be caused by
> having
> queries run in multiple threads, but this is not the case.
Basically, you can't have two open (SELECT) statements on the
same connection. For example,
Open query 1
Get some info from a record
Use that to set params in query 2
Open query 2 -- This will fail
This assumes both statements are attached to the same hDBC. It
is a result of using a client-side cursor for the hStmt's.
You'll have to use server-side cursors for the statements to make
this work. See MSDN.
This is one way to force a server-side cursor:
SQLSetStmtAttr( m_hStmt, SQL_ATTR_CURSOR_SCROLLABLE,
(SQLPOINTER) SQL_SCROLLABLE, 0 );
Good luck,
- Arnie
|||So you can never have 2 open queries? I do that all the time, in one
thread. Maybe I'm not understanding. For example, this code works
fine, which creates 101 open queries:
procedure TForm1.ManyQueriesClick(Sender: TObject);
var qs : array[0..100] of TQuery ;
var q : Tquery;
var i : Integer;
begin
for i := 0 to 100 do begin
qs[i] := TQuery.Create(self);
q := qs[i];
q.databasename := 'WM';
q.SQL.Clear;
q.SQL.Add('SELECT * FROM CUSTOMERFIELDS');
statusbar1.SimpleText := 'Query ' + IntToStr(i);
q.active := true;
end;
for i := 0 to 100 do
qs[i].Free;
end;
|||Arnie wrote:

> "Doug Stephens" <dougstephens@.rogers.com> wrote in message
> news:%23OgCxf7FGHA.1396@.TK2MSFTNGP11.phx.gbl...
> Basically, you can't have two open (SELECT) statements on the same
> connection. For example,
> Open query 1
> Get some info from a record
> Use that to set params in query 2
> Open query 2 -- This will fail
> This assumes both statements are attached to the same hDBC. It is a
> result of using a client-side cursor for the hStmt's. You'll have to
> use server-side cursors for the statements to make this work. See
> MSDN.
> This is one way to force a server-side cursor:
> SQLSetStmtAttr( m_hStmt, SQL_ATTR_CURSOR_SCROLLABLE, (SQLPOINTER)
> SQL_SCROLLABLE, 0 );
>
> Good luck,
> - Arnie
How can I run SQLSetStmtAttr from Delphi?
|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:uVMztRHGGHA.2012@.TK2MSFTNGP14.phx.gbl...
> How can I run SQLSetStmtAttr from Delphi?
You can't. It's an ODBC statement. The equivalent in Delphi
would be CursorLocation := clUseServer for TADO components.
Sorry, but I've totally forgotten about the BDE. It may use
server-side cursors by default.
The problem occurs in ODBC when nesting queries that use the same
connection handle. Open q1, read some field values, use these to
set params in q2 and then open q2. This last open will cause the
error. In theory, SQL Server 2005 has 'fixed' this 'feature',
though I haven't tried it yet.
- Arnie
|||I found a way to call this function in ODBC32.DLL from Delphi but what
is the hstmt?
|||We have same problem with 2005.
|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:e3UtnUqGGHA.2000@.TK2MSFTNGP15.phx.gbl...
> We have same problem with 2005.
What DB objects are you using with 2005?
- Arnie
|||"Doug Stephens" <dougstephens@.rogers.com> wrote in message
news:OfWhHUqGGHA.2000@.TK2MSFTNGP15.phx.gbl...
>I found a way to call this function in ODBC32.DLL from Delphi
>but what
> is the hstmt?
As far as I know, you'd have to be using ODBC directly rather
than the BDE. hStmt is the ODBC statement handle.
- Arnie
|||Uh, tables and indexes. No stored procs. Is that what you mean?

Key Violation during synchronization

Dear Friends

I restored same database in Publisher & subscriber.If I want to apply Transactional replication I have to apply initial snapshot.then I am getting key-violation problems during initialization .Some times Primary key table will be dropped before foreign key table.sometimes it won't able to drop some indexes.This I am getting if I am going for all tables of database.But here i need all tables.If I am going for selective table I don't have any problem.For avoiding this problem I tried all the options in table article option in publication wizard.But some na some key violation I am getting always.So please give me some better suggestion

Thanks in Advance

Filson

hi,

though i haven't done this

how about having a snapshot replication for the table that

encounter the key violation?

When your transaction replication encounters a key violation

run the snapshot replication.

this will work if there is no updating from the subscriber.

works like a multiple publication -multiple subscriber topology

regards,

|||

Sounds like you are trying to initialize a subscription with a backup. You may want to check the following document in book online to see if it helps.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/75c8c1f8-60bc-44a8-944b-d18d1f6bda11.htm

Gary

|||

Gary I won't able to find this document in net.Can you give me it as a link.

Thanks

Filson

|||

You can access the article on web from here.

http://msdn2.microsoft.com/en-us/library/ms151705.aspx

FYI, the previous link I post is for SQL Server Book Online.

Cheers,

Gary

Key Violation during synchronization

Dear Friends

I restored same database in Publisher & subscriber.If I want to apply Transactional replication I have to apply initial snapshot.then I am getting key-violation problems during initialization .Some times Primary key table will be dropped before foreign key table.sometimes it won't able to drop some indexes.This I am getting if I am going for all tables of database.But here i need all tables.If I am going for selective table I don't have any problem.For avoiding this problem I tried all the options in table article option in publication wizard.But some na some key violation I am getting always.So please give me some better suggestion

Thanks in Advance

Filson

hi,

though i haven't done this

how about having a snapshot replication for the table that

encounter the key violation?

When your transaction replication encounters a key violation

run the snapshot replication.

this will work if there is no updating from the subscriber.

works like a multiple publication -multiple subscriber topology

regards,

|||

Sounds like you are trying to initialize a subscription with a backup. You may want to check the following document in book online to see if it helps.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/75c8c1f8-60bc-44a8-944b-d18d1f6bda11.htm

Gary

|||

Gary I won't able to find this document in net.Can you give me it as a link.

Thanks

Filson

|||

You can access the article on web from here.

http://msdn2.microsoft.com/en-us/library/ms151705.aspx

FYI, the previous link I post is for SQL Server Book Online.

Cheers,

Gary

key to db error code meaning?

tbh
Open an ERROR.LOG to see what is going on? Deadlocks?
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:OypijxhbIHA.1208@.TK2MSFTNGP03.phx.gbl...
> on a server running SQL Server 2000 we occasionally get errors. the most
> frequent ones in a recent profiler trace, for example, are 208 and 1205.
> i've been searching in vain for an explanation of what these mean. i found
> a key to severity, but not to the meaning of the errors themselves. can
> someone please point me to a guide on the subject?
> cheers,
> Tim Hanson
>
The generic error messages are in master.dbo.sysmessages. E.G.,
Select * From master.dbo.sysmessages Where error = 208
But when you actually get the errors, SQL Server will pass back a string as
well as the error message. This string will have the parameters replaced
with actual values. For example, error 208 is invalid object name, but when
you actually get the message, it will tell you which object name was
invalid. But if whatever connection method you are using is swallowing the
error text and only returning the error number, you can look it up in
sysmessages. You can also search on it in BOL. BOL doesn't have every
error, but it gives additional info about some of them.
Tom
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:%23g3a4iibIHA.4144@.TK2MSFTNGP05.phx.gbl...
> thanks. i was thinking more in terms of a table of definitions. i can find
> hints, e.g., for error 208:
>
> http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-replication-208.htm
> thought maybe there is a summary of error message meanings (or range
> categories) along the lines of what I found for "severity".
> the ones we get appear to be routine. there isn't much in the ERROR.LOGs.
> thanks again,
> tbh
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAQscEibIHA.536@.TK2MSFTNGP06.phx.gbl...
>

key to db error code meaning?

on a server running SQL Server 2000 we occasionally get errors. the most
frequent ones in a recent profiler trace, for example, are 208 and 1205.
i've been searching in vain for an explanation of what these mean. i found a
key to severity, but not to the meaning of the errors themselves. can
someone please point me to a guide on the subject?
cheers,
Tim Hansontbh
Open an ERROR.LOG to see what is going on? Deadlocks?
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:OypijxhbIHA.1208@.TK2MSFTNGP03.phx.gbl...
> on a server running SQL Server 2000 we occasionally get errors. the most
> frequent ones in a recent profiler trace, for example, are 208 and 1205.
> i've been searching in vain for an explanation of what these mean. i found
> a key to severity, but not to the meaning of the errors themselves. can
> someone please point me to a guide on the subject?
> cheers,
> Tim Hanson
>|||thanks. i was thinking more in terms of a table of definitions. i can find
hints, e.g., for error 208:
http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-replication-208.htm
thought maybe there is a summary of error message meanings (or range
categories) along the lines of what I found for "severity".
the ones we get appear to be routine. there isn't much in the ERROR.LOGs.
thanks again,
tbh
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eAQscEibIHA.536@.TK2MSFTNGP06.phx.gbl...
> tbh
> Open an ERROR.LOG to see what is going on? Deadlocks?
>
>
> "tbh" <femdev@.newsgroups.nospam> wrote in message
> news:OypijxhbIHA.1208@.TK2MSFTNGP03.phx.gbl...
>> on a server running SQL Server 2000 we occasionally get errors. the most
>> frequent ones in a recent profiler trace, for example, are 208 and 1205.
>> i've been searching in vain for an explanation of what these mean. i
>> found a key to severity, but not to the meaning of the errors themselves.
>> can someone please point me to a guide on the subject?
>> cheers,
>> Tim Hanson
>|||The generic error messages are in master.dbo.sysmessages. E.G.,
Select * From master.dbo.sysmessages Where error = 208
But when you actually get the errors, SQL Server will pass back a string as
well as the error message. This string will have the parameters replaced
with actual values. For example, error 208 is invalid object name, but when
you actually get the message, it will tell you which object name was
invalid. But if whatever connection method you are using is swallowing the
error text and only returning the error number, you can look it up in
sysmessages. You can also search on it in BOL. BOL doesn't have every
error, but it gives additional info about some of them.
Tom
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:%23g3a4iibIHA.4144@.TK2MSFTNGP05.phx.gbl...
> thanks. i was thinking more in terms of a table of definitions. i can find
> hints, e.g., for error 208:
>
> http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-replication-208.htm
> thought maybe there is a summary of error message meanings (or range
> categories) along the lines of what I found for "severity".
> the ones we get appear to be routine. there isn't much in the ERROR.LOGs.
> thanks again,
> tbh
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eAQscEibIHA.536@.TK2MSFTNGP06.phx.gbl...
>> tbh
>> Open an ERROR.LOG to see what is going on? Deadlocks?
>>
>>
>> "tbh" <femdev@.newsgroups.nospam> wrote in message
>> news:OypijxhbIHA.1208@.TK2MSFTNGP03.phx.gbl...
>> on a server running SQL Server 2000 we occasionally get errors. the most
>> frequent ones in a recent profiler trace, for example, are 208 and 1205.
>> i've been searching in vain for an explanation of what these mean. i
>> found a key to severity, but not to the meaning of the errors
>> themselves. can someone please point me to a guide on the subject?
>> cheers,
>> Tim Hanson
>>
>

Key time column for time series algorithm

Hi, all experts here,

Thank you very much for your kind attention.

I am confused on key time column selection. e.g, I want to predict monthly sales amount, then what column in date dimension should I choose to be the key time column? Is it calendar_date (the key of date dimension) column or calendar_month?

Thanks a lot for your kind advices and help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Key Time is the column that sorts your data in a series and the granularity for the column should be the same as your data. Since in your example you're predicting Monthly Sales, the Key Time should be the calendar_month.

However, the data type for key time is required to be sortable, i.e. long, double or datetime.

|||

Hi, Shuvro,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

Key Relationship

This is the message that i get when trying to assign keys when creating diagrams in visual express:

'tbh_Polls' table saved successfully
'tbh_PollOptions' table
- Unable to create relationship 'FK_tbh_PollOptions_tbh_Polls'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tbh_PollOptions_tbh_Polls". The conflict occurred in database "C:\USERS\STICKER\DOCUMENTS\MY WEB SITES\PERCSHARP\APP_DATA\ASPNETDB.MDF", table "dbo.tbh_Polls", column 'PollID'.

PollID is my primary key in tbh_Polls

And PollID is in tbh_PollOptions table

No matter what I do, I get this message, I'm Lost!

Help plz.

Thanks

hi,

It seems to me the underlying tables are already populated, and there's a row (at least) in the referencing table (tbh_PollOptions) not satisfying the relationship you like to enforce..

you could define the foreign key constraint WITH NOCHECK, meaning the already inserted rows will not be validated at constraint creation, so that the exception will not raise.. but you stay with invalid relationship in the underlying table to the referenced table.. this option, WITH NOCHECK, should be used when you already know the relationship is already satified and you do not have "bad data"..

regards

|||

So in order for me to create the relationship is to get rid of the data i have in these 2 tables and then create the fk?

That's not a proble because i only populated them with a sample data and not a real thing. I'll try that first and see if it will work.

Thanks a lot.

|||

IT WORKED

YEAAAAHHHHHH!

Thanks a milion!

You know, i only started with programing 2 months ago and i'm already hooked, especially when there are people who happen to know what's causing the bugs. Untill i learn more i'll have to ask often. so thanks!

|||

hi,

Kliker wrote:

So in order for me to create the relationship is to get rid of the data i have in these 2 tables and then create the fk?

no, you have to get rid of "bad data", that's to say the row(s) where the referencing column does/do not match the referenced table values... or fix it/them..

That's not a proble because i only populated them with a sample data and not a real thing. I'll try that first and see if it will work.

Thanks a lot.

you're welcome..

regards

Key portion of datetime 'UniqueName' varies between Trees

I have 2 trees that use the attribute Calendar date.

In the first tree, the unique name is in this format:

..[2004-02-08T00:00:00]

in the second, it does not have the T:

..[2004-02-08 00:00:00]

I guess I'm wondering why this is happening and also, how to make it so that both trees have the same format. It wasn't always this way, but something might have changed with the cube definition - I just can't see anything that would cause this. It's currently causing an issue in reporting because I convert between the tree types by slapping on the key portion of the UniqueName to the tree name. Having the T or absence of a T causes issues in this transformation.

This was found to be caused by relationship changes between attributes of one of the hierarchies.

Key not valid for use in specified state?

Hi!
I just ran into the same old problem that I got a few months back.
Reporting Server stops working and logs the message "Key not valid for use
in specified state".
I did never manage to solve the problem when it occured before but at that
time it happened on a development server, this time it is worse as it is
on one of our production servers.
I know that there was several people suffering from the same problem after
applying .Net Framework 1.1 SP1.
Did anyone find a solution?
Best regards,
Per SalmiHello Per,
Based on my research, I recommend you perform the following steps to
resolve the issue:
Step 1: Deleting the files which represent Microsoft SQL Server Reporting
Services Key Container
===============================================================
Search for files with the pattern "1aedd7b5699f3d6a88e354100b596aae_*".
These files represent the Microsoft SQL Server Reporting Services Key
Container.
Backup these files first. Then delete the original files.
You may find the file in the folder "\documents and settings\<machine
name>\aspnet\application data\microsoft\crypto\rsa\<user
sid>\1aedd7b5699f3d6a88e354100b596aae_*".
Try to start Reporting Server.
If you receive "The report server cannot decrypt the symmetric key used to
access sensitive or encrypted data in a report server database. You must
either restore a backup key or delete all encrypted content and then
restart the service. Check the documentation", please continue with the
following steps:
Step 2: Back up Reportserver and ReportserverTempDB databases
===========================================
Step 3: Reapplying the symmetric keys
==================================
1. Run Rskeymgmt -e to extract the keys
2. Run Rskeymgmt -d to delete the keys
3. Run rskeymgmt -a to reapply the keys and restart the windows service.
4. Run Rsactivate -c to activate the service
For detailed information about the RsKeyMgmt utility, please access the
following web site:
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref
/htm/cpu_rsconfig_v1_29ly.asp
I hope above information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Key not valid for use in specified state

Hi!
On thursday last week one of our clients Reporting Services installation
stopped working and reports "Key not valid for use in specified state" error
message in the log files.
This is strange as we have not done any changes to the server. It is running
Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
Anyone got similar problems or know what could cause this behaviour?
I have tried reinstalling the encryption keys and finally removing and
reinstalling the complete Reporting Services but the same error is logged
and the service doesn't work.
Best regards,
Per SalmiI am getting exactly the same problem, also in Win2k3, and have also done a
complete uninstall and reinstall of RS, to no avail.
Surely someone in Microsoft can resolve this'? I have had to abandon work
because of this error.
brian smith
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> Hi!
> On thursday last week one of our clients Reporting Services installation
> stopped working and reports "Key not valid for use in specified state"
error
> message in the log files.
> This is strange as we have not done any changes to the server. It is
running
> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
> Anyone got similar problems or know what could cause this behaviour?
> I have tried reinstalling the encryption keys and finally removing and
> reinstalling the complete Reporting Services but the same error is logged
> and the service doesn't work.
> Best regards,
> Per Salmi
>|||I have found one thing that differs between two servers we have one where RS
works perfectly and the one mentioned with the "key problem". The difference
is that the server that doesn't work has an SQL instance that was upgraded
from SQL7 but the one that works is running on a clean installed SQL2K
instance.
The OS is W2K3 on both servers.
On the one that now suffers from the problem I also had problems where the
Report Manager web application would not install/configure correctly during
install. Never got the manager to work so I used another machine for the web
application.
/Per Salmi
"Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
>I am getting exactly the same problem, also in Win2k3, and have also done a
> complete uninstall and reinstall of RS, to no avail.
> Surely someone in Microsoft can resolve this'? I have had to abandon
> work
> because of this error.
> brian smith
> "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
>> Hi!
>> On thursday last week one of our clients Reporting Services installation
>> stopped working and reports "Key not valid for use in specified state"
> error
>> message in the log files.
>> This is strange as we have not done any changes to the server. It is
> running
>> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
>> Anyone got similar problems or know what could cause this behaviour?
>> I have tried reinstalling the encryption keys and finally removing and
>> reinstalling the complete Reporting Services but the same error is logged
>> and the service doesn't work.
>> Best regards,
>> Per Salmi
>>
>|||I don't think the SQL7 upgrade is relevant - my server was a clean install
with SQL 2000. I have followed 2 possible causes on my system:
1 - the .Net Framework 1.1 SP1 update (although RS did continue for a week
or so)
2 - the fact that I originally installed the 120 day trial version of RS,
before updating it a few weeks later.
After a clean removal, including the databases, and reinstall, plus RS SP1
I'm no better off. This looks like a bug, which worries me greatly as I have
customers dependant on the product and I fear this error will suddenly occur
on their system too.
Brian
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I have found one thing that differs between two servers we have one where
RS
> works perfectly and the one mentioned with the "key problem". The
difference
> is that the server that doesn't work has an SQL instance that was upgraded
> from SQL7 but the one that works is running on a clean installed SQL2K
> instance.
> The OS is W2K3 on both servers.
> On the one that now suffers from the problem I also had problems where the
> Report Manager web application would not install/configure correctly
during
> install. Never got the manager to work so I used another machine for the
web
> application.
> /Per Salmi
> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
> >I am getting exactly the same problem, also in Win2k3, and have also done
a
> > complete uninstall and reinstall of RS, to no avail.
> > Surely someone in Microsoft can resolve this'? I have had to abandon
> > work
> > because of this error.
> >
> > brian smith
> >
> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> >> Hi!
> >>
> >> On thursday last week one of our clients Reporting Services
installation
> >> stopped working and reports "Key not valid for use in specified state"
> > error
> >> message in the log files.
> >>
> >> This is strange as we have not done any changes to the server. It is
> > running
> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
> >>
> >> Anyone got similar problems or know what could cause this behaviour?
> >>
> >> I have tried reinstalling the encryption keys and finally removing and
> >> reinstalling the complete Reporting Services but the same error is
logged
> >> and the service doesn't work.
> >>
> >> Best regards,
> >> Per Salmi
> >>
> >>
> >
> >
>|||To follow on from my earlier messaege - the error appears to relate to
something to do with encryption. I know nothing about encryption, or why it
is involved in RS, but I assume it involves licensing.
These are lines in the RS log:
aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Initializing crypto as
user: DRAKE\ASPNET
aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Exporting public key
aspnet_wp!webserver!cfc!09/24/2004-13:08:28:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
Brian
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I have found one thing that differs between two servers we have one where
RS
> works perfectly and the one mentioned with the "key problem". The
difference
> is that the server that doesn't work has an SQL instance that was upgraded
> from SQL7 but the one that works is running on a clean installed SQL2K
> instance.
> The OS is W2K3 on both servers.
> On the one that now suffers from the problem I also had problems where the
> Report Manager web application would not install/configure correctly
during
> install. Never got the manager to work so I used another machine for the
web
> application.
> /Per Salmi
> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
> >I am getting exactly the same problem, also in Win2k3, and have also done
a
> > complete uninstall and reinstall of RS, to no avail.
> > Surely someone in Microsoft can resolve this'? I have had to abandon
> > work
> > because of this error.
> >
> > brian smith
> >
> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> >> Hi!
> >>
> >> On thursday last week one of our clients Reporting Services
installation
> >> stopped working and reports "Key not valid for use in specified state"
> > error
> >> message in the log files.
> >>
> >> This is strange as we have not done any changes to the server. It is
> > running
> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
> >>
> >> Anyone got similar problems or know what could cause this behaviour?
> >>
> >> I have tried reinstalling the encryption keys and finally removing and
> >> reinstalling the complete Reporting Services but the same error is
logged
> >> and the service doesn't work.
> >>
> >> Best regards,
> >> Per Salmi
> >>
> >>
> >
> >
>|||Ok, I did never install any evaluation version of RS on this server. This
actually happened on aserver used in full production. But I moved the
reporting stuff to the other server. I am afraid that it will break on that
server too.
/Per Salmi
"Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
news:%237KuxYjoEHA.2912@.TK2MSFTNGP10.phx.gbl...
>I don't think the SQL7 upgrade is relevant - my server was a clean install
> with SQL 2000. I have followed 2 possible causes on my system:
> 1 - the .Net Framework 1.1 SP1 update (although RS did continue for a week
> or so)
> 2 - the fact that I originally installed the 120 day trial version of RS,
> before updating it a few weeks later.
> After a clean removal, including the databases, and reinstall, plus RS SP1
> I'm no better off. This looks like a bug, which worries me greatly as I
> have
> customers dependant on the product and I fear this error will suddenly
> occur
> on their system too.
> Brian
> "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
>> I have found one thing that differs between two servers we have one where
> RS
>> works perfectly and the one mentioned with the "key problem". The
> difference
>> is that the server that doesn't work has an SQL instance that was
>> upgraded
>> from SQL7 but the one that works is running on a clean installed SQL2K
>> instance.
>> The OS is W2K3 on both servers.
>> On the one that now suffers from the problem I also had problems where
>> the
>> Report Manager web application would not install/configure correctly
> during
>> install. Never got the manager to work so I used another machine for the
> web
>> application.
>> /Per Salmi
>> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
>> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
>> >I am getting exactly the same problem, also in Win2k3, and have also
>> >done
> a
>> > complete uninstall and reinstall of RS, to no avail.
>> > Surely someone in Microsoft can resolve this'? I have had to abandon
>> > work
>> > because of this error.
>> >
>> > brian smith
>> >
>> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
>> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
>> >> Hi!
>> >>
>> >> On thursday last week one of our clients Reporting Services
> installation
>> >> stopped working and reports "Key not valid for use in specified state"
>> > error
>> >> message in the log files.
>> >>
>> >> This is strange as we have not done any changes to the server. It is
>> > running
>> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
>> >>
>> >> Anyone got similar problems or know what could cause this behaviour?
>> >>
>> >> I have tried reinstalling the encryption keys and finally removing and
>> >> reinstalling the complete Reporting Services but the same error is
> logged
>> >> and the service doesn't work.
>> >>
>> >> Best regards,
>> >> Per Salmi
>> >>
>> >>
>> >
>> >
>>
>|||Seems like exactly the same error I get.
/Per Salmi
"Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
news:eIYFOhjoEHA.3424@.TK2MSFTNGP12.phx.gbl...
> To follow on from my earlier messaege - the error appears to relate to
> something to do with encryption. I know nothing about encryption, or why
> it
> is involved in RS, but I assume it involves licensing.
> These are lines in the RS log:
> aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Initializing crypto as
> user: DRAKE\ASPNET
> aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Exporting public key
> aspnet_wp!webserver!cfc!09/24/2004-13:08:28:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
> for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
>
> Brian
> "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
>> I have found one thing that differs between two servers we have one where
> RS
>> works perfectly and the one mentioned with the "key problem". The
> difference
>> is that the server that doesn't work has an SQL instance that was
>> upgraded
>> from SQL7 but the one that works is running on a clean installed SQL2K
>> instance.
>> The OS is W2K3 on both servers.
>> On the one that now suffers from the problem I also had problems where
>> the
>> Report Manager web application would not install/configure correctly
> during
>> install. Never got the manager to work so I used another machine for the
> web
>> application.
>> /Per Salmi
>> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
>> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
>> >I am getting exactly the same problem, also in Win2k3, and have also
>> >done
> a
>> > complete uninstall and reinstall of RS, to no avail.
>> > Surely someone in Microsoft can resolve this'? I have had to abandon
>> > work
>> > because of this error.
>> >
>> > brian smith
>> >
>> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
>> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
>> >> Hi!
>> >>
>> >> On thursday last week one of our clients Reporting Services
> installation
>> >> stopped working and reports "Key not valid for use in specified state"
>> > error
>> >> message in the log files.
>> >>
>> >> This is strange as we have not done any changes to the server. It is
>> > running
>> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
>> >>
>> >> Anyone got similar problems or know what could cause this behaviour?
>> >>
>> >> I have tried reinstalling the encryption keys and finally removing and
>> >> reinstalling the complete Reporting Services but the same error is
> logged
>> >> and the service doesn't work.
>> >>
>> >> Best regards,
>> >> Per Salmi
>> >>
>> >>
>> >
>> >
>>
>|||Actually I find that the .NET FW 1.1 SP1 is not installed on the server
where RS continues to work...
/Per Salmi
"Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
news:%237KuxYjoEHA.2912@.TK2MSFTNGP10.phx.gbl...
>I don't think the SQL7 upgrade is relevant - my server was a clean install
> with SQL 2000. I have followed 2 possible causes on my system:
> 1 - the .Net Framework 1.1 SP1 update (although RS did continue for a week
> or so)
> 2 - the fact that I originally installed the 120 day trial version of RS,
> before updating it a few weeks later.
> After a clean removal, including the databases, and reinstall, plus RS SP1
> I'm no better off. This looks like a bug, which worries me greatly as I
> have
> customers dependant on the product and I fear this error will suddenly
> occur
> on their system too.
> Brian
> "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
>> I have found one thing that differs between two servers we have one where
> RS
>> works perfectly and the one mentioned with the "key problem". The
> difference
>> is that the server that doesn't work has an SQL instance that was
>> upgraded
>> from SQL7 but the one that works is running on a clean installed SQL2K
>> instance.
>> The OS is W2K3 on both servers.
>> On the one that now suffers from the problem I also had problems where
>> the
>> Report Manager web application would not install/configure correctly
> during
>> install. Never got the manager to work so I used another machine for the
> web
>> application.
>> /Per Salmi
>> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
>> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
>> >I am getting exactly the same problem, also in Win2k3, and have also
>> >done
> a
>> > complete uninstall and reinstall of RS, to no avail.
>> > Surely someone in Microsoft can resolve this'? I have had to abandon
>> > work
>> > because of this error.
>> >
>> > brian smith
>> >
>> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
>> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
>> >> Hi!
>> >>
>> >> On thursday last week one of our clients Reporting Services
> installation
>> >> stopped working and reports "Key not valid for use in specified state"
>> > error
>> >> message in the log files.
>> >>
>> >> This is strange as we have not done any changes to the server. It is
>> > running
>> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
>> >>
>> >> Anyone got similar problems or know what could cause this behaviour?
>> >>
>> >> I have tried reinstalling the encryption keys and finally removing and
>> >> reinstalling the complete Reporting Services but the same error is
> logged
>> >> and the service doesn't work.
>> >>
>> >> Best regards,
>> >> Per Salmi
>> >>
>> >>
>> >
>> >
>>
>|||Has anyone found the actual cause of this error? I do not want to
have to re-install RServices on a regular basis.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message news:<eU5aTJkoEHA.1664@.tk2msftngp13.phx.gbl>...
> Seems like exactly the same error I get.
> /Per Salmi
> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> news:eIYFOhjoEHA.3424@.TK2MSFTNGP12.phx.gbl...
> > To follow on from my earlier messaege - the error appears to relate to
> > something to do with encryption. I know nothing about encryption, or why
> > it
> > is involved in RS, but I assume it involves licensing.
> >
> > These are lines in the RS log:
> > aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Initializing crypto as
> > user: DRAKE\ASPNET
> > aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Exporting public key
> > aspnet_wp!webserver!cfc!09/24/2004-13:08:28:: e ERROR: Internal error:
> > System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
> > for
> > use in specified state.
> > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > errorCode, IntPtr errorInfo)
> > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> >
> >
> > Brian
> >
> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> > news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
> >> I have found one thing that differs between two servers we have one where
> RS
> >> works perfectly and the one mentioned with the "key problem". The
> difference
> >> is that the server that doesn't work has an SQL instance that was
> >> upgraded
> >> from SQL7 but the one that works is running on a clean installed SQL2K
> >> instance.
> >>
> >> The OS is W2K3 on both servers.
> >>
> >> On the one that now suffers from the problem I also had problems where
> >> the
> >> Report Manager web application would not install/configure correctly
> during
> >> install. Never got the manager to work so I used another machine for the
> web
> >> application.
> >>
> >> /Per Salmi
> >>
> >> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> >> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
> >> >I am getting exactly the same problem, also in Win2k3, and have also
> >> >done
> a
> >> > complete uninstall and reinstall of RS, to no avail.
> >> > Surely someone in Microsoft can resolve this'? I have had to abandon
> >> > work
> >> > because of this error.
> >> >
> >> > brian smith
> >> >
> >> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> >> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> >> >> Hi!
> >> >>
> >> >> On thursday last week one of our clients Reporting Services
> installation
> >> >> stopped working and reports "Key not valid for use in specified state"
> error
> >> >> message in the log files.
> >> >>
> >> >> This is strange as we have not done any changes to the server. It is
> running
> >> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
> >> >>
> >> >> Anyone got similar problems or know what could cause this behaviour?
> >> >>
> >> >> I have tried reinstalling the encryption keys and finally removing and
> >> >> reinstalling the complete Reporting Services but the same error is
> logged
> >> >> and the service doesn't work.
> >> >>
> >> >> Best regards,
> >> >> Per Salmi
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >|||I have an ongoing (paid) support case with MS, but so far despite all the
suggestions, my RS still does not work. When (and if) they fix it, I'll post
an update.
brian
"Austin S" <austinswope@.gmail.com> wrote in message
news:b68c96f7.0410180951.57c3121e@.posting.google.com...
> Has anyone found the actual cause of this error? I do not want to
> have to re-install RServices on a regular basis.
>
> "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:<eU5aTJkoEHA.1664@.tk2msftngp13.phx.gbl>...
> > Seems like exactly the same error I get.
> >
> > /Per Salmi
> >
> > "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> > news:eIYFOhjoEHA.3424@.TK2MSFTNGP12.phx.gbl...
> > > To follow on from my earlier messaege - the error appears to relate to
> > > something to do with encryption. I know nothing about encryption, or
why
> > > it
> > > is involved in RS, but I assume it involves licensing.
> > >
> > > These are lines in the RS log:
> > > aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Initializing crypto
as
> > > user: DRAKE\ASPNET
> > > aspnet_wp!crypto!cfc!09/24/2004-13:08:27:: i INFO: Exporting public
key
> > > aspnet_wp!webserver!cfc!09/24/2004-13:08:28:: e ERROR: Internal error:
> > > System.Runtime.InteropServices.COMException (0x8009000B): Key not
valid
> > > for
> > > use in specified state.
> > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > errorCode, IntPtr errorInfo)
> > > at RSManagedCrypto.RSCrypto.ExportPublicKey()
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > >
> > >
> > > Brian
> > >
> > > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> > > news:eDXedHjoEHA.2380@.TK2MSFTNGP14.phx.gbl...
> > >> I have found one thing that differs between two servers we have one
where
> > RS
> > >> works perfectly and the one mentioned with the "key problem". The
> > difference
> > >> is that the server that doesn't work has an SQL instance that was
> > >> upgraded
> > >> from SQL7 but the one that works is running on a clean installed
SQL2K
> > >> instance.
> > >>
> > >> The OS is W2K3 on both servers.
> > >>
> > >> On the one that now suffers from the problem I also had problems
where
> > >> the
> > >> Report Manager web application would not install/configure correctly
> > during
> > >> install. Never got the manager to work so I used another machine for
the
> > web
> > >> application.
> > >>
> > >> /Per Salmi
> > >>
> > >> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> skrev i meddelandet
> > >> news:ezlcI$ioEHA.1300@.TK2MSFTNGP12.phx.gbl...
> > >> >I am getting exactly the same problem, also in Win2k3, and have also
> > >> >done
> > a
> > >> > complete uninstall and reinstall of RS, to no avail.
> > >> > Surely someone in Microsoft can resolve this'? I have had to
abandon
> > >> > work
> > >> > because of this error.
> > >> >
> > >> > brian smith
> > >> >
> > >> > "Per Salmi" <per.salmi@.nospam.nospam> wrote in message
> > >> > news:OOi$DPhoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> > >> >> Hi!
> > >> >>
> > >> >> On thursday last week one of our clients Reporting Services
> > installation
> > >> >> stopped working and reports "Key not valid for use in specified
state"
> > error
> > >> >> message in the log files.
> > >> >>
> > >> >> This is strange as we have not done any changes to the server. It
is
> > running
> > >> >> Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed...
> > >> >>
> > >> >> Anyone got similar problems or know what could cause this
behaviour?
> > >> >>
> > >> >> I have tried reinstalling the encryption keys and finally removing
and
> > >> >> reinstalling the complete Reporting Services but the same error is
> > logged
> > >> >> and the service doesn't work.
> > >> >>
> > >> >> Best regards,
> > >> >> Per Salmi
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >|||I'd love to hear the solution too - I just ran into this exact error after
.Net Framework 1.1 SP1 was installed over the weekend.
I've tried the other solutions in these threads, but nothing has worked.
Dave
"Brian Smith" wrote:
> I have an ongoing (paid) support case with MS, but so far despite all the
> suggestions, my RS still does not work. When (and if) they fix it, I'll post
> an update.
> brian
>

Key not valid for use in specified state

Reporting Services has been fine for me up until last night and now I can't
view any reports as the R/Server keeps throwing the error:
"Key not valid for use in specified state"
I can't seem to track down any help and the link provided in the error
report is completly useless saying:
"Internal errors are uncommon and difficult to diagnose."
If it helps the log file is below:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__09_10_2004_08_31_45.log</Path>
<SystemName>SRV120W03</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
aspnet_wp!webserver!9b8!10/09/2004-08:31:45:: i INFO: Reporting Web Server
started
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
InstanceName to 'MSSQLSERVER' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45:: i INFO: Running on 1
physical processors, 2 logical processors
aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45:: i INFO: Reporting
Services starting SKU: Standard
aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Database Cleanup
(Web Service) timer enabled: Cycle: 600 seconds
aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Running Requests DB
timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Memory stats update
timer enabled: Cycle: 60 seconds
aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO: Exporting public key
aspnet_wp!webserver!9b8!09/10/2004-08:31:46:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!9b8!09/10/2004-08:31:46:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO: Exporting public key
aspnet_wp!webserver!9b8!09/10/2004-08:32:20:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!9b8!09/10/2004-08:32:20:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:32:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:33:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:34:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:35:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:36:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:37:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:38:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:39:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:40:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO: Exporting public key
aspnet_wp!library!e18!10/09/2004-08:41:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error doing timer action for Database Cleanup (Web Service);
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.CleanBatchRecords()
at Microsoft.ReportingServices.Library.RSService.CleanBatch()
at
Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:41:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO: Exporting public key
aspnet_wp!library!c54!10/09/2004-08:42:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO: Exporting public key
aspnet_wp!webserver!9b8!09/10/2004-08:43:30:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!9b8!09/10/2004-08:43:30:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:43:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO: Exporting public key
aspnet_wp!library!c54!10/09/2004-08:44:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO: Exporting public key
aspnet_wp!library!c54!10/09/2004-08:45:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO: Exporting public key
aspnet_wp!webserver!9b8!09/10/2004-08:46:35:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!9b8!09/10/2004-08:46:35:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:46:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO: Exporting public key
aspnet_wp!webserver!9b8!09/10/2004-08:47:00:: e ERROR: Internal error:
System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for
use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!library!9b8!09/10/2004-08:47:00:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO: Exporting public key
aspnet_wp!library!c54!10/09/2004-08:47:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:48:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO: Initializing crypto as
user: SRV120W03\ASPNET
aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO: Exporting public key
aspnet_wp!library!3b8!10/09/2004-08:49:45:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8009000B): Key
not valid for use in specified state.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --Simon,
In your machine.config file, what are your <machineKey> settings?
--Carlos
"Simon Dingley" <newsgroups@.nospam-creativenrg.co.uk> wrote in message
news:ueiTVzwlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> Reporting Services has been fine for me up until last night and now I
can't
> view any reports as the R/Server keeps throwing the error:
> "Key not valid for use in specified state"
> I can't seem to track down any help and the link provided in the error
> report is completly useless saying:
> "Internal errors are uncommon and difficult to diagnose."
> If it helps the log file is below:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>GMT Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__09_10_2004_08_31_45.log</Path>
> <SystemName>SRV120W03</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> aspnet_wp!webserver!9b8!10/09/2004-08:31:45:: i INFO: Reporting Web Server
> started
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> ConnectionType to '0' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> IsEventService to 'True' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> PollingInterval to '10' second(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
MemoryLimit
> to '60' percent as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
RecycleTime
> to '720' minute(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> MaxQueueThreads to '0' thread(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> MaxScheduleWait to '5' second(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> InstanceName to 'MSSQLSERVER' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO: Initializing
> DisplayErrorLink to 'True' as specified in Configuration file.
> aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45:: i INFO: Running on 1
> physical processors, 2 logical processors
> aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45:: i INFO: Reporting
> Services starting SKU: Standard
> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Database Cleanup
> (Web Service) timer enabled: Cycle: 600 seconds
> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Running Requests
> Scavenger timer enabled: Cycle: 60 seconds
> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Running Requests
DB
> timer enabled: Cycle: 60 seconds
> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i INFO: Memory stats
update
> timer enabled: Cycle: 60 seconds
> aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO: Exporting public key
> aspnet_wp!webserver!9b8!09/10/2004-08:31:46:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> aspnet_wp!library!9b8!09/10/2004-08:31:46:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO: Exporting public key
> aspnet_wp!webserver!9b8!09/10/2004-08:32:20:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> aspnet_wp!library!9b8!09/10/2004-08:32:20:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:32:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:33:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:34:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:35:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:36:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:37:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:38:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:39:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:40:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO: Exporting public key
> aspnet_wp!library!e18!10/09/2004-08:41:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error doing timer action for Database Cleanup (Web Service);
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.CleanBatchRecords()
> at Microsoft.ReportingServices.Library.RSService.CleanBatch()
> at
> Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
> at
> Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
> unused)
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:41:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO: Exporting public key
> aspnet_wp!library!c54!10/09/2004-08:42:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO: Exporting public key
> aspnet_wp!webserver!9b8!09/10/2004-08:43:30:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> aspnet_wp!library!9b8!09/10/2004-08:43:30:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:43:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO: Exporting public key
> aspnet_wp!library!c54!10/09/2004-08:44:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO: Exporting public key
> aspnet_wp!library!c54!10/09/2004-08:45:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO: Exporting public key
> aspnet_wp!webserver!9b8!09/10/2004-08:46:35:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> aspnet_wp!library!9b8!09/10/2004-08:46:35:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:46:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO: Exporting public key
> aspnet_wp!webserver!9b8!09/10/2004-08:47:00:: e ERROR: Internal error:
> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid
for
> use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> aspnet_wp!library!9b8!09/10/2004-08:47:00:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO: Exporting public key
> aspnet_wp!library!c54!10/09/2004-08:47:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:48:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO: Initializing crypto as
> user: SRV120W03\ASPNET
> aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO: Exporting public key
> aspnet_wp!library!3b8!10/09/2004-08:49:45:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., Error getting running jobs;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Runtime.InteropServices.COMException (0x8009000B):
Key
> not valid for use in specified state.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
>|||For the benefit of others that may come across this error it was something
to do with the installation of a patch for the invalid cursor state(KB
Article http://support.microsoft.com/default.aspx?kbid=831997 ). Microsoft
appeared to know of this when we called and here is the worst of it - a full
reinstall of Reporting Services was the only way to correct the error which
meant having to republish every single report on the reporting server.
Simon
"Carlos C Tapang" <ctapang@.centerus.com> wrote in message
news:efWak4xlEHA.1008@.tk2msftngp13.phx.gbl...
> Simon,
> In your machine.config file, what are your <machineKey> settings?
> --|||Carlos, Simon, have you discovered a solution to this
issue? Same thing happened to me after I installed
VS.NET remote debugging on the development server where I
was hosting the report service. I tried reinstalling
reporting services, but I'm getting the same error.
FWIW, my machine key setting is
<machineKey
validationKey="AutoGenerate,IsolateApps"
decryptionKey="AutoGenerate,IsolateApps"
validation="SHA1"/>.
Thanks,
-Marc
>--Original Message--
>Simon,
>In your machine.config file, what are your <machineKey>
settings?
>--Carlos
>"Simon Dingley" <newsgroups@.nospam-creativenrg.co.uk>
wrote in message
>news:ueiTVzwlEHA.2864@.TK2MSFTNGP14.phx.gbl...
>> Reporting Services has been fine for me up until last
night and now I
>can't
>> view any reports as the R/Server keeps throwing the
error:
>> "Key not valid for use in specified state"
>> I can't seem to track down any help and the link
provided in the error
>> report is completly useless saying:
>> "Internal errors are uncommon and difficult to
diagnose."
>> If it helps the log file is below:
>> <Header>
>> <Product>Microsoft SQL Server Reporting Services
Version
>> 8.00.743.00</Product>
>> <Locale>en-US</Locale>
>> <TimeZone>GMT Daylight Time</TimeZone>
>> <Path>C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
Services\LogFiles\ReportServer__09_10_2004_08_31_45.log</P
ath>
>> <SystemName>SRV120W03</SystemName>
>> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> <OSVersion>5.2.3790.0</OSVersion>
>> </Header>
>> aspnet_wp!webserver!9b8!10/09/2004-08:31:45:: i INFO:
Reporting Web Server
>> started
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> ConnectionType to '0' as specified in Configuration
file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> IsSchedulingService to 'True' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> IsNotificationService to 'True' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> IsEventService to 'True' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> PollingInterval to '10' second(s) as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>MemoryLimit
>> to '60' percent as specified in Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>RecycleTime
>> to '720' minute(s) as specified in Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> MaximumMemoryLimit to '80' percent as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> MaxAppDomainUnloadTime to '30' minute(s) as specified
in Configuration
>file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> MaxQueueThreads to '0' thread(s) as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> MaxActiveReqForOneUser to '20' requests(s) as
specified in Configuration
>> file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> MaxScheduleWait to '5' second(s) as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> DatabaseQueryTimeout to '120' second(s) as specified
in Configuration
>file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> InstanceName to 'MSSQLSERVER' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> ProcessRecycleOptions to '0' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> RunningRequestsScavengerCycle to '60' second(s) as
specified in
>> Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> RunningRequestsDbCycle to '60' second(s) as specified
in Configuration
>file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> RunningRequestsAge to '30' second(s) as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> SecureConnectionLevel to '0' as specified in
Configuration file.
>> aspnet_wp!library!9b8!10/09/2004-08:31:45:: i INFO:
Initializing
>> DisplayErrorLink to 'True' as specified in
Configuration file.
>> aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45::
i INFO: Running on 1
>> physical processors, 2 logical processors
>> aspnet_wp!resourceutilities!9b8!10/09/2004-08:31:45::
i INFO: Reporting
>> Services starting SKU: Standard
>> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i
INFO: Database Cleanup
>> (Web Service) timer enabled: Cycle: 600 seconds
>> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i
INFO: Running Requests
>> Scavenger timer enabled: Cycle: 60 seconds
>> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i
INFO: Running Requests
>DB
>> timer enabled: Cycle: 60 seconds
>> aspnet_wp!runningjobs!9b8!10/09/2004-08:31:45:: i
INFO: Memory stats
>update
>> timer enabled: Cycle: 60 seconds
>> aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!9b8!09/10/2004-08:31:46:: i INFO:
Exporting public key
>> aspnet_wp!webserver!9b8!09/10/2004-08:31:46:: e ERROR:
Internal error:
>> System.Runtime.InteropServices.COMException
(0x8009000B): Key not valid
>for
>> use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> aspnet_wp!library!9b8!09/10/2004-08:31:46:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., ;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!9b8!09/10/2004-08:32:20:: i INFO:
Exporting public key
>> aspnet_wp!webserver!9b8!09/10/2004-08:32:20:: e ERROR:
Internal error:
>> System.Runtime.InteropServices.COMException
(0x8009000B): Key not valid
>for
>> use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> aspnet_wp!library!9b8!09/10/2004-08:32:20:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., ;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:32:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:32:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:33:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:33:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:34:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:34:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:35:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:35:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:36:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:36:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:37:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:37:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:38:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:38:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:39:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:39:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:40:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:40:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!e18!10/09/2004-08:41:45:: i INFO:
Exporting public key
>> aspnet_wp!library!e18!10/09/2004-08:41:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error doing timer action for Database
Cleanup (Web Service);
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
Microsoft.ReportingServices.Library.DBInterface.CleanBatch
Records()
>> at
Microsoft.ReportingServices.Library.RSService.CleanBatch()
>> at
Microsoft.ReportingServices.Library.DatabaseCleanupTimer.D
oTimerAction()
>> at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.Ti
merAction(Object
>> unused)
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:41:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:41:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!c54!10/09/2004-08:42:45:: i INFO:
Exporting public key
>> aspnet_wp!library!c54!10/09/2004-08:42:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!9b8!09/10/2004-08:43:30:: i INFO:
Exporting public key
>> aspnet_wp!webserver!9b8!09/10/2004-08:43:30:: e ERROR:
Internal error:
>> System.Runtime.InteropServices.COMException
(0x8009000B): Key not valid
>for
>> use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> aspnet_wp!library!9b8!09/10/2004-08:43:30:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., ;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:43:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:43:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!c54!10/09/2004-08:44:45:: i INFO:
Exporting public key
>> aspnet_wp!library!c54!10/09/2004-08:44:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!c54!10/09/2004-08:45:45:: i INFO:
Exporting public key
>> aspnet_wp!library!c54!10/09/2004-08:45:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!9b8!09/10/2004-08:46:35:: i INFO:
Exporting public key
>> aspnet_wp!webserver!9b8!09/10/2004-08:46:35:: e ERROR:
Internal error:
>> System.Runtime.InteropServices.COMException
(0x8009000B): Key not valid
>for
>> use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> aspnet_wp!library!9b8!09/10/2004-08:46:35:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., ;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:46:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:46:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!9b8!09/10/2004-08:47:00:: i INFO:
Exporting public key
>> aspnet_wp!webserver!9b8!09/10/2004-08:47:00:: e ERROR:
Internal error:
>> System.Runtime.InteropServices.COMException
(0x8009000B): Key not valid
>for
>> use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> aspnet_wp!library!9b8!09/10/2004-08:47:00:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., ;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.Storage.get_Connection
()
>> at
Microsoft.ReportingServices.Library.Storage.NewStandardSql
Command(String
>> storedProcedureName)
>> at
>Microsoft.ReportingServices.Library.DBInterface.GetOneCon
figurationInfo(Stri
>> ng key)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetSystemProperty
>> (String name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.Get(String
>> name)
>> at
>Microsoft.ReportingServices.Library.CachedSystemPropertie
s.GetParameter(Stri
>> ng name)
>> at
Microsoft.ReportingServices.Library.RSService.get_MyReport
sEnabled()
>> at
Microsoft.ReportingServices.Library.RSService.PathToIntern
al(String
>> source)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path, Boolean validate, Boolean convert, Boolean
translate)
>> at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext
.SetPath(String
>> path)
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPageCon
>> tent()
>> at
>Microsoft.ReportingServices.WebServer.ReportServiceHttpHa
ndler.RenderPage()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!c54!10/09/2004-08:47:45:: i INFO:
Exporting public key
>> aspnet_wp!library!c54!10/09/2004-08:47:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:48:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:48:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>> aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO:
Initializing crypto as
>> user: SRV120W03\ASPNET
>> aspnet_wp!crypto!3b8!10/09/2004-08:49:45:: i INFO:
Exporting public key
>> aspnet_wp!library!3b8!10/09/2004-08:49:45:: e ERROR:
Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details., Error getting running jobs;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.Interna
lCatalogException:
>> An internal error occurred on the report server. See
the error log for
>more
>> details. -->
System.Runtime.InteropServices.COMException (0x8009000B):
>Key
>> not valid for use in specified state.
>> at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR
(Int32
>> errorCode, IntPtr errorInfo)
>> at RSManagedCrypto.RSCrypto.ExportPublicKey()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.GetE
ncryptionKey()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.Con
nectStorage()
>> at
Microsoft.ReportingServices.Library.ConnectionManager.Veri
fyConnection()
>> at
>Microsoft.ReportingServices.Library.ConnectionManager.get
_Connection()
>> at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRun
ningJobs()
>> -- End of inner exception stack trace --
>>
>
>.
>