SAP Knowledge Base Article - Preview

2556253 - CDS view query sql fails with Error 325 - SAP ASE for Business Suite

Symptom

On SAP NetWeaver 7.5 systems on SAP ASE 160 SP02 PL06 HF1, CDS view access fails with the following error:

Database error 325 with PRE access to table <CDS view name>

An example of the failing query is:

SELECT "ID" "ID" ,"TEXT" "TEXT" ,"LEVELNO" "LEVELNO"
FROM "/CREDINS/VORG2N" "PDORGNODESET"
WHERE "MANDT" = '100'
ORDER BY  "PDORGNODESET" ."ID" ROWS LIMIT 20

Msg 325, Level 18, State 1: Server 'ABC', Line 1:
Adaptive Server finds no legal query plan for this statement. If an Abstract
Plan is forcing the query plan, check its correspondence to the query. If not,
please contact SAP Technical Support.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 160 SP02 PL06 HF1 for Business Suite
  • SAP NetWeaver (NW) 7.5

Product

SAP NetWeaver 7.5

Keywords

325, legal query plan, LIMIT, CDS views, UNION, view, 811716 , KBA , BC-DB-SYB , Business Suite 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.