• State Suggested Answer
  • Locked Locked
  • Replies 21 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 17251 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

MYSQL integration to sync account from mysql to D1IM7.1

dorisaini
over 7 years ago

Hi All,

 

I have installed and configured OrangeHRM system which is using mysql as backend database. I am trying to sync account from mysql to identity one. I have configured everything and see the schema as well for mysql using Native Database.

When I run execute then I am seeing below error

Could not load or assemble Mysql.Data. System cannot find the file specified.

 

I copied Mysql.Data.DLL file under windows, system32 and DELL/installation directory as well for job server and work station.

 

Please advise.

 

Thanks

Dori

  • 0 over 7 years ago
    So, you are saying you are able to configure your synch project in Synchronization Editor but you are unable to start the synchronization in the same Synch Editor?
  • 0 over 7 years ago
    Thank You Markus,

    I have configured the mysql sync project with one identity but when I execute to bring data from mysql to one identity then it through exception.

    could not load Mysql.Data. System cannot find the specified file.
  • 0 over 7 years ago
    Never seen that before as the same DLL would be needed to create the sync project in the first place.

    Where are you getting the error message exactly? In Sync Edit or in the JobService log? Can you post a full stack trace?
  • 0 over 7 years ago
    Hello Markus,

    Below is the error-

    [2134003] Error executing synchronization.
    [1777018] Error executing workflow (orn) of synchronization project (orangehrm).
    [1777026] Error getting revision of schema type ( (hs_hr_employee))!
    [1777292] Error connecting system (Native Database Connector)!
    [1777223] DistributionConnector: Error connecting the system.
    [System.IO.FileNotFoundException] Could not load file or assembly 'MySql.Data' or one of its dependencies. The system cannot find the file specified.
    at StdioProcessor.StdioProcessor._Execute(Job job)
  • 0 over 7 years ago
    So your are running the sync on a job service.

    Ensure that:

    - the MySQL.Data.Dll is present on the job service executing the sync
    - the Job service is configured as Native Database Connector, means the necessary DLLs like VI.Projector.Database.Native.MySql.dll are present.
    - take a look at the event log if you are able to detect if a dll the MySQL.Data.dll depends on is missing.

    Which version of the MySQL.Data.dll are you using?
  • 0 over 7 years ago
    Thank you Markus for your quick reply.

    I am using Mysql.Data.dll mysql 5.2. Yes I copied this dll under job server directory.
  • 0 over 7 years ago
    VI.Projector.Database.Native.MySql.dll is present under job server installation directory as well under the work station directory.
  • 0 over 7 years ago
    5.2? Are you sure?

    I have a working demo with 6.9.7 of the dll according to the product version of the properties tab in Windows Explorer.
  • 0 over 7 years ago
    yes I download 5.3 .NET or Mono dll from mysql. Let me download 6.9.7 and give a try.
  • 0 over 7 years ago
    After putting 6.9.7 dll file under the job server and work station and restart the job server as well but still see the same error.

    [System.IO.FileNotFoundException] Could not load file or assembly 'MySql.Data' or one of its dependencies. The system cannot find the file specified.