Symptom
- The following error is reported in ASE:
Msg 11031, Level 16, State 1:
Server '<server>', Line 1:
Execution of unknown type ptncond_548193972_0 failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.ptncond_548193972_0.
- The following command was executed:
sp_quotepartitiontext "fix"
go
- After running the sp_quotedpartitiontext with the fix option it changed syscomments:
548193972 676194428 1 3 <= (9223372036854775807)
548193972 676194428 1 4 <= (9223372036854775807)
548193972 660194371 2 3 <= (-9223372036854775808)
548193972 660194371 2 4 <= (-9223372036854775808)
548193972 644194314 3 3 <= (MAX)
548193972 644194314 3 4 <= (MAX)
to
548193972 660194371 2 3 <= (""""""-9223372036854775808)
548193972 660194371 2 4 <= (""""""-9223372036854775808)
548193972 676194428 1 3 <= (""""9223372036854775807)
548193972 676194428 1 4 <= (""""9223372036854775807)
548193972 660194371 2 3 <= (""""""-9223372036854775808)
548193972 660194371 2 4 <= (""""""-9223372036854775808)
548193972 644194314 3 3 <= (""""MAX)
548193972 644194314 3 4 <= (""""MAX)
- Table involved has a bigtdatetime or bigtime column
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP04
Product
Keywords
11031, sp_quotepartitiontext, problem, Wrong SQL structure Executed , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.