Comments

7 comments

  • Best answer
    Avatar
    Ben Bauer

    Hi Ravi,

    The error indicates that this query run against the source database is yielding 0 results:

    SELECT TABNAME, AS4LOCAL, AS4VERS, TABCLASS, SQLTAB FROM {{Source Schema Owner}}.DD02L WHERE TABNAME = 'A605'

    NOTE:  {{Source Schema Owner}} should be replaced with the SCHEMA OWNER value you've entered for the Target Source record in Collect.

    The 0 results can be caused by several things.  Some sort of permissions issue with the source database user, an incorrect source schema owner, or maybe the A605 table just isn't registered in the SAP data dictionary (so it doesn't have a record in DD02L in the source database).

    One quick workaround is to blank out the {Sap Settings} tab on the vertical of the Target Source record in Collect.  This will tell the 'build package' code to use the source database metadata instead of the SAP data dictionary.

    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Hi Ben,

    Thanks for your response.

    I can see that table maintained in DD02L table in the schema from where i am extracting the data.

     

    I tried to blank out SAP settings tab on vertical pane, however target source become inactive because we have few tables with BOA/SAP RFC package type.

    We don't have issue with any other table.

    Thanks & Regards

    Ravi

    0
    Comment actions Permalink
  • Avatar
    Ben Bauer

    Hi Ravi,

    This doesn't seem like a very common case.  Please submit a support ticket so our agents can provide further assistance.

    1
    Comment actions Permalink
  • Avatar
    Ben Bauer

    Hi Ravi,

    I haven't seen any ticket opened regarding this A605 issue.  Were you able to sort it out?

    0
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Hi Ben,

    Yes, i was able to create the package.

    Thanks & Regards

    Ravi

    0
    Comment actions Permalink
  • Avatar
    Jon Green

    Ravi, can you provide details on how you resolved this or what was found to be the issue so that if someone has a similar issue they can see the resolution.

    0
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Hi Jon,

    I didn't do any additional activity for this, i tried it after couple of days and then it worked. Not sure what changed in between.

    Thanks & Regards

    Ravi

    0
    Comment actions Permalink

Please sign in to leave a comment.