Skip to Content

Invalid query;Failed to find attribute 0REQTSN_KEY: query on top of Composite provider

Hi All,

We have created a query on top of Composite provider, which is build using Non-Cumulative Advanced DSO. When we not enable the

navigational attribute at composite provider the query is executed and giving output result. When we check or enable the any of the

navigational attribute in Composite provider it is going for ABAP debug mode and giving below error.

Thanks and regards,

Madhukar Manda

Capture1.PNG (28.4 kB)
Capture2.PNG (181.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 03, 2015 at 10:07 AM

    Hi Madhu,

    Try running the below program for the affected object in the error message and later on try -

    RSDDB_LOGINDEX_CREATE

    Also is this a transitive attribute ?

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2015 at 11:19 AM

    Hi Amit,

    We have not using any Transitive attribute. Composite provider using Advance DSO which is with non-cumulative key figure. Issue occurring only when we enable navigation attributes in Composite provider. We have already tried running the program RSDDB_LOGINDEX_CREATE for info providers (master data object also) but no luck. And the queries on Composite providers which we dnt have non-cumilative KF (with normal KF's) and enabled nav-attributes are working fine.

    Regards,

    Madhukar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Madhu,

      Can you please share how the 0Reqstn_Key is mapped in the CP.

      Also are you able to List output of the CP and the underlying DSO.

      Do you see any erroneous record with inconsistent values in 0Reqstn_Key ?

      Regards,

      Amit

  • Nov 05, 2015 at 11:55 AM

    Hi Amit,

    Actually there no mapping for this key and not even able to find in the any of the provider. This key is technical key of Advance DSO as i know ( like 0recordmode, 0record_DTP). Dnt know the reason the error message giving this field. Just raised with SAP and waiting for reponse.

    Regards,

    Madhukar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2015 at 04:22 PM

    HI Madhukar,

    You can check this way when you check navigation attribute on.

    1. View the data in composite provider.

    2. View the data in underlying Advance DSO.

    if you are getting the data there then the errorĀ  has something to do with query and if not then I would like to look into specific traget.

    Dhiraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2016 at 11:34 PM

    Hi Madhukar,

    we are also facing same issue. have you found a solution to your case??

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2016 at 02:48 PM

    Hi Madhukar, Kishore,


    when i create another composite provider based on same advanced dso(s) and with old logic, it works fine for me.


    Regards,

    Mikhail.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2016 at 04:25 PM

    Hi Madhukar,

    Hope you were able to find the answer for this problem, could you please share it if it was solved.

    Thanks,

    Madhu

    Add comment
    10|10000 characters needed characters exceeded