Backup Troubleshooting - Sybase iDataAgent

Table of Contents

Configuration Failures

SYB0001:  CLSybBrowse150.exe - System Error when Configuring Sybase Instance on Windows Configuration

Issue

On a Windows configuration, the following error message is received when configuring an instance.

CLSybBrowse150.exe - System Error

Resolution

Verify the following paths are added to the System Variables.

%SYBASE%\%SYBASE_ASE%\bin

%SYBASE%\%SYBASE_ASE%\jobscheduler\bin

%SYBASE%\%SYBASE_ASE%\dll;

%SYBASE%\%SYBASE_OCS%\lib3p64;

%SYBASE%\%SYBASE_OCS%\lib3p

%SYBASE%\%SYBASE_OCS%\dll

%SYBASE%\%SYBASE_OCS%\bin

%Simpana%\Base

Variable Definition
%SYBASE% SYBASE HOME - the base install path
%SYBASE_ASE% The Sybase ASE folder name
%SYBASE_OCS% The Sybase OCS name
%SIMPANA% The Simpana directory name
Expand All

Example

SYBASE HOME is E:\sybase\syb157

SYBASE_ASE folder is ASE-15_0

SYBASE_OCS folder is OCS-15_0

Verify the following System Path entries

 E:\sybase\syb157\ASE-15_0\jobscheduler\bin

E:\sybase\syb157\ASE-15_0\dll;

E:\sybase\syb157\ASE-15_0\bin

E:\sybase\syb157\OCS-15_0\lib3p64;

E:\sybase\syb157\OCS-15_0\lib3p ·

E:\sybase\syb157\OCS-15_0\dll

E:\sybase\syb157\OCS-15_0\bin ·

C:\Simpana\Base

SYB0002: Instance Configuration Error

Issue

Sometimes, you may receive an error while configuring Sybase server instance. You may receive this error when you try to set the Sybase server parameter net password encryption to 2.

Resolution

As a workaround, add the following entries manually in OCS.CFG file to avoid the error:

[DEFAULT]
CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE

[isql]
CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE

[ClSybAgent]
CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE
 

You can find the OCS.CFG file at the following location:

Unix
$SYBASE/$OCS/config/ocs.cfg
Windows
$SYBASE/$OCS/ini/OCS.CFG

Backup Failures

SYB0003: Invalid Argument

Issue

Sometimes, backup jobs may fail with the following error:

Invalid Argument.

This issue occurs when you use Sybase 15.5 ESD #4. The backups will not fail if you use 15.5 GA binary (backupserver and sybmultbuf).

Resolution/Workaround

Set the block size. For more information, see Changing the Default Block Size

SYB0004: Failure of Backups Performed from a Remote Desktop on Windows

Issue

Currently, backups and restores cannot be performed from a remote desktop on Windows.

Resolution/Workaround

Use any one of the following solutions that suits your setup:

  • Login to remote desktop using the following command:

    mstsc /v:winclient /console

  • Use netmeeting
  • Use telnet
  • Use the clients console

SYB0005: Backup Failure Due to Incorrect Backup Server Name

Issue

If there is a mismatch between an actual backup server name and the name existing in sysservers table of master database, backup fails with the following error message:

Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.

Resolution/Workaround

Verify and update the srvnetname of backupserver in sysservers table:

update master.dbo.sysservers set srvnetname = "<Backup-Server-Name>" where srvname = "SYB_BACKUP"

Verify the backupserver entry in interface file and that the backup server name is same as mentioned in instance properties.

Completed with one or more errors

Backup jobs from Sybase iDataAgent will be displayed as "Completed w/ one or more errors" in the Job History in the following cases:

  • If the subclient contains multiple databases, killing a backup job when some of the database backup jobs are not completed.

  • If the subclient contains multiple databases, if some of the databases in the subclient are corrupted or removed.