2541380 - SQL9573 returned after migration to Solution Manager 7.2

• 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.

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Solution Manager 7.2

9573, error 9573, SQL9573, solution manager, DBSQL_SQL_ERROR , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem