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