Search the web
Sign In
New User? Sign Up
brioportalusersgroup · Hyperion Performance Suite - Users Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Can Output From Scheduled SQR Be Published To Portal?   Message List  
Reply | Forward Message #649 of 744 |
We have an SQR job/program that has been published to the Portal.
The main purpose of the job/program is to query an Oracle table and
send email to individuals based on the query results. The output file
(s) contain the body of each email that is sent and is used as
confirmation of the individual email sent by the administration team.

When that SQR job/program is executed manually through Portal (end
user selects the SQR job/program) the program runs successfully,
emails are sent and the output files are 'pubished' to the Portal
(html and spf files). However, when the same SQR job/program is
executed via Scheduler it runs successfully, sends email but no
output files are created in Portal.

Is this normal? Can the Scheduled SQR job/program be 'enabled' to
produce the same output files in Portal that are generated when it is
executed manually?

We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.

Any help is appreciated.

Thanks,
Bernie






Fri Oct 17, 2003 4:43 pm

shemkbd
Offline Offline
Send Email Send Email

Forward
Message #649 of 744 |
Expand Messages Author Sort by Date

We have an SQR job/program that has been published to the Portal. The main purpose of the job/program is to query an Oracle table and send email to individuals...
shemkbd
Offline Send Email
Oct 17, 2003
4:43 pm

Hi Bernie, the behaviour of a run-on-demand job and a scheduled job should be the same. It could be a permissions problem - if different users run the job vs ...
Steve Cavill
stevecavill
Offline Send Email
Oct 18, 2003
4:06 am

Thanks Steve. Success - although not straight forward. Permissions are a bit confusing to me. Originally, I logged into One/Administrator using the...
shemkbd
Offline Send Email
Oct 22, 2003
12:06 pm

Certainly sounds odd. The Administrator's Guide is the only resource I am aware of. administrator is defined as a "super-user" so permissions are ignored for ...
Steve Cavill
stevecavill
Offline Send Email
Oct 22, 2003
12:52 pm

Steve, I think I found the problem. I believe it had to do with the default group that was selected for the user creating the portal objects. After reading...
shemkbd
Offline Send Email
Oct 23, 2003
4:30 pm

Great to hear it's working, that's what the email group is here for :-) Steve. ... From: shemkbd [mailto:shemkbd@...] Sent: Friday, 24 October 2003 2:30 AM ...
Steve Cavill
stevecavill
Offline Send Email
Oct 24, 2003
6:32 am

There's another group called rm-users (meaning reportmart users - reportmart is the old name of brio.portal). Though it's pretty quiet. You can subscribe to...
Steve Cavill
stevecavill
Offline Send Email
Oct 24, 2003
6:38 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help