Skip to main content
J
JR_99546114-Participant
4-Participant
June 22, 2023
Solved

Logging Data to Non-dbo Schema Table Using Data Logger

  • June 22, 2023
  • 2 replies
  • 2245 views

Hello,

 

I am currently using KepwareEx in conjunction with the DataLogger plugin for recording data from PLCs and CheckWeighers. The process works seamlessly when I log the data to dbo.FrequentReading. However, I'm experiencing issues when trying to log data to Kepware.FrequentReading (Kepware schema instead of dbo schema).

 

Despite setting the default database and schema to Kepware for the user connection, the problem persists. Interestingly, Kepware does recognize the table and allows me to select it, but fails when attempting to write to it.

 

Furthermore, when I try to set the table definition to Kepware.FrequentReading, I receive an error message stating that the table doesn't exist.

 

We make heavy use of schemas within our databases, so it would suck to have to use dbo for the datalogger tables. 

 

I'd appreciate any advice or solutions to this problem.

 

JR_9954611_0-1687474104702.png

 

Best answer by cmorehead

@JR_9954611 

 

The Datalogger Plugin will only log to tables that are in the user's default schema. Please feel free to log an enhancement request to potentially have your described functionality added to the product. Here is a link to the Kepware knowledge base article that covers how to submit the enhancement request:

 

Article - CS295047 - How to open an Enhancement Request for PTC Kepware Products

 

Thanks,

*Chris

2 replies

J
JR_99546114-ParticipantAuthor
4-Participant
June 23, 2023

Where my PTC Peeps at 

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
June 23, 2023

Hi @JR_9954611 

 

You have posted it on the wrong board. 

 

Please post your queries related to Kepware here - Kepware - PTC Community

 

/VR

C
cmorehead13-AquamarineAnswer
13-Aquamarine
June 26, 2023

@JR_9954611 

 

The Datalogger Plugin will only log to tables that are in the user's default schema. Please feel free to log an enhancement request to potentially have your described functionality added to the product. Here is a link to the Kepware knowledge base article that covers how to submit the enhancement request:

 

Article - CS295047 - How to open an Enhancement Request for PTC Kepware Products

 

Thanks,

*Chris

    J
    JR_99546114-ParticipantAuthor
    4-Participant
    July 14, 2023

    @cmorehead are you sure? Multiple people have said this, but in practice it only ever logs to dbo schema, regardless of the users default schema. I've made a user called kepware, and I've given it the default schema of kepware, and it still logs to dbo. 

    J
    JR_99546114-ParticipantAuthor
    4-Participant
    August 9, 2023

    In the end it was indeed possible to log to a non "dbo" schema. I had to restart all the permissions for the user I was using to log and remove all permissions to DBO so all it could see was the Kepware schema. 

    Terms & ConditionsCookie settingsAccessibility statement