SAP Knowledge Base Article - Preview

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

Symptom

You have SAP NetWeaver 7.5 applications running on SAP ASE 160 SP02 PL06 HF1.

You find CDS view access to fail 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 , SAP Business Suite on Sybase ASE Database Platform , 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.