Skip to main content
J
JaimePR10-Marble
10-Marble
August 12, 2024
Solved

Troubleshooting SQL Errors

  • August 12, 2024
  • 2 replies
  • 1507 views

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,

 

Best answer by JaimePR

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

 

Cheers,

 

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
August 13, 2024

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 

J
JaimePR10-MarbleAuthor
10-Marble
August 13, 2024

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,

J
JaimePR10-MarbleAuthorAnswer
10-Marble
August 15, 2024

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

 

Cheers,

 

Terms & ConditionsCookie settingsAccessibility statement