Alfred Tech Life

Today i had hard time installing SSL certificate on one of our IIS servers. when i was trying to follow the provider instructions and "Complete Certificate Request" i got "Failed to remove certificate"! and import required pfx file which i didn't have, we only got crt file. and trying converting that to pfx was failing. until i hit this gem "OR it could be the cert (Network solutions is notorious for this as they charge $150 for helping to install it) doesn't actually have a privatge key.  Here are instructions to make the PFX if you have no private key. To fix this, use the MMC snapin to import the cert into PERSONAL, click it and grab the serial # line.  Go to dos, run certutil -repairstore my "paste the serial 3 in here" (you need the quotes) then refresh MMC with personal certs, right click it – export – select everything except DELETE PRIVATE KEY, hit ok.  Then go to IIS and IMPORT cert instead of finish request.  bingo – fix...

Finally got to what i think the root case for the student.xml not updating Network Id field on Sunapsis. using this query which is taken from a SQL stored procedure which i think update Network ID SELECT countingOfAllNetworkIDs.idnumber FROM (SELECT * , COUNT( listingOfAllNetworkIds.networkid ) OVER (PARTITION BY listingOfAllNetworkIds.networkid) duplicateCount FROM (SELECT idnumber , networkid FROM dbo.jbInternational WHERE COALESCE( networkid, '' ) <> '' UNION SELECT idnumber , PRSN_NTWRK_ID FROM dbo.iuieBio WHERE COALESCE( PRSN_NTWRK_ID, '' ) <> '') AS listingOfAllNetworkIds) AS countingOfAllNetworkIDs WHERE countingOfAllNetworkIDs.duplicateCount >= 2 Copy to Clipboard so any id on that list wouldn't get network id updated based Sunapsis support tip we removed all duplicates and kept only latest record on iuieBio table for the same univ...

So ... we had an odd issue, we have that datafeed xml for students and it dose have the network id, but after the scheduled task run still no network id on the core bio. information. thanks for my ColdFusion friend Marcus i found a log entry on application.log indicating that the .cfm that is scheduled to import the xml have a query which timed out! finally some meaningful information in a log