SAP Knowledge Base Article - Preview

2541380 - SQL9573 returned after migration to Solution Manager 7.2

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

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

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 ONE Support launchpad (Login required).

Search for additional results

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