Headache from Hell due to failed JDBC installation using JSPM

Last couple of days were tough .. trying to install sql drivers in SAP PI 7.3 system. Started off using JSPM which had worked in the DEV and QA system but was failing in production why? you will get to know in a bit :-) .

So JSPM indicates successful deployment of the com.sap.aii.lib.sda (after a tedious preparation of the file using winzip ref to this good link https://archive.sap.com/kmuuid2/8000cffc-6b92-2d10-3493-f2ac1399242f/Deploying%20JDBC%20Drivers%20in%20PI%207.1x%20Systems ) but when you check the logs there is an error! indicating an issue with port 50004.

This led to numerous parameter changes i.e. checking the port configuration in config tool, adding parameters in the default profile , checking if SAP processes are running on that port . Some of the useful information came from the following commands , notes and urls

sapcontrol -nr 00 -function GetAccessPointList

./STARTUP confighostagent <SID>

http://www.sapbasis1solution.com/HOW_To_Launch_NEW_SUM_SP_14_15_16_17_Upgrade.htm

set in profile parameter icm/server_port_1 = PORT=5$(SAPSYSTEM)04,PROT=P4

We also had to define *.* to port 50004 in hosts file as the server had a virtual host name since it was previously a cluster set up.