Jaspersoft Commands for CA PPM Administrators

As an administrator, use the following commands to manage the Jaspersoft advanced reporting content for . 
ccppmod142
As an administrator, use the following commands to manage the Jaspersoft advanced reporting content for 
Clarity Project and Portfolio Management (PPM)
: Apply the latest release patches for your version of
Clarity Project and Portfolio Management (PPM)
to take advantage of all available commands.
First-Time Installation and Upgrades
To install Jaspersoft content for the first time, run the following command on your
Clarity Project and Portfolio Management (PPM)
 system: 
admin content-jaspersoft <contentpackId> -userName superuser -password superuser
Run this command only to import the content for the first time. Also use this command during release and patch upgrades.
This command performs the following actions:
  • Verifies whether the organization that you defined on the CSA Reporting subtab already exists. 
    • If the organization already exists, this command exits with an appropriate message. It does not execute the import because it is a new install.
    • If the organization does not exist, this command creates the organization defined in the CSA Reporting subtab and continues.
  • Creates a zip file specific for the organization in a temporary folder by replacing the org name with given in CSA
  • Imports the content from the temporary zip file
  • Creates the CA PPM folder and its subfolders in the organization’s repository
  • Creates the Advanced Reporting roles
  • Creates the PMO Accelerator roles. These roles determine content permissions and begin with the CSK_ prefix.
  • Updates the domains with the Data Warehouse schema owner name specific to the database
  • Uploads the UI Themes
  • Creates the user profile attributes
  • Update e-mail notification settings (available with Jaspersoft 6.2.1)
  • Creates the Jaspersoft administrator user. The default user is “ppmjasperadmin“. This user can be changed in the CSA Reporting subtab before importing, but after importing this user should not be modified. The Create and Update Jaspersoft Users job and the Load Data Warehouse job, which dynamically updates domains, require this user
  • Create shared folder and set permissions of that folder
  • Set permissions on themes, other folders and public folder
  • Creates cmn_install_history entry which will be used to track install history and also identify the upgrade mode
 
: When the default settings such as Organization name, Admin user name, Key store, Database configurations, or JASPERSOFT folder level permissions change, do not try to fix them by reimporting the content. Execute the related commands to fix them.
Upgrades
This command is used to install the jaspersoft content upgrade. This command needs to be executed on top of patch releases or release upgrades
admin content-jaspersoft <contentpackId> -userName superuser –password superuser upgrade
Run this command only to import the content for the first time in the 
Clarity Project and Portfolio Management (PPM)
 environment. Also use this command during release and patch upgrades.
This command performs the following actions:
  • Verifies if the organization defined in the CSA Reporting subtab already exists.
    • If the organization does not exist, it exits with an appropriate message. It does not create the organization which means it does not execute the import because it is an upgrade, not a new install.
    • If the organization does exist, it creates a zip file specific for the organization in a temporary folder and continues.
  • Imports the content from the temporary zip file
  • Updates the CA PPM/Reports folder and its subfolders in the organization’s repository.
  • Retains the CA PPM folder, default subfolders, and their permissions.
  • Updates the out-of-the-box Jaspersoft Advanced Reporting items, in the CA PPM folder and subfolders. Items include domains, reports, input controls, templates, images, etc
  • It should not matter what is in the zip file being imported because no content is going to be deleted. If the zip file includes content previously imported, update the content with the content from the zip file. If the zip file includes new content, import the new content without modifying the content previously imported. In summary, always only update the content which is coming from the zip file
  • Updates the domains being imported with the Data Warehouse schema owner name specific to the database
  • If content contains domains then Dynamic Domain routine will run
  • Uploads the UI Themes
  • Verify if the Jaspersoft administrator user already exists or if the Jaspersoft administrator user was modified in CSA and needs to be recreated
  • Verify if the Shared folder already exists or needs to be recreated. If the Shared folder exists skip it, do not modify it. Permissions should not be modified
  • Creates cmn_install_history entry after the import. This table tracks install history and also identify the upgrade mode
Maintenance
Update User Profile
Updates the jasperadmin user profile attributes using properties.xml entries.
admin update jasperParameters
Run this command when changes occur in one or more of the following items:
  • the configuration of
    Clarity Project and Portfolio Management (PPM)
  • the database username or password
  • the data warehouse username or password
  • the key store
Repair Domain Corruption
Run this command only when your domains are corrupt. Domain corruption prevents the Load Data Warehouse job from running.
admin content-jaspersoft <contentpackId> -userName superuser –password superuser restoreDomains
This command performs the following actions:
  • Verifies if the organization defined in the CSA Reporting subtab already exists. If the organization does not exist, it exits with an appropriate message. It does not create the organization which means it does not execute the import because it is an upgrade, not a new install.
  • Creates a zip file specific for the organization in a temporary folder
  • Imports the content from the temporary zip file
  • Replaces all the OOTB domains which are under ca ppm/domains folder
  • Updates the domains being imported with the Data Warehouse schema owner name specific to the database
  • Runs the dynamic domain updates
This command needs to be run when Load Data warehouse job fails by complaining Domain updates are failing. While working on adhoc views using domains if it fails to fetch data and configuring columns, check domains definition and if it reports any error then run this command.
List Domains
This command checks the user profile attribute and get list of email domains supported.
admin jaspersoft email listDomains
Add Domains
This command adds the email domain in the supported domain list.
admin jaspersoft email –addDomains
  • Emails will be sent via Jaspersoft only for these supported domains. Other domain specific emails will be rejected.
  • Check if the domains is already in the supported list.
  • If list of domains provided, if some already exists in list then additional domains will be added
Remove Domains
This command removes the email domain in the supported domain list.
admin jaspersoft email –removeDomains
  • Emails will be sent via JASPERSOFT only for the supported domains. Removed domain specific emails will be rejected
  • Checks if provided domains are present in domains list
  • If available removes them otherwise ignores
Advanced Reporting Notifications
This command enables or disables the notification system in JASPERSOFT instance. If enabled, then notifications like email or alert will be sent out from JASPERSOFT else nothing will be communicated to outer world.
admin jaspersoft email disableNotifications|enableNotifications