Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    28

    Unanswered: Sybase upgrade to 12.5:: Arithmetic overflow error

    Hi,
    While doing a Sybase upgrade from 11.9.2.4 to 12.5, we encountered the following error...

    ************************************************
    Adding ssl certificates class to sysattributes
    Adding new configuration variables to sysconfigures.
    Adaptive Server message 247, state 1, severity 16:
    Arithmetic overflow during implicit conversion of INT value '66565' to a SMALLINT field .
    DB-LIBRARY error: 20018
    General SQL Server error: Check messages from the SQL Server.
    ************************************************

    At this point the database was in an inconsistent state and the upgrade process could not be resumed from that point.

    Attempts to then restart the server also failed with reports of corruption on the master device.

    We are not sure what exactly caused the master device corruption and the upgrade to fail midway.

    I would agree that normally, arithmetic overflows in Sybase are due to stack sizes, however, we did substantially increased the stack size BEFORE we ran the upgrade.

    Any pointers would be appriciated.

    Regards
    Debkumar

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Hi,

    Isn't it an option to install the new version on its own instead of an upgrade?
    If you have dumps of the 11.9.2.4 databases you can load them into the 12.5-databases.
    A bit more work, you have to install and configure stuff first, and create the devices and databases before loading the dumps, but I think it will work.

    Good luck!

  3. #3
    Join Date
    Nov 2002
    Posts
    207
    I found this on Sybase web site, but this is for AIX. You can call Sybase and check if the same is true for your OS also.

    Case Description:
    Customer ran sp_recompile and received error 247: Arithmetic overflow during implicit conversion of INT value '32768' to a SMALLINT field

    Tip or Workaround:
    Reset the sysobjects.schemacnt to 1 and rerun the sp_recompile

    Resolution:
    Customer was hitting CR 122070: "A 247 error, "Arithmetic overflow during implicit conversion of INT value '32768' to a SMALLINT field" is reported by a stored procedure when incrementing an object's schema count from 32767. "

    This CR is fixed in 12.5.0.2.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •