Hi
Customer noticed time to time that wadaco terminal freeze for none specific step for about 20-60s. I find out that one of the reason is checking wadaco license for every new or updated wadaco session.
So probably there is some issue with web services.
For test I prepared below procedure as o copy of license check using by Wadaco.
Then I noticed that when I open new test window in PLSQL Developer first every launch of this anonymous block on IFSAPP account takes about 20-60 seconds. It waits on calls:
Plsqlap_Server_API.Invoke_Record_Impersonate('BrowseLicenseFile', 'GetCustomLicense', record_);
Customer is using AD authentication so maybe here is the problem. As I know Invoke_Record_Impersonate procedure is using IFSPLSQLAP user for authentication. I have got confirmation that this user is not used in AD confirmation.
I heard beside this application firstly tring find this user on LDAP server and this could take much time.
How could I figure out the source of this problem? What should I check first? PL/SQL Access provider is ok.
DECLARE
license_name_ VARCHAR2(200);
number_of_users_ NUMBER;
usage_view_ VARCHAR2(200) := 'ACTIVE_DATA_CAPTURE_SESSIONS';
record_ Plsqlap_Record_API.type_record_;
BEGIN
dbms_output.put_line('1. '||to_char(sysdate, 'hh24:mi:ss'));
record_ := Plsqlap_Record_API.New_record('CUSTOM_LICENSE');
--
dbms_output.put_line('2. '||to_char(sysdate, 'hh24:mi:ss'));
Plsqlap_Record_API.Set_Value(record_, 'VIEW', usage_view_, Plsqlap_Record_API.dt_Text_Key, FALSE);
--
dbms_output.put_line('3. '||to_char(sysdate, 'hh24:mi:ss')||' - '||record_.Name_||' - '||record_.buffer_);
Plsqlap_Server_API.Invoke_Record_Impersonate('BrowseLicenseFile', 'GetCustomLicense', record_);
--
dbms_output.put_line('4. '||to_char(sysdate, 'hh24:mi:ss'));
license_name_ := Plsqlap_Record_API.Get_Value(record_, 'NAME');
dbms_output.put_line('5. '||to_char(sysdate, 'hh24:mi:ss')||' - '||license_name_);
--
number_of_users_ := Plsqlap_Record_API.Get_Value(record_, 'NUMBER_OF_USERS');
dbms_output.put_line('6. '||to_char(sysdate, 'hh24:mi:ss')||' - '||number_of_users_);
END;