XML XOG issue for more 65 GB File and got time out issue

The below settings has been done in addition to session time out and the environment has load balancer too.


TCP timeout was set to 10 min on ARP and load balancers. This was increased to 30 min same as idle time out in clarity.

note: there is no issue without load balancer. 
Regards,
Bala

Resource Allocation Calculation

) Resource X availability is 8 hrs per day.        

2) Resource X,  50% allocated for X Project,

    75% allocated for Y 

100% Allocated for Z Project.  

 

Allocated Hrs Per Day:                           

X project : 4 hrs day , Resource X Availability : 8 hrs per day   (also it will consider calendar and date of hire)

Y Project : 6 hrs day

Z project : 8 hrs day

Note : it could be for different period.

 % Allocation =

(allocated Hrs per Day for particular project)/Availability Hrs per day

 

(4/8)*100 = 50% 

 

(6/8)*100 = 75% 

 

(8/8)*100 = 100% 

Regards,

Bala

Application Portfolio Management Add-In In Clarity

Application Portfolio Management (APM) Add-In

CA PPM SaaS has Application and Portfolio Management (APM) capabilities that allow organizations to track and analyze their application portfolio. The application portfolio is an important portfolio to manage for the following reasons:

1. Organizations tend to accumulate applications over time (due to purchasing, mergers and acquisitions) and not all applications deliver value.
2. Certain applications may be redundant to each other, meaning that an organization has multiple applications that deliver the same capability.
3. Research tells us that organizations typically have a larger percentage of IT spend aligned to supporting these applications.
4. Organizations have limited budgets and are constrained with respect to funding innovation.

Benefits

The Application Portfolio Management (APM) add-in helps you manage your application portfolios. APM shares objectives that align with your existing project and portfolio management goals. This add-in helps you invest in people and allocate funds to their maximum value. Application rationalization and risk management help you reduce costs and deliver the most important services. 

Organizations that are interested in Application Portfolio Management are concerned with a few key questions:

• Which applications can we retire to save money?
• Which applications can we add to the portfolio?
• How can we better manage application risk?
• How are our projects performing on key applications?

Use APM to rank your applications based on mission criticality, risk, business value, and technical value. 

What Does the APM Add-In Include?

This add-in includes new CA PPM SaaS attributes, subobjects, portlets, and the following reports:

• Application Assessment Analysis: This report compares mission criticality with risk. Use this report to identify the high-risk critical applications and to determine which actions to take as a result. 
• KPIs by Application: This report lists applications, that are grouped by either manager, software category, or mission criticality. Use this report to view the key performance indicators of value score, technical score, and risk score with the number of users and the annual planned cost for each application.

Like other add-ins, APM is delivered as part of CA PPM SaaS. Your organization can decide whether to install and use this optional functionality.R

Clear Cache in Server Level to avoid clearing the Cache in Local machine

STEP 2: Clear the CA PPM Server cache.
a. Login to CA PPM application as an admin user 
b. Modify the URL field to: http:///niku/nu#action:security.caches
c. Click Caches tab, click FLUSH ALL button
d. Click Groups tab, click FLUSH ALL button 
e. Logout
f. Login and check if problem persists.


That's Correct, Its better to be doing via CSA/Server and if you use flush all from security.caches and user don't log out then he/she will be in the same server and it will be quicker

Use this stored procedure to get the Auto number from Production

CALL CMN_AUTONUM_GET_NEXT_SP('project', 'unique_code', 'NIKU.ROOT', 'inv_investments', 'code', NULL, 5000000, :P_NEXT_ID)

How to find the template used for the project creation in CA Clarity PPM

Use the below query to find the template used during project creation. 

select object_id project_id,src_object_id template_id
from ODF_OBJECT_COPY_FLAT
where object_code='project'

Happy coding.

Bala

SAP Connect PPM+ add on

There is also the option of connecting our CA Clarity PPM with SAP CO or FI using our SAP Connect PPM+ add-on.

Improving Actuate Reporting Performance in Clarity

Improving Actuate Reporting Performance in Clarity

 

Reporting Performance issue is very common and an challenge to address it.I faced that and managed to overcome with the help of experts advice and some ground work.i worked and tested in throwly in Test server and then implemented in Production.This is specific to Actuate Reporting.

1. Tuning the Sql
In Most situations the poor performance of Reports is due to inefficient Sql.Pls extract the SQL queries to run them directly against the database to measure the Performance.Tuning your SQL is often the best way to increase overall Reporting performance.

2. Minimise the data
Minimise the data in your report at every opportunity. Only bring back records that are required.That will improve the reporting performance significantly.Less Data More speed.Optimize the Tables & Indexes.

3. Run acverify utility Monthly.
The acverify command-line utility validates an Encyclopedia volume and optionally attempts to repair problems found in the volume. Use acverify with an offline volume.It cannot be used with an online volume.
Command:- Run acverify check all repair

4. Archiving
Clear the Old Archival Files which will Free enough space and will boost the Reporting server performance.

A) Setting archive folder
Create a new environment variables in the actuate server called AC_ROOT_FOLDER and set the archive folder.

B) Setting the archive library
Login to Actuate Management Console System Administration, click at System Volumes -> General. Enter the archive library path into the archive library name. The archive.dll usually located in the Actuate9\iServer\Examples\Archive folder.You need to restart the server for this field to take effect.

C) Setting archive rules
Login to Actuate Management Console System Administration then go to the Files and Folder(where the roi files resides,usually /cus/) and right click properties and then select the file type to archive (Actuate Report Document - roi) and choose the Archive files before deletion Option.
This option will archive the files to the archive folder before the file is deleted. This is useful to recover the report at a later stage.However, this will add on additional disk space in the server as it will be keep as an archive file.So probably after some time you can delete the Files.

D)Setting archive schedule
Login to Actuate Management Console System Administration thenClick at Volume -> Archive Schedule then Select the start date and time to start the schedule. Advise to start the archive schedule during non peak hours and the time doesn’t clash with the backup schedule.

5. Increase the Buffer pool size
In Actuate Management Console System increase the Buffer pool size where the default is 10mb.Actuate iServer manages this information using a page buffer pool.Actuate recommends setting the buffer pool as large as possible to keep the buffer pool data in the Actuate iServer machine’s memory and not in the machine’s disk swap space.

6. Adding Factory processes (Important)
In both stand-alone and cluster configurations, the optimum number of Factory processes for Actuate iServer depends on the speed of the CPU that runs the Actuate iServer workload and the mix of reports in the workload.To begin, configure two Factory processes on a processor. Adding Factory
processes can enhance performance if the database that Actuate iServer uses to create reports is a performance-limiting resource.
Actuate iServer can use the multiple Factory processes to run multiple, simultaneous reports that use the database. When Actuate iServer runs multiple, simultaneous reports, some of the Factory processes access the database while other Factory processes perform report generation tasks that do not access the database.

7. Increase the View Server Performance.
The default value is 50, which means 50MB.You can increase the file size accordingly.The View process maintains caches for reports and report executable files. You can set Actuate iServer parameters to configure cache sizes, time-out values, and other View process parameters. In most cases, you do not have to change the values for these parameters from the default values.
The View process stores session information in a cache. Increasing cache size can improve View process performance when cache size is a limiting resource. The View process uses cache to store ROX files and view session information.

8. Improve report generation for long running reports
Improve report generation for long running reports by increasing the value of the environment variable.The default is 15 seconds, you can increase to 30 seconds.
AC_FACTORY_PAGE_COUNT_UPDATE_INTERVAL -- default is 15 seconds.

9. De fragmenting the Report Encyclopedia
To improve Report Encyclopedia performance, run the ACDEFRAG utility on a regular basis. Alternatively, back up and restore the Report Encyclopedia using the ACEXPORT AND ACIMPORT utilities on a regular basis.

10. Optimizing Memory
Actuate recommends a minimum of 1GB of RAM per CPU for Large Workloads.It is important not to use up all available memory.When CPU Requires more memory than available.There must be standards for each server like WebbLogic,Webshere and Tomcat,stick on that.

11.Run the Remove Job Logs and Report Library Entries
This job removes job log and Report Library entries from databases that are
older than a specified number of days.Schedule it weekly.

12.Schedule the Reports
During High Traffic Times Run large reports by scheduling rather running immediately and also if possible
schedule it on Non Peak Hours.

13. Seperate Server for Reporting
To provide for sufficient resources for both Application and Database servers, place the report server on a different CPU from the database or application server . Both report generation on the report server and database or application server tasks are CPU-intensive. If you cannot place the report server and database server on separate CPUs, plan for additional CPU, memory, and disk resources to support the report server.

14. Check All Resource Utilizing
Check the Operating System resources including I/O ,Network ,CPU and Memory.

15. Monitor the Reporting Performance
Monitor the Report performance via OS Utilities at regular Intervals which will help you to analyze Performance.

* For windows -- Windows Task Manager,Windows Performance Monitor.
* For Unix -- Top,Vmstat,iostat,netstat,sar

Set Environment Variable Java home

Please find the screen shot for the same.


Note: "bin" folder add only at the end of path.

Hidden knowledge about the Clarity Tables

I had a experience during installation of Clarity 13.3, though database available.
And not connected directly to the table level, due to right access.(Ref previous article Label:Clarity Install)

If you look at the clarity tables it starts with "Niku.ddd" ,
But from Clarity application, it will use only ddd. so in that case the user which going to create in database must have the right access and select query has work with out "niku".

You must enable the access and need to run query with out niku..

Happy installation by Bala

Clarity 13.3 with SQL SERVER 2008 R2

I have installed Clarity 13.3 with SQL SERVER 2008 R2 and faced issue
though followed all the steps in the installation document of Clarity 13.3.

I have configured the database in NSA, and it says available, also health check report is green for database. But the status of the installation "Database incomplete".

We tried many options and could not find the root cause, finally found there is an access issue.

After setting up the changes, finally in Clarity i could see database complete.

Clarity Installation Check

To view the IP Address for the server name/host name
Please use the below command for viewing the IP address

ping -a -4

Happy Coding
Bala

Clarity Installation Check

Using the below command in the command prompt will help us to see the list of port open for the server.
netstat -aon



Happy Coding
Bala

Maintain date format in Excel for Clarity Data migration

Function GetPhilipsWeekYear(getDate As String)
 Dim weeknumber As String
 Dim YYYear As String
 Dim mmmonth As String
 Dim strDate As String
 Dim dddate As String
If getDate <> "" Then
 ' Getting the Week Number and Any format will convert to "mm-dd-yyyy"

strDate = Format(getDate, "mm-dd-yyyy")
 weeknumber = Application.WorksheetFunction.WeekNum(strDate, 21)
 ' Getting the year from the date
 YYYear = Year(getDate)
 mmmonth = Month(getDate)
 dddate = Day(getDate)

 GetPhilipsWeekYear = YYYear & "-" & mmmonth & "-" & dddate & "Bala"
End If
End Function

User Configuration After upgrade loses verify in this table and take back up before upgrade Clarity 12.1.3 from 12.1.0

ODF_Filter_Expressions 

Custom objects deletion

Note :

we can delete the custom object and but it will delete only the tables in the database
relevant views, functions stored procedure will not be deleted.

Also note, if you create again same object and still can not be used existing stored procedure , function,
internal database might be changed lot.

What is stock Object in Clarity

Stock object nothing but a out of box objects which is available in Clarity.

Note: Stock object can not be deleted.

 

Clarity Exam Questions

Question 1

Which open standards does CA Clarity PPM support? (Choose three)

A. Web Ontology Language (OWL)

B. Java Database Connectivity (JDBC)

C. Java 2 Platform, Enterprise Edition (J2EE)

D. Lightweight Directory Access Protocol (LDAP)

E. Synchronized Multimedia Integration Language (SMIL)

Ans: B, C, D

Question 2

If you are configuring an Oracle database for CA Clarity PPM v13, which tasks do you need to perform? (Choose two)

A. Set the Oracle Net Manager port to 1521.

B. Configure at least one listener per server.  Yes

C. Run the setup.exe file in the disk1 directory.

D. Configure a Transparent Network Substrate (TNS) entry. Yes

Right answer: B,D

Question 3

Before you can run datamart jobs, which tasks do you need to perform? (Choose three)

A. Create partition rules.

B. Configure action items.

C. Define time slice ranges.

D. Select the datamart entity.

E. Select the datamart currency.

Ans: C, D, E

Question 4

Which Oracle database details do you need for the Clarity System Administration (CSA)? (Choose three)

A. Database server name

B. Database listener name

C. Location of tnsnames.ora file

D. Schema username and password

E. Oracle System ID (SID) and/or service name

Ans:A,D,E

Question 5

You have installed CA Business Intelligence (CABI). Next, under the Properties > Reporting tab of Clarity System Administration (CSA), which URLS do you need to set? (Choose two)

A. Web URL

B. Service URL

C. Proxy Host URL

D. Web Service Description Language (WSDL) URL

Ans: A, C

Right Answer : A,B

Question 6

Which file stores the details of Clarity System Administration (CSA) settings?

A. niku.ear – Used websepeer

B. properties.xml

C. clarity_home.xml

D. CA_Clarity_PBK.BIAR

Ans: B

Question 7

Which password expression metacharacter is used to denote a whitespace character?

A. \s

B. \S

C. \w

D. \W

Ans: A

Question 8

Because you are about to apply a Fix Pack, you want to make sure that you minimize the possibility of data and configuration loss. For this reason, you will use the admin backup command on the CA Clarity PPM application server. What does the admin backup command back up?

A. CA Clarity PPM folders only

B. CA Clarity PPM folders and database only

C. CA Clarity PPM folders, Apache Tomcat folders, and the database

D. CA Clarity PPM, Apache Tomcat, and CA Business Intelligence (CABI) folders and the database

Ans: A

Question 9

When you manage CA Clarity PPM services in Clarity System Administration (CSA), which action packages the service startup files?

A. Add

B. Start

C. Deploy

D. Refresh

Ans: C

Question 10

What is the correct syntax for validating a Generic Execution Language (GEL) script?

A. Validate gel .xml

B. Validate .xml gel

C. gel .xml –validate

D. .xml gel –validate

Ans :C

Question 11

In the test.properties file, the portnumber parameter is the non-Secure Sockets Layer (SSL) port number used on the server. What is the default value of this parameter?

A. 60

B. 70

C. 80

D. 90

Ans: 80

Question 12

After you install the XML Open Gateway (XOG) client, you need to verify the required folders and files are installed properly. Which folder contains the batch file to run the XOG client and .properties file to set the client parameter?

A. lib

B. bin

C. xml

D. xsd

Ans: B

Question 13

In the folder structure created by the XML Open Gateway (XOG) client install, what are the two main folders you will use?

A. \bin and \xml

B. \prj and \rsm

D. \xog and \biz

C. \cmn and \pac

Ans : A

Ans: b

Ans:  b

Ans: C

Ans: a

SOAP SONAR using Clarity Webservices

SOAP SONAR is the tool to validate the webservices which is created in Clarity PPIM

Gel Script Execution error in local machine - Client

Unspecified folder path error

better to install XOG Client folder with out space, so that we can avoid "unspecified error"


Install XOG client C:XOG not in

C:\Program Files (x86)\CA\Clarity\CA Clarity PPM XOG\bin