[midPoint] Ninja tool error - Update 3.7.2 - 3.8

[Fabian Bosch]

Hi

it has been a while but I had the same setup and error while upgrading.

As far as I remember this did the trick:

  * setup a new DB (the schemas aren't compatible)
  * download jdbc-driver and save to any location (to explicitly name it
    for ninja-tool)

    https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar

  *

    use ninja-3.2.7.jar out of midpoint-3.8's sources to export the
    3.2.7-Objects

      o

        java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja-3.7.2.jar -m /opt/midpoint/midpoint-3.7.2-home -U 'jdbc:mariadb://localhost:3306/midpoint' -u 'midpoint' -p '<pw>' export -O midpoint-pre-v3_8.zip -z -l 4`

  * start your new mP3.8-Instance with new DB (use provided sql-script
    for initial db-setup like in any new installation beforehand)

  * then import the Objects using ninja.jar out of midpoint 3.8's sources

      o

        java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja.jar -m /opt/midpoint/midpoint-3.7-home -U 'jdbc:mariadb://localhost:3306/midpoint38' -u 'midpoint' -p '<pw>' import -i midpoint-pre-v3_8.zip -z -l 4` 

good luck!

Fabian

Am 13.11.18 um 15:14 schrieb Nico:
> Hello everyone,
>
> i am trying to update an existing midpoint instance 3.7.2 with mariaDB
> to 3.8.
>
> My installation path is: /opt/idm/midpoint-3.7.2/
> And my MIDPOINT_HOME is: /opt/idm/midpoint-3.7.2/var
> Java 1.8.0.191 is installed
>
> config.xml looks like:
>         <repository>
>            
> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
>             <database>mariadb</database>
>             <jdbcUsername>midpoint</jdbcUsername>
>             <jdbcPassword>PASSWORD</jdbcPassword>
>            
> <jdbcUrl>jdbc:mariadb://HOST:3306/midpoint?characterEncoding=utf8</jdbcUrl>
>         </repository>
>
> Command: /opt/idm/midpoint/bin/ninja.sh -v count
> (Like said in the upgrade documentation step 1.c)
>
> The Error says:
> 2018-11-13 14:58:09,518 [main] INFO  (SYSOUT): Initializing repository
> using midpoint home
> Unexpected exception occurred (class
> org.springframework.beans.factory.UnsatisfiedDependencyException),
> reason: Error creating bean with name 'repositoryService': Unsatisfied
> dependency expressed through field 'sequenceHelper'; nested exception
> is org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'sequenceHelper': Unsatisfied dependency
> expressed through field 'objectUpdater'; nested exception is
> org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'objectUpdater': Unsatisfied dependency
> expressed through field 'closureManager'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'orgClosureManager': Invocation of init method
> failed; nested exception is org.hibernate.TransactionException:
> Transaction not successfully started
> Exception stack trace:
> org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'repositoryService': Unsatisfied
> dependency expressed through field 'sequenceHelper'; nested exception
> is org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'sequenceHelper': Unsatisfied dependency
> expressed through field 'objectUpdater'; nested exception is
> org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'objectUpdater': Unsatisfied dependency
> expressed through field 'closureManager'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'orgClosureManager': Invocation of init method
> failed; nested exception is org.hibernate.TransactionException:
> Transaction not successfully started
> ...
> ...
> ...
> Caused by: org.hibernate.TransactionException: Transaction not
> successfully started
>         at
> org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:202)
> ...
>
> I enabled the sql query log. But there is not one SQL which is getting
> executed.
> Has someone managed to upgrade from 3.7.2 with mariaDB? Or had someone
> the same problem?
>
> Kind Regards
> Nico Pätzelt
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-- 
    -- 
    Fabian Bosch, Solutions-Engineer

    DAASI International GmbH
    Europaplatz 3
    D-72072 Tübingen
    Germany

    phone: +49 7071 407109-0
    fax:   +49 7071 407109-9

    email: fabian.bosch at daasi.de
    web:   www.daasi.de

    Sitz der Gesellschaft: Tübingen
    Registergericht: Amtsgericht Stuttgart, HRB 382175
    Geschäftsleitung: Peter Gietz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20181113/9b4f3fe7/attachment.htm>