Skip to Content

The identifier that starts with '@skip_compact_extents_reorg_st' is too long. Maximum length is 30

Hi,

I've just upgrade my produktive system from 15.7.0.121 to 15.7.0.136, it's all OK but some reorg jobs end with errors:

Job execution failed. See job history and log file for details.

----------------------------------------------
starting job execution at 2016-10-16 10:30:52
(1 row affected)
The identifier that starts with '@skip_compact_extents_reorg_st' is too long. Maximum length is 30.
The identifier that starts with '@skip_compact_extents_reorg_st' is too long. Maximum length is 30.
Execution of procedure SP_ADM_REORG failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.SP_ADM_REORG.

I? also already try to drop the job definition and then re-create again... but not solution.

The job was created as:

Have you got any idea?

Thank you.

m8whi.png (18.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2016 at 05:04 PM

    Did you try dropping and recreating the dbo.SP_ADM_REORG stored proc?

    Add comment
    10|10000 characters needed characters exceeded

    • You could extract the code using ddlgen, then apply the resulting SQL against Sybase (the SQL generated by ddlgen should include drop/create proc and grant commands).

      Alternatively, find the script/package that contains the source code for SP_ADM_REORG and extract the code from said source.

      NOTE: If this Sybase instance is supporting a SAP application then there may be a SAP note about this type of issue; I don't work with SAP so someone else would need to provide details on such a note.

  • avatar image
    Former Member
    Apr 12, 2017 at 11:10 AM

    Hi there,

    I had the same issue today and this is how I fixed it:

    1> dbcc upgrade_object (saptools, "SP_ADM_REORG")
    2> go

    I hope this helps.

    Regards,
    John

    Add comment
    10|10000 characters needed characters exceeded