• State Suggested Answer
  • Replies reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    27
  • Views views
    81
  • Users 0 members are here

IDM Analyzer and MySQL

tschloesser

Dear Forum,

to enhance the performance of IDM Analyzer, I configured it to use a (local) MYSQL8 Database.

This did enhance the import performance dramatically - in my case from 10+ hours to less than 10 minutes!

Unfortunately the uniqueness test, which did work before, is running into an SQL error, and I did not find any way to dive deeper into this issue.

The only thing I am receiving in Analyzer is the following error:

Can anybody please provide some hints, to solve this issue?

BTW: I ain't a DB geek, and tehrefore I do not konw, how to debug this issue from the DB side, but if anybody can provide the steps to debug the SQL query on the server-side, this could be more than useful.

Kind regards

Thorsten

Tags:

  • Suggested Answer

    0

    Meanwhile, I was able to solve the issue on my own ;-)

    Replacing MySQL 8 with the latest MySQL 5.7 version, Analyzer was able to run the uniqueness test and other operation without any trouble.

    From the technical perspective, the SQL query should not be very special, so I am really wondering why MySQL 8 cannot be used, but finally, I got a performant and working solution.

    I believe, Analyzer did not change (much) since its first release, and therefore it has to be used with a rather old version of MySQL! Maybe it would be worth to add a note reading the compatibility to the documentation.

    Kind regards

    Thorsten

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.