Symptom
- SELECT on a view fails with ASE Error 530
- On systems running SAP applications, you find the following ST22 short dump to occur:
C ERROR: -1 in function StartSelect (execute) [line 20225]
C (530) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Attempt to insert NULL value in
C to column 109 in work table (table id 4290838519); column does not allow NULLS.
C UPDATE fails.
C
B ***LOG BY4=> sql error 530 performing SEL on table CAUFV [dbtran 7634]
B ***LOG BY0=> [ASE Error SQL530]Attempt to insert NULL value into column 109 in work table (table id 4290838519); column does not
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 and higher for Business Suite
- SAP Solution Manager (Solman) 7.1
- SAP Adaptive Server Enterprise (ASE) 15.7 and higher
Product
Keywords
error 530, Error: 530, update index statistics, work table, VIEW, SQL530, CAUFV , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.