report port page is not loading

[nbonagi]

Hi Team,

I have deployed all the application related to report portal in kubernetes cluster. All the srvices are up and running. but when I am accesing the ui page ,the page still loading now page is displying. When i check the logs from devtools it is shwoing like below

undefined or null to object
at Function.keys ()
at main.app.9c19d7.js:6:90252
at c (main.app.9c19d7.js:12:41694)
at Generator._invoke (main.app.9c19d7.js:12:41482)
at S.forEach.e. [as next] (main.app.9c19d7.js:12:42117)
at N (main.app.9c19d7.js:26:844227)
at y (main.app.9c19d7.js:26:845066)
at main.app.9c19d7.js:26:845721
at i (main.app.9c19d7.js:26:906246)
at c (main.app.9c19d7.js:26:906396)
(anonymous) @ main.app.9c19d7.j

please help.

[alec-afs]

I was having the same problem but found this issue:
#288

Which was closed by this issue:
#297

TL:DR - I had to adjust my ingress controller so different path requests went to the correct container/pod:

    - host: reportportal.domain
      http:
        paths:
          - path: /
            pathType: Prefix
            backend:
              service:
                name: reportportal-index
                port:
                  number: 8080
          - path: /ui
            pathType: Prefix
            backend:
              service:
                name: reportportal-ui
                port:
                  number: 8080
          - path: /uat
            pathType: Prefix
            backend:
              service:
                name: reportportal-uat
                port:
                  number: 9999
          - path: /api
            pathType: Prefix
            backend:
              service:
                name: reportportal-api
                port:
                  number: 8585
          - path: /jobs
            pathType: Prefix
            backend:
              service:
                name: reportportal-jobs
                port:
                  number: 8686

This resolved my issue.
Hope this helps!

[nbonagi]

Hi Team,

As you mentioned above i followed the below setps,

apiVersion: traefik.containo.us/v1alpha1
kind: IngressRoute
metadata:
name: reportportal-gateway-ingress-traefik
namespace: report-portal
spec:
entryPoints:

• web
  routes:
• match: Host(rls-test.app.corpintra.net) && PathPrefix(/)
  kind: Rule
  middlewares:
• name: index
  services:
• name: reportportal-index
  kind: Service
  port: 8080
• match: Host(rls-test.app.corpintra.net) && PathPrefix(/ui)
  kind: Rule
  middlewares:
• name: ui
  services:
• name: reportportal-ui
  kind: Service
  port: 8080
• match: Host(rls-test.app.corpintra.net) && PathPrefix(/uat)
  kind: Rule
  middlewares:
• name: uat
  services:
• name: reportportal-uat
  kind: Service
  port: 9999
• match: Host(rls-test.app.corpintra.net) && PathPrefix(/api)
  kind: Rule
  middlewares:
• name: api
  services:
• name: reportportal-api
  kind: Service
  port: 8585
• match: Host(rls-test.app.corpintra.net) && PathPrefix(/jobs)
  kind: Rule
  middlewares:
• name: jobs
  services:
• name: reportportal-jobs
  kind: Service
  port: 8686

apiVersion: traefik.containo.us/v1alpha1
kind: Middleware
metadata:
name: ui
namespace: report-portal
spec:
stripPrefix:
prefixes:

• /ui
  apiVersion: traefik.containo.us/v1alpha1
  kind: Middleware
  metadata:
  name: uat
  namespace: report-portal
  spec:
  stripPrefix:
  prefixes:
• /uat
  apiVersion: traefik.containo.us/v1alpha1
  kind: Middleware
  metadata:
  name: api
  namespace: report-portal
  spec:
  stripPrefix:
  prefixes:
• /api
  apiVersion: traefik.containo.us/v1alpha1
  kind: Middleware
  metadata:
  name: jobs
  namespace: report-portal
  spec:
  stripPrefix:
  prefixes:
• /jobs

after created the above resources i can able to see the login page but when i try to login with default credenatls i am getting the below error.

when i verify the pod logs i can find the below

API LOGS

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.postgresql.util.PSQLException: ERROR: column sendercase2_.attributes_operator does not exist
Position: 679
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
... 158 common frames omitted

2023-06-27 06:38:38.533 WARN 1 --- [io-8585-exec-10] c.e.t.r.c.e.rest.RestExceptionHandler : Resolved [org.hibernate.exception.SQLGrammarException: could not extract ResultSet.

DATABASE LOGS

2023-06-26 11:11:52.732 GMT [2629] LOG: incomplete startup packet
2023-06-27 06:38:38.507 GMT [21968] ERROR: column sendercase2_.attributes_operator does not exist at character 679
2023-06-27 06:38:38.507 GMT [21968] STATEMENT: select project0_.id as id1_15_0_, project0_.allocated_storage as allocate2_15_0_, project0_.creation_date as creation3_15_0_, project0_.metadata as metadata4_15_0_, project0_.name as name5_15_0_, project0_.organization as organiza6_15_0_, project0_.project_type as project_7_15_0_, patterntem1_.project_id as project_4_35_1_, patterntem1_.id as id1_35_1_, patterntem1_.id as id1_35_2_, patterntem1_.enabled as enabled2_35_2_, patterntem1_.name as name3_35_2_, patterntem1_.project_id as project_4_35_2_, patterntem1_.type as type5_35_2_, patterntem1_.value as value6_35_2_, sendercase2_.project_id as project_5_40_3_, sendercase2_.id as id1_40_3_, sendercase2_.id as id1_40_4_, sendercase2_.attributes_operator as attribut2_40_4_, sendercase2_.enabled as enabled3_40_4_, sendercase2_.project_id as project_5_40_4_, sendercase2_.send_case as send_cas4_40_4_, launchattr3_.sender_case_id as sender_c4_31_5_, launchattr3_.id as id1_31_5_, launchattr3_.id as id1_31_6_, launchattr3_.key as key2_31_6_, launchattr3_.sender_case_id as sender_c4_31_6_, launchattr3_.value as value3_31_6_, launchname4_.sender_case_id as sender_c1_32_7_, launchname4_.launch_name as launch_n2_32_7_, recipients5_.sender_case_id as sender_c1_38_8_, recipients5_.recipient as recipien2_38_8_ from public.project project0_ left outer join pattern_template patterntem1_ on project0_.id=patterntem1_.project_id left outer join sender_case sendercase2_ on project0_.id=sendercase2_.project_id left outer join launch_attribute_rules launchattr3_ on sendercase2_.id=launchattr3_.sender_case_id left outer join launch_names launchname4_ on sendercase2_.id=launchname4_.sender_case_id left outer join recipients recipients5_ on sendercase2_.id=recipients5_.sender_case_id where project0_.id=$1 order by patterntem1_.id asc, launchattr3_.id

UAT LOGS

2023-06-27 06:46:15.674 DEBUG 1 --- [nio-9999-exec-4] o.s.security.web.FilterChainProxy : Secured POST /sso/oauth/token
2023-06-27 06:46:15.675 DEBUG 1 --- [nio-9999-exec-4] .s.o.p.e.FrameworkEndpointHandlerMapping : Mapped to org.springframework.security.oauth2.provider.endpoint.TokenEndpoint#postAccessToken(Principal, Map)
2023-06-27 06:46:15.676 DEBUG 1 --- [nio-9999-exec-4] .o.p.p.ResourceOwnerPasswordTokenGranter : Getting access token for clientId
2023-06-27 06:46:15.957 DEBUG 1 --- [nio-9999-exec-4] s.s.w.c.SecurityContextPersistenceFilter : Cleared SecurityContextHolder to complete request
2023-06-27 06:46:38.609 DEBUG 1 --- [nio-9999-exec-8] o.s.security.web.FilterChainProxy : Securing GET /health
2023-06-27 06:46:38.609 DEBUG 1 --- [nio-9999-exec-8] s.s.w.c.SecurityContextPersistenceFilter : Set SecurityContextHolder to empty SecurityContext
2023-06-27 06:46:38.609 DEBUG 1 --- [nio-9999-exec-8] o.s.s.w.a.AnonymousAuthenticationFilter : Set SecurityContextHolder to anonymous SecurityContext
2023-06-27 06:46:38.609 DEBUG 1 --- [nio-9999-exec-6] o.s.security.web.FilterChainProxy : Securing GET /health
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-6] s.s.w.c.SecurityContextPersistenceFilter : Set SecurityContextHolder to empty SecurityContext
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-6] o.s.s.w.a.AnonymousAuthenticationFilter : Set SecurityContextHolder to anonymous SecurityContext
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-8] o.s.s.w.a.i.FilterSecurityInterceptor : Authorized filter invocation [GET /health] with attributes [permitAll]
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-8] o.s.security.web.FilterChainProxy : Secured GET /health
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-6] o.s.s.w.a.i.FilterSecurityInterceptor : Authorized filter invocation [GET /health] with attributes [permitAll]
2023-06-27 06:46:38.610 DEBUG 1 --- [nio-9999-exec-6] o.s.security.web.FilterChainProxy : Secured GET /health
2023-06-27 06:46:38.614 DEBUG 1 --- [nio-9999-exec-8] s.s.w.c.SecurityContextPersistenceFilter : Cleared SecurityContextHolder to complete request
2023-06-27 06:46:38.614 DEBUG 1 --- [nio-9999-exec-6] s.s.w.c.SecurityContextPersistenceFilter : Cleared SecurityContextHolder to complete reques

Please do the needful

[sim-dav]

Hi @nbonagi , we're having a similar issue in our logs,...

Caused by: org.postgresql.util.PSQLException: ERROR: column sendercase2_.attributes_operator does not exist
  Position: 679

Did you make any progress? We're deploying with a helm chart, and think we might need to run the migrations job prior to the upgrade, but can't seem to trigger it

[nbonagi]

hI @sim-dav ,

There is no progress on this issue but I created that coloumn(sendercase2_.attributes_operator) manullay then the login was successfull. I had run the migration job prior to all the pods. The job status was succesfull but still iam getting the above mentioned error.

Not only one column missing there is another table owned_entity table also was missing.

Finally I decided to go with RP version 5.7.4. I deployed the version 5.7.4 then the login is succesfull I could able to create dashboard also.