OpsCenter data collection failing for Job data type during Exchange backups

Article:TECH187938  |  Created: 2012-05-02  |  Updated: 2013-10-14  |  Article URL http://www.symantec.com/docs/TECH187938
Article Type
Technical Solution


Issue



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


Error



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


Supplemental Materials

SourceETrack
Value2760835
Description

Data collection fails for Job while collecting job details for Exchange backups.



Article URL http://www.symantec.com/docs/TECH187938


Terms of use for this information are found in Legal Notices