Your SAS programs, embedded in web apps and elsewhere

failed running stored process from web report studio

Reply
Occasional Contributor
Posts: 6

failed running stored process from web report studio

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.
SAS Employee
Posts: 285

Re: failed running stored process from web report studio

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
Contributor
Posts: 61

Re: failed running stored process from web report studio

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.
Occasional Contributor
Posts: 6

Re: failed running stored process from web report studio

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.
Contributor
Posts: 61

Re: failed running stored process from web report studio

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.
Ask a Question
Discussion stats
  • 4 replies
  • 297 views
  • 0 likes
  • 3 in conversation