Back to forum list… Back to Issues and Problems...

IMan 4.1 - Hung Database Update (2 replies)

Randy
5 years ago
Randy 5 years ago

When attempting to update the DB after upgrade IMan from 3.2 to 4.1, IMan hangs indefinitely.

Steps taken:

  1. Un-licensed and uninstalled IMan 3.2.
  2. Install IMan 4.1.
  3. Attempted to license, ran into issue (will be in another ticket)
  4. Open Admin Console.
  5. In "Database Settings" hit "Test".  "Requires Updates" shows in yellow on screen.
  6. Hit "Update"
https://www.realisable.co.uk/wp-content/uploads/2019/09/2019-09-04_10-52-41.png
Randy
5 years ago
Randy 5 years ago

Disregard for now...

 

After leaving alone, it finally completed after (I'm guessing) 20 minutes.  Is is expected to take this long?  I can give you the row counts of some of the tables if it will help to find the culprit.  The only table I can think of which would be large would be AUDITLOG... if it's related to that then I suggest adding a note about truncating that table first.

Let me know if you'd like to dig further into this.

Support
5 years ago
Support 5 years ago

Its the AUDITLOG table conversion.

In 4.0 we added an incrementing row value and index, so it's this operation which is taking a long time.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close