Sybase Interface Not Working

Hello,
I am new to this forum and 24x7 Scheduler.
We installed 24x7 Scheduler Multi-platform edition version 4.3 on a Windows XP machine for evaluating the software. The installation has a pre-defined Sybase Interface with the following details:

Driver's path : ./drivers/syb/jconn3.jar
Driver's class: com.sybase.jdbc3.jdbc.SybDriver

It seems this interface is not working. Whenever we open the Interface Properties dialog box of this interface and click on OK button, nothing happens! The dialog box just stays there!! Also, any profile created based on this interface is not working. Kindly note that we are able to connect to Sybase DB using jisql. Please let me know what to be done.

Regards

Hi,

Please enable the tracing options in the scheduler Tools/Options menu -> Log tab. Attempt a new connection and take a look at debug.log file. Check for messages with words Error or Exception and let us know what you get there. Also, if you see jdbc.log file in the scheduler directory, please post its content too.

Thanks

Thank you for the reply

I enabled tracing and attempted a new connection. There are no words Error or Exception. Here is what I get there

2010-09-19 09:40:42,130 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.agent.remote.RemoteAgentImpl - Authenticating user <username>
2010-09-19 09:40:42,132 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService - authNativeUser: /usr/local/24x7_Scheduler/auth.pl
2010-09-19 09:40:42,499 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService -
2010-09-19 09:40:51,012 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.agent.remote.RemoteAgentImpl - Authenticating user
2010-09-19 09:40:51,014 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService - authNativeUser: /usr/local/24x7_Scheduler/auth.pl
2010-09-19 09:40:51,045 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService -

Also note that there is no jdbc.log anywhere inside the HP machine.

Regards

Sorry, kindly ignore the previous posting of portion of debug.log. That was the one from HP-UX machine. Here is the part of debug.log after enabling tracing and trying to test connection of a Sybase profile from a Windows machine

2010-09-19 11:11:02,765 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=./drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-19 11:11:02,765 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-19 11:11:02,765 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/./drivers/syb/jconn3.jar
2010-09-19 11:11:02,765 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@1cec874
2010-09-19 11:11:02,765 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@51e67c
2010-09-19 11:11:03,921 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=./drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-19 11:11:03,921 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-19 11:11:03,921 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/./drivers/syb/jconn3.jar
2010-09-19 11:11:03,921 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@1ab5dae
2010-09-19 11:11:03,921 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@19480b8
2010-09-19 11:11:05,296 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=./drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-19 11:11:05,296 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-19 11:11:05,296 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/./drivers/syb/jconn3.jar
2010-09-19 11:11:05,296 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@1609c13
2010-09-19 11:11:05,312 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@5ce40

I could not find any file jdbc.log in the entire PC where 24x7 is installed.

Regards

Quote:

2010-09-19 09:40:51,012 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.agent.remote.RemoteAgentImpl - Authenticating user
2010-09-19 09:40:51,014 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService - authNativeUser: /usr/local/24x7_Scheduler/auth.pl
2010-09-19 09:40:51,045 [RMI TCP Connection(2)-<Windows>] DEBUG com.softtreetech.jscheduler.business.runner.security.SecurityService -

This tells us that the agent is configured for PAM authentication but that is not yet working because there is no "user authenticated" message in the log.

Please run manually the following shell command on your HP system.
/usr/local/24x7_Scheduler/auth.pl your_user_iid your_password

What does this command print to the screen?

	Quote:
	C:/Program Files/24x7_Scheduler/./drivers/syb/jconn3.jar

This doesn't look right. Please try the following. Shutdown 24x7. Open preferences.xml in Notepad. Search text for ./drivers/syb/jconn3.jar. Replace this with an absolute path C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar Save changes and restart 24x7. Check if that helps with the connection. Please let uis know if this helps.

Hi

Changing the path of sybase driver to an absolute path did not help us. Please find the log after making the changes and trying to connect

2010-09-20 08:54:10,112 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:10,112 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:10,112 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@3f265b
2010-09-20 08:54:10,112 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@511e0a
2010-09-20 08:54:10,300 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-20 08:54:10,300 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:10,300 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:10,300 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@114a306
2010-09-20 08:54:10,393 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@2264da
2010-09-20 08:54:10,518 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-20 08:54:10,518 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:10,518 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:10,518 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@107dcfe
2010-09-20 08:54:10,534 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@e5ace9
2010-09-20 08:54:10,690 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-20 08:54:10,690 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:10,690 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:10,690 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@dafa2c
2010-09-20 08:54:10,690 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@1fc25e5
2010-09-20 08:54:11,175 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-20 08:54:11,175 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:11,175 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:11,175 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@caf083
2010-09-20 08:54:11,175 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@16a9424
2010-09-20 08:54:11,987 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - loadDriver() driverPath=C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar driverClass=com.sybase.jdbc3.jdbc.SybDriver
2010-09-20 08:54:11,987 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - parsed urls: 1
2010-09-20 08:54:11,987 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - url #0 file:/C:/Program Files/24x7_Scheduler/drivers/syb/jconn3.jar
2010-09-20 08:54:11,987 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - java.net.URLClassLoader@8ef177
2010-09-20 08:54:11,987 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.business.OOoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.B - com.sybase.jdbc3.jdbc.SybDriver@1017ca1

How do you enter the Database URL string?

For example, for an ASE server running on system JUPITER and listenning on port 5004, I enter it as

jdbc:sybase:Tds:jupiter:5004/master

Also, are you able to connect via 24x7 ODBC interface?

We are entering URL as

jdbc:sybase:Tds:<ip>:<port>/master

Yes, we are able to connect using ODBC interface to the same database that we tried using sybase interface.

Sybase driver doesn't understand IP address in the URL. It expects to find hostname. Please try entering hostname.

Here is what I found in Sybase FAQ for JConnect http://www.sybase.com/detail?id=1009876

	Quote:
	What URL should I use when making a connection? The URL should be: jdbc:sybase:Tds:<hostname>:<port>For example, to connect to a SQL Server on alder listening on port 6689, I would use the following commands:Connection _con; String url = "jdbc:sybase:Tds:alder:6689";

We tried with host name also and found it is not solving the problem. We had also made sure that the host name is there in /etc/host and it is possible to ping host name.

Does this "Whenever we open the Interface Properties dialog box of Sybase interface and click on OK button, nothing happens! The dialog box just stays there!!" happen at your end? We are asking this for two reasons:

1. We have this behaviour on both Windows XP and HP-UX
2. We are using evaluation version

Please let me know.

So you don't get an error, just no response after OK click? It might be that the connection is actually ok, just the driver is not returning a valid status required for the "Connected Successfully" message after a test connection.

Please try the following:
1. Save the profile with the host name in URL as indicated in the example in mentioned Sybase FAQ.
2. Create a new SQL job in 24x7 (right-click on a job folder, choose New Job)
3. Select database job type. Enter some job name, click Next. In the database profile drop-down Select the profile created earlier. Enter [color=blue]RAISERROR('Hello World', 16, 1)/color] for the job SQL script. Click Finish to close the Job Properties dialog
4. Right-click the new job and select Run Now, select Test mode. The job should fail. Check the job log. If says connection failed or something similar, the connection isn't working. If you get an error and it says "Hello World" then the connection is ok.

You indicated earlier that the ODBC based interface and connection is working for you. If the above doesn't help with the native connection, you can continue using the ODBC based connection. ODBC based connection to ASE should be just as good as a native connection.

I tried the experiment that you suggested with both Sybase profile and ODBC profile. ODBC profile worked the way you described. Everything was fine. However, when I ran against sybase profile in Test Mode, 24x7 hangs! When I ran in Normal mode it just doesn't get completed. When I checked the log all I could see was 'Job Started'. Is there any customer using Sybase profile? I seriously think that something internally wrong with Sybase Interface in 24x7 Scheduler. Please note that I was even able to connect to Sybase ASE server using IP address using JISQL (which uses JDBC).

I double-checked today. The Sybase driver is not returning the expected message (returned by all other drivers) and no confirmation is displayed in the Test Connect dialog in case of a successful connection and no error is displayed in case of a failed connection). But if the parameters are entered correctly, the connection is usable. I have scheduled and run couple of jobs using that connection, one executing meaningless SELECT 'test' and one executing an existing stored procedure, and they both run just fine.

Thank you for your reply. I believe you did this from a 24x7 installation on a Windows machine. Was your Sybase Server running on HP-UX? Was it connecting to Sybase ASE or ASA? Can I know the version of Sybase client installed on the machine where 24x7 agent/master was running?