I am getting an error message and would like some help from the community experts.
Using BI 4.0 SP4, BW 730, I have a webi report using BICS connection and on the BW query I have a variable for Cost Element Hierarchy Nodes (Multiple Single Values).
I created a publication and saved some cost element nodes on the selection, along with other parameters (Cost centers, period etc).
The publication executed fine (to BI Inbox) and I was able to refresh the webi from the BI inbox without any issues (I did not change any prompts).
Now when I tried to change the prompt and add a new cost element group, I get an error message: "recv() returned zero"
I just added the new node (Secondary Cost Elements) to the prompt, but I also notice that the Hierarchy name now shows as a prefix on the right side (Selected values) -see example"OneShire CE Hierarchy\" is the hierarchy name.
As a workaround, I removed all nodes and added all again and the report refreshes fine.
I have 300 publications created and I do not want to change all. Interesting in the root cause for this issue.
Anyone had this before? any ideas?