Having Issue with ALM crash after going into the Customization screen within a project after transferring from another project in ALM 12?

  • Questions
  • Having Issue with ALM crash after going into the Customization screen within a project after transferring from another project in ALM 12?
Question ID: 106526
0
0

Hello,
I am having an issue in that when I am within the customization of one project and then exit that setting and use the option to go to another project from them menu, then when I try to enter the new project’s customization screen the system hangs and crashes.

However, I have found that if I exit the customization on the first project, then log out, and log into the new project from the start screen then I can go into the second project’s customization without any issue.

How can I stop this from occurring as it is annoying and shouldn’t work like this, as it has worked in last versions. Only since upgrading to ALM 12 versions have we experienced this issue.

Thanks for any help,
Homer J

Marked as spam
Posted by (Questions: 327, Answers: 19)
Asked on December 1, 2015 4:07 pm
1 views
Answers (1)
1
Private answer

Hi HomerJ,
I have heard from HP that this is in fact an known issue and bug within the newest versions. They have provided a set of queries to run against the projects Sequence table (run this at your own risk and make sure before doing so to have known good backups in place should something occur. It is also recommended to try this in a test environment on your system first).

the queries are as follows (make sure to adjust them for your correct naming of the sequence table within the project as if the table naming is different then the queries will fail for your instance):

''.. we are aware of this bug, please run the provided query in order to fix the issue with the extension.

insert into td.ACTIONS (AC_ACTION_NAME, AC_IS_SYSTEM_INTERNAL,
AC_GRANT_MASK, AC_OWNER_SENSIBLE, AC_OWNERED_TABLE,
AC_IS_COLUMNS_MODIFY, AC_IS_AUDIT, AC_ENTITY_NAME,
AC_OPERATION_NAME)
values ('ac_ei_open_bpca_url', NULL,
(select AC_GRANT_MASK from td.ACTIONS where AC_ACTION_NAME='ac_ei_manage_defect_pool'),
(select AC_OWNER_SENSIBLE from td.ACTIONS where AC_ACTION_NAME='ac_ei_manage_defect_pool'), '-', 'N', 'N','BPCA', 'Open_Bpca_Url')

insert into td.ACTIONS (AC_ACTION_NAME, AC_IS_SYSTEM_INTERNAL, AC_GRANT_MASK, AC_OWNER_SENSIBLE,AC_OWNERED_TABLE, AC_IS_COLUMNS_MODIFY, AC_IS_AUDIT, AC_ENTITY_NAME, AC_OPERATION_NAME)
values ('ac_ei_view_bpca_result_url', NULL,
(select AC_GRANT_MASK from td.ACTIONS where AC_ACTION_NAME='ac_ei_manage_defect_pool'),
(select AC_OWNER_SENSIBLE from td.ACTIONS where AC_ACTION_NAME='ac_ei_manage_defect_pool'), '-', 'N', 'N','BPCA', 'View_Bpca_Result_Url')

update SEQUENCES set SQ_SEQ_VALUE=SQ_SEQ_VALUE+1 where SQ_SEQ_NAME='td.ACTIONS_VERSION'

''

I hope this helps your situation,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 721)
Answered on December 1, 2015 4:12 pm
Thanks for the queries. They have been applied and seem to be working so far. I will continue to monitor but this seems to have fixed our issue! Thanks!!
( at December 1, 2015 4:54 pm)