Remote Database not working

[llarge]

I had a remote database setup and it was working last I checked. There was no app created yet but today when I tried to preview it, I got an API failure message. I tried editing the data source and it put the job into message wait. This was the message I got from the job log.

CALL PGM(VVBATCH) PARM('BATCH' 776940 ' ' 'SPACESAND ')
Data area VVCONTEXT created in library QTEMP.
Data area VVOUTBUFF created in library QTEMP.
Java Virtual Machine is IBM Technology for Java. PID(39689)
JVM properties were loaded from a properties file.
Java exception received when calling Java method.
Function check. RNX0301 unmonitored by VVBATCH at statement 0000039600,
instruction X'0000'.
The call to BATCHPROCE ended in error (C G D F).

The database is a SQL DB and I have confirmed the account I was using is correct and has access.
Any advice on how to resolve it?

[robert.swanson]

The problem may stem from a Java classpath issue. Is the job still in MSGW status? If yes, can you get the extended message info for the "Java exception received" message (i.e., using the HELP or Alt-F1 key)?

If the MSGW job has already been cancelled, please restart the server instance and make the error happen again, then we can confirm it is indeed a classpath issue at play.

[llarge]

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure EXECUTERMT in program SPACEDEV/VVBATCH
received Java exception "java.lang.NoClassDefFoundError:
org.apache.log4j.Appender" when calling method "<init>" with signature "()V"
in class "com.cnx.java.rmt.RemoteHandler". Recovery . . . :

Is this what you were looking for?

[robert.swanson]

Yes, that confirms it's a classpath issue. It appears to be looking for the old log4j routine that was removed for security reasons recently. I'm not sure how the classpath could have gotten out of sync with your core programs there, but I think the easiest fix would be to simply update that instance to the latest build. Or any build after 6.0.20211111.

[llarge]

I'm on version Valence Framework 6.0.20211209.1
I removed the remote data source and reset it up. I'm still not able to connect. This is how I have it setup.

https://www.screencast.com/t/MejSOCTy2T

What do you think we can do?

[robert.swanson]

Is upgrading to a newer build not an option? The problem remains that somehow your codebase is out of sync with your classpath settings.

If you can't upgrade, you could go into Portal Admin > Settings > IBM i Settings > Java Classpath and insert the following string of text at the end:

:[ROOT_PATH]java/remotedb/log4j-1.2.17.jar

[DrGadget]

working again after updating to 6.0.20220119.0