Database error 9561是什么错误

happy2k

免费乐捐，感谢支持

我在用PB打开表时提示下面错误

Select error:An insert or update to table'#spindtab_01000850020024838'
places column 'index_num' at offset 6,ending at offset 10.
The maximum permitted ending offset for this column is 6.
This is a server internal error.

如何解决

ehxz

Sybase ASE Error: 9561, Severity: 20, State: 2
Sybase ASE Error message in the error log file looks as below

00:00000:00432:2009/12/11 02:01:16.07 server Error: 9561, Severity: 20, State: 2
00:00000:00432:2009/12/11 02:01:16.07 server An insert or update to table '#abcd_6q98799778798' places column '' at offset 70, ending at offset 86. The maximum permitted ending offset for this column is 70. This is a server internal error.


Possible Solution

This error could be because of

--Table definition mismatch.
--To resolve the issue, Stored Procedure which is creating this temp table should be reviewed and try rescripting with correct column definition.

If everything is fine

this could be a bug also.there is a CR related to this in : Targeted CR List for ASE 15.0 ESD #2

Error 511 "Attempt to update or insert row failed because resultant row of size < value > bytes is larger than the maximum size ( < value > bytes) allowed for this table..." may be raised during the execution of a stored procedure using the reformatting strategy and the creation of a DOL (Datarows Only Locking) work table. Alternatively the error 9561 "An insert or update to table 'temp worktable' places column '(unknown column)' at offset < value > ..." may be raised.

http://www.sybase.de/detail?id=1038862