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.
Forums
Hello!
Tried to read ActivityCalendar using Director + Ami and got an exception
System.Data.SQLite.SQLiteException: "SQL logic error
unrecognized token: "'""
Image
Hi,
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
Hello!
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.
Hi,
Hi,
Update GXDLMSDirector to the latest version and try again.
BR,
Mikko
Updated. But still the same
Updated. But still the same error.
Hi,
Hi,
What you try to update?
BR,
Mikko
Downloaded AMI from git and
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.
GURUX.DLMS.AMI was updated.
GURUX.DLMS.AMI was updated.
GURUX.DIRECTOR was updated.
Hi,
Hi,
I mean what did you try to read or write? What action did you make when this occurred?
BR,
Mikko
I tried to read
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.
As an example - I tried to
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.
Hi,
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
11:31:40 Read object type
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
Selected item.
Selected item.
Hi,
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
Thanks for your help.
Thanks for your help.
Everything is ok using web.
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.
Hi,
Hi,
I know the reason for this. We are implementing GXDLMSDirector UI so it can show non-ASCII Activity Calendar names.
BR,
Mikko
Kiitos avusta!
Kiitos avusta!