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
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.