Problem: Upgraded Insight Reporter from v3.2.0 to 3.4.0, existing traffic database show disconnected
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
Both Jar files can be downloaded from here:
http://dl.advanxer.com/stuff/Software/CiscoInsight/SybaseJDBC/
