How to feed data manually

[Mixa]

Good day for all,

I'm a new TorQ user and I'm stuck with the first steps.

My setup: Windows 2019 Server, 2days old TorQ master and TorQ-Finance-Starter-Pack copied above.

If I start the clear stack by start_torq_demo.bat rdb and hdb works fine. The test records are collected. But if I try to push records to tickerplant manually then NO records are stored in RDB.

My steps are:

1. Remove start of all test feed processes from  start_torq_demo.bat

2. Added test table `iva:([]time:`timestamp$(); sym:`g#`symbol$(); md:`symbol$())` to database.q

3. Start stack by  start_torq_demo.bat

4. Open the new q console 

5. Connect to tickerplant: h:hopen`:localhost:6000:segmentedtickerplant:pass

6. h"meta iva"

c   | t f a
----| -----
time| p
sym | s
md  | s

7. Try to push a new record: h(`.u.upd;`iva;(`timestamp$.z.P;`AAFF;`blabla))

8. Connect to gateway localhost:6007

9. .gw.syncexec["select [-10] from `iva";`rdb]

10. Get an empty result.

Also I tried to push records to the trade table from IDE with the same effect.

`.u.pub;`trade;(`timestamp$.z.p;`AAFT;33342.87;7i;0b;"B";"N";`sell)

In other cases if feed.q process is started I see records in rdb in the trade table. 

Mixa.

[Mixa]

Also I'm aware about conversation "Which function is used to feed realtime data" and tried these recomendations.

[Jamie Peters]

Hi Mixa, 

I will take a look at this for you, going to try recreate it now and I will keep you updated.

Kind regards, 

Jamie 

[Jamie Peters]

Hi Mixa, 

The stp is set up  by default to add a timestamp to the records (since this keeps a record of exactly when the data is received and if the data already comes with a timestamp we can store both by helping to diagnose potential latency issues) and then there is a length error when trying to insert the record, if you try to add the record without a timestamp like

h(`.u.upd;`iva;(`AAFF;`blabla)) it should work. If you want to pass the records with a timestamp you can change the value in .stplg.updtab for that particular table like .stplg.updtab[`iva]:{[x;y]x} , documentation of this is here. Using the first method I can then see the record in the rdb, however I am a little unsure exactly how you were querying the gateway, using qcon and then running exactly what you have stated still returns nothing (note this is a bug within TorQ and we are going to look into it), however passing a sync message to the gateway using  h(`.gw.syncexec;"select [-10] from `iva";`rdb) is returning the record for me. 

Hope this helps, any other questions feel free to ask,

Jamie

[Mixa]

Jamie, 

Big thanks for your help. Removing timestamp from the record resolved my problem. Now stack works as I expected.

Mixa