error in rs

aspnet_wp!ui!980!20.9.2004-09:42:16:: e ERROR: An internal error occurred on
the report server. See the error log for more details. --> An internal error
occurred on the report server. See the error log for more details. --> Key
not valid for use in specified state.
aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException: An internal error occurred on
the report server. See the error log for more details. --> An internal error
occurred on the report server. See the error log for more details. --> Key
not valid for use in specified state. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
Item) at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at
Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at
Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs
e) at System.EventHandler.Invoke(Object sender, EventArgs e) at
System.Web.UI.Control.OnInit(EventArgs e) at
System.Web.UI.Control.InitRecursive(Control namingContainer) at
System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Try deleting the following file:
\documents and settings\<machine name>\aspnet\application
data\microsoft\crypto\rsa\<user sid>\1aedd7b5699f3d6a88e354100b596aae_*
Then run rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:%23ldrknwnEHA.4088@.TK2MSFTNGP10.phx.gbl...
> aspnet_wp!ui!980!20.9.2004-09:42:16:: e ERROR: An internal error occurred
on
> the report server. See the error log for more details. --> An internal
error
> occurred on the report server. See the error log for more details. --> Key
> not valid for use in specified state.
> aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException: An internal error occurred on
> the report server. See the error log for more details. --> An internal
error
> occurred on the report server. See the error log for more details. --> Key
> not valid for use in specified state. at
>
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall) at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
>
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> Item) at
> Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
> Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at
> Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
> at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at
> Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender,
EventArgs
> e) at System.EventHandler.Invoke(Object sender, EventArgs e) at
> System.Web.UI.Control.OnInit(EventArgs e) at
> System.Web.UI.Control.InitRecursive(Control namingContainer) at
> System.Web.UI.Page.ProcessRequestMain()
> aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>

Error in Processing Cube (Microsoft Analysis Services)

Hi,
I am processing one cube using Full Process option and it's giving
following error.

Analysis Server Error: Internal error [Object does not exist] '11948' ;
Time:1/8/2004 6:11:11 PM

Error(-2147221421): Internal error (Internal error [Object does not
exist] '11948' ); Time:1/8/2004 6:11:11 PM

Can anyone help me on this.If you are using shared dims, process your dimensions, then the cube and see if that fixes it.

GO COLTS!!

HTH

Error in deploying cube

Hi,

I'm getting an internal exception error while deploying the solution. The error is as follows -

"Error - 1056964586: Internal error: An unexpected exception occured."

When deployed for the first time, it went through and subsequent changes processed as well. For a specific reason I had to delete the database and redeploy.

From then on I'm getting this error. Earlier threads said try SP2, still the error persists.

Had to share this solution with my teammate as well and even he is getting this error, even though he is deploying it for the first time.

Any help on this would really help, otherwise I would have to recreate the entire solution, changes etc.

Thanks in advance.

Hi,

I do not know this sepcific error message or number.

But I now - you cannot deploy the cube if you have a role with a user which does not exists. Remove incorrect users from you roles (or try remove all and then deploy again)

I had such issues in most of my deployment scenarios.

Else - does the message come from deployment or processing - try only deploy the solution and do not process.

HANNES

|||

Hi Hannes,

I dont have any user roles defined. Also I'm the administrator of the system and the Analysis Services server as well.

And the error comes when I'm trying to deploy the solution.

|||

"Unexpected Exception" errors usually indicate a bug in the server, and we would require either a crash dump or a copy of the solution in order to diagnose exactly why we're hitting it. I'd recommend opening a support ticket if that option is available to you.

- Brad

|||

I was able to track down the problem in my case.

I had 3 cubes and there was 2 relationships (linked objects), viz. Cube 1 refering Cube 2 and Cube 2 refering Cube 3.

When I removed one of the references, the deployment and processing went through.

I guess this is a limitation not to have such kind of references.

-

Vivek C.

Error handling...

I am needing to check for an error code after a SQL statement has run, but
the error is being trapped internal to the Select statement. How do I make
this work?
I am trying to set up some code that will try the SQL statement and if it
gets an error, it will wait 30 seconds and then try again. And if it trys 3
times (or so) with out success THEN return the error message (in the error
dialog box that halts everything till you click "OK") or better yet, just
log that the error occured and allow the process to continue and take
appropriate action based on the error number.
The file pointed to by the OPENROWSET, was just copied from a local PC to
the server. The problem is that the file still has write processes occuring
in the background after the scripted copy thinks it is finished and passes
control to the next line.
I am trying to make this work with out resorting to DTS or SSIS. The
product I am using has it's own proprietary scripting set up that can call i
n
and run Transact-SQL statements.
*** SQL Code ***
Declare @.trys int
Set @.trys = 1
PRINT 'At top'
While @.trys < 3
BEGIN
Print 'Attempting Try # ' + Cast(@.Trys as char(4))
SELECT SN.CustomerID, C.CustomerID, C.FirstName, C.LastName, C.Status
FROM Customers AS C
LEFT OUTER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'C:\StudentList.mdb';'admin';'', StudentNumbers) AS SN
ON (C.CustomerID = SN.CustomerID)
WHERE SN.CustomerID Is not null
If @.@.ERROR = 0
BREAK
Else
BEGIN
WAITFOR DELAY '000:00:30'
Set @.Trys = @.Trys + 1
CONTINUE
END
END
Print 'At bottom'
Regards,
JohnJohn Keith (JohnKeith@.discussions.microsoft.com) writes:
> I am needing to check for an error code after a SQL statement has run,
> but the error is being trapped internal to the Select statement. How do
> I make this work?
It may prove difficult if you are on SQL 2000. On SQL 2000 many errors
are not trappable in SQL, because they abort the batch. There is a trick
with setting up a linked server, but it's fairly kludgy.
On SQL 2005 you can use TRY CATCH.
For lots of details in error handlin in SQL Server, see this
article: http://www.sommarskog.se/error-handling-I.html. The linked-
server trick is described somewhere in the middle.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks for that link.
Your page was very informative on the hows-and-whys. I can tell from your
sarcasm on the page that we are in the same boat on this. The remark about
"Now, taste that concept: an informational error." made me laugh.
I'm checking into SQL Server 2005 to see if my package-application (not DTS,
just an externaly written bought app) will support the newer SQL Server 2005
.
Regards,
John
"Erland Sommarskog" wrote:

> John Keith (JohnKeith@.discussions.microsoft.com) writes:
> It may prove difficult if you are on SQL 2000. On SQL 2000 many errors
> are not trappable in SQL, because they abort the batch. There is a trick
> with setting up a linked server, but it's fairly kludgy.
> On SQL 2005 you can use TRY CATCH.
> For lots of details in error handlin in SQL Server, see this
> article: http://www.sommarskog.se/error-handling-I.html. The linked-
> server trick is described somewhere in the middle.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>