[midPoint] Ninja tool error - Update 3.7.2 - 3.8

[Nico]

 Hello Fabian,

I have followed your instructions and i was able to export all the objects.
Now i'm running on mP3.8.

Thanks for sharing your solution.
Nico Pätzelt

Am Di., 13. Nov. 2018 um 15:42 Uhr schrieb Fabian Bosch <
fabian.bosch at daasi.de>:

> 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
>    -
>
>       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
>
>    -
>
>       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 listmidPoint at lists.evolveum.comhttp://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/20181114/84171e6b/attachment.htm>