Upgrade Identity Manger from 12.6 SP7 to 14.3 (Reporting Server)

[Jiangping Li]

Hi There,

We are looking at doing an in-place upgrade for a customer from IM 12.6 SP7 to 14.3. By checking the online documentation, it seems that all components except the reporting server will be ok for an in-place upgrade.

According to the documentation "Upgrade the Report Server", I will need to (Use Case 2) "Install and configure CA Business Intelligence JasperReports Server."

Basically, I will need to set up a "CA Business Intelligence JasperReports Server 6.4.3" to replace "CA Business Intelligence 4.x" that is already in the existing 12.6 SP7 environment.

My questions are:

•  When we install the new "CA Business Intelligence JasperReports Server 6.4.3", can it use the existing snapshot database and report database that are used by the existing "CA Business Intelligence 4.x" report server?
• If the answer is NO, we will have to create new snapshot database and report database for the new "CA Business Intelligence JasperReports Server 6.4.3". Then we need to know if we have to migrate the existing data in the existing databases to the new databases and how to do it.
• We have a few custom reports defined in the environment. Can anyone provide pointers/suggestions/tips/tools that might help with converting them to the new reporting server. I could not find any documentation about this.

Thanks
JP

[Scott Owens]

Hi JP,

4.x is an older release and no longer supported by Tibco.  With 14.3 we know support Jasper 7.1.1.  I recommend you upgrade from 4.x to 6.4.3 and once that is complete you upgrade to Jasper 7.1.1.

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-release-notes/v643/upgrade-notes#Upgrade3

http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/business-intelligence/6-4-3/upgrading-ca-business-intelligence-jasperreports-server.html

Back up everything including the database and perform the upgrade to 6.4.3.  Once completed and working, upgrade to 7.1.1.

You may also review encryption.  I believe in the older releases it was clear txt and the newer releases expect encrypted.  See the KB below on the steps to set this.

Reset Jaspersoft password for encryption

https://ca-broadcomcsm.wolkenservicedesk.com/wolken/esd/knowledgebase_search?articleId=136102

------------------------------
Best regards,

Scott Owens
Sr Support Engineer

------------------------------
And, as always Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.

Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at [e-mail]. https://www.hcltech.com/enterprise-studio
------------------------------
------------------------------

[Bill Patton]

To add to what Scott posted above

You need to see Use Case number 2 here:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-manager/14-3/upgrading/upgrade-the-report-server.html#concept.dita_0cdc7d2ddfb52dd7b8838d814fa2003b4d8a0ca6_bodyContent

it talks about upgrading CA Identity Manager (that supports CA Business Intelligence 4.x) to a release (that supports CA Business Intelligence Reports Server 6.2, 6.3, 6.4.3),

The process only talks about using a fresh database, I cannot find any information on schema changes from report server 4.x to 6.x so I am unsure if you can use the same database. You could create a "dummy" database that is a copy of the current database and as a test and use that while testing an upgrade, but since this is not documented at Broadcom we are unsure of what the results may be.

3) Migrate custom objects:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/business-intelligence/6-4-3/administration/import-and-export.html



Bill Patton

------------------------------
And, as always Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.

Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at [e-mail]. https://www.hcltech.com/enterprise-studio
------------------------------

[Jiangping Li]

Thanks Guys for your reply.

According to the documentation "Upgrade the Report Server", I will need to (Use Case 2) "Install and configure CA Business Intelligence JasperReports Server."

So I guess I will tried the steps out in my test environment and see how I go.

Regards,
JP