SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Connection Error
Goto page Previous  1, 2
 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Connection Error
Author Message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
The last 10 lines are as follows:

2009-08-27 09:28:19,015 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-27 09:28:19,015 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getdatabaseprofile
2009-08-27 09:28:19,015 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSRSRSRSRBRSRS
2009-08-27 09:28:19,015 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 7
2009-08-27 09:28:19,015 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [Repository Server, com.sybase.dpb.StringHolder@178e13f, com.sybase.dpb.StringHolder@10c0fa7, com.sybase.dpb.StringHolder@d7a9c9, com.sybase.dpb.BooleanHolder@cbffde, com.sybase.dpb.StringHolder@10b755d, com.sybase.dpb.StringHolder@14649ed]
2009-08-27 09:29:26,125 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-27 09:29:26,125 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getdatabaseprofile
2009-08-27 09:29:26,125 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSRSRSRSRBRSRS
2009-08-27 09:29:26,125 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 7
2009-08-27 09:29:26,125 [Thread-8] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [Repository Server, com.sybase.dpb.StringHolder@190725e, com.sybase.dpb.StringHolder@44a013, com.sybase.dpb.StringHolder@1697d14, com.sybase.dpb.BooleanHolder@92de02, com.sybase.dpb.StringHolder@2d80ae, com.sybase.dpb.StringHolder@15b5c1f]
Wed Aug 26, 2009 9:31 pm View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
There is also the following error in the debug.log:

2009-08-27 12:55:38,953 [AWT-EventQueue-0] ERROR com.softtreetech.jscheduler.business.C.class - parseLogRecord (...):
java.text.ParseException: Unparseable date: "08/27/2009 12:10:38 ? ??? ? ????"
at java.text.DateFormat.parse (DateFormat.java: 335)
at com.softtreetech.jscheduler.business.C.class.o00000 (Unknown Source)
at com.softtreetech.jscheduler.business.C.class.o00000 (Unknown Source)
at com.softtreetech.jscheduler.ui.O0OO.Oo0O.super (Unknown Source)
at com.softtreetech.jscheduler.ui.O0OO.Oo0O $ 1.o00000 (Unknown Source)
at com.softtreetech.jscheduler.ui.B.oooO.propertyChange (Unknown Source)
at javax.swing.event.SwingPropertyChangeSupport.firePropertyChange (SwingPropertyChangeSupport.java: 264)
at javax.swing.event.SwingPropertyChangeSupport.firePropertyChange (SwingPropertyChangeSupport.java: 232)
at javax.swing.AbstractAction.firePropertyChange (AbstractAction.java: 178)
at javax.swing.AbstractAction.putValue (AbstractAction.java: 113)
at com.softtreetech.jscheduler.ui.oOOO.o0OO $ 4.valueChanged (Unknown Source)
at javax.swing.JTree.fireValueChanged (JTree.java: 2392)
at javax.swing.JTree $ TreeSelectionRedirector.valueChanged (JTree.java: 2763)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged (DefaultTreeSelectionModel.java: 629)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange (DefaultTreeSelectionModel.java: 1076)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths (DefaultTreeSelectionModel.java: 287)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath (DefaultTreeSelectionModel.java: 170)
at javax.swing.JTree.setSelectionPath (JTree.java: 1168)
at com.softtreetech.jscheduler.ui.oOOO.D $ 1.run (Unknown Source)
at java.awt.event.InvocationEvent.dispatch (InvocationEvent.java: 189)
at java.awt.EventQueue.dispatchEvent (EventQueue.java: 478)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy (EventDispatchThread.java: 201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java: 151)
at java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java: 145)
at java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java: 137)
at java.awt.EventDispatchThread.run (EventDispatchThread.java: 100)

This should be the Chinese date format parsing error, whether this causes problems in front of
Thu Aug 27, 2009 1:11 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
There is another question about the Alert:
I set up an Alert, when it is scheduled, it will raising an Alert. But in log viewer to display the following:

ERROR: Unable to run database query.String index out of range: 254


The following is debug.log displayed:

2009-08-28 16:56:07,859 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.queue.JobQueue - QUEUE_UNLOCKED
2009-08-28 16:56:07,875 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - runJob(): start
2009-08-28 16:56:07,875 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - execProcess(): command line [java -jar alertCenter.jar /JOB 15] in Directory [null]
2009-08-28 16:56:07,875 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - waitForProcess(): start
2009-08-28 16:56:07,875 [Thread-618] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): start
2009-08-28 16:56:07,875 [Thread-618] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): timeout to wait is 72000000 milliseconds
2009-08-28 16:56:08,328 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 1
2009-08-28 16:56:08,328 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Connect called DB Audit _JAVA_ DB Audit
2009-08-28 16:56:08,343 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name opensession
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSSS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 4
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [24x7 Java API, DB Audit, DB Audit, ]
2009-08-28 16:56:08,359 [Thread-3] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Open session called 24x7 Java API DB Audit DB Audit
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, NAME, com.sybase.dpb.StringHolder@fa4c96]
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, MSG_SQL, com.sybase.dpb.StringHolder@ba117b]
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, MSG_ACCOUNT, com.sybase.dpb.StringHolder@1d1be4e]
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, MSG_PASSWORD, com.sybase.dpb.StringHolder@1252d43]
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,359 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, PROFILE, com.sybase.dpb.StringHolder@1be8a4b]
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, MSG_RECIPIENT, com.sybase.dpb.StringHolder@695a6a]
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, MSG_JOB_ID, com.sybase.dpb.StringHolder@aee86f]
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, DESCRIPTION, com.sybase.dpb.StringHolder@11e082e]
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getdatabaseprofile
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSRSRSRSRBRSRS
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 7
2009-08-28 16:56:08,375 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [Repository Server, com.sybase.dpb.StringHolder@ab12f1, com.sybase.dpb.StringHolder@1689bf1, com.sybase.dpb.StringHolder@d62562, com.sybase.dpb.BooleanHolder@1304a7c, com.sybase.dpb.StringHolder@16a4cf2, com.sybase.dpb.StringHolder@1e1b0e7]
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, LOG, com.sybase.dpb.StringHolder@2516dc]
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name logmessage
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LLSLSB
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 5
2009-08-28 16:56:09,062 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, LOU, 1, WARNING: Alert condition found, raising alert..., false]
2009-08-28 16:56:09,062 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - sourceID 15
2009-08-28 16:56:09,062 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Type 1
2009-08-28 16:56:09,062 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - job LOU - Lots of Connection Attempts From the Same Te
2009-08-28 16:56:09,062 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Log record Fri Aug 28 16:56:09 CST 2009, IuEsMRcxwmVfRI1U4iQ6P6NKdQk=, 1, 15, LOU - Lots of Connection Attempts From the Same Te, WARNING: Alert condition found, raising alert...
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, LOG, com.sybase.dpb.StringHolder@f65160]
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name logmessage
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LLSLSB
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 5
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [15, LOU, 2, ERROR: Unable to run database query. String index out of range: 254, false]
2009-08-28 16:56:09,078 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - sourceID 15
2009-08-28 16:56:09,078 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Type 3
2009-08-28 16:56:09,078 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - job LOU - Lots of Connection Attempts From the Same Te
2009-08-28 16:56:09,078 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Log record Fri Aug 28 16:56:09 CST 2009, IuEsMRcxwmVfRI1U4iQ6P6NKdQk=, 3, 15, LOU - Lots of Connection Attempts From the Same Te, ERROR: Unable to run database query. String index out of range: 254
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name closesession
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature L
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 0
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params null
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 2
2009-08-28 16:56:09,078 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - disconnect called
2009-08-28 16:56:09,078 [Thread-621] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Unregistering session received
2009-08-28 16:56:09,125 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - waitForProcess(): end
2009-08-28 16:56:09,125 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner - isFailed(...) : exit code 6
2009-08-28 16:56:09,125 [Thread-617] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner - isFailed(...) : Enumeration found [0]
2009-08-28 16:56:09,125 [Thread-618] INFO com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run():
java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method)
at com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier.run(Unknown Source)
2009-08-28 16:56:09,125 [Thread-618] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): end
2009-08-28 16:56:09,125 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - mail.smtp.auth=true
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): Date: Fri, 28 Aug 2009 16:56:09 +0800 (CST)
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): From: *****hk-computech.com
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): To: ****hk-computech.com
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): Subject: Message from Alert Center
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): X-Mailer: MailProcessor
2009-08-28 16:56:09,140 [Thread-617] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): account & password information is specified
Fri Aug 28, 2009 5:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Yesterday I sent a request to the development asking for help with this issue and still waiting for their reply. I think that OutOfMemory exception is not a sign of memory problems. In Java this type of exception is often raised in cases of "unknown" errors. In the previous post, in debiug.log I see that the exception is triggered by Remote Console call to the Alert Center to retrieve database connection settings. Likely some of the values it is getting back or not getting back are causing the OutOfMemory exception.

I suspect after all that manual connection setup something is still missing on the Alert Center side and leading to erratic behavior.
Fri Aug 28, 2009 8:00 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
about ERROR: Unable to run database query.String index out of range: 254

I am anti-compiled alertCenter.jar, use the following parameters when you call the method raiseAlert:
con, recipient, profile, JOBid, "LOT", account, password, mailcontent
method raiseAlert use subString processing parameters recipient and the "LOT", but the recipient is not 254 long, so generate an error as above.
Mon Aug 31, 2009 6:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
You are looking in the wrong place. The error says "Unable to run database query" and this has nothing to do with raiseAlert method.

By the way, did you know that decompilation is illegal? You may not decompile not your own software without software autor's explicit approval. Here is an except from our license agreement which you accepted during the installation and which says:

COPYRIGHT: The Software is the proprietary product of SoftTree Technologies and is protected by copyright law. You acquire only the right to use the Software and do not acquire any rights of ownership. You agree not to remove any product identification, copyright notices, or other notices or proprietary restrictions from the Software. You agree not to cause or permit the reverse engineering, disassembly, or decompilation of the Software.

A copy of that is available in the LICENSE.TXT file installed in the Alert Center home directory.

***
Now, I assume that you have not been aware of that legal clause and decompiled the code only for to troubleshooting the error, and you will not do that again.

To find out what's causing "unable to run database query" check log files in the Data subdirectory of the Alert Center installation. Open the most recent log file and let us know what appears in the log.That might be related to your connection problem.
Mon Aug 31, 2009 8:43 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
Sorry, I just want to solve the problem, and no other meaning.


The following is the record in the debug.log to manually run the "LOT" Alert in the Alert Center Scheduler:

2009-09-01 11:47:38,296 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - runJob(): start
2009-09-01 11:47:38,296 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.queue.JobQueue - QUEUE_UNLOCKED
2009-09-01 11:47:38,328 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - execProcess(): command line [java -jar alertCenter.jar /JOB 20] in Directory [null]
2009-09-01 11:47:38,328 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - waitForProcess(): start
2009-09-01 11:47:38,328 [Thread-108] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): start
2009-09-01 11:47:38,328 [Thread-108] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): timeout to wait is 72000000 milliseconds
2009-09-01 11:47:38,812 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 1
2009-09-01 11:47:38,812 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Connect called DB Audit _JAVA_ DB Audit
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 3
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name opensession
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSSS
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 4
2009-09-01 11:47:38,828 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [24x7 Java API, DB Audit, DB Audit, ]
2009-09-01 11:47:38,828 [Thread-3] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Open session called 24x7 Java API DB Audit DB Audit
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, NAME, com.sybase.dpb.StringHolder@788a7b]
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, MSG_SQL, com.sybase.dpb.StringHolder@1cbc5cb]
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, MSG_ACCOUNT, com.sybase.dpb.StringHolder@126cdd1]
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, MSG_PASSWORD, com.sybase.dpb.StringHolder@9278d5]
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, PROFILE, com.sybase.dpb.StringHolder@3b0b1e]
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,843 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, MSG_RECIPIENT, com.sybase.dpb.StringHolder@571615]
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, MSG_JOB_ID, com.sybase.dpb.StringHolder@16ac92e]
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, DESCRIPTION, com.sybase.dpb.StringHolder@1be2b55]
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getdatabaseprofile
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSRSRSRSRBRSRS
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 7
2009-09-01 11:47:38,859 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [Repository Server, com.sybase.dpb.StringHolder@f11bc, com.sybase.dpb.StringHolder@1557ee8, com.sybase.dpb.StringHolder@1fef1a0, com.sybase.dpb.BooleanHolder@a97cec, com.sybase.dpb.StringHolder@1486b51, com.sybase.dpb.StringHolder@17db660]
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, LOG, com.sybase.dpb.StringHolder@5063a5]
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name logmessage
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LLSLSB
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 5
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, LOT, 1, WARNING: Alert condition found, raising alert..., false]
2009-09-01 11:47:39,593 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - sourceID 20
2009-09-01 11:47:39,593 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Type 1
2009-09-01 11:47:39,593 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - job LOT - Lots of Failed Connection Attempts In a Shor
2009-09-01 11:47:39,593 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Log record Tue Sep 01 11:47:39 CST 2009, IuEsMRcxwmVfRI1U4iQ6P6NKdQk=, 1, 20, LOT - Lots of Failed Connection Attempts In a Shor, WARNING: Alert condition found, raising alert...
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name getjobproperty
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LSSRS
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 3
2009-09-01 11:47:39,593 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, LOG, com.sybase.dpb.StringHolder@1be1f3e]
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name logmessage
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature LLSLSB
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 5
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params [20, LOT, 2, ERROR: Unable to run database query. String index out of range: 254, false]
2009-09-01 11:47:39,609 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - sourceID 20
2009-09-01 11:47:39,609 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Type 3
2009-09-01 11:47:39,609 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - job LOT - Lots of Failed Connection Attempts In a Shor
2009-09-01 11:47:39,609 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - Log record Tue Sep 01 11:47:39 CST 2009, IuEsMRcxwmVfRI1U4iQ6P6NKdQk=, 3, 20, LOT - Lots of Failed Connection Attempts In a Shor, ERROR: Unable to run database query. String index out of range: 254
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 6
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Method name closesession
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - methodSignature L
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - arguments 0
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - method params null
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - requestId 2
2009-09-01 11:47:39,609 [Thread-2] DEBUG com.softtreetech.jscheduler.business.remotecontrol.RemoteOperationsImpl - disconnect called
2009-09-01 11:47:39,609 [Thread-111] DEBUG com.softtreetech.jscheduler.business.remotecontrol.SocketConnection - Unregistering session received
2009-09-01 11:47:39,656 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.ProgramJobRunner - waitForProcess(): end
2009-09-01 11:47:39,671 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner - isFailed(...) : exit code 6
2009-09-01 11:47:39,671 [Thread-107] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner - isFailed(...) : Enumeration found [0]
2009-09-01 11:47:39,687 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - mail.smtp.auth=true
2009-09-01 11:47:39,796 [Thread-108] INFO com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run():
java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method)
at com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier.run(Unknown Source)
2009-09-01 11:47:39,828 [Thread-108] DEBUG com.softtreetech.jscheduler.business.runner.AbstractJobRunner$TimeoutVerifier - run(): end
2009-09-01 11:47:39,875 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): Date: Tue, 1 Sep 2009 11:47:39 +0800 (CST)
2009-09-01 11:47:39,875 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): From: ******@hk-computech.com
2009-09-01 11:47:39,875 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): To: ******@hk-computech.com
2009-09-01 11:47:39,875 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): Subject: Message from Alert Center
2009-09-01 11:47:39,875 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): X-Mailer: MailProcessor
2009-09-01 11:47:39,937 [Thread-107] DEBUG com.softtreetech.jscheduler.business.O0oO - sendEmailImpl(): account & password information is specified
2009-09-01 11:47:56,859 [Thread-107] DEBUG com.softtreetech.jscheduler.business.queue.JobQueue - QUEUE_UNLOCKED
Tue Sep 01, 2009 12:03 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Sorry, you posted this same debug.log as before. I'm asking for a log file in the Data subfolder. I think the name of that file should be 20.log and that file should provide us with a clue for which database query is leading to the error. Please post the contents of 20.log file.

For your information, I just tried and failed to reproduce this error on 2 of our test Oracle 9i and Oracle 10g servers. Which version of the Oracle server are you running?
Wed Sep 02, 2009 7:19 pm View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
The following is the content in 20.log:

Getting properties of job #20...
Alert type: LOT
Alert description: Lots of Failed Connection Attempts In a Short Period of Time
Alert recipient: ***@hk-computech.com
Alert sender: ********@hk-computech.com
Database profile: Repository Server
SQL: SELECT counter, server_name FROM (SELECT count(1) as counter, t.server_name FROM DB_AUDIT.REP_SYS_AUDIT_TRAIL t, DB_AUDIT.REP_CATALOG c WHERE t.server_name = c.server_name and t.status = 0 and t.event_time BETWEEN sysdate - 1/24*60 and sysdate and ((c.server_type = 'ORA' AND t.action_name = 'LOGON') or (c.server_type = 'SQL' AND t.action = 20) or (c.server_type = 'ASE' AND t.action = 45) or (c.server_type = 'MY' AND t.action_name = 'CONNECT') or (c.server_type = 'DB2' AND t.ses_actions = 'VALIDATE' and t.action_name = 'AUTHENTICATION' and t.audit_option = 'SERVER')) GROUP BY t.server_name ) tbl WHERE counter > 100
Getting properties of database profile Repository Server...
JDBC interface: ./drivers/ora/ojdbc14_g.jar
JDBC driver: oracle.jdbc.OracleDriver
Database URL: jdbc:oracle:thin:@192.168.1.52:1521:DBAREP
User: system
Connecting to database...
Connected
Running job #20...
Query execution time: 0.0 seconds.
WARNING: Alert condition found, raising alert...
Writing alert data to the repository log table.
ERROR: Unable to run database query. String index out of range: 254

Oracle server's version is 9.2.0.1.0
Fri Sep 04, 2009 2:55 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Aha... the error occurs while it is trying to insert alert log record into one of the repository table.

Please check if you have a table called DB_AUDIT.REP_ALERTS. If you do, how maby columns are in this table?
Fri Sep 04, 2009 11:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Something is not right here. You have said earlier that you are not using the central repository and that it is a single database server system. Why is the alert job is trying to connect using special database profile with fixed name Central Repository? and why it is trying to run in a mode as if it was a centralized job setup for monitoring multiple servers?

When creating this alert, which database connection have you selected for the job?
Fri Sep 04, 2009 11:32 pm View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
Yes, there are DB_AUDIT.REP_ALERTS tables, columns are as follows:
ID
ALERT_TIME
ALERT_RECIPIENT
ALERT_TYPE
ALERT_SUBJECT
ALERT_MESSAGE

As you said, using the central repository.
Because through the alert center remote console to add alert or report, it always prompts me "class java.lang.OutOfMemoryError",
Therefore, only in DB Audit Expert use Tools-> Central Repository Deloyement Tools ... to Add alert and report, the use of the connection for the Central Repository database
Sun Sep 06, 2009 10:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
The following query must be failing
SELECT id FROM db_audit.REP_CATALOG WHERE client_connect_profile = ?

And the reason for that is that in the DB Audit graphical interface you don't have a connection with exactly the same name as in the Alert Center. I guess you have configured it manually and named it differently. To fix that problem, please rename the connection in DB Audit console settings to match the other name.
Mon Sep 07, 2009 8:29 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.