Skip to main content
Home
for DLMS smart meters
Open source solutions for DLMS smart metering

Main navigation

  • Home
  • Products
  • About us
  • Open Source
  • Community
  • Forum
  • Downloads
User account menu
  • Log in

Breadcrumb

  1. Home
  2. Forums
  3. Problem With Record In MSSQL

Problem with record in MSSQL

Forum Rules

Before commenting read Forum rules

Don't comment the topic if you have a new question.

You can create a new topic selecting correct category from Gurux Forum and then create a new topic selecting "New Topic" from the top left.

By polyrem , 22 December, 2019
Forums
Gurux.DLMS.AMI

I am running Gurux.DLMS.AMI with MSSQL database. When I read Profile from meter, there are in "Value" table string in xml format ( type of table is varchar(max)):
<Structure> <None/> <UInt8 Value="0" /> <UInt32 Value="16" /> <UInt32 Value="4" /> <UInt32 Value="8" /> <UInt32 Value="0" /> <UInt16 Value="240" /> <UInt16 Value="239" /> <UInt16 Value="241" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="1000" /> </Structure>
There should be Clock ( OBIS 1.0.0 ) as first value, but there is <None/>

When I read this profile, the first record has right value ( in octet string }
<Structure> <OctetString Value="07 E3 0C 16 07 06 0F 00 00 FF C4 00" /> <UInt8 Value="0" /> <UInt32 Value="12" /> <UInt32 Value="0" /> <UInt32 Value="4" /> <UInt32 Value="0" /> <UInt16 Value="241" /> <UInt16 Value="240" /> <UInt16 Value="241" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="0" /> <UInt16 Value="1000" /> </Structure>
but every other record has <None/> . I know, that every record is 15 minutes after previous, but it will be better with real Clock value. The best, with no octet format.
I try it only with MSSQL now. Maybe some test on linux with MariaDB will show something else.

Profile picture for user Kurumi

Kurumi

6 years 5 months ago

Hi,

Hi,

Are you reading Iskra meter? Iskra is saving bytes and date-time is null except for the first row when data is read. This is not DB depending issue.

BR,

Mikko

polyrem

6 years 5 months ago

Yes, it is Iskra meter. I

Yes, it is Iskra meter. I must count it from first line.
Thank You.

Profile picture for user Kurumi

Kurumi

6 years 5 months ago

Hi,

Hi,

I need to check if date-time can be saved in textual format and not octet string. It'll help a lot, but the main problem is that data is lost, example is DST used.

BR,
Mikko

Profile picture for user Kurumi

Kurumi

6 years 4 months ago

Hi,

Hi,

There is a new version where support for Iskraemeco is improved.

BR,
Mikko

  • Create new account
  • Reset your password

Hire Us!

Latest Releases

  • Tue, 06/09/2026 - 11:16
    gurux.dlms.java 4.0.95
  • Tue, 06/09/2026 - 10:03
    Gurux.DLMS.Python 1.0.199
  • Mon, 06/08/2026 - 13:39
    gurux.dlms.cpp 9.0.2606.0801
  • Mon, 06/01/2026 - 10:15
    gurux.dlms.cpp 9.0.2606.0101
  • Thu, 05/28/2026 - 16:06
    gurux.dlms.java 4.0.94

New forum topics

  • Error reading L&G Meter
  • Pass a TCP Client to GXNet
  • Australian EDMI Mk10D (Essential Energy area)
  • Strange mix of data notificiation vs get response
  • DLMS Connection
More

Who's new

  • Tuanhgg
  • Adel
  • charnon
  • Paddles
  • Miguel Ángel
RSS feed
Privacy FAQ GXDN Issues Contact
Follow Gurux on Twitter Follow Gurux on Linkedin