SAP Knowledge Base Article - Preview

2203873 - Number (326) Severity (16) State (1) Server when trying to add an extra partition in ASE.

Symptom

When trying to split a partition to add an extra partition to a table getting the following error:

alter table xxx_xxx_xxx_xxx partition pM20140201 into (
pD20160102 VALUES <(><<)>= ("D", "01/02/2016"),
pM20140201 VALUES <(><<)>= ("M", "02/01/2014")
)

Number (326) Severity (16) State (1) Server (XXXXXXX) ALTER TABLE 'xxx_xxx_xxx_xxx_info' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 

Product

SAP Adaptive Server Enterprise 15.7

Keywords

PARTITION,compatibility mode , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.