New EmailDetails Not Saving into Database at First, At Second Works Properly - SP Issue
Description - Data Come from Outlook/Google API Stored into DB with All Email, Recipient, Attachment details using Multiple call single API.
Where API insertEmailMasterDetails used to stored email details into database but data is not inserted properly only partial info stored and throw error not giving response with out parameters but when we call again with same data it updates the info but when we sync data we haven't call 2nd call.
Error due to second select statement added for debugging purpose and didn't removed due to that error gives 2 result set and API gives error.
Solution - Debug all API and Test SP and remove the extra piece of select statement from SP.
New EmailDetails Not Saving into Database at First, At Second Works Properly - SP Issue
Description - Data Come from Outlook/Google API Stored into DB with All Email, Recipient, Attachment details using Multiple call single API. Where API insertEmailMasterDetails used to stored email details into database but data is not inserted properly only partial info stored and throw error not giving response with out parameters but when we call again with same data it updates the info but when we sync data we haven't call 2nd call. Error due to second select statement added for debugging purpose and didn't removed due to that error gives 2 result set and API gives error.
Solution - Debug all API and Test SP and remove the extra piece of select statement from SP.