Forum Stats

  • 3,874,184 Users
  • 2,266,680 Discussions
  • 7,911,761 Comments

Discussions

OLVM web portal error ---help me

my update oracle linux 8.6 to 8.7 ,OLVM web portal error display message 500 - Internal Server Error, help me thk

Comments

  • User_IBCS5
    User_IBCS5 Member Posts: 5 Red Ribbon

    same here when deploy new selfhosted engine :

    Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - no procedure/function/signature for 'gettagsbyparent_id'

    at [email protected]//org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:362)

    at [email protected]//org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:114)

    at [email protected]//org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.lambda$createMetaDataProvider$0(CallMetaDataProviderFactory.java:127)

    at org[email protected]//org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:324)

    at [email protected]//org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:70)

    at [email protected]//org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:252)

    at [email protected]//org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:313)

    at org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.compileInternal(PostgresDbEngineDialect.java:106)

    at [email protected]//org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:296)

    at org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.getCall(SimpleJdbcCallsHandler.java:157)

    at org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:134)

    at org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:105)

    at org.ovirt.engine.core.dal//org.ovirt.engine.core.dao.TagDaoImpl.getAllForParent(TagDaoImpl.java:82)

    at deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.TagsDirector.addChildren(TagsDirector.java:116)

    at deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.TagsDirector.init(TagsDirector.java:75)

    ... 64 more


    2022-11-23 02:16:34,380+01 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "engine.ear")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.deployment.subunit.\"engine.ear\".\"bll.jar\".component.Backend.START" => "java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance

      Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance

      Caused by: javax.ejb.EJBException: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke protected void org.ovirt.engine.core.bll.TagsDirector.init() on [email protected]

      Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke protected void org.ovirt.engine.core.bll.TagsDirector.init() on [email protected]

      Caused by: java.lang.reflect.InvocationTargetException

      Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - no procedure/function/signature for 'gettagsbyparent_id'"}}

  • User_IBCS5
    User_IBCS5 Member Posts: 5 Red Ribbon

    on OLVM :

    dnf install postgresql-jdbc-42.2.3-3.el8_2

    service engine-service restart

  • User_IBCS5
    User_IBCS5 Member Posts: 5 Red Ribbon

    for install new selfhosted OLVM :

    change in file /usr/share/ansible/collections/ansible_collections/ovirt/ovirt/roles/hosted_engine_setup/hooks/enginevm_before_engine_setup/pre_setup_tasks.yml

    - name: Add proxy to yum.conf

     lineinfile:

      line: "proxy={{ he_proxy }}"

      path: /etc/yum.conf

     when: he_proxy != ''


    - name: Install Oracle oVirt repo

     yum:

      name: "{{ he_oracle_ovirt_release_rpm_url }}"

      state: present

      validate_certs: no

      disable_gpg_check: yes

     when:

      - ovirt_engine_setup_product_type | lower == 'ovirt'

      - he_oracle_ovirt_release_rpm_url != ''


    - name: Install Oracle oVirt repo

     package:

      name: "oracle-ovirt-release-el8"

      state: present

     when:

      - ovirt_engine_setup_product_type | lower == 'ovirt'

      - he_oracle_ovirt_release_rpm_url == ''


    - name: Install postgresql-jdbc

     package:

      name: postgresql-jdbc-42.2.3-3.el8_2

      state: present

     when: ovirt_engine_setup_product_type | lower == 'ovirt'


    - name: Exclude postgresql-jdbc update

     lineinfile:

      path: /etc/dnf/dnf.conf

      line: "exclude=postgresql-jdbc"


    - name: Install oVirt Engine packages for restoring backup

     package:

      name: ovirt-engine

      state: present

     when: ovirt_engine_setup_product_type | lower == 'ovirt'


    and execute : hosted-engine --deploy


    Good luck