Sybase ASE Error SQL4956 in SM21 for Solution Manager 7.1

[Former Member]

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

[Former Member]

Hi Jansi,

The user I am using "sa" has roles 'sa_role' and 'sybase_ts_role'. See below:

1> sp_displayroles sa

2> go

Role Name

------------------------------

sa_role

sso_role

oper_role

sybase_ts_role

mon_role

sa_serverprivs_role

(6 rows affected)

(return status = 0)

Hi Rishi,

I had checked this note. Its regarding the issue with SAP system. I am trying to solve at DB level.

Thanks to both. Any further comments?

Best Regards,

Hrishikesh Wagle

[Former Member]

Hi,

Please also check the below note .

1817223  - EarlyWatch Alert (EWA) Job - SM:EXEC SERVICES is taking a long time to complete

Thanks

Rishi Abrol

[Former Member]

hi,

if i am not wrong, "dbcc cacheremove" is one f the undocumented comments from sybase, so you need to have additional permission to run those comments, like the permission "sa_role" and "sybase_ts_role" . Please check more reference on the Note from the below blog

assign those user permissions and try to clear cache with cacheremove comments.

Thanks

Jansi