[holly]

Hi there, i did load the f1 tables in the hdbH , however im hitting the same issue

hdbH”tables[]”

s#`event`lap`sensor

[holly]

ex2:.perm.users: (“S*S”;enlist “\t”)0: hsym `$getenv[`AX_WORKSPACE],”/AdvancedCapstone.Data/users.txt”

update password: .Q.sha1 each password from `.perm.users

[holly]

ex5: .perm.parseQuery: { first parse x}

hdbH (set;`.perm.parseQuery;.perm.parseQuery)

[holly]

ex4: hdbH “.z.pw :{[user;pswd]$[(.Q.sha1 pswd) in select password from `.perm.users;1b;0b]}”

[holly]

.z.pg

hdbH “.z.pg:{permission:.perm.users[.z.u;`api];test:.perm.parseQuery[x];$[permission~`all;value x;($[test~permission;value x;:`notAuthorized])]}”

• This reply was modified 2 weeks, 1 day ago by  holly.
• This reply was modified 2 weeks, 1 day ago by  holly.
• This reply was modified 2 weeks, 1 day ago by  holly.
• This reply was modified 2 weeks, 1 day ago by  holly.

[holly]

able to access now, thanks  a lot ((((failed again at 7:30am))))))

• This reply was modified 2 weeks, 1 day ago by  holly. Reason: issue happened again
• This reply was modified 2 weeks, 1 day ago by  holly.

[holly]

it works now, thank you very much 

[holly]

dont think this is the issue, i reboot and load the database again , the tables are matching 

hdbH"meta sensor"
c          | t f a
-----------| -----
date       | d    
sensorId   | s   p
time       | t    
lapId      | j    
units      | s    
sensorValue| f    
session    | s    

meta sensor
c          | t f a
-----------| -----
date       | d    
sensorId   | s   p
time       | t    
lapId      | j    
units      | s    
sensorValue| f    
session    | s  

[holly]

only issues im noticing is that after i load f1 database to the process, 

the  sensor table is different to the one i load on disk 

hdbH"meta sensor"
c       | t f a
--------| -----
date    | d    
sensorId| j    

meta sensor
c          | t f a
-----------| -----
date       | d    
sensorId   | s   p
time       | t    
lapId      | j    
units      | s    
sensorValue| f    
session    | s    

[holly]

hdbH”sensor”

hdbH “event”

hdbH “lap”

date       sensorId
-------------------
2020.01.02 2       
2020.01.02 3       
2020.01.02 3       

date       session lapId time         endTime     
--------------------------------------------------
2020.01.01 P1      1     11:00:26.033 11:00:36.611
2020.01.01 P1      2     11:00:36.611 11:06:59.897
2020.01.01 P1      3     11:06:59.897 11:12:06.853
2020.01.01 P1      4     11:12:06.853 11:19:25.885
2020.01.01 P1      5     11:19:25.885 11:25:02.752
2020.01.01 P1      6     11:25:02.752 11:27:11.547
2020.01.01 P1      7     11:27:11.547 11:36:08.701
2020.01.01 P1      8     11:36:08.701 11:43:41.360
2020.01.01 P1      9     11:43:41.360 11:45:51.509
2020.01.01 P1      10    11:45:51.509 11:45:55.556
date       sensorId       session lapId time         endTime      sensorValue
-----------------------------------------------------------------------------
2020.01.02 tempBackLeft   P3      1     12:00:42.329 12:01:14.042 20.61488   
2020.01.02 tempBackLeft   P3      2     12:01:14.042 12:02:27.094 20.62392   
2020.01.02 tempBackLeft   P3      3     12:02:27.094 12:02:54.318 20.61883   
2020.01.02 tempBackLeft   P3      4     12:02:54.318 12:16:52.146 20.621     
2020.01.02 tempBackLeft   P3      5     12:16:52.146 12:17:12.914 20.61416   
2020.01.02 tempBackLeft   P3      6     12:17:12.914 12:17:30.610 20.62186   
2020.01.02 tempBackLeft   P3      7     12:17:30.610 12:21:49.433 20.61864   
2020.01.02 tempBackLeft   P3      8     12:21:49.433 12:23:43.561 20.61508   
2020.01.02 tempBackLeft   P3      9     12:23:43.561 12:28:25.547 20.62206   
2020.01.02 tempBackLeft   P3      10    12:28:25.547 12:28:36.391 20.62515   
2020.01.02 tempBackLeft   P3      11    12:28:36.391 12:28:56.155 20.60884   
2020.01.02 tempBackLeft   P3      12    12:28:56.155 12:32:36.277 20.61889   
2020.01.02 tempBackLeft   P3      13    12:32:36.277 12:39:54.766 20.62077   
2020.01.02 tempBackLeft   P3      14    12:39:54.766 12:43:03.983 20.62077   
2020.01.02 tempBackLeft   P3      15    12:43:03.983 12:55:41.601 20.62054   
2020.01.02 tempBackLeft   P3      16    12:55:41.601 12:56:32.863 20.61843   

[holly]

Sorry, the issue happened again

Same thing i noticed is that, it will automatically hit this issue.whenever i hit some error in exercise 3 and trying to resolve the questions again (usually in between ex3.5 and 3.6)

 Is there any other possible way to get this resovled, because i still have few questions to complete for ex3 and this might happened again until i get the capstone submitted 

=================================================================

I got the server reboot, it works fine now

• This reply was modified 2 weeks, 1 day ago by  holly. Reason: i managed to get it reboot

[holly]

{[raceTab;lapTab;mySensor]

// Get avg benchmark values from historical lap data // THESE

this_dict: `temp`tyre`wind`all!(“temp*”;”tyre*”;”wind*”;”[a-z]*”);

if [0b=mySensor in key this_dict;.Q.trp[‘string [mySensor], ” is not a valid option for mysensor – valid options include `temp `tyre `wind `all”]];

if[not mySensor in key[this_dict];’string[mySensor],” is not a valid option for mysensor – valid options include `temp`tyre`wind`all”];

benchmark:?[lapTab;();(enlist `sensorId)!enlist `sensorId;(enlist `benchmarkValue)!enlist (avg;`sensorValue)] ;

chk:?[raceTab;();(enlist `sensorId)!enlist `sensorId;`avgValue`stdDevValue!((avg;`sensorValue);(dev;`sensorValue))] ;

chk:![lj[benchmark;chk];();0b;(enlist `diffValue)!enlist ($;”F”;(.Q.f’;5;(abs;(-;`benchmarkValue;`avgValue))))] ;</p><p>chk:![chk;();0b;`diffFlag`stdFlag!((?;(>;`diffValue;1);0b;1b);(?;(>;`stdDevValue;1.5);0b;1b))];</p><p>chk:?[chk;enlist(like;`sensorId;this_dict[mySensor]);0b;()];

chk

}