Cisco Insight Reporter: Sybase DB issue

By | April 11, 2013
2 Comments

Problem: Upgraded Insight Reporter from v3.2.0 to 3.4.0, existing traffic database show disconnected

insight1

Workaround/Solution:
1) To get Sybase JDBC Connector
Download JConnect from this link http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
Extract and Install it in Insight Server

./setup.bin -i console

Go to /opt/sybase/jConnect-7_0/classes and copy conn4.jar and  jTDS3.jar into Cisco Insight directory (/home/user/Insight/apache-tomcat-6.0.20/webapps/insight/WEB-INF/lib/)
Restart tomcat

/etc/init.d/tomcat-user stop
/etc/init.d/tomcat-user start

2) To determine SCE CM db schema info
Go to your SCE CM server and execute cm file located at /home/user/cm/bin

./cm version
CM CD Version 3.7.5 Build 105

insight2

Both Jar files can be downloaded from here:
http://dl.advanxer.com/stuff/Software/CiscoInsight/SybaseJDBC/

Loading