Java agent generates errors when it is scheduled

HCL Domino Domino Forum
1

Hi Al,I have a java agent that runs without error when manually run.But when it is scheduled it generates errors.In short it uploads files to Was by a servlet and it creates records in db2 table.I have added "JavaUserClasses=C:\lotus\domino\jvm\lib\db2java.zip; to servers notes.ini file. Below you can find errors.

Thanks,

18.03.2008 16:03:48 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

18.03.2008 16:03:48 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method java/lang/Class.forName0 …

18.03.2008 16:03:48 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

18.03.2008 16:03:48 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Connection.SQLConnect …

18.03.2008 16:03:48 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Connection.SQLGetConnectOption …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Statement.SQLAllocStmt …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2PreparedStatement.SQLPrepare …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Connection.SQLGetTypeMaxLen …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2PreparedStatement.SQLBindChar …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: not found]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Statement.SQLFreeStmt …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2PreparedStatement.freeArrays …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Connection.SQLDisconnect …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method COM/ibm/db2/jdbc/app/DB2Connection.SQLFreeConnect …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method lotus/domino/NotesThread.NnotesTermThread …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method com/ibm/jvm/Trace.snap …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: java.lang.UnsatisfiedLinkError: SQLBindChar

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method java/lang/Throwable.getStackTraceDepth …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method java/lang/Throwable.getStackTraceElement …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown Source)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at com.akbank.portal.dao.DuyuruYayinlaDAO.insert(DuyuruYayinlaDAO.java:154)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at JavaAgent.NotesMain(JavaAgent.java:144)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at lotus.domino.AgentBase.runNotes(Unknown Source)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: at lotus.domino.NotesThread.run(Unknown Source)

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method lotus/domino/local/NotesBase.RecycleObject …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: External JNI]

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: [Dynamic-linking native method java/lang/SecurityManager.getClassContext …

18.03.2008 16:03:49 AMgr: Agent (‘2.PortaleUpload’ in ‘KYBL\POSTA\duyuru.nsf’) error message: Internal JNI]

2

Subject: java agent generates errors when it is scheduled.

I suspect that you definition added to the server’s notes.ini should not refere to a zip-library. you probalby need to use the exanded version.

3

Subject: RE: java agent generates errors when it is scheduled.

Oztur,

I agree with Rob. I’ve never seen a Zip file specified in a classpath. I would expect a JAR file.

One thing I do know about agents (LotusScript or Java) involving file I/O that explains why an agent will run manually but not on a server is the agent properties security settings. You need to specify “3. Allow restricted operations with full administration rights” (maybe #2 will work, but I’ve always gone with #3).

Ken A Collins

New York City

4

Subject: java agent generates errors when it is scheduled.

Thanks for your replies,I’ve found the problem.It is incompatibility between my local db2 version and dvlp server. Dvlp server has a prior db2 client.After we upgraded it problem resolved.

By the way, agent generates many Dynamic-linking messages. Have can I overcome it?