Data Backup and Recovery Discussions

Highlighted

SYBASE ASE QUIESCE error SnapCenter 4.1

Hi.

I'm trying to configure a backup for SAP (Sybase) ASE 16 on SnapCenter 4.1.

When I run a backup of the Database, during the "Quiesce Application", I receive an error:

"SCC-00164: Application quiesce for plug-in [SYBASE] failed with exit code [1] and with error :"

 

I checked the full log and the message is:

 

Fri Sep  7 14:20:50 2018#SYBASE:QUIESCE: Starting, SC_MSG#INFO#
Fri Sep  7 14:20:50 2018#SYBASE:EXPAND_DB: Entered, SC_MSG#INFO#
Fri Sep  7 14:20:50 2018#SYBASE:EXPAND_DB: No database discovery required, finishing, SC_MSG#INFO#
Fri Sep  7 14:20:50 2018#SYBASE:QUIESCE: Quiescing database BICMC, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#SYBASE:BACKUP_CHECK: Checking Database BICMC state, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#SYBASE:BACKUP_CHECK: Executing SQL sequence:, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018# SELECT CASE WHEN (status3 &   128) = 0 THEN 'Fq' ELSE 'Tq' END AS [(qui)], SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#   from master.dbo.sysdatabases where name="BICMC", SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#go, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#SYBASE:RUN_CMD: Executing command [ -Usa -Pxxxxx -S -w 1024 -i C:\Windows\TEMP\uHNlmyoEDe.sc], SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#SYBASE:RUN_CMD: Command [ -Usa -Pxxxxx -S -w 1024 -i C:\Windows\TEMP\uHNlmyoEDe.sc] finished with, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#exit code: [1], SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#stdout: [], SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#stderr: [], SC_MSG#ERROR#
Fri Sep  7 14:20:50 2018#[syb-00012] SYBASE:RUN_CMD: Command [ -Usa -Pxxxxx -S -w 1024 -i C:\Windows\TEMP\uHNlmyoEDe.sc] failed with return code 1 and message , SC_MSG#DEBUG#

Fri Sep  7 14:20:50 2018#SYBASE:BACKUP_CHECK: Database BICMC sql unable to execute :  SELECT CASE WHEN (status3 &   128) = 0 THEN 'Fq' ELSE 'Tq' END AS [(qui)], SC_MSG#DEBUG#

Fri Sep  7 14:20:50 2018#, SC_MSG#DEBUG#
Fri Sep  7 14:20:50 2018#   from master.dbo.sysdatabases where name="BICMC", SC_MSG#DEBUG#

 

I'm always getting this error.

Is there a way to check the detailed command/query that SC is trying to execute on ASE?

Could you please help me to solve this problem?

 

Thanks.

Forums