Error saving user profile

Today I encountered strange behavior:
When I tried to edit the Authentication Query on the database (MS SQL EXPRESS) user source and hit the save button, this happened:

I’m accessing the gateway (Ignition 7.9.14) over the company VPN with Chrome on Windows 10 pro.
Yesterday everything was ok…
The same happens with the new Microsoft Edge browser and with Firefox also.
I tried to clear the browser’s cache and cookies but nothing helps.

I have no idea, what can cause this…?
Can anyone share some light?

Here are gateway logs… Ignition-propc-9010-cno2_Ignition_logs_20200701-1832.zip (773.9 KB)

Hm… anyone… IA people?

Are you able to paste the authentication query here?

Yes, here it is:

============================================================
Authentication Query:

declare @user varchar(50)
declare @rfid varchar(100)
declare @geslo varchar(100)
set @user = ? 
set @geslo = ? 
set @rfid = CASE WHEN @geslo <> '' THEN @geslo ELSE 'unknown' END 

SELECT OPR_IME FROM 
(SELECT * 
FROM XMESQOPR
UNION ALL
SELECT '9999' AS MQOPR_ID, 
'0' AS MQOPR_STA, 
getdate() AS MQOPR_MSD, 
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) AS p
WHERE OPR_SIF = @user AND @rfid IN (OPR_GES,OPR_RFID1,OPR_RFID2,OPR_RFID3) AND OPR_AKT = '5'
============================================================
List Roles Query:

SELECT DISTINCT 
	CASE 
		WHEN OPR_LVL = 0 THEN 'Operater' 
		WHEN OPR_LVL = 1 THEN 'Tehnolog' 
		WHEN OPR_LVL = 2 THEN 'Administrator' 
		WHEN OPR_LVL = 99 THEN 'User' 
		ELSE 'unknown' 
		END AS "role" 
	FROM 
	(SELECT * FROM XMESQOPR 
	UNION ALL
	SELECT '9999' AS MQOPR_ID, 
	'0' AS MQOPR_STA, 
	getdate() AS MQOPR_MSD, 
	'99999' AS OPR_SIF,
	'User12' AS OPR_IME,
	'5' AS OPR_AKT,
	'user12' AS OPR_GES,
	'99' AS OPR_LVL,
	'user12' AS OPR_RFID1,
	'user12' AS OPR_RFID2,
	'user12' AS OPR_RFID3) as p
	WHERE OPR_AKT = '5'
============================================================
Users Roles Query:

declare @name varchar(50)
set @name = ?

SELECT DISTINCT 
	CASE 
		WHEN OPR_LVL = 0 THEN 'Operater' 
		WHEN OPR_LVL = 1 THEN 'Tehnolog' 
		WHEN OPR_LVL = 2 THEN 'Administrator' 
		WHEN OPR_LVL = 99 THEN 'User' 
		ELSE 'unknown' 
		END AS "role" 
	FROM 
	(SELECT * FROM XMESQOPR 
	UNION ALL
	SELECT '9999' AS MQOPR_ID, 
	'0' AS MQOPR_STA, 
	getdate() AS MQOPR_MSD, 
	'99999' AS OPR_SIF,
	'User12' AS OPR_IME,
	'5' AS OPR_AKT,
	'user12' AS OPR_GES,
	'99' AS OPR_LVL,
	'user12' AS OPR_RFID1,
	'user12' AS OPR_RFID2,
	'user12' AS OPR_RFID3) as p
	WHERE OPR_AKT='5' AND OPR_SIF = @name
========================================================
List Users Query:

SELECT OPR_IME FROM 
(SELECT *  
FROM XMESQOPR 
UNION ALL
SELECT '9999' AS MQOPR_ID, 
'0' AS MQOPR_STA, 
getdate() AS MQOPR_MSD, 
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) AS p
WHERE OPR_AKT = '5' 

The query works. I can log in on the client…
And this is my users table:

This happening only on this ‘page’… everywhere else (Gateway settings, Connections, Devices,…) I can save the config…

EDIT: I just tried to VNC directly to the Ignition gateway PC and tried there with Microsoft Edge browser to save the user source and it works no problem…??? :confused:

So… nothing, ha…
I really don’t know what else to try… :confused:

Bump…???