Cross Project Customization verify fails with no errors in the verify report

  • Questions
  • Cross Project Customization verify fails with no errors in the verify report
Question ID: 107109
1
0

We recently upgraded from ALM 11.52 to ALM 12.50. The ALM 11.52 is still up and running as we are doing a migration over for projects. On some successfully upgraded and migrated projects, we get a verify fail during cross project customization. When doing the cross project, you have to verify the project then when that passes, you do the apply after. However some projects fail the verify and the verify reports show no failures. Everything in the report is a pass, but overall the verify fails.

Please help as this is preventing us from moving forward on doing any new template customization and applies.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on September 23, 2016 2:16 pm
22 views
Answers (1)
1
Private answer

Hello,

Evidently there is a known issue that ''sometimes'' comes up during upgrade from 11.52 to 12.01 and up ALM. According to HP this issue does not always occur (upgrade sometimes corrects for and sometimes does not). It will be patched for ALM 12.53 patch 1 and on going, according to HP.

This is referenced in QCCR1J86086

The issue is that some records in the ACTION table were taken out for 12.01 ALM and up. But the upgrade process may or may not remove them.

To check for culprit items, please run the following query on the template project database:

select * from td.actions where AC_ACTION_NAME in (
'ac_kill_process_pc',
'ac_check_host_pc',
'ac_install_patch_pc',
'ac_reboot_machines_pc',
'ac_reconfigure_host_pc',
'ac_dp_queue_pc',
'ac_download_apps_pc');

*This is a query for SQL DB, remove the table prefix if using Oracle.

If the above query pulls results, then proceed to the following.

**Please make a backup of the template DB and repository for security reasons.**

Run the below query on the template DB:

delete from td.ACTIONS where AC_ACTION_NAME in (
'ac_kill_process_pc',
'ac_check_host_pc',
'ac_install_patch_pc',
'ac_reboot_machines_pc',
'ac_reconfigure_host_pc',
'ac_dp_queue_pc',
'ac_download_apps_pc');

update SEQUENCES set sq_seq_value=sq_seq_value+1 where sq_seq_name='actions_version'

At this point, try the verify again and it should pass.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on September 23, 2016 2:20 pm
Great reply! The first query pulled a result for each action item. Ran the delete statement and now the verify passes.
( at September 23, 2016 2:27 pm)
EyeOnTesting