We have a form that is prompting for demographic information about a student - examples: permission to display artwork, student email, phone numbers, preferred language for correspondence, guardian and emergency contact information.
We are using workflow to transfer information from the form to a "staging" table in SQLSERVER. A snippet of the workflow :
One of the custom queries looks like this:
INSERT INTO Student_Contact_Staging (BPID,BPName,InstanceID,StudentID,Language,HomePhone,CellPhone)
VALUES
( @BPID,@BPName,@InstanceID,@StudentID,NULLIF(@Language, ''),NULLIF(@HomePhone, ''),NULLIF(@CellPhone, '') ) )
The workflow and custom queries work.
During testing there were a few columns in the staging table that were not large enough and the insert did NOT happen. The workflow completed with NO indication there was an issue. We increased the size of the staging table columns to resolve the issue.
My question is there a "return" code we can capture so that we KNOW there is an insert issue that needs attention? Having the workflow complete "successfully" with a missed insert is really NOT successful. Any advice on how to handle errors in custom queries in the workflow?