topic Re: failed running stored process from web report studio in Developers

failed running stored process from web report studio

Haiyan — Thu, 02 Apr 2009 18:56:33 GMT

Hi Forks,

We tried to run a stored process from WRS and get the following error message:
============================================================
Error messages:There is a problem with the current page.
Error Rendering the Report
Storedprocess did not run successfully: cxo.200.ex.msg: LogicalServer A52IEFCM.AV000002 must be associated with at least one ServerComponent through the UsingComponents association.!

Root Cause: com.sas.report.render.models.ReportModelException: Storedprocess did not run successfully: cxo.200.ex.msg: LogicalServer A52IEFCM.AV000002 must be associated with at least one ServerComponent through the UsingComponents association.!
at com.sas.report.render.util.SASProcessUtil.runSASProcess(SASProcessUtil.java:124)
........(rest ommited)
=============================================================
Our problem is that our stored process server seems never working since it was installed(for Development). And only recently our developer wanted to use it and we started testing the stored process server and got here.

Can any one out there give me some hints to trouble should this? Thanks.

Re: failed running stored process from web report studio

Vince_SAS — Thu, 02 Apr 2009 20:57:40 GMT

Please open a track with our Technical Support department. Here is the link:

http://support.sas.com/ctx/supportform/createForm

Vince DelGobbo
SAS R&D

Re: failed running stored process from web report studio

venkatesh — Fri, 03 Apr 2009 06:48:18 GMT

Haiyan,

I think Problem with authentication, did u tried through admin credentials.
still not working then hot fix link here and raise a track with tech support..

http://support.sas.com/kb/14/091.html
http://support.sas.com/kb/34/792.html

Venky.

Re: failed running stored process from web report studio

Haiyan — Tue, 07 Apr 2009 20:09:52 GMT

Hi Wenky,
Thank you very much for your help. I am now working with SAS support on this issue and waiting for their solutions. I tried logging in as sasdemo and sasadm, both credentials worked; meanwhile all other user accounts failed with the original error message. This proved your theory. So now I am wondering where I should start to fix this. Can you please throw me some quick hints?

Thanks.

Re: failed running stored process from web report studio

venkatesh — Wed, 08 Apr 2009 09:39:49 GMT

Haiyan

In management console add user account in to defaultact as per your requirements and assign permissions to the account.

if u assigned all permissions to the account, this user will work as admin, if not this user under control of sasadm account.

Venky.