The procedure DNN_UpdateServer has a exception if the server is not in DNN_WebServers. Found in DNN 4.9.2.
To fix this issue catch the exception:
CREATE OR REPLACE PROCEDURE DNNxx.DNN_UpdateServer
(
p_ServerName IN VARCHAR2,
p_CreatedDate IN DATE,
p_LastActivityDate IN DATE
)
is
l_ServerID NUMBER(11);
l_Count NUMBER(11);
begin
select COUNT(*) into l_Count from DNN_WebServers;
If l_Count = 0 Then
l_ServerID := 0;
Else
BEGIN
select NVL(ServerID, 0) into l_ServerID from DNN_WebServers where UPPER(ServerName) = UPPER(p_ServerName);
EXCEPTION WHEN NO_DATA_FOUND THEN l_ServerID := 0;
END;
End If;
IF l_ServerID = 0 Then
INSERT INTO DNN_WebServers
(
ServerName,
CreatedDate,
LastActivityDate
)
VALUES
(
p_ServerName,
p_CreatedDate,
p_LastActivityDate
);
Else
Update DNN_WebServers
SET
LastActivityDate = p_LastActivityDate
Where ServerID = l_ServerID;
End If;
end;