Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
AW: 9205 error
From: Anhaus, Thomas (thomas.anhaussap.com)
Date: Tue Oct 04 2005 - 03:21:45 CDT
Carlos Yabut wrote :
>From: Carlos Yabut [mailto:c_yabutyahoo.com]
>Sent: Saturday, October 01, 2005 9:37 AM
>Subject: 9205 error
>I am having the same problem as the one i reported
>about 3 months ago. I got disctracted but I thought it
>would be fixed with the newest release. I am now using
>MAXDB 22.214.171.124. My existing set up is SAPDB 126.96.36.199.
>I did a complete backup using the database manager of
>a database i created with this server. And then I
>restored the backup the the new 188.8.131.52 server. After
>I updated the SYSTEM TABLES I am getting the following
>Auto Commit: On, SQL Mode: Internal, Isolation Level:
> General error;-9205 POS(1) System error: AK Catalog
>information not found:0000000000000000007200
>SELECT DISTINCT schemaname FROM domain.triggers WHERE
>TRIGGERNAME LIKE '%'
>I need to move to the new version to take advantage of
>your SYNC option.
I fear it will not be possible to fix the problem just by
a new release, because it seems that there's some inconsistency inside
persistent part of the catalog.
Please send me a trace of the select statement that produces the error.
Maybe it's possible to identify the corresponding trigger or table and
to drop and recreate it afterwards.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb