Skip to Content
0
Former Member
Oct 29, 2013 at 05:50 PM

Sybase ASE Error SQL4956 in SM21 for Solution Manager 7.1

190 Views

Hello,

I see below errors frequently in my newly installed Solution Manager 7.1 based on Sybase

Database error 4956

Database error 4956 at EXE

> [ASE Error SQL4956]Cannot alter table if REORG command or

> level 0 scans are active.#

When checked trace file for respective workprocess, I see below errors:

C DbSlExecute - Error 99 (dbcode 4956) on DDLExecute

C DbSlExecute - <alter table "/BI0/F0SMD_PE2H" add partition ( "/BI0/F0SMD_PE2H_0000000036" values <= (36) ) >

C dbdssyb: DBSL99 SQL4956

C [ASE Error SQL4956]Cannot alter table if REORG command or level 0 scans are active.

I was trying to resolve this with the help of note 1904426 - SQL error 4956 cannot alter table add partition when loading data. But face below issues.

I logged into isql with user sa and when I execute the cacheremove command get below error:

hostname% isql -Usa -SSID -DSID -X

Password:

1> dbcc cacheremove(SID, "/BI0/F0SMD_PE2H")

2> go

Msg 15088, Level 16, State 1:

Server 'SID', Line 1:

Parameter 'object id or name' (number 2) to DBCC command 'cacheremove' has

invalid value/type.

Msg 2526, Level 16, State 103:

Server 'SID', Line 1:

Incorrect DBCC command: Please see the ASE Reference Manual for DBCC commands

and options.

I get the similar output when use 'dbcc dec' command. However, if I do select query here, I can see the table /BI0/F0SMD_PE2H.

Does anyone have any idea how above issue can be solved or why the sybase command is failing? Please suggest.

Thanks & Regards,

Hrishikesh Wagle