When attempting to use the Provider By Provider Sharing option in the Central Administration domain, this error comes up.
Cannot insert the value NULL into column 'prv_sh_mp_shr_tp_rfk', table 'CW_Data.dbo.cw_provider_sharing_map'; column does not allow nulls. INSERT fails.The statement has been terminated. INSERT INTO cw_provider_sharing_map ( prv_sh_mp_shr_tp_rfk , prv_sh_mp_sharing_dmn_fk , prv_sh_mp_share_with_dmn_fk , prv_sh_mp_last_updated) VALUES (@prv_sh_mp_shr_tp_rfk , @prv_sh_mp_sharing_dmn_fk , @prv_sh_mp_share_with_dmn_fk , @prv_sh_mp_last_updated)cw_provider_sharing_map.prv_sh_mp_shr_tp_rfk=cw_provider_sharing_map.prv_sh_mp_sharing_dmn_fk=94497a60-c087-49ee-acf8-fc6e7b547212cw_provider_sharing_map.prv_sh_mp_share_with_dmn_fk=1f114911-c19e-4b91-82df-f9fbf8aaffbd^ at jProgBusiness.jBusiness.jSQLTransactionHelper.ExecuteWithTransactions(jBusinessShared BusinessShared, jUser User, String DomainPK, Boolean LogChanges, Boolean RollbackOnError, jServiceManager serviceManagerToUse, Boolean closeConnectionAfterUse) at jProgBusiness.jBusiness.jSQLTransactionHelper.Execute(jBusinessShared BusinessShared, jUser User, String DomainPK, Boolean LogChanges, Boolean RollbackOnError, jServiceManager serviceManagerToUse, Boolean closeConnectionAfterUse, Boolean forceNoTransaction) at jProgBusiness.jBusiness.jSQLTransactionHelper.Execute(String sessionToken, Boolean logChanges, Boolean forceNoTransaction) at jProgBusiness.jBusiness.jDataSharingOperations.ADM_Grant_Provider_By_Provider_Sharing(jParameterList params) at jProgBusiness.jBusiness.DocumentAdmin.getDocument(jParameterList parameterList)
at Client.ProviderByProviderSharingWorksheet.cmdShareRight_Click(Object sender, EventArgs e)
This error message is generated because no
Sharing Type was chosen from the drop down menu. Make sure to choose a
Sharing Type prior to clicking the Share button.
Back to
Provider By Provider Sharing