RSA G&L is very slow..even swaping Tabs is taking time.Can anybody suggest possible reason for this.

[RajeshKumar1]

RSA G&L is very slow in dev environment.I checked in logs but could not get any clue.

Can any body suggest possible reason for this and what should I check.

Thanks in advance.

[JamiePryer]

Hey,

Various things that this could be.

• Have you checked the logs?
• are you running out of disc space?
• have you deployed the solution to the correct minimum specs? 
• Check out some of the content here: https://community.rsa.com/community/products/governance-and-lifecycle/client-partner-community/blog/... 

[JamiePryer]

also, is this just you or everyone? 

[D.S.9]

You mentioned it's a dev environment. Most likely it's filled with garbage data and is just a basic playground to try stuff so there may be thousands of errors that were generated intentionally and unintentionally. My suggestion is that you export all the metadata(roles, business descriptions, workflows, all), reset your data and import the metadata back. This will clean out all the data from your dev environment but will retain your old configuration. 

Now if you cannot do that and want to retain your old data, I suggest you open a support case with RSA. Performance issue requires thorough analysis of system data, config. 

[RajeshKumar1]

Thanks Jamie and Dipendra for the reply.

Jamie Pryer‌ : I checked logs and can not identify issue. I have pasted part of log for your reference. Please let me know if you want more info for analyzing the issue.

• are you running out of disc space?

Checked disc space also and see enough space available in the server.

• have you deployed the solution to the correct minimum specs? 

It was working fine only few days back we noticed it is very slow.

also, is this just you or everyone?

It is slow for everybody.

02/02/2021 22:45:20.932 WARN (ThreadPool-1) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 6533, SQLState: 65000
02/02/2021 22:45:20.961 ERROR (ThreadPool-1) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-06533: Subscript beyond count
ORA-06512: at "SYS.DBMS_STATS", line 34634
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 66
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 89
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 215
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 273
ORA-06512: at "AVUSER.DATABASE_STATISTICS", line 100
ORA-06512: at line 1

02/01/2021 00:00:33.748 ERROR (SystemReport) [SystemErr] java.sql.SQLException: ORA-20200: Database/Instance 1689510366/1 does not exist in STATS$DATABASE_INSTANCE
ORA-06512: at line 28

02/01/2021 00:00:33.770 ERROR (SystemReport) [SystemErr] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
02/01/2021 00:00:33.770 ERROR (SystemReport) [SystemErr] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
02/01/2021 00:00:33.770 ERROR (SystemReport) [SystemErr] at oracle.jdbc

^[[0m^[[0m06:48:08,321 INFO [stdout] (Query_jobq#Normal#WPDS) 2021-02-02 06:48:08,321 [Query_jobq#Normal#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=5
^[[0m^[[0m06:53:10,185 INFO [stdout] (Query_jobq#Urgent#WPDS) 2021-02-02 06:53:10,185 [Query_jobq#Urgent#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=0
^[[0m^[[31m09:00:38,429 ERROR [stderr] (ThreadPool-4)
^[[0m^[[31m09:00:38,430 ERROR [stderr] (ThreadPool-4)
^[[0m^[[31m09:00:38,430 ERROR [stderr] (ThreadPool-4)

stdout.log

^[[0m^[[0m17:21:26,468 INFO [stdout] (Query_actionq#Role#WPDS) 2021-02-02 17:21:26,467 [Query_actionq#Role#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=5
^[[0m^[[0m17:26:27,483 INFO [stdout] (Query_alertq#Normal#WPDS) 2021-02-02 17:26:27,483 [Query_alertq#Normal#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=0
^[[0m^[[31m21:00:00,452 ERROR [stderr] (ThreadPool-3)

WorkPoint.log

2021-02-02 06:48:08,321 [Query_jobq#Normal#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=5
2021-02-02 06:53:10,185 [Query_jobq#Urgent#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=0
2021-02-02 17:21:26,467 [Query_actionq#Role#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=5
2021-02-02 17:26:27,483 [Query_alertq#Normal#WPDS] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis.WPDS, value=0

Dipendra Shrestha‌ : We want to retail old data. I will discuss with my team for opening RSA case.

Please have a look at above pasted log info and suggest.

Thanks

Rajesh Kumar

[JamiePryer]

+1 - this is a great idea

[JamiePryer]

• have you deployed the solution to the correct minimum specs? 

It was working fine only few days back we noticed it is very slow.

What are the following values set to?

- SGA

- PGA

- CPU

- HEAP

• how do these differ to PROD?
• How long have you had this DEV enviroment running?
• What version is this enviroment?
• Did you run the cleanup scripts as per the links in the webinar to purge old data?

[wjmay]

I'm curious what configuration you are running? We've went from 7.0.2x on Websphere to 7.2x on Wildfly several months ago and our GUI performance has been severely degraded since. Many pages that used to load in 1-2 seconds now can take up to 15-20.

[IanStaines · Accepted solution]

It is not practicable to do a performance analysis in this forum.  I recommend you open a support case. 

[JamiePryer]

Hey Bill! This is NOT expecte, please can you raise a case to help us resolve this for you