REXYGEN Community Forum / REX Module error

Re: REX Module error

2016-09-02T10:08:58Z

Hi Adam,
thanks for the update. At the moment I have no better advice than ignoring the error. I'll try some more to replicate the bug but so far I was not successful.

Jaroslav

Re: REX Module error

2016-08-30T17:17:47Z

Hi Jaroslav and Stetina,

It does seem to be only occurring immediately after the Pi is restarted. Enabling 'Wait for Network at Boot', makes no difference.

Do you think I should be worried, or as the error does not seem to be affecting the operation of the system, should I ignore it?

Adam

Re: REX Module error

2016-08-29T09:07:38Z

Hi Adam,
can you please examine this in more detail? Does the error occur only after the Raspberry Pi is powered on? RexCore starts very early during the boot-up, sooner than the Ethernet adapter is initialized, therefore it cannot connect to an external SQL server until the network is properly configured.

Please run "sudo raspi-config" on your RPi and enable "Wait for Network at Boot" and let me know if and how it affects the error.

Hope this helps.
Jaroslav

Re: REX Module error

2016-08-29T06:10:28Z

You got connection failed after 1st downloading configuration (line "Swapping configuration" in log file), but no fail after 2nd downloading configuration, so data are written into database.
I hope you know what was changed beetwen both downloads. Sometimes configuration not work correctly after Raspberry power on, but work correctly after manual download. This happend when some component (MySQL deamon or ODBC deamon in this case) start too late, but we not see this problem with MySQL.
By the way ODBC-connection-failed log message contain standardised error code (IM008) and error description (Invalid window handle) returned by MySQL. You can find more information in MySQL and/or ODBC documetation, internet forums etc. I try google, but I get only general advise to see ODBC and MySQL logfile for more details.

Re: REX Module error

2016-08-29T05:34:18Z

Hi Adam,
thanks for the screenshot. I have passed it to our developers. Hope they'll be able to shed some light on it.

Jaroslav

Re: REX Module error

2016-08-26T09:08:16Z

Hi Tomas,

Screenshot uploaded

Adam

Re: REX Module error

2016-08-26T07:41:17Z

Hi Adam,

can you please post a screenshot of your System log in RexView? It's strange that you get the data to your database correctly and Rex database driver says "Connect to DB failed". I will have a look at it.

Cheers, Tomas

Re: REX Module error

2016-08-25T15:49:20Z

Hi Tomas,

I have got data into my database now (silly miss type in odbcinst.ini), but I am still getting the error

'2016-08-25;16:31:30.285;Error;DBDRV: connect to 'DRIVER=MySQL;SERVER=192.168.1.XXX;PORT=3306;DATABASE=test;UID=XXX;PWD=XXX;' failed!!!! ([IM008] [unixODBC][MySQL][ODBC 5.1 Driver]Invalid window handle);

Is it a problem? is it something I can fix?

[edited to put separate questions in a separate post]

Cheers,

Adam

Re: REX Module error

2016-08-25T14:52:55Z

Hi Tomas,

I was following 'MbDrv_ENG.pdf' which doesn't seem to have the bit about installing the ODBC driver, I had therefore assumed it was installed with the module. I can now download to the target, though I don't seem to be getting data inserted into the database; hopefully that is just a configuration issue though.

Thank you very much for your help.

Regards,

Adam

Re: REX Module error

2016-08-25T13:22:11Z

Hi Adam,

did you go through the README.md file which is part of the MySQL simple export example? There are some important prerequisites. The README file also contains link to Database driver documentation. You will find configuration notes for ODBC interface instalation inside.

Hope it will help you.

Please let me know if you have any questions.

Cheers, Tomas

Re: REX Module error

2016-08-25T13:05:14Z

Hi Tomas,

Thank you for replying.

As you guessed, the System log is showing a error 'unable to load module 'DbDrv', error = -108' (attached zip file includes the full log).

Also as you presumed, my target device is a Raspberry Pi, and the 'rex-dbdrvt' is listed as installed (attached zip file includes the full output of 'dpkg -l').

If you can think of a solution for me, I would be most grateful.

Cheers,

Adam

ModuleErrorLogs.zip

Re: REX Module error

2016-08-25T11:03:57Z

Hi Adam,

it seems that there is missing one of REX modules on your target device. Please, try to connect to your target device with RexView and go to a "System log" tab. There should be specified which REX module are you missing.
My guess is that you are missing rex-dbdrvt as you are trying to run one of database examples.

I presume that your target device is Raspberry Pi, am I right? If so, you can check all installed packages on your Raspberry with following command:

dpkg -l

Look for packages named "rex-*".

Let me know what did you find and we will think of a solution for you.

Cheers, Tomas

REX Module error

2016-08-25T10:17:29Z

Trying to download the MySQL_simple_export example to my Pi, I get the error 'Connection to target device failed! Reason: REX Module error'; see screenshot below

What have I missed, or is something not working?

Cheers,

Adam