Hello there folks!
I am working on a Flow that handles the request process of a TRM Record. When doing the process, I get an error after approving it, instead of the product being created (Screenshot 1).
In reviewing the logs, I could tell that the error seems to be in some reference to the “sys_domain_path” field. The full log message:
Operation(TRM Software Product Request F failed with error: com.snc.process_flow.exception.InValEvaluationException: sys_domain_path is not a valid dot-walk for record sn_apm_trm_product_request
Using the Flow engine - Execution Details tool, reviewing the executions, I can notice that the Flow has the error in the action 5: Look up Record (Screenshot 2)
I get into the table “sn_apm_trm_standards_product” that appears in the error message, and I entered the record of the Product that I used in this example “.NET”. Here inside the record, I used the option “Show XML” and here inside, I could notice that the product ID that appears in the Flow executions tool does NOT appear. That is, the tool shows “product=4e7bac489731315046bbf4c11153afa2” (the sys_id of the .NET product, or what it should be). BUT going directly into the .NET Product from the sn_apm_trm_standards_product table, this sys_id does not exist or appear anywhere in the product XML. (Screenshot 3).
It seems that the Flow is taking this sys_id from the Record created in the “sn_apm_trm_product_request” Table. Since when entering the record in this table of the request that I created initially, reviewing the XML of this record, it DOES appear the sys_id “4e7bac489731315046bbf4c11153afa2”. More specifically, in the XML appears: <samp_sw_product display_value=“.NET”>4e7bac489731315046bbf4c11153afa2</samp_sw_product> (Screenshot 4).
So, the error must be that it is looking in the sn_apm_trm_standards_product table for the sys ID that does NOT exist in that table, but exists in the Product request table.
I also attach a picture of this Look Up in my Flow (Screenshot 5)
As extra information, in the specific case of the Product used in this “.NET” test, in the table “sn_apm_trm_product_request” the field “samp_sw_product” has as value “4e7bac489731315046bbf4c11153afa2”. (screenshot 6)
However, in the table “sn_apm_trm_standards_product”, the field referring to the id “u_product_id” has as value “4051”. (Screenshot 7).
As it is visible, they are two different fields, with completely different values, but both refer to the same “.NET” product.
How can I fix this?
I can add more images of what you think is necessary to solve this. Any help is appreciated!
