ActivityCalendar reading error

19 posts / 0 new
Last post
Valeriy
ActivityCalendar reading error

Hello!
Tried to read ActivityCalendar using Director + Ami and got an exception
System.Data.SQLite.SQLiteException: "SQL logic error
unrecognized token: "'""

Kurumi
Kurumi's picture

Hi,

I just checked this and it works without problems.

Check that you are using the latest version from Gurux.DLMS.AMI.
Can you paste generated SQL string here? You can get it if you move the mouse over arg.
What attribute index did you try to read.

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

Hello!
Updated Gurux.DLMS.AMI
The same error.
About the arg =
arg
{UPDATE GXAttribute SET "Value" = '
Joins: {Gurux.Service.Orm.GXJoinCollection}
Settings: {SqLite}
Where: {WHERE "Id" = 243}

The object is highlighted in the picture. I tried to read it.

Image: 
Kurumi
Kurumi's picture

Hi,

Update GXDLMSDirector to the latest version and try again.

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

Updated. But still the same error.

Kurumi
Kurumi's picture

Hi,
What you try to update?

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

Downloaded AMI from git and Director asked me to update. I confirmed.
One remark - I tried to read ActivityCalender by Director using Gurux.DLMS.AMI.

Valeriy

GURUX.DLMS.AMI was updated.
GURUX.DIRECTOR was updated.

Kurumi
Kurumi's picture

Hi,

I mean what did you try to read or write? What action did you make when this occurred?

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

I tried to read ActivityCalender 0.1.13.0.1.255
Marked in the picture. Connected to the meter, selected the object, tried to read it.

Valeriy

As an example - I tried to read Atbitrator and ActivityCalendar after that.
In ValueController.css in line 110 for ActivityCalendar got error. The same as above.
For Arbitrator arg value looks like:
{UPDATE GXAttribute SET `Value` = '<Array>
<Structure>
<OctetString Value="00 66 0A 00 6C FF" />
<UInt16 Value="3" />
</Structure>
<Structure>
<OctetString Value="00 66 0A 00 6C FF" />
<UInt16 Value="4" />
</Structure>
<Structure>
<OctetString Value="00 66 0A 00 6C FF" />
<UInt16 Value="1" />
</Structure>
<Structure>
<OctetString Value="00 66 0A 00 6C FF" />
<UInt16 Value="2" />
</Structure>
</Array>
', `Read` = '2020-07-06 17:06:47' WHERE `Id` = 212}

For ActivityCalendar (where the error occures):
{UPDATE GXAttribute SET `Value` = '
And nothing more.

Kurumi
Kurumi's picture

Hi,

Activity Calendar is now tested with several meters and it works without problems.
Can you read the Activity Calendar with GXDLMSDirector and add trace here. Add just Activity Calendar read trace, nothing more.

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

11:31:40 Read object type ActivityCalendar index: 2
TX: 7E A0 19 03 0F 3E 20 AB E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 02 00 FA 0B 7E
11:31:40
RX: 7E A0 1B 0F 03 12 3B 75 E6 E7 00 C4 01 C1 00 09 09 00 00 00 00 00 00 00 00 00 73 B0 7E
11:31:40 Read object type ActivityCalendar index: 3
TX: 7E A0 19 03 0F 50 58 21 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 03 00 22 12 7E
11:31:40
RX: 7E A0 12 0F 03 34 6C C8 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:40 Read object type ActivityCalendar index: 4
TX: 7E A0 19 03 0F 72 48 23 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 04 00 2A 5F 7E
11:31:40
RX: 7E A0 12 0F 03 56 78 88 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:40 Read object type ActivityCalendar index: 5
TX: 7E A0 19 03 0F 94 70 A1 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 05 00 F2 46 7E
11:31:40
RX: 7E A0 12 0F 03 78 04 40 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:40 Read object type ActivityCalendar index: 6
TX: 7E A0 19 03 0F B6 60 A3 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 06 00 9A 6C 7E
11:31:40
RX: 7E A0 1B 0F 03 9A 7B 7D E6 E7 00 C4 01 C1 00 09 09 43 41 4C 49 4D 50 00 00 00 27 5D 7E
11:31:40 Read object type ActivityCalendar index: 7
TX: 7E A0 19 03 0F D8 18 29 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 07 00 42 75 7E
11:31:40
RX: 7E A0 6A 0F 03 BC B1 7F E6 E7 00 C4 01 C1 00 01 04 02 03 09 01 01 09 0C FF FF 0B 01 FF 00 00 00 FF 80 00 FF 09 01 01 02 03 09 01 82 09 0C FF FF 0B 01 FF 00 00 00 FF 80 00 FF 09 01 00 02 03 09 01 83 09 0C FF FF 05 01 FF 00 00 00 FF 80 00 FF 09 01 00 02 03 09 01 04 09 0C FF FF 06 01 FF 00 00 00 FF 80 00 FF 09 01 02 DC F0 7E
11:31:40 Read object type ActivityCalendar index: 8
TX: 7E A0 19 03 0F FA 08 2B E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 08 00 8A F6 7E
11:31:41
RX: 7E A0 38 0F 03 DE C5 D3 E6 E7 00 C4 01 C1 00 01 02 02 08 09 01 01 11 01 11 01 11 01 11 01 11 01 11 02 11 02 02 08 09 01 02 11 03 11 03 11 03 11 03 11 03 11 04 11 04 EB DF 7E
11:31:41 Read object type ActivityCalendar index: 9
TX: 7E A0 19 03 0F 1C 30 A9 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 09 00 52 EF 7E
11:31:41
RX: 7E A8 89 0F 03 F0 BE 3C E6 E7 00 C4 01 C1 00 01 04 02 02 11 01 01 02 02 03 09 04 07 00 00 00 09 06 00 01 0A 00 64 FF 12 00 01 02 03 09 04 16 00 00 00 09 06 00 01 0A 00 64 FF 12 00 02 02 02 11 02 01 02 02 03 09 04 00 00 00 00 09 06 00 01 0A 00 64 FF 12 00 01 02 03 09 04 17 2D 00 00 09 06 00 01 0A 00 64 FF 12 00 02 02 02 11 03 01 02 02 03 09 04 06 00 00 00 09 06 00 01 0A 00 64 FF 12 00 01 02 03 09 04 16 00 53 81 7E
11:31:41
TX: 7E A0 07 03 0F 31 34 3E 7E
11:31:41
RX: 7E A0 1C 0F 03 F2 14 C5 00 00 09 06 00 01 0A 00 64 FF 12 00 02 02 02 11 04 01 00 2B 29 7E
11:31:41 Read object type ActivityCalendar index: 10
TX: 7E A0 19 03 0F 5E 26 C8 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 00 FF 0A 00 3A C5 7E
11:31:41
RX: 7E A0 1E 0F 03 14 5A 7E E6 E7 00 C4 01 C1 00 09 0C FF FF FF FF FF 00 00 FF FF 80 00 FF 94 42 7E
11:31:41 Read object type ActivityCalendar index: 2
TX: 7E A0 19 03 0F 70 5A 00 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 02 00 41 17 7E
11:31:41
RX: 7E A0 1B 0F 03 36 1D 12 E6 E7 00 C4 01 C1 00 09 09 00 00 00 00 00 00 00 00 00 73 B0 7E
11:31:41 Read object type ActivityCalendar index: 3
TX: 7E A0 19 03 0F 92 46 C4 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 03 00 99 0E 7E
11:31:41
RX: 7E A0 12 0F 03 58 06 61 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 4
TX: 7E A0 19 03 0F B4 72 80 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 04 00 91 43 7E
11:31:41
RX: 7E A0 12 0F 03 7A 16 63 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 5
TX: 7E A0 19 03 0F D6 66 C0 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 05 00 49 5A 7E
11:31:41
RX: 7E A0 12 0F 03 9C 2E E1 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 6
TX: 7E A0 19 03 0F F8 1A 08 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 06 00 21 70 7E
11:31:41
RX: 7E A0 1B 0F 03 BE 5D 1A E6 E7 00 C4 01 C1 00 09 09 43 41 4C 45 58 50 00 00 00 C7 FE 7E
11:31:41 Read object type ActivityCalendar index: 7
TX: 7E A0 19 03 0F 1A 06 CC E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 07 00 F9 69 7E
11:31:41
RX: 7E A0 12 0F 03 D0 46 69 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 8
TX: 7E A0 19 03 0F 3C 32 88 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 08 00 31 EA 7E
11:31:41
RX: 7E A0 12 0F 03 F2 56 6B E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 9
TX: 7E A0 19 03 0F 5E 26 C8 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 09 00 E9 F3 7E
11:31:41
RX: 7E A0 12 0F 03 14 6E E9 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:41 Read object type ActivityCalendar index: 10
TX: 7E A0 19 03 0F 70 5A 00 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 01 FF 0A 00 81 D9 7E
11:31:41
RX: 7E A0 1E 0F 03 36 4A 7C E6 E7 00 C4 01 C1 00 09 0C FF FF FF FF FF 00 00 FF FF 80 00 FF 94 42 7E
11:31:41 Read object type ActivityCalendar index: 2
TX: 7E A0 19 03 0F 92 46 C4 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 02 00 8C 32 7E
11:31:42
RX: 7E A0 1B 0F 03 58 65 98 E6 E7 00 C4 01 C1 00 09 09 00 00 00 00 00 00 00 00 00 73 B0 7E
11:31:42 Read object type ActivityCalendar index: 3
TX: 7E A0 19 03 0F B4 72 80 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 03 00 54 2B 7E
11:31:42
RX: 7E A0 12 0F 03 7A 16 63 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 4
TX: 7E A0 19 03 0F D6 66 C0 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 04 00 5C 66 7E
11:31:42
RX: 7E A0 12 0F 03 9C 2E E1 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 5
TX: 7E A0 19 03 0F F8 1A 08 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 05 00 84 7F 7E
11:31:42
RX: 7E A0 12 0F 03 BE 3E E3 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 6
TX: 7E A0 19 03 0F 1A 06 CC E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 06 00 EC 55 7E
11:31:42
RX: 7E A0 1B 0F 03 D0 25 90 E6 E7 00 C4 01 C1 00 09 09 43 41 4C 44 53 4E 00 00 00 E3 D0 7E
11:31:42 Read object type ActivityCalendar index: 7
TX: 7E A0 19 03 0F 3C 32 88 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 07 00 34 4C 7E
11:31:42
RX: 7E A0 12 0F 03 F2 56 6B E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 8
TX: 7E A0 19 03 0F 5E 26 C8 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 08 00 FC CF 7E
11:31:42
RX: 7E A0 12 0F 03 14 6E E9 E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 9
TX: 7E A0 19 03 0F 70 5A 00 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 09 00 24 D6 7E
11:31:42
RX: 7E A0 12 0F 03 36 7E EB E6 E7 00 C4 01 C1 00 01 00 8A D8 7E
11:31:42 Read object type ActivityCalendar index: 10
TX: 7E A0 19 03 0F 92 46 C4 E6 E6 00 C0 01 C1 00 14 00 01 0D 00 02 FF 0A 00 4C FC 7E
11:31:42
RX: 7E A0 1E 0F 03 58 32 F6 E6 E7 00 C4 01 C1 00 09 0C FF FF FF FF FF 00 00 FF FF 80 00 FF 94 42 7E

Valeriy

Selected item.

Image: 
Kurumi
Kurumi's picture

Hi,

Your meter is returning hex(000000000000000000) as active calendar name and it was causing this.

This is now fixed. The active calendar name is now empty.

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

Thanks for your help.

Valeriy

Everything is ok using web. But problem using Director (with Ami).
Director without Ami reads full name of the calendar. But if we start to use Ami for reading - only first two characters.
Picture attached.

Image: 
Kurumi
Kurumi's picture

Hi,

I know the reason for this. We are implementing GXDLMSDirector UI so it can show non-ASCII Activity Calendar names.

BR,
Mikko

________________________________________
Mikko Kurunsaari
Gurux Ltd
http://www.gurux.fi

Valeriy

Kiitos avusta!