SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.0

Keywords

ASE, BW, 325, selective deletion, delete, infocube, 788226 , 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.