Access plan calculation error in sender system for filtering approach

[former_member252769]

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

[Saritha_K · Accepted solution]

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

[former_member252769 · Accepted solution]

Hi Saritha,

Thanks for prompt reply.

My DMIS version is 2011_1_731, SP-level 0007.

I am not sure whether these notes are implemented but I checked the related objects to the notes are present in the system.

Strange thing is that the source system error is coming when more than one field is inserted in table as selection criteria.

For single field selection criteria, it is working perfectly.

Any thoughts to resolve this.

Regards

BJ

[former_member252769 · Accepted solution]

Thanks Guys...

Problem solved. By default AND is working if operator is blank.

Closing this thread.

Regards

BJ