Highlighted
Absent Member.. WarrenPowers Absent Member..
Absent Member..

Re: Login is very slow

Jump to solution

It looks like you can only attach images to the site. Here are some excerpts from the log:

Here is the breach:

6357052(87425103) 12/05/2016 15:13:15  RTE D (0x372AE2E0)      DBACCESS - Fetch Abs(  0) against file Todo
6357052(87425103) 12/05/2016 15:13:15  RTE D (0x372AE2E0)      DBACCESS - Fetch Abs(  0) against file Todo in 0.000000 seconds [rc=0 ] (record.id="C98667")
6357052(73728031) 12/05/2016 15:13:18  RTE W sqllimit exceeded, user=XXXXXXX          limit=5.000 actual=21.601 SQL statement follows
6357052(73728031) 12/05/2016 15:13:18  RTE D 1466: sqociSelectSome - EXECUTE:SELECT m1."NAME" FROM OPERATORM1 m1 WHERE ((LOWER(m1."NAME")=:Y)) ORDER BY m1."NAME" ASC
6357052(73728031) 12/05/2016 15:13:18  RTE D _ociDescribeSqlda:   1: NAME                             type=1  -  p/s=  0/   0 size=  60/  60 BYTE  871 1 VARCHAR2(60) NULLABLE
6357052(73728031) 12/05/2016 15:13:18  RTE D sql diff 0.000  total 23.717  call#:1467 --> _describe:SELECT m1."NAME" FROM OPERATORM1 m1 WHERE ((LOWER(m1."NAME")=:Y)) ORDER BY m1."NAME" ASC
6357052(73728031) 12/05/2016 15:13:18  RTE D sqociInitSqlda: NAME, type: 9-VARCHAR (was 1-VARCHAR2), len: 62
6357052(73728031) 12/05/2016 15:13:18  RTE D sql diff 0.000  total 23.717  call#:1468 --> sqociSelectSome - SINGLE FETCH:SELECT m1."NAME" FROM OPERATORM1 m1 WHERE ((LOWER(m1."NAME")=:Y)) ORDER BY m1."NAME" ASC
6357052(73728031) 12/05/2016 15:13:18  RTE D sql diff 0.000  total 23.717  call#:1469 --> sqociSelectSome - SINGLE FETCH:EOF

Earlier in the thread we had a query to operatorm1 with the same clause, but without lower:

6357052(73728031) 12/05/2016 15:12:54  RTE D (0x3557AF40)      DBACCESS - Cache Term   against file info
6357052(73728031) 12/05/2016 15:12:54  RTE D (0x35A3B7C0)      DBACCESS - Cache Init   against file operator
6357052(73728031) 12/05/2016 15:12:54  RTE D (0x354C7470)      DBACCESS - Cache Find   against file scaccess found 1 NULL record (filename="operator" and security.id="")
6357052(73728031) 12/05/2016 15:12:54  RTE D (0x354C7470)      DBACCESS - Cache Find   against file scaccess found 1 NULL record (filename="operator" and security.id=NULL)
6357052(73728031) 12/05/2016 15:12:54  RTE D (0x35A3B7C0)      DBACCESS - Find         against file operator
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.000  total 2.039  call#:1258 --> _prepare:SELECT * FROM OPERATORM1 WHERE "NAME"=:Y
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.000  total 2.039  call#:1259 --> _ociBindQuery:SELECT * FROM OPERATORM1 WHERE "NAME"=:Y
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.003  total 2.042  call#:1260 --> sqociSelect - EXECUTE:SELECT * FROM OPERATORM1 WHERE "NAME"=:Y
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.000  total 2.042  call#:1261 --> _ociReadDataFromLob - Get LOB length:NAMES
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.001  total 2.043  call#:1262 --> _ociReadDataFromLob - Read LOB:NAMES
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.000  total 2.043  call#:1263 --> _ociReadDataFromLob - Get LOB length:VALUES
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.001  total 2.044  call#:1264 --> _ociReadDataFromLob - Read LOB:VALUES
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.000  total 2.044  call#:1265 --> _ociReadDataFromLob - Get LOB length:GROUPS
6357052(73728031) 12/05/2016 15:12:54  RTE D sql diff 0.001  total 2.045  call#:1266 --> _ociReadDataFromLob - Read LOB:GROUPS

 

Acclaimed Contributor.. brav0 Acclaimed Contributor..
Acclaimed Contributor..

Re: Login is very slow

Jump to solution
One more question -- Did you also looked at your ToDo inbox queries ?. These are also run when a user logs in. Also, I am unable to interpret much from the abstract of the log which you have provided.
I am Listening..
TomPowe Acclaimed Contributor.
Acclaimed Contributor.

Re: Login is very slow

Jump to solution

Can you do another trace with RTM:3 and debugdbquery:999 and provide that log?

Absent Member.. WarrenPowers Absent Member..
Absent Member..

Re: Login is very slow

Jump to solution

brav0, I did check the Inbox queries. The users land at Todo with the inbox of "My To Do List" or "My Group's To Do List". Here are their queries:

My To Do List: assignee=$lo.user.name and status~="Canceled" and status~="Closed"

My Group's To Do List: (itemType="probsummary" or itemType="incidents" or itemType="rootcause" or itemType="rootcausetask" or itemType="imTask" or itemType="cm3r" or itemType="cm3t"or itemType="timeperiodDefinition" or itemType="SurveyDefinition" or itemType="request" or itemType="requestTask") and group isin $lo.pm.assignments

I've also reattched yesterdays log.

TomPowe, I've attached a log with RTM:3 and debugdbquery:999.

Please rename the attached file to OperatorLogs.zip. Within you'll file log14080noRTM.log (yesterdays log) and log14080withRTM.log (new log today).

TomPowe Acclaimed Contributor.
Acclaimed Contributor.

Re: Login is very slow

Jump to solution

Right before it does that query, I see this in the logs.  Looks like you have Collaboration integration.  Can you review those ScriptLibrary records to see if you can locate the query? :

13238286(59244781) 12/06/2016 08:21:32  RTE D (0x3563B4F0)      DBACCESS - Cache Find   against file ScriptLibrary found 1 record (name="SMCRemoteService")
13238286(59244781) 12/06/2016 08:21:32  RTE D (0x3563B4F0)      DBACCESS - Cache Find   against file ScriptLibrary found 1 record (name="c")
Absent Member.. WarrenPowers Absent Member..
Absent Member..

Re: Login is very slow

Jump to solution

Good find! Surprisingly, we do not use Collaberation.

I could not find anything in SL c, however in SL SMCRemoteService there are some references.

First is here (around line 319:

  /**
   * To get the contact's info by an operator, additionally, add the label to the contact info.
   */
  function getContactByOperator(operatorName, label, needPortrait){
    var operator = $('operator').select('tolower(name) = \"' + operatorName.toLowerCase() + '\"').uniqueResult();
    if(operator){
      var contact = getContact(operator.contact_name); // legacy SMC stored this field in xml
      contact.label = label;
      if(needPortrait){
        contact.portrait = getPortrait(operatorName);
      }
      return contact;
    }
    return null;
  }

Second is here (around line 489):

  function getPortrait(userName){
    var operator = $('operator').select('tolower(name) = \"' + userName.toLowerCase() + '\"').uniqueResult();
    if(operator){
      var contact = $('contacts').select('contact.name = \"' + operator.contact_name + '\"').uniqueResult();
      if(!contact){
        return null;
      }
      var attachments = contact.getAttachments();
      for(var index in attachments){
        var attachment = attachments[index];
        if(attachment.name == contact.contact_name && attachment.attachmentType == 'img'){
          return {base64Image: compressImage(attachment.value, 64), mimeType: attachment.type};
        }
      }
    }
    return null;
  }

I can certainly change these libraries to not use the lower function, however is there a better solution? Thoughts?

I beleive these functions populate the data and icon in the upper right for the logged in user.

TomPowe Acclaimed Contributor.
Acclaimed Contributor.

Re: Login is very slow

Jump to solution

First, let's verify that you don't have Collaboration enabled.  Try this out:

 

1.  Login as an Admin.

2.  Click System Administration > Ongoing Maintenance > Collaboration > Configuration to open the Collaboration Settings form.

3.  See if "Enable Collaboration" is checked.  If so, uncheck it.

Absent Member.. WarrenPowers Absent Member..
Absent Member..

Re: Login is very slow

Jump to solution

It is not checked.

Collaboration.png

 

TomPowe Acclaimed Contributor.
Acclaimed Contributor.

Re: Login is very slow

Jump to solution

I'm a little lost at this point. I don't have this in my environment, so I'm hoping someone can chime in.

Can you pull up the "smcconfig" table in Database Manager?  See how many records are in that table.  Go through them and see if you can see anything about Collaboration. 

You might want to open a ticket with HP if you haven't already.

Absent Member.. WarrenPowers Absent Member..
Absent Member..

Re: Login is very slow

Jump to solution

There are 10 records in the table. They don't seem relevant other than all but device are enabled for collaboration.

smcconfig.png

I do have an OOTB 9.41 environment. It also does not have this Script Library, however P3 was not applied to the OOTB environment.

As a test, i did change the statements in the SL to remove the lower calls and performance drastically improved. I'll raise an HP case to see what they say.

Acclaimed Contributor.. brav0 Acclaimed Contributor..
Acclaimed Contributor..

Re: Login is very slow

Jump to solution
Guys, were you able to resolve this ? Did you actually tweak in the SMCReporting SL ? Let us know what is done to resolve the slowness. thx
I am Listening..
Acclaimed Contributor.. brav0 Acclaimed Contributor..
Acclaimed Contributor..

Re: Login is very slow

Jump to solution
*SMCReportService -- SL
I am Listening..
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.