Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
7 subscribers
Views
3942 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, I am facing a very strange problem, where I am using a Execute Process r
harshav
over 8 years ago
Hi All, I am facing a very strange problem, where I am using a Execute Process report, and I am having a column of ID, which is the same variable in all the sub processes and the mail processes as well. Now in Dev, this is having all the IDs, and after moving to Prod the value of this is not getting populated, due to which I am not able to apply a condition with COlumn ID= ID value, and My process is failing, I went into that instance and I can see the data is available in the PV. pv!CDT.ID is the pv name.
Can anybody tell me how to figure out this problem
Thanks In advance!!!
OriginalPostID-213114
OriginalPostID-213114
Discussion posts and replies are publicly visible
0
sikhivahans
over 8 years ago
@harshav Hi, as a part of brain storming, it would be good to have answers for the following questions:
If data isn't present in report:
1. How is 'Allow data from this sub-process to be included in reports on the parent process model' configured on sub-process nodes?
2. How is 'Variable is hidden from parent processes and reports' configured for PVs?
3. Is the variable name same across all the processes?
If data is present in report:
1. Is the functionality being executed under basic user privileges? If so, does the basic user hold privileges to the processes that were present in the report?
2. Did you analyse the data present in the report and are you sure that there would be an outcome?
To the best of my knowledge, the quickest way to debug is to use a!queryprocessAnalytics()/fn!getportalreportdatasubset()(If a version prior to Appian 7.8 is used) and apply the filter settings same as in Execute Process Report. Debugging this way and a few permutations/combinations thereafter will help you identifying the issue as per my knowledge.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
Thank you sikhivahans for the detailed Inputs,
I have checked the following things 1. In all the sub processes it is configured.
2.Variable is not hidden
3.The variable Name ID is same in all the processes.
4.I am running the Report as Run as administrator
5.Data is present in Main model and the sub processes, but it is not reflecting in the Report.
If I use the getportaldatasubset also I will get the same data which is there in report right, I need to have that data in report so that I can use the output for some other purposes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
also the strange thing is I am using that Pv for the tp!display that is coming correct. like task Name-123 but in the report when I call this pv It is coming blank not sure why this is happening.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@harshav No worries, may I please know how the ID column (the one that's blank) is configured?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
sure , it is coming from the process variable and it is number integer field, it is a primary Key. it is coming from the CDT, pv!CDT.Id and there is no link to task ,
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
basically I am doing a task report per process model and the pv!cdt is same across the subprocesses, and it is configured like pv!cdt.id and it is number
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
Sorry for Many posts, It is populating for some instances and for some other instances it is not,....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
@sikhivahans, any thoughts pls I am stuck up with this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 8 years ago
I tried Appending that ID to process ID field as pp!id&"-"&pv!cdt.id and changed it text field. now , The process ID for those rows in which the case ID is not getting displayed,.... the process ID column also gone blank :'(
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@harshav May I please ask you to observe any differences between the processes that are able to populate value and that aren't? I believe it would be tough to conclude until and unless we draw a pattern by carefully analysing the artifacts(that is, for instance, is the PV multiple in some cases and singular in other cases?).
One more question please - Would you please be able to configure the value as pv!CDT.id[1] or pv!CDT[1].id and check once again?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>