2190868 - Error SQL325 returned when doing selective delete on Infocube - SAP BW on ASE

• Your BW is running on an ASE version equal or higher than ASE 16 SP01 PL01
• You have implemented the last BW Correction Collection according to your BW version.
• ST22 shortdump on RAISE_EXCEPTION is generated when trying to do a selective delete on Infocube.
• From SM37 you also have the error reported for the  BI_INDXxxx / xxxx job generated:
  
  Date       Time     Message text                                                                        Message class Message no. Message type
  
  06.08.2015 20:08:47 Job started                                                                              00           516          S
  06.08.2015 20:08:47 Step 001 started (program RSINDEX1, variant &0000000001742, user ID xxxx)              00           550          S
  06.08.2015 20:08:50 SQL: 06.08.2015 20:08:50 xxxxxx                                                         DBMAN         099          I
  06.08.2015 20:08:50  delete "/BIC/FXXXXX" from "/BIC/FXXXX" "F"                                          DBMAN         099          I
  06.08.2015 20:08:50 where "F"."KEY_XXXXX" IN ( select                                                     DBMAN         099          I
  06.08.2015 20:08:50 "DIM1"."DIMID" from "/BIC/DXXXX" "DIM1" join                                         DBMAN         099          I
  ... (skipped lines)
  ...
  06.08.2015 20:08:50 '2015001' AND '2015012' ) ) plan ' (use optgoal                                         DBMAN         099          I
  06.08.2015 20:08:50 sap_olap) (use fact_table F) (use parallel 4)                                           DBMAN         099          I
  06.08.2015 20:08:50 (prop F (parallel 4))                                                                   DBMAN         099          I
  06.08.2015 20:08:50 SQL-END: 06.08.2015 20:08:50 00:00:00                                                   DBMAN         099          I
  06.08.2015 20:08:50 SQL Error: [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adap     DBMAN         257          I
  06.08.2015 20:08:50 Internal session terminated with a runtime error RAISE_EXCEPTION (see ST22)              00           671          A
  06.08.2015 20:08:50 Job cancelled    

• Checking SM21 at the same datetime we can get those messages with the infomation of the developper worker process file (in this case 024):

06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @5C\Qvery high priority@ BY2 Database error 325 at EXE
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ BY0 > [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ BY0 > Enterprise]Adaptive Server finds no legal query plan for thi
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ BY0 > statement. If an Abstract Plan is forcing the query plan,
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ BY0 > check its correspondence to the query. If not, please contac
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ BY0 > SAP Technical Support.
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @5C\Qvery high priority@ AB0 Runtime error "RAISE_EXCEPTION" occurred.
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @SR\Qinformation@ AB1 > Short dump "150906 200850 xxxxxxxx_<SID>_00 xxxxx" created.
06.08.2015 20:08:50 xxxxxxxx_<SID>_00 BTC 024 100 xxxxx @5C\Qvery high priority@ D01 Transaction Canceled 00 671 ( RAISE_EXCEPTION 20150806200850xxxxxxxx_<SID>_00 xxxxx 100 )

• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Business Warehouse

ASE, BW, 325, selective deletion, delete, infocube, 788226 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem