Governance is not installing on Vapp

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

Adding governance to vapp deployment installation, get deployment failing

 

Environment

Release : 14.3, 14.4, 14.5 

Component : IdentityMinder(Identity Manager)

Cause

1)  tail_ig_log shows will show these generic errors:
      service jboss.deployment.unit."eurekify.war".component."com.eurekify.i18n.LocalizationHelperConfigListener".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.eurekify.security.ClearUserDetailsFilter".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.eurekify.security.SecurityFilter".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.eurekify.security.VerifyAuthenticationFilter".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.eurekify.spring.SpringContextLoaderListener".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.sun.faces.config.ConfigureListener".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.sun.jersey.server.impl.container.servlet.Include".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."com.sun.jersey.spi.spring.container.servlet.SpringServlet".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."javax.faces.webapp.FacetTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.acegisecurity.taglibs.authz.AccessControlListTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.acegisecurity.taglibs.authz.AclTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.acegisecurity.taglibs.authz.AuthenticationTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.acegisecurity.taglibs.authz.AuthorizeTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.apache.wicket.protocol.http.WicketFilter".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.filter.DelegatingFilterProxy".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.DispatcherServlet".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.BindTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.EscapeBodyTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.EvalTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.HtmlEscapeTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.MessageTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.NestedPathTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.ParamTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.ThemeTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.TransformTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.UrlTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.CheckboxTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.CheckboxesTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.ErrorsTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.FormTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.HiddenInputTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.InputTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.LabelTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.OptionTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.OptionsTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.PasswordInputTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.RadioButtonTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.RadioButtonsTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.SelectTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.deployment.unit."eurekify.war".component."org.springframework.web.servlet.tags.form.TextareaTag".START (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
      service jboss.undertow.deployment.default-server.default-host./eurekify (missing) dependents: [service jboss.deployment.unit."eurekify.war".deploymentCompleteService]
JBAS014777:   Services which failed to start:      service jboss.undertow.deployment.default-server.default-host./eurekify

2) eurekify.log errors:

13:57:51,887 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 2) JBAS015003: Found eurekify.war in deployment directory. To trigger deployment create a file called eurekify.war.dodeploy
13:58:02,541 INFO  [stdout] (Timer-2) 2020-09-04 13:58:02,529 [Timer-2] INFO  com.workpoint.server.ServerProperties  - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis, value=-17
13:58:02,898 INFO  [stdout] (Timer-3) 2020-09-04 13:58:02,884 [Timer-3] INFO  com.workpoint.queue.core.QMonitor  - QMonitor alertq#AlertQ1#72 successfully started.
13:58:03,765 INFO  [stdout] (Timer-4) 2020-09-04 13:58:03,760 [Timer-4] INFO  com.workpoint.queue.core.QMonitor  - QMonitor jobq#JobQ1#73 successfully started.
13:58:03,796 INFO  [stdout] (Timer-2) 2020-09-04 13:58:03,796 [Timer-2] INFO  com.workpoint.queue.core.QMonitor  - QMonitor actionq#ActionQ1#74 successfully started.

3) This messages indicates that some problem in IG DB.

13:58:03,213 ERROR [org.springframework.web.context.ContextLoader] (MSC service thread 1-6) Context initialization failed: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tmsClientInjector' defined in class path resource [META-INF/applicationContext.xml]: Cannot resolve reference to bean 'connectorDal' while setting bean property 'connectorDal'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'connectorDal' defined in class path resource [META-INF/managerContext.xml]: Cannot resolve reference to bean 'connectorDalTarget' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'connectorDalTarget' defined in class path resource [META-INF/applicationContext.xml]: Cannot resolve reference to bean 'raciManager' while setting bean property 'raciManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'raciManager' defined in class path resource [META-INF/securityContext.xml]: Invocation of init method failed; nested exception is org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2

Resolution

Check if not reusing existing DB. If yes, ask to DBA leave only the users and drop the tables (this will lost all data if have any in tables. Do this if doing deploy from scratch and a you are sure that has no data in tables. if in doubt, make a backup of the database as a precaution.)

1. undeploy IG

2. ask to DBA drop the tables for each of IG users:

EUREKIFY_SDB
TICKET_DB
REPORT_DB
WPDS

3. Also double check if they Granted a quota to the tablespace of the Identity Governance database

4. Ask to DBA also double check these permissions with WPDS:

And also if granted  the  XA permissions on the database to the WPDS user as by running the following statements (for full details, see: https://access.redhat.com/solutions/22274):

     GRANT SELECT ON sys.dba_pending_transactions TO <WPDS_USER>;
     GRANT SELECT ON sys.pending_trans$ TO <WPDS_USER>;
     GRANT SELECT ON sys.dba_2pc_pending TO <WPDS_USER>;
     GRANT EXECUTE ON sys.dbms_system TO <WPDS_USER>;
     GRANT FORCE ANY TRANSACTION TO <WPDS_USER>;

5. Deploy IG and now deployment is done successfully and will create all IG tables in DB.