Hi all,
We are facing issue in application as user information is not passed from Siteminder/Web server to application. Application code expects user_Id of the user who logged in to be passed on as part of SMUNIVERSALID field on the header. This issue is occurring for both prod and non-prod environments post migration.
But user is able to login application by providing user credentials at siteminder challenge page and below is the supported loges that siteminder is auth is working but issue with writing data in database, and are not seeing any errors in smps/smaccess log for odbc/jdbc or for database connectivity issue.
We have migrated website to new Linux servers. Post this migration, SMUNIVERSALID is passed as null to the application. This is preventing application to track the user information who have logged into the application. Also as checked in logs from prod server, the user_id was getting fetched properly when site was hosted on new servers. below is the application log ,
<Insite System--Tue Sep 11 11:27:06 EDT 2018>running jsp=/jsp/AccuracyIndexJSP.jsp
<Insite System--Tue Sep 11 11:27:09 EDT 2018>logging enabled
<Insite System--Tue Sep 11 11:27:09 EDT 2018>CmdServlet started in mode (env) test
<Insite System--Tue Sep 11 11:27:09 EDT 2018>new Session started...g42NWhG4i14TNnmPbQNg4MQ, null, CMD=ODR
<Insite System--Tue Sep 11 11:27:09 EDT 2018>CMD ODR
<Insite System--Tue Sep 11 11:27:09 EDT 2018>Test = HttpQueryString -http://insite-tst.kraft.com/servlet/CmdServlet?CMD=ODR
<Insite System--Tue Sep 11 11:27:09 EDT 2018>CMD request=ODR
<Insite System--Tue Sep 11 11:27:10 EDT 2018>pool Connection opened=com.kraft.operations.inventory.util.UConnection>com.microsoft.sqlserver.jdbc.SQLServerDriver / jdbc:sqlserver:DRPI0001
<Insite System--Tue Sep 11 11:27:10 EDT 2018>running class=com.kraft.operations.inventory.accuracy.bean.ReconciledOrdersQuery
<Insite System--Tue Sep 11 11:27:10 EDT 2018>pool Connection closed=com.kraft.operations.inventory.util.UConnection>com.microsoft.sqlserver.jdbc.SQLServerDriver / jdbc:sqlserver:DRPI0001
<Insite System--Tue Sep 11 11:27:10 EDT 2018>running jsp=/jsp/ReconcileOrdersJSP.jsp
Siteminder logs:
AzAccept MDZUSOKTULUTL06 [12/Sep/2018:08:48:24 -0500] "10.53.170.17 CN=HCU5126,OU=Non-Employees,OU=Users,OU=India,OU=AP,OU=Kraft,OU=Users and Workstations,DC=KRFT,DC=Net" "insite.kraft.com GET /html/Footer.html" [00000000000000000000000051bf360a-4772-5b991928-f53fcb70-7b464febb811] [0] [] []
Kindly advise on this issue,
Its Urgent Please,
Regards
Rajkumar G