One of the codes generated error in 8.3 but everything is still working as is

Hi all,

Not sure why

from com.ibm.as400.access import AS400, DataQueue

generated error

Traceback (most recent call last):
File "", line 1, in
ImportError: No module named ibm

in 8.3. But 8.1 is fine. Even though everything is working fine as is.

They both have jt400.jar installed correctly.

Thanks for inputs

What does this mean? The JDBC driver is installed? Or you've put this JAR file somewhere like $IGNITION/lib/core/gateway?

Initially, I installed jbdc with the jt400.jar on the 8.3 gateway. My whole script didn’t work.

Then, I dropped jar file to $IGNITION/lib/core/gateway and $IGNITION/lib/core/common, script worked but still generated above mentioned error.

With my 8.1, I installed the jar on its gateway.

Did you restart the Gateway after this?

Again - what does this mean?

The only way this ever should have worked is if you put it into lib/core/gateway, on either version, and it should still work in either version AFAICT.

Is your test script executing in gateway scope? i.e. not the Designer script console?

Hi Kevin,

I did restart the Gateway, and the existing event change script worked after the restart.

In Ignition 8.1, I imported the JAR file using the “Create JDBC Driver” option, so I’m not sure where that JAR was actually stored. I just checked, and the JAR is currently located in core/common, not in core/gateway.

For Ignition 8.3, I followed the same process. In addition, I manually copied the JAR file into both core/common and core/gateway.

It’s an event change script; it is working fine. The test script I tried in designer script console. Have a look at pics below.

Here is the 8.3

Here is the 8.1

You or somebody else probably also copied the JAR file to the right place on the Ignition 8.1 Gateway... installing/creating a JDBC Driver does not move the JAR into lib/core/common or lib/core/gateway.

Yep. I suspect that. It was long time ago so my memory could be wrong