SAP Knowledge Base Article - Preview

2137610 - Error 233: "The column pad1 in table sysusers does not allow null values" running sp_adduser on upgraded database. - ASE

Symptom

  • Upgraded ASE 15.7sp130 to ASE 16.0
  • Running sp_adduser reporting the following error:
Msg 233, Level 16, State 2:
Server 'l<server>', Procedure 'sp_adduser', Line 248:
The column pad1 in table sysusers does not allow null values.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 (15.7.0.130) and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 GA on any PL (16.0.00.0x)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sysusers.user_status, sysusers, user_status , KBA , sp_downgrade_esd , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.