Throughout day by day upkeep in Oracle EPM
Cloud, the system creates a upkeep snapshot, applies patches, adjusts
configurations, and analyzes actions to generate an Exercise Report. The
atmosphere is then rebooted, with preliminary entry restricted to Service
Directors. Sure operations are restricted throughout this era,
particularly for processes like Planning and Monetary Consolidation. Upkeep
normally begins between 10:00 p.m. and 1:00 a.m. native time and a 15-minute
discover is given earlier than upkeep begins. The method usually takes much less
than an hour.
Throughout the day by day upkeep of Oracle
Enterprise Efficiency Administration (EPM) Cloud, the next duties are
carried out:
1.
Creation of a upkeep snapshot
named “Artifact Snapshot” of present artifacts and knowledge.
2.
Utility of any required patches.
3.
Configuration changes, resembling
cache updates.
4.
Evaluation of the day prior to this’s
actions and logs, leading to an Exercise Report.
The atmosphere is then rebooted, and
preliminary entry is restricted to Service Directors. Sure operations are
restricted or unavailable throughout this era to make sure upkeep duties are
accomplished successfully.
Throughout the day by day upkeep of Oracle
EPM Cloud, the next functionalities are
Unavailable for Planning:
·
Clear Dice
·
Compact Define
·
Knowledge Integration
·
Export Knowledge
·
Export Metadata
·
Import Knowledge
·
Import Metadata
·
Merge Knowledge Slices
·
Optimize Aggregation
·
Refresh Database
·
Restructure Dice
These restrictions be sure that the
upkeep duties are accomplished with out interference and assist preserve the
integrity and efficiency of the system.
Enterprise Profitability and Price Administration – Operations
Not Accessible
- Clear
Dice - Compact
Define - Knowledge
Integration - Export
Knowledge - Export
Metadata - Import
Knowledge - Import
Metadata - Merge
Knowledge Slices - Optimize
Aggregation - Refresh
Database
Monetary Consolidation and Shut – Operations Not
Accessible
- Knowledge
Integration - Export
Knowledge - Export
Metadata - Import
Knowledge - Import
Metadata - Refresh
Database - Restructure
Dice
Default Upkeep Begin Time
Since environments are unavailable to
customers in the course of the upkeep window, the Service Administrator ought to choose a
one-hour interval when the service isn’t in use. Any related customers will likely be
logged off, and any unsaved knowledge will likely be misplaced.
The default upkeep begin time is
between 10:00 p.m. and 1:00 a.m. native time of the info middle internet hosting your
atmosphere. If you don’t change the default begin time, Oracle will randomize
it to begin inside this window. When you select a upkeep begin time,
Oracle will adhere to your choice. For extra particulars, seek advice from the part on
Setting the Upkeep Begin Time for an Setting.
Some providers would possibly want extra
upkeep operations. For instance, Planning Modules, Account Reconciliation,
and Monetary Consolidation and Shut might require further upkeep time for
content material upgrades.
Moreover, attributable to deliberate day by day
upkeep, the atmosphere standing within the My Providers console is all the time
displayed as Deliberate Upkeep (in yellow), even when no different upkeep is
scheduled for that day.
Groovy Script to Inform Customers of Day by day Upkeep Completion
This script is designed to inform customers upon completion of day by day
upkeep for an Oracle EPM atmosphere. It logs in to the EPM service,
retrieves the upkeep begin time, and sleeps till that point. The script
then makes an attempt to log in repeatedly till upkeep is full. As soon as
accomplished, it sends a notification e mail to the required addresses. Lastly,
it logs out of the EPM service.
// Day by day Upkeep Accomplished Notification script
// Replace the next parameters
// ——————————-
String username=dayalan@onlyhyperion.com
String password=”Password”
String url=https://epm-test-epm.us-phoenix-1.ocs.oraclecloud.com
String emailaddresses=dayalan@onlyhyperion.com
// ——————————-
// Operate to log messages with a timestamp
def LogMessage(String message) {
def date = new Date()
def sdf = new SimpleDateFormat(“MM/dd/yyyy
HH:mm:ss”)
println(‘[‘ + sdf.format(date) + ‘] ‘ + message);
}
// Operate to log the standing of an EPM Automate operation
def LogOperationStatus(EpmAutomateStatus opstatus) {
def returncode = opstatus.getStatus()
if (returncode != 0){
LogMessage(opstatus.getOutput())
}
LogMessage(‘return code: ‘ + returncode)
}
// Operate to get the day by day upkeep begin time
def getDailyMaintenanceStartTime(EpmAutomate automate) {
LogMessage(“Operation:
getDailyMaintenanceStartTime”)
EpmAutomateStatus amwtimestatus =
automate.execute(‘getDailyMaintenanceStartTime’)
LogOperationStatus(amwtimestatus)
def amwstring = (amwtimestatus.getOutput())
def parts = amwstring.cut up(‘ ‘)
def amwtime = parts[0]
return amwtime
}
// Operate to sleep till the day by day upkeep begin time
def goToSleep(String amw_time) {
def date = new Date()
def current_mdy = new
SimpleDateFormat(“MM/dd/yyyy”)
def current_date_time = new
SimpleDateFormat(“MM/dd/yyyy HH:mm:ss”)
float current_epoch = date.getTime() / 1000
def sample = “MM/dd/yyyy HH:mm:ss”
def enter = current_mdy.format(date) + ” ” +
amw_time + “:00”
def target_date_time = Date.parse(sample, enter)
float target_epoch = target_date_time.getTime() / 1000
int sleep_seconds = Math.spherical(target_epoch –
current_epoch)
// Right now’s AMW begin time has already handed, so add 24
hours to sleep_seconds
if (sleep_seconds
sleep_seconds = sleep_seconds + 86400
}
def sleep_milliseconds = sleep_seconds * 1000
LogMessage(“Present time is ” +
current_date_time.format(date) + “. Sleeping till day by day upkeep begin
time of ” + amw_time + “:00.”)
sleep(sleep_milliseconds)
}
// Operate to try login repeatedly till day by day upkeep is
accomplished
def attemptLogin(EpmAutomate automate, String username, String password,
String url) {
def serverdown = 1
whereas (true) {
LogMessage(“Operation: login ” +
username + ” ” + password + ” ” + url)
EpmAutomateStatus standing = automate.execute(‘login’,
username, password, url)
def returncode = standing.getStatus()
if (returncode == 0) {
if (serverdown == 0){
LogMessage(“Day by day upkeep processing has accomplished …”)
break
} else {
LogMessage(“Day by day upkeep processing has not but began. Sleeping for
2 minutes earlier than the following verify …”)
sleep(120000)
}
} else {
if (serverdown == 0){
LogMessage(“Ready
for day by day upkeep processing to finish. Sleeping for two minutes earlier than the
subsequent verify …”)
sleep(120000)
} else {
LogMessage(“Day by day upkeep processing is now starting. Sleeping for two
minutes earlier than the following verify …”)
sleep(120000)
serverdown = 0
}
}
}
}
// Operate to ship a notification e mail after upkeep is accomplished
def sendNotification(EpmAutomate automate, String url, String
emailaddresses) {
def servername = url.tokenize(“/”)[-1];
def topic = “Day by day upkeep processing has
accomplished”
def formattedmessage = “Day by day upkeep processing
has accomplished for server ” + servername
def emailaddressesformatted =
emailaddresses.replaceAll(‘,’, ‘;’)
LogMessage(“Operation: sendmail ” +
emailaddressesformatted + ” ” + topic + ” Physique=” +
formattedmessage)
EpmAutomateStatus standing = automate.execute(‘sendmail’,
emailaddressesformatted, topic, ‘Physique=’ + formattedmessage)
LogOperationStatus(standing)
}
// Script begins right here
LogMessage(“Starting day by day upkeep completion notification
script.”)
// Get an occasion of EpmAutomate
EpmAutomate automate = getEpmAutomate()
// Log in to the EPM service
LogMessage(“Operation: login ” + username + ” ” +
password + ” ” + url)
EpmAutomateStatus standing = automate.execute(‘login’, username, password,
url)
LogOperationStatus(standing)
// Get the day by day upkeep begin time and sleep till that point
String amwtime = getDailyMaintenanceStartTime(automate)
goToSleep(amwtime)
// Try and log in repeatedly till upkeep is full
attemptLogin(automate, username, password, url)
// Ship a notification e mail after upkeep is full
sendNotification(automate, url, emailaddresses)
// Sign off from the EPM service
LogMessage(“Operation: logout”)
standing = automate.execute(‘logout’)
LogOperationStatus(standing)
// Script processing has accomplished
LogMessage(“Script processing has accomplished.”)
The Job is operating and waits for the Upkeep to begin.
Hope this helps, Pleased days on the Cloud!
