Error while migrating PMP from MySQL to PgSQL

Error while migrating PMP from MySQL to PgSQL

Hello,

I'm trying to migrate our MySQL database for PMP to PgSQL and have followed the instructions stated here:  http://www.manageengine.com/products/passwordmanagerpro/help/installation.html#migrate

After running the MigrateMySQLToPgSQL.bat, I get this:

  1. C:\Program Files\PMP\bin>MigrateMySQLToPgSQL.bat
  2.         1 file(s) copied.

  3. Creating PgSQL configuration files.................[Completed]
  4. Populating PgSQL database..........................[Completed]

  5. Going to migrate MySQL tables to PgSQL database:

  6. AaaAccAdminProfile.................................[Completed]
  7. AaaAccBadLoginStatus...............................[Completed]
  8. AaaAccHttpSession..................................[Completed]
  9. AaaAccOldPassword..................................[Completed]
  10. AaaAccount.........................................[Completed]
  11. AaaAccountOwner....................................[Completed]
  12. AaaAccountStatus...................................[Completed]
  13. AaaAccOwnerProfile.................................[Completed]
  14. AaaAccPassword.....................................[Completed]
  15. AaaAccSession......................................[Completed]
  16. AaaAccSessionAudit.................................[Completed]
  17. AaaAccSessionProp..................................[Completed]
  18. AaaAccUserProfile..................................[Completed]
  19. AaaAce.............................................[Completed]
  20. AaaAuthorizedRole..................................[Completed]
  21. AaaContactInfo.....................................[Completed]
  22. AaaDisableAuth.....................................[Completed]
  23. AaaEnvironmentEntry................................[Completed]
  24. AaaGenderHonorific.................................[Completed]
  25. AaaImpliedByTableColumn............................[Completed]
  26. AaaImpliedPermission...............................[Completed]
  27. AaaImpliedRole.....................................[Completed]
  28. AaaImpliedTableColumn..............................[Completed]
  29. AaaSSOConfig.....................................[Completed]
  30. AaaLDAPAdapter.....................................[Completed]
  31. AaaLogin...........................................[Completed]
  32. AaaMethodParams....................................[Completed]
  33. AaaMethodPermission................................[Completed]
  34. AaaModuleService...................................[Completed]
  35. AaaOrganization....................................[Completed]
  36. AaaOrgContactInfo..................................[Completed]
  37. AaaOrgContactUser..................................[Completed]
  38. AaaOrgDetail.......................................[Completed]
  39. AaaOrgPostalAddr...................................[Completed]
  40. AaaOrgStatus.......................................[Completed]
  41. AaaOrgUser.........................................[Completed]
  42. AaaPamConf.........................................[Completed]
  43. AaaPamModule.......................................[Completed]
  44. AaaPamModuleOption.................................[Completed]
  45. AaaPassword........................................[Completed]
  46. AaaPasswordHint....................................[Completed]
  47. AaaPasswordProfile.................................[Completed]
  48. AaaPasswordRule....................................[Completed]
  49. AaaPasswordStatus..................................[Completed]
  50. AaaPermission......................................[Completed]
  51. AaaPostalAddress...................................[Completed]
  52. AAARadiusConfig....................................[Completed]
  53. AaaRole............................................[Completed]
  54. AaaRoleCategory....................................[Completed]
  55. AaaRoleOwner.......................................[Completed]
  56. AaaRoleToCategory..................................[Completed]
  57. AaaService.........................................[Completed]
  58. AaaServicePasswordRule.............................[Completed]
  59. AaaSimplePermission................................[Completed]
  60. AaaTableAccessSPI..................................[Completed]
  61. AaaTablePermission.................................[Completed]
  62. AaaTableReadPermission.............................[Completed]
  63. AaaTableUpdatePermission...........................[Completed]
  64. AaaTrustedRole.....................................[Completed]
  65. AaaUser............................................[Completed]
  66. AaaUserConfigRecord................................[Completed]
  67. AaaUserContactInfo.................................[Completed]
  68. AaaUserPostalAddr..................................[Completed]
  69. AaaUserProfile.....................................[Completed]
  70. AaaUserProperty....................................[Completed]
  71. AaaUserStatus......................................[Completed]
  72. AaaUserTwoFactorDetails............................[Completed]
  73. ActiveDirectoryInfo................................[Completed]
  74. Calendar...........................................[Completed]
  75. Periodic...........................................[Completed]
  76. Ptrx_AaaContactInfo................................[Completed]
  77. Ptrx_AaaOrgDetailInfo..............................[Completed]
  78. Ptrx_AAARadiusConfig...............................[Completed]
  79. Ptrx_AccAddFileColumn..............................[Completed]
  80. Ptrx_AccAtriDefVal.................................[Completed]
  81. Ptrx_AccessControl.................................[Completed]
  82. Ptrx_AccessControlAdmin............................[Completed]
  83. Ptrx_AccessControlTask.............................[Completed]
  84. Ptrx_AccessControlUsers............................[Completed]
  85. Ptrx_AccessedTime..................................[Completed]
  86. Ptrx_AccessRights..................................[Completed]
  87. Ptrx_Account.......................................ERROR OCCURRED: while migrati
  88. ng data from MySQL to PgSQL.
  89. ERROR OCCURRED: Error while creating custom reports.
  90. Data migrated from MySQL to PgSQL server successfully.
  91. Error while encrypting mysql columns.
  92. Error while encrypting mysql columns.
I feel like that I have tried almost everything now, but I can't get it to work. Any ideas?

Thanks!

                  New to ADSelfService Plus?