OpsCenter data collection failing for Job data type during Exchange backups

Problem

Job data collection proceeds normally until Failing with the below shown error messages seen in the OpsCenter NetBackup data collection status user interface.

Error Message

Errors seen in the NetBackup data collection status user interface for Job.
[OpsCenter Database exception]: OpsCenterDb Column value issue around:domain_Job(client:78987:59) while executing DBAddInsert
[OpsCenter Database exception]: OpsCenterDb Column value issue around:domain_JobArchive(client:132953:59) while executing DBAddInsert

The OpsCenter server logs (for OID 148) show a lot of errors similar to:
PushPullCollectorContext JobCollector7x master initialSync failed - com.symantec.nbu.nom.scl.common.CollectionFailedException: [OpsCenter database exception]: OpsCenterDb Column value issue around:domain_Job(client:8729:59) while executing DBAddInsert

There is a similar error of the domain_JobArchive table.

SQL Anywhere Error -638: Right truncation of string data

Cause

Trying to insert a "long varchar" in to column for nb_JobAttempt/currentFile, but that column is only declared "varchar 255" in the schema.

Same issue for the nb_JobAttemptArchive table

Solution

To resolve this problem, do the following:
 

1. Stop the OpsCenter server and webserver services.
2. Make a backup copy of the OpsCenter database
3. Connect to the database with dbisqlc.
4. Execute the following commands in dbisqlc:
   SET OPTION PUBLIC.string_rtruncation = 'OFF';
commit;
5. Start OpsCenter server and webserver services
6. Collect data and confirm problem resolution.

As an alternative to using dbisqlc, you can use the loadSql.bat command.  Add the commands shown under step 4 above to a text file in a temporary location and then use the loadSql.bat (or loadsql.sh) command to invoke the changes.

Windows:  \Program Files\Symantec\OpsCenter\server\bin\loadSql.bat \temp\filename.txt

UNIX:  /opt/SYMCOpsCenterServer/bin/loadsql.sh -sqlFile /tmp/filename.txt