PL/pgSQL Function user_roles_disabled_utrg_tf Error Disabling Secondary Institution Role




 
PL/pgSQL Function user_roles_disabled_utrg_tf Error Disabling Secondary Institution Role

Date Published: Apr 11,2025 Category: Product:User_and_Role_Management_SaaS   Article No.: 000063009

Producto: Learn SaaS

Versión: SaaS

Descripción: Unable to disable Secondary Institution Roles during a refresh. See the following error: Caused by: org.postgresql.util.PSQLException: ERROR: query has no destination for result data Hint: If you want to discard the results of a SELECT, use PERFORM instead. Where: PL/pgSQL function user_roles_disabled_utrg_tf() line 28 at SQL statement

Pasos para repetir:

  1. Create a User
  2. Generate a Secondary Role feed file and upload
  3. Rerun feed file with the Second Role not in the feed file
Expected Behavior:
Role is marked as disabled

Observed Behavior:
Unexpected error removing sis object error
Caused by: org.postgresql.util.PSQLException: ERROR: query has no destination for result data
  Hint: If you want to discard the results of a SELECT, use PERFORM instead.
  Where: PL/pgSQL function user_roles_disabled_utrg_tf() line 28 at SQL statement

 




Versión de destino: Future Reference
Parche disponible: No