When running the commands used to generate electronic workpapers there can be instances where the desired results are not obtained. Sometimes this is due to an error in processing. The system will generally include two important messages on the work paper as a start in correcting the problem

1. An error message, and
2. The SQL that was generated by the system

The table below shows examples of the types of messages which may be generated, and the most common cause the message, as well as tips on how to correct the error. This information is needed for postings, support calls or e-mail support requests.

 

Electronic work paper error messages

Message	Description and most common cause
Error: No value given for one or more required parameters	Generally, this is due to a misspelling of a column name or failure to enclose a column name which has embedded spaces with brackets. Two examples are shown below: 1. Column name "cost_amount" spelled as "cost_amt" 2. Column name "cost amount" used without brackets, i.e. should be "[cost amount]"