on 03-12-2014 7:08 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.