SG-1519 Work Orders | Permits - Hyperlink on the Permits tab on a cloned Work Orders screen gives error ORA-01422: exact fetch returns more than requested number of rows - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

SG-1519 Work Orders | Permits - Hyperlink on the Permits tab on a cloned Work Orders screen gives error ORA-01422: exact fetch returns more than requested number of rows

 Description 

When going to Work | Permit To Work | Permit to Work Request | Permits, in this customer environment Hyperlink in field PTW gives error : The SQL Statement is invalid: ORA-01422: exact fetch returns more than requested number of rows ORA-06512 : at "EAM117_00105.O7GETDATASPYNAME", line 8

Possible Data Corruption

Issue has been reproduced in environment of the client.

Steps to reproduce

# Log in environment provided

# Navigate to Work | Permit To Work | Permit to Work Request | Permits

# Open screen designer

# On Field PTW (see attachment), right click and click on “Hyperlink“

# Error message display (see attachment)

Expected result

User will be redirected to Hyperlink screen

Actual result

Error message is displayed