SSL connectivity errors

SSL certificates not trusted/accepted
ServiceNow certificate not accepted by SAP organization
Extra reading:
http://www.scribd.com/doc/26029682/EP-SSO-How-to-Implement-Security-Using
http://wiki.sdn.sap.com/wiki/display/SCM/SCM+Optimizers+in+the+Cloud+White+Paper+-+Security
http://help.sap.com/saphelp_nw04/helpdata/en/d8/a922d7f45f11d5996e00508b5d5211/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/43/6b7ee9f3fa1b459825aebaf82f7340/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/9a/53a2a4a45e244aa189c2b7065a0b78/frameset.htm
http://help.sap.com/saphelp_nw04s/helpdata/en/52/31683ab81fd846e10000000a11402f/frameset.htm
http://help.sap.com/saphelp_erp2004/helpdata/en/39/09a63d7af20450e10000000a114084/content.htm
You can check some info at the ICM trace. -Goto SMICM tocde -Goto->Trace File—>Display All There you can find some information about it.

Check SNOW certificate: open SNOW instance > select Secure ‘padlock’ > select Certificate.

Select Certificate Path tab > select each certificate one at a time > View Certificate
Note: Do not view/save the final/last/bottom certificate: ‘*.service-now.com’. This one contains an expiration date that you will need to maintain.

Opens another ‘Certificate properties’ > select Details tab > Copy to File : Opens Certificate Export Wizard.
Note: view the certification path tab to make sure your copying the correct cert. based on the previous screens cert. selection.

Select Base-64 encoded X.509 (.CER) > Next > give it a name and location to save > Next

Confirm and complete/finish.

In SAP > t-code: Strustsso2
Select SSL client SSL Client (Anonymo > Change mode > section Certificate > Import certificate > Import Certificate from saved file location

Select Add to Certificate List

Results:

SAVE
N.B. Please restart ICM.

Back to SOAMANAGER Consumer Proxy to test web service connectivity.

Or

the certificate expired and was not set as trusted in the client system. steps:

1. the old ssl-certificate expired. To resolve this, create a new one refer to the article: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/964f67ec-0701-0010-bd88-f995abf4e1fc
2. get the certificate with accessing the https url; and with the prompt, install the certificate in your local machine.
3. set the certificate as trusted in transaction /nstrust. Refer to Thomas Jung blog: /people/thomas.jung3/blog/2005/05/13/calling-webservices-from-abap-via-https
4. restart ICM. to transaction /nsmicm, Menu: Administration >> ICM >> Exit Soft.
   

Error: Failed to create BT

FAILED TRYING TO EXECUTE ON CONNECTION 15: INSERT INTO task (`u_cf_user`, `made_sla`, `watch_list`, `upon_reject`, `sys_updated_on`, `a_int_6`, `number`, `sys_updated_by`, `opened_by`, `sys_created_on`, `sys_domain`, `state`, `sys_created_by`, `a_bln_1`, `knowledge`, `cmdb_ci`, `impact`, `active`, `work_notes_list`, `priority`, `sys_domain_path`, `opened_at`, `u_template`, `a_ref_4`, `approval_set`, `work_notes`, `short_description`, `assignment_group`, `u_quarter`, `a_int_1`, `sys_class_name`, `u_market_or_product_affected`, `sys_id`, `x_bate_transport_e_te_status`, `contact_type`, `a_int_2`, `urgency`, `company`, `reassignment_count`, `u_year`, `a_int_3`, `x_bate_transport_e_te_attempts`, `comments`, `a_str_38`, `approval`, `sys_mod_count`, `a_int_7`, `x_cros2_tfs_issue_submitted`, `escalation`, `u_created_date`, `upon_approval`, `u_prod_market`, `location`, `a_str_3`) VALUES(‘550ea36e132992002236fc04e144b0ea’, 1, NULL, ‘cancel’, ’2018-07-26 16:16:06’, 0, ‘INC0250403’, ‘preed’, ’550e