Symptom
- After migration to Solution Manager to release 7.2, SM21 is reporting those messages:
<datetime> <server> DIA 012 001 <user> @5C\Qvery high priority@ BY4 Database error 9573 with INS access to table <table_name>
<datetime> <server> DIA 012 001 <user> @SR\Qinformation@ BY0 > [ASE Error SQL9573]
<datetime> <server> DIA 012 001 <user> @5C\Qvery high priority@ AB0 Runtime error "DBSQL_SQL_ERROR" occurred.
<datetime> <server> DIA 012 001 <user> @SR\Qinformation@ AB1 > Short dump "........" created.
- Checking the related developper trace file, those lines are reported:
C ERROR: -1 in function ExeNormalModify (execute) [line 28161]
C (9573) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The server failed to create or
C update a row in table '<table_name>' because the values of the row's partition
C -key columns do not fit into any of the table's partitions.
C
C sql statement is ==> INSERT INTO "<table_name>" VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
C ? ) plan '(use ins_by_bulk on)'
C /* R3:....... :5058 T:....
C .... M:001 */
C
B ***LOG BY4=> sql error 9573 performing INS on table <table_name> [dbdbslst 4609]
B ***LOG BY0=> [ASE Error SQL9573] [dbdbslst 4609]
- No errors are reported at same datetime on the ASE error log (you may check it from DBACockpit or from server on $SYBASE/ASE-16_0/install/<SID>.log
- The latest load request for related infocube was complete.
- Last BW Correction Collection is implemented on your system.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Solution Manager 7.2
Product
Keywords
9573, error 9573, SQL9573, solution manager, DBSQL_SQL_ERROR , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.