Troubleshooting SQL Errors

[JaimePR]

Hello community,
Is there a way to check what the real error is in KEPServerEX for SQL diagnostics?

This doesn't help at all:

Date Time Level Source Event
12/08/2024 16:39:18 Error Data Logger Plug-in Unknown error while executing query in table 'mytable' for log group 'datalog-azure'.

I am guessing it's something about security/privileges since I am trying to log data in an Azure database.

I am able to see tables, columns when I am mapping the data but unable to write values to table.

Using app version 6.16 (V6.16.203.0)

Any help is appreciated.

Cheers,

[VladimirN]

Article - "Datalogger with Store and Forward enabled fails with "Unknown error while executing query in table" in PTC Kepware Products": https://www.ptc.com/en/support/article/CS321247 

[JaimePR]

Hi VladimirN,
I don't have store and forward enabled. I tried to first alternative though ("Create a new table once and append to this table").

Since the user has full privileges over the database  (role membership "db_owner"), KEPServer was able to generate the new table, but it fails populating data in it.

db_owner role membership on a local connection works fine..not sure how I can track the error in "raw-mode". Is there a log file I can track all this?
Tried searching information in "Event Viewer" on windows but there is nothing for PTC/KEPServer.

Cheers,

[JaimePR · Accepted solution]

Ended up using a Dynamic DNS to my computer. KEPServer doesn't seem to work for Azure Database environment.

Cheers,