com.sybase.jdbc3.jdbc.SybSQLException: Couldn’t find an available partition descriptor. Raise the value of the configuration parameter ‘number of open partitions’ for more partition descriptors.

com.sybase.jdbc3.jdbc.SybSQLException: Couldn’t find an available partition descriptor. Raise the value of the configuration parameter ‘number of open partitions’ for more partition descriptors.

org.springframework.jdbc.UncategorizedSQLException:
Hibernate operation: Could not execute query;
uncategorized SQLException for SQL []; SQL state [ZZZZZ]; error code [14126]; Couldn’t find an available partition descriptor. Raise the value of the configuration parameter ‘number of open partitions’ for more partition descriptors.;
nested exception is com.sybase.jdbc3.jdbc.SybSQLException: Couldn’t find an available partition descriptor. Raise the value of the configuration parameter ‘number of open partitions’ for more partition descriptors.

从报错来看是Sybase15数据库的参数配置问题

摘自
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00729_1500/html/errMessageAdvRes/CHDGEGGC.htm

Error 14126
Severity

17

Message text

Couldn’t find an available partition descriptor. Raise the value of the configuration parameter ‘number of open partitions’ for more partition descriptors.

Explanation

In Adaptive Server Enterprise version 15.0 and later, all tables have at least one partition, whether or not a partition was explicitly defined on the table. When you upgrade a database to Adaptive Server Enterprise 15.x, all existing tables in the database are modified to have one partition. When data is accessed from a table, necessary partitions are kept open; however, a DBA can limit the number of open partitions at any given point of time. This error indicates that there is not enough room to open a new partition.
Action

Use sp_configure to set the number of open partitions value appropriately for your server. See “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for details on setting this parameter.
Versions in which this error is raised

Version 15.0 and later

sybase,jdbc,sp_configure

文章的脚注信息由WordPress的wp-posturl插件自动生成

此条目发表在javaee分类目录,贴了, , 标签。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用*标注

评论链接可以 移除 nofollow.