Unable to Built Cranport package in Collect

Answered

Venkata Ravi Kumar Mullamuri

• April 04, 2021 22:16

Hi All,

I am facing below error while trying to build a package in collect for one of the table,

How can we fix this issue?

Thanks & Regards

Ravi

1

• Best answer

  

  Ben Bauer

  • April 19, 2021 13:37
  • Edited

  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.

  0
• 

  Venkata Ravi Kumar Mullamuri

  • April 05, 2021 19:47

  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
• 

  Ben Bauer

  • April 06, 2021 12:36

  Hi Ravi,

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

  1
• 

  Ben Bauer

  • April 19, 2021 12:53

  Hi Ravi,

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

  0
• 

  Venkata Ravi Kumar Mullamuri

  • April 19, 2021 13:06

  Hi Ben,

  Yes, i was able to create the package.

  Thanks & Regards

  Ravi

  0
• 

  Jon Green

  • April 19, 2021 13:10

  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
• 

  Venkata Ravi Kumar Mullamuri

  • April 19, 2021 13:23

  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

Please sign in to leave a comment.