Skip to Content

Access plan calculation error in sender system for filtering approach

Hello All,

I am filtering MARA data with selection criteria

Select * from MARA where (MTART = 'UNBW' OR MTART = 'VERP') AND (SPART = '00')

I made entry in DMC_ACSPL_SELECT table as

But job is going into error "Batch job for access plan calculation in sender system ended with errors"

And in source system, the short dump is specifying error for dynamic selection criteria.

"The reason for the exception is:

An Open SQL clause was specified dynamically. The contained field name

")" does not exist in any of the database tables from the FROM clause."

Looks like there is something wrong in my selection criteria (DMC_ACSPL_SELECT).

- Please can you point me where I am wrong here.

- Also, when I am using parallel approach even with 1 filter option, the complete data is getting loaded without any filter. Any thought on this?

Regards

BJ

Capture1.JPG (60.4 kB)
Capture2.JPG (87.9 kB)
Capture3.JPG (49.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 12, 2016 at 05:25 AM

    Hi BJ,

    Your syntax for filter condition looks to be correct.

    The error related to CX_SY_DYNAMIC_OSQL_SEMANTICS looks to be some bug. Have you applied correction notes based on your SLT DMIS version? Please check if below two notes solve your problem or not-

    1885704 - Precalculation fails with SAPSQL_WHERE_PARENTHESES


    1995954 - SLT (2011 SP06 / 2010 SP10) - Correction 11

    depends on your SLT version.


    Regards,

    Saritha K

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.