'Error ORA-01422: exact fetch returns more than requested number of rows' when running any of sql script (4239856)

The error is caused by one of the 2 queries below referenced in the scripts, where the select statement expects just one value and it returns more than one value.

The following SQL query (SELECT username, schemaname, machine, osuser, module….) returns always 1 row (value USERENV ('sessionid') is always unique).

There will be no record in STAT_DBSCRIPT_TBL about this script, because the insert to the query which caused the error stops executing the script. At the beginning of the script, there is the same query, but it finished successfully, so something may have happened during the execution of the script.

The error occurred in the step doing the update of the STAT_DBSCRIPT_TBL table, and appears that one of the two selects returned more than one row, when expecting only a single row to be returned.

Please run these two selects and see which one is the issue:

   SELECT stat_db_version
--     INTO l_version
     FROM stat.system_tbl;

   SELECT username, schemaname, machine, osuser, module
--     INTO l_username, l_schemaname, l_machine, l_osuser, l_module
     FROM v$session
   WHERE audsid = USERENV ('sessionid');

If both queries return only one row, then please re-run the script and it should run successfully.

If more than one row is returned, please contact support to investigate further.