Skip to Content
0

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

Oct 16, 2016 at 08:46 AM

203

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark A Parsons Oct 16, 2016 at 05:04 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

No... how can I do it?

0

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.

0
Ionut Iacob
Apr 12, 2017 at 11:10 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded