Saturday, August 23, 2014

Annals of Oracle's Improbable Errors: Sharing SQLDeveloper SQL history across several ma...

Annals of Oracle's Improbable Errors: Sharing SQLDeveloper SQL history across several ma...: Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates . A quick tip for keeping a s...

Tuesday, August 19, 2014

Cortex-A/M: Cooking with Chef: Create private and pubic subnet...

Cortex-A/M: Cooking with Chef: Create private and pubic subnet...: In order to access your AWS instance in a VPC private subnet you need a bastion host ( NAT instance) . The setup of a bastion is quite easy ...

Linux Commando: Using double dash to specify pesky command line pa...

Linux Commando: Using double dash to specify pesky command line pa...: Many Linux commands accept command-line options and positional parameters. The grep command searches for a pattern in a given file. Its 2...

Saturday, August 9, 2014

Hyperion Error of the Day: Fun with the Hyperion Log Analysis Utility

Hyperion Error of the Day: Fun with the Hyperion Log Analysis Utility:  I was recently playing around with the Log Analysis tool on 11.1.2.2. John Goodwin has a good write up of the basic operation of the log...

Thursday, August 7, 2014

Cameron's Blog For Essbase Hackers: Limitations in Hybrid BSO Essbase

Cameron's Blog For Essbase Hackers: Limitations in Hybrid BSO Essbase: Before I begin Lest anyone think that this blog post is Cameron’s Exercise in Whining About Essbase or Cameron’s Gift to Oracle’s Competi...

Friday, December 14, 2007

How to Inactivate PSRF_REPORT_CREATE messages


PT 8.48: Unable to inactivate PSRF_REPORT_CREATE messages for Report Distribution.

SPECIFIC TO
Tools 8.48

ISSUE:
Unable to prevent PSRF_REPORT_CREATE messages when reports are run from the Process Scheduler and posted by the Distribution Agent to Report Manager. These Report Distribution messages are not wanted and cause performance issues with other Integration Broker messages. Integration Broker messages are activated or inactivated by the Service Operations page. This works for other messages but not with PSRF messages.

SOLUTION:

To Inactivate Report Distribution Messages:

1. PeopleTools, Integration Broker, Integration Setup, Service Operations, Service: PSRF, Search.

2. Click on the hyperlink for each message and uncheck the "Active" box for the following Report Distribution
messages:
PSRF_FOLDER_CREATE
PSRF_REPORT_CREATE
PSRF_REPORT_DATE_CHANGE
PSRF_REPORT_DELETE

3. Click on the Save button for each message.

NOTE: This is all that should normally be performed to inactivate Report Distribution messages.

Additional Workaround Steps:

1) PeopleTools, Security, User Profiles, User Profiles, User ID (e.g. VP1), Search.

2) Roles Tab.

3) Add EIR Administrator, press Save.

4) Log out and back into PIA.

5) PeopleTools, Portal, Structure and Content.

6) Click on the Enterprise Components Hyperlink: do not select Edit or Delete.

7) EI Repository, click on Edit hyperlink.

8) Uncheck "Hide from portal navigation, click Save.

9) Enterprise Components, EI Repository, Message Properties, Message Name Begins With: PSRF,
Press Search.

10) The following messages will display:
PSRF_FOLDER_CREATE
PSRF_REPORT_CREATE
PSRF_REPORT_DATE_CHANGE
PSRF_REPORT_DELETE

11) Inactivate these messages from Message/Subscription tab, press Save.

12) Bounce the app server and Process Scheduler and clear cache.

13 PeopleTools, Integration Broker (IB), Service Operations Monitor, Async Services.

14 Note PSRF_REPORTING_FOLDERS: Done Column => note number.

15 From another browser Run AEMINITEST.

16 On the Service Operations Monitor/Async Services page, click on the Refresh button: the number should no
longer increment.