Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

SQL Report Error Messages

There are several error messages that may occur during the validation phase of this process. These messages are listed on the Error Report. 

The error report lists the following information:

  • Error File Line: The line number (physical position, no actual line number is assigned) associated with the ASCII error file that may be produced. There may be multiple errors associated with the original input line. However, the line is written to the error file once. You can correct this error file, rename it, and process it separately.
  • Original Line: The line number (physical position, no actual line number is in the input file) associated with the original ASCII file being processed. There can be multiple errors associated with one original input line.
  • Item: The Item ID (ITEM_ID) from the input file associated with the error.
  • Rev: The Item Revision ID (ITEM_RVSN_ID) from the input file associated with the error.
  • Line Type: The Line Type associated with the error (for example, the PT2 line type that populates the ITEM table). Line Type is the first field that appears on each input file line.
  • Value In Error: The value from the input file that is in error (the displayed value is limited to 15 characters — it can be truncated).
  • Error Description: Briefly describes why the value (or lack thereof) is in error. Refer to the error message descriptions in this section for additional information and possible remedies.

The less complicated of these errors have been generalized and are documented in the "General Report Error Messages" section. Errors associated with the PT2 Line Type are outlined in the "Part (PT2) Error Messages" section.