Symptom
- High Availability (HA) is enabled and the companionship is configured as active/active, symmetric.
- The client raising the error is connected to the Secondary companion when the insert is executed.
Attempt an insert on secondary node:
1> insert t_test (c_int) values (2)
2> go
Msg 233, Level 16, State 2:
Server 'ASE1501_HA2', Line 1:
The column c_char in table t_test does not allow null values.
Msg 233, Level 16, State 2:
Server 'ASE1501_HA2', Line 1:
The column c_date in table t_test does not allow null values.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 12.5.4
- SYBASE Adaptive Server Enterprise (ASE) 12.5.4
- SAP Adaptive Server Enterprise (ASE) 15.0
Product
SAP Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0
Keywords
defaults , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.