Pass values in Stored Procedure through sync editor

Question

Hello, 
 We have a target system connected with Generic Database connector configured through sync editor. We are calling stored procedure on the target system as part of insert/update/delete operation which have some parameters(say A and B). Now, during insert operations, values are getting correctly populated in target system but if there is an update for parameter A only, then Parameter B value becomes null in target system. Process configured in One identity is using AdHoc-Projection component. 
 How can we send the same value of B each time even if not updated in One Identity?

Niels de Groot · Answer

Did you set the parameter ForceSyncOf in the AdHocProjection jobstep ForceSyncOf: ParameterA, ParameterB 
 If this doesn't solve the issue then maybe you could customize the schema of the Generic Database connector Start the SynchronizationEditor.exe with the &ndash;D option. Two new buttons will appear in the menu bar. You can now export to a .projshell file change schema 
 Make properties mandatory: Example... <SchemaProperty Id="CCC-.." Type="VI.NativeDatabaseSchemaProperty" Name="ParameterA" MandatoryBehavior="Always" ... <SchemaProperty Id="CCC-.." Type="VI.NativeDatabaseSchemaProperty" Name="ParameterB" MandatoryBehavior="Always" ... and import it again. P.s: If you update the schema afterwards, your customizations will be undone!