Hi IdM Experts,
I wanted to build a reporting functionality that can be triggered through a UI task (Report Form). The UI task starts a process (type: form action process) which uses a script with an SQL query to grab the data from the database. I'...
Hi IdM Experts!
I tried to set up a filter in version 8 on a form's access control tab to limit which users can be selected. It is required that only users which are not disabled (MX_Disable <> 1) can be selected for the task. Unfortunately the fil...
Hi experts,
in IdM 8 if a role is assigned to a user with two validity ranges that are next to each other, e.g.
01.01.2018 - 20.01.2018 and then
21.01.2018 - 28.01.2018
what happens is that at midnight on the 20.01.2018 the role will be remov...
Hi Plaban,
I use the following script to call a custom BAPI. In our case Z_GENERATE_BP_FROM_SAPUSER.
Kind regards,
Zoltan
function CallBAPI(Par) {
var mskeyvalue = Par.get("MSKEYVALUE");
importClass(Packages.com.sap.idm.ic.sa...
Hi Norman,
the customer was not available in the past couple of weeks so I was only able to check with them yesterday the dispatcher settings. Unfortunately I was not able to locate where to change the settings, nor was I able to find any informati...
Hi Chenyang,
it is the query which takes a very long time if it is executed from a SAP IdM process. The CSV export is quick. I have also tested the uSelect with a very simple SQL like:
select top (20000) * from idmv_bw_current_values
And this a...
Hi Norman,
thank you very much, I will try adjusting the JAVA VM parameter.
What I also tested today how uSelect reacts when you run a very simple query which pulls a large amount of data. I used:
select top (20000) * from idmv_bw_current_value...
Hi Norman,
thank you for your answer.
I have the impression that SQL Studio fetches all of the data, as after 5 seconds I'm able to export the results to a CSV file and all of the approx. 17.000 rows are exported which is ~5 MB of data. So I can...