Error "Invalid procedure call or argument" in the NuGenesis Archive Agent log file - WKB20685

SYMPTOMS

• The following message appears in the NuGenesis Archive Agent log file:
  • "FillTransactionDO. (5): Invalid procedure call or argument."
• The SDMS project was migrated into NuGenesis 8 from an earlier version of NuGenesis. Some Constant Values do not migrate correctly and must be re-saved in the template after migration.

ENVIRONMENT

• NuGenesis 8 SDMS

CAUSE

One or more of the tag labels in the migrated project or projects contains a trailing space. These spaces were allowed in SDMS v6.0. They are not allowed in NuGenesis 8; however, projects with such tag labels can be migrated into NuGenesis 8.

FIX or WORKAROUND

1. Run the attached SQL query on the SDMS database as the system user to find all labels that end with a blank space; or, carefully examine in SDMS Administrator each field label in the migrated projects for blank spaces. Erase the blank spaces with SDMS Admin.
2. Open all template lines that show this error in the AAActivity log file. Edit each "Constant Value" (in most cases, the prior value is there), click OK, and then click "Save".

ADDITIONAL INFORMATION

SQL query:

SELECT d.ngprojname, f.ngfieldname, f.ngfieldlabel FROM ngsdms60.ngfields f, ngsdms60.ngprojdefs_all d WHERE d.ngprojguid = f.ngprojguid AND LENGTH(f.ngfieldlabel) > LENGTH(RTRIM(f.ngfieldlabel)) ORDER BY 1,2;