@Saranga Amaraweera your solution works. Thanks a lot!~Juni
hi @Saranga Amaraweera , yes. the hierarchy select retuns multiple rows.thanks for your answer. I will try it. Regarding the link, as I am not IFS employee nor partner, I am not able to see the post.Could you please post the conversation here?Thank you and best regards,~Juni
Good suggestion to test it like your suggestion. I haven’t tried it, as don’t know it. On DEV I could get the image. It seems the SAS TOKEN on PROD is not valid. I got this error:<Error><Code>AuthenticationFailed</Code><Message>Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. ….</Message><AuthenticationErrorDetail>Signature did not match. String to sign used was…...</AuthenticationErrorDetail></Error> I will request new SAS TOKEN for PROD. Thanks Roman for your answers and input! Much appreciated! Cheers,~Juni
Sorry for the confusion. The image is stored in azure. Info about path is stored in database. The SAS TOKEN is needed. I checked the SAS TOKEN, there is no entry like &sip=146.xxx.xxx.xxx Report definition should be the same, as the same report is uploaded to all environments. Any other way to debug the issue? Cheers,~Juni
Hi Roman,nice to hear from you!!! You mentioned about IP restricted, where can I checked it?The signature is stored in database, and for the report is taken from there. The signature can be viewed from (task)attachment. The SAS Token shows 2021-06-24T11:56:30Z&se=2023-06-24T19:56:30Z. I assume it’s valid until 2023-06024, isn’t it? Look forward to further enlightenment from you. :-) Cheers,~Juni
Hi @Anjula Priyanath ,I did, but didn’t work before.Let me try again, and will let you know the outcome.Until later,~Juni
Hi @Hasara Dinu, @Anjula Priyanath, for testing at moment, the distribution list I set only to send to me. It works. I got the email. But the substitution map for person-id does not work..The attachment/report contains no data.
Hi @brian.gummin,the locale_code(s) are all correct.
Hi Saranga,it’s not replicated on other environments. It’s only on DEV.What I also notice, cache refresh for webclient version on DEV is also very slow. We use FSM6U16. ~Juni
Hi @Hasara Dinu,understood that the query returns error because of not correct statement. The question, what causes the query returns when doing the cache refresh. You mentioned: (You need to check and investigate the specific place where this error is coming from) » this is the intention of my post :-) How can I check and investigate the specific place where the error is coming. Entry of locale-code is correct, but error occurs when doing cache refresh. ;-)I have tried to increase the exception, information, BR level of server log, but don’t see any other exception unless that message.. Any other idea how to check and investigate? Best regards,~Juni
Hi @Hasara Dinuthe data in locale-code looks correct. And there are no double entries. Length of code value reflects the number of characters in code-value.
@Saranga Amaraweera,that’s true. I also wondered what happened there, as server log is intended for analyzing issue..:-)
Thank you @Saranga Amaraweera.After increasing the exception log level to 2, it works. (I didn’t do any change in the setup. :D )
@Lee Pinchbeck , @Hushan Hasarel , thank you for your replies. We have FSM6U14. And the app params USAGE_DAYS_TO_SAVE exists. In the value it is set 14, I see 1st data now is from 4 Feb, 2022. Best regards,~Juni.
Thanks for this valuable info, @Lee Pinchbeck ! ~Juni
Hi @Hushan Hasarel,thank you for your reply.Yes, understood that the table does not need to be persisted for long time. It will be used for troubleshooting purpose. In order to be able to use it as intended, we need to understand the data shown there. We have the data shown in the table like that, and repeating data like that shown. That’s the reason I ask how to interpret the data in that table if we have entries like that. To see whether it’s a correct behavior, or any other process to check.Hope you understand my question. Cheers,~Juni
Hi @SanjeewaJ ,if we cannot create a new view with correct format of the date-field, is there any other option?e.g. is there any possibility to convert the date-field in design-time? Best regards,~Juni @drooij
Thanks for the explanation, @Lee Pinchbeck
Hi @Constantin Mav , have you tried using max_rows=”[number]”, instead of starting/ending_rrow_number? <hierarchy_select max_rows="15"> ~Juni
Hi @Kalpa Perera ,here is the result of the query: (3 rows) Only ADHOCCATEGORY screen exists. As also listed in UI Designer: ~Juni
Hi @Kalpa Perera ,here is the screenshot from our environment: The functions are not disabled on the new role :-) ~Juni
o yeah, I refreshed the cache.and also relogin :-)
Hi @Kalpa Perera,previously, I have ADMIN role which has the standard functions. Then I created new role (and added myself to that role) which will contain the functions you mentioned.But I cannot find the function ADHOCREPORT. I also checked the baseline screen, cannot find it there. Any idea? ~Juni
Hi @Kalpa Perera, @Atheeq Maharoof, I tried to find the Ad Hoc Reports screen you mentioned. But I don’t have it.Can you enlighten me under which menu the screen is? Thanks,~Juni
hi @Kalpa Perera , I am trying to edit it from Report screen > Ad-Hoc Reports (button) and then edit it from the wizard. ~Juni
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
