Database error 9561是什么错误
<P>我在用PB打开表时提示下面错误</P><P>Select error:An insert or update to table'#spindtab_01000850020024838'<BR>places column 'index_num' at offset 6,ending at offset 10.<BR>The maximum permitted ending offset for this column is 6.<BR>This is a server internal error.</P>
<P>如何解决</P> 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
页:
[1]