Skip to Content

No results from DB Lookup when simulating BRF+ rule

I am building a rule that receives an article performs a DB Lookup to MARA to return dimensions, article type, and a z-field for regulatory category. This data is used to determine if the product will fit or is excluded from gift boxing. I am unable to simulate the DB Lookup directly since the tables are not on the DSM system. When I simulate the function and specify the QA system, the results returned for dimensions are zero. Basis sees the call for the values to ECQ with no errors.

The structure of the rule and the details of the DB Lookup to MARA.

Executing against our ECQ system

MARA values for the article used in Simulation in our ECQ system.

Simulation details. You can see zero values for the dimensions.

image001.jpg (38.3 kB)
image002.jpg (10.6 kB)
image003.jpg (8.5 kB)
image004.jpg (33.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Mar 13, 2014 at 07:49 AM

    1. Is the field maybe using output conversion, means the internal value is different than the external value?

    2. Did you deploy and then debug the generated code? In the generated code you should find a comment with the database lookup ID so that you easily find the place of the SELECT.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 13, 2014 at 10:31 PM

    Hi Jim

    I'm looking at your simulation trace and I can see a rule with a description starting with "Lookup ..." (screenshot is a little too blurry to read the full description) but I can't see any DB Lookup expressions being executed within it. Do you have a condition on your rule that is preventing it's execution?

    If you need help determining this, can you post a screenshot of your rule?

    Regards

    Glen

    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.