February

New and improved

Key Summary Status Updated Component Description Resolution
FV-1863 Implement keyboard snippets Resolved 20/02/18 Kiosk It's already in the DAL, just implement it in the UI. Fixed
FV-4347 Kiosk: print member cards Resolved 01/03/18 Kiosk After the registration, the kiosk already prints a member card with the personalized data.
Subscribe, go to pos and your personalized card is ready there.
Fixed
FV-4881 Choose COUNTRY standard based on choose LANGUAGE in kiosk Resolved 26/02/18 Kiosk when there is no country filled in for a member, the Business Intelligence won't show them in the map results. but putting it in the kiosk is slowing down the registration.
* to increase to quality of the Business Intelligence and speed up the registration, it would be best to apply a standard country already based on the choosen language
* Because some languages can be used for multiple countries (English = USA / UK / Australia ) (Dutch = Holland or Belgium), (German = Germany, Austria, Swiss, Belgium) etc etc., a field has to be made with standardcountry per language. see mockup....

more info with Senne.
Fixed
FV-5000 Allowing the Language to be a trigger in the kiosk Resolved 26/02/18 Kiosk In the FAST 5 Kiosk, we can't use Language as one of the possible triggers.
This would be useful if we would only want to show a certain question or a certain page to people who have selected a certain language.
Fixed
FV-5250 Remake the minor registration, convert to page kinds Resolved 01/03/18 Kiosk The guardian/minor registration was hacked into the software.
But we'll need to make it properly. These minor popups should be converted to special pages with a different kind.
Fixed
FV-6598 Add mobile phone number to "Timing - Scores" export Resolved 28/02/18 Timing   Fixed
FV-6753 Swipe driver in timing on idle heat Resolved 11/02/18 Timing It might be a nice option to add a member driver directly to a heat if you swipe them inside the pit.

So a combination of add driver and link to a member
Fixed
FV-6763 Buttons don't make much sense Resolved 28/02/18 Booking Select current heat (hardly ever used, easier right mouse)
Minimize reservations (sorry, doesn't look very interesting anymore, right mouse)
Really missing session settings
Fixed
FV-6907 Multiline labels in kiosk Resolved 26/02/18 Kiosk Be able to put multiline text in the label, instead of using multiple labels.

Example: Nettedrom.
Fixed
FV-7011 Show person deposits on Sales Ticket Resolved 03/03/18 Reports For the selfbooking Kiosk in XAP, they want to show it in the sales receipt.
Since we only print entry tickets for Karting and only a small part actually buys Karting products, it would be nice to have it on the sales receipt instead/as well.
Fixed
FV-7393 User rights: Changing/deleting lap times Resolved 09/02/18 Timing An admin/manager should and should be the only authorized user that can change lap times deliberately. Fixed
FV-7664 Lasermaxx update protocol + f5 impl Resolved 21/02/18 Booking   Fixed
FV-7876 User rights: change /delete kiosk survey Resolved 26/02/18 Configurator, Kiosk Hey,

a client noticed that everybody in the employee role is able to do small adjustments to the surveys. They can adjust the font and the text-position.

Kind regards,
Steve Dekerf
Fixed
FV-7950 do not print sales ticket when making bill on tab Resolved 26/02/18 Booking Use PRINT SALES ON TAB setting

At the moment it is not printing when you put something on tab, while the setting is set to true..
Requested by Gokartcentralen
Fixed
FV-8653 French Fiscal System Resolved 21/02/18   Prepare for 2018 France Fixed
FV-8731 Site screens, only show site where the node is active Resolved 28/02/18 Configurator Now all 64 site for all nodes are shown, we should show only the active ones.

Also do some sorting and show the node id
Fixed
FV-8770 Sort drivers by age button Resolved 09/02/18 Booking, Timing ability to sort drivers in the heat by age, to use loop assignment (children are going first, or last) Fixed
FV-8825 Visit report Resolved 23/02/18 BI, Booking Send it every day.

Should contain customers who was here in the period:
* new customers
* returning customers
* membercards
* mobile apps

age distribution



check the old report attached.
Fixed
FV-8899 optimize TR_GET_TRM_ID to have a fetch less Resolved 28/02/18 Database there is room for optimizations and it gets called pretty often Fixed
FV-8900 Individual reservation report Resolved 05/02/18 Booking In fast 4 there was a button inside the reservation screen to print the reservation with all its details.

Attached a reservation with the printed report.



If possible put this high on priority, they asked us 6 months ago but it got lost somewhere.



Thanks!

!image-2018-01-29-12-12-23-851.png!
Fixed
FV-8905 make months smaller in kiosk date time picker Resolved 07/02/18 Kiosk Can you make the months a little bit smaller, now it's difficult to read sometimes the bottom months Fixed
FV-8913 History ticket Resolved 03/02/18 Booking Make a history ticket Fixed
FV-8915 When updater fails show exception in console before/after bomb Resolved 28/02/18 Updater Now if updater crashed you need to go to log folder to check the exception Fixed
FV-8921 Export parameters Resolved 01/02/18 Configurator allow them to change the type in the query params dialog. This will be much more intuitive and will free a lot of space on the main query screen. Fixed
FV-8923 Allow Configurator and TV, even when license rejected Resolved 01/02/18 Configurator It is hard to enter a new license when configurator isn't starting up Fixed
FV-8928 Searching on Person BirthDay doesn't work Resolved 02/02/18 Database   Fixed
FV-8930 Booking: Show firstname & lastname person (maybe setting?) Resolved 02/02/18 Booking !image-2018-02-02-09-39-18-177.png!

Instead of showing the alias, show the firstname and lastname.

Maybe also make a setting for this?
Fixed
FV-8931 Improve performance of person search Resolved 02/02/18 Database   Fixed
FV-8935 kart assignment in booking Resolved 03/02/18 Booking make a button in context menu to assign karts Fixed
FV-8936 Stock for packages Resolved 04/02/18 Booking Implement tock deduction from packages Fixed
FV-8950 Selection of TVScenes is too small when you launch new tv Resolved 05/02/18 Configurator It is a bit silly that the column name is so small and that the column Active is even visible.

Let the column name fill up the available width

But make sure you don't delete the active column for all the rest. Also... removing the active column is less important. The "inactives" though should be gone.







!image-2018-02-05-12-46-49-971.png!
Fixed
FV-8952 Add shows to configurator Resolved 05/02/18 Configurator make shows visible in the main buttons Fixed
FV-8954 Fast sessions allows to copy drivers Resolved 09/02/18 Booking It has to be disabled. Only move can be allowed Fixed
FV-8955 Default birthday email configuration Resolved 28/02/18 Post Office   Fixed
FV-8958 Migrate to firebird 3.0.3 Resolved 06/02/18 Database   Fixed
FV-8959 Create new person after swipe when list empty Resolved 09/02/18 Booking When cashiers swiped new member card and list of registered persons is empty, they always need to press "+". We could do it automatically. Fixed
FV-8961 AutomailCampaign additional fields ShowOnKiosk, ShowOnline and Default Resolved 06/02/18 Database Allows people to configure if these campaigns should be allowed to change in Kiosk, Online and what the default value will be Fixed
FV-8963 Execute script in unit tests and buildserver should return error Resolved 12/02/18 Framework Now it just returns true false and that is really annoying because you can't see what is actually failing.

Is it the firebird, security, udf, or just the script... you have no idea. This takes too long to investigate.

It would be much easier if the build log contained the proper error
Fixed
FV-8965 User rights, separate registered members from new members Resolved 09/02/18 Booking Make another Group New_PERSON and separate all DATA actions from PERSON group.



Otherwise cashiers cannot register new members in case if they don't have PERSON Add/Edit/Delete actions
Fixed
FV-8968 group paid deposits in sales ticket Resolved 09/02/18 Booking Now it shows deposits per person, but it has to be grouped by kind Fixed
FV-8969 Make translation removable Resolved 08/02/18   For example if you want to change the name of a pay method 'credit card' and you activated a few languages, they'll all have a translation for this. If you want to change it to Visa for example, you have to overwrite all existing translations because if you empty them, they don't get saved. Same for default scoregroup and all other translations.



Either we should remove it when it's empty or put a X button to delete it or something.
Fixed
FV-8973 disable history ticket printing on void Resolved 09/02/18 Booking   Fixed
FV-8974 Change DNS condition in timing Resolved 07/02/18 Timing If participant has only 1 passing, but 0 laps (0 time) it should have DNS state, not finished Fixed
FV-8978 Race and karts report group by rental kind Resolved 09/02/18 Booking, Timing Group karts by rental kind Fixed
FV-8981 Scoreboard column header is not resizable Resolved 28/02/18 TV Make a setting to use the font for scoreboard column header Fixed
FV-8984 Fix CCCode during upgrade Resolved 07/02/18 Installer Check the next CCCode number when you do an upgrade Fixed
FV-8985 Enforce the upgrader to check for StableF4 to make sure laps are converted Resolved 07/02/18 Upgrader The upgrader MUST make sure the correct versions are applied Fixed
FV-8988 Performance tweak on create mobile token Resolved 08/02/18 Backend, Database Special index for creating faster random mobile token Fixed
FV-8994 Total in raceandsales report Resolved 19/02/18 Reports the client would like a total sales label on the bottom of the raceandsales report Fixed
FV-8996 do not include anonymized persons in person search Resolved 08/02/18 Database   Fixed
FV-8997 Implement "Build date" in Updater Resolved 08/02/18 Updater This way you can insert update scripts for after a certain fix, not only a BuildNr Fixed
FV-8998 add compression to heavy API calls Resolved 21/02/18 Backend, Mobile logo, background, translations Fixed
FV-9004 Don't allow deletion of records with negative ID Resolved 09/02/18 Framework The database will not allow it anyway, but people still try it so the UI complains Fixed
FV-9005 Implement virtual scroll for race statistics Resolved 13/02/18 Mobile When person have a lot of sessions, app just dies on race stats page Fixed
FV-9007 Rename GOnline Generic Servicehost Resolved 19/02/18 ServiceHost Hi JIri



Can you easily rename GOnline Generic Servicehost to "Fast Servicehost"

then we can find it back easier.

Can this "fix" itself during an upgrade?
Fixed
FV-9011 Make dividers in session list by month Resolved 13/02/18 Mobile Make visuall separatorn in race stats list by month name and year Fixed
FV-9017 Show country in the scores Resolved 11/02/18 Timing Show person's country Fixed
FV-9036 Online Kiosk: opacity mess pictures Resolved 12/02/18 Web modules When you take a picture the opacity is wrong.

Picture not clear.
Fixed
FV-9040 Do not print the sales ticket, when only deposits was used Resolved 26/02/18 Booking Make a setting to not print the ticket when no money was taken.

Also do not increase ticket number for it (give it 0 number)
Fixed
FV-9049 NullableId Syntax Change => "?" Resolved 13/02/18 Framework New native syntax Fixed
FV-9063 Performance DPS_AVAILABLE Resolved 21/02/18 Booking On big databases it can be around 500 ms per request. (if they heavily uses credits)
Example easykart pattaya:

If ticket contains 5 drivers, this means it will be called 5 times during creation of member, creation of bill line, calc bill, UI refresh, calc on pay, deposits on entry ticket...

this means user looses ~10-15 sec only on that procedure
Fixed
FV-9064 Cash report show subtotal bold Resolved 22/02/18 Booking   Fixed
FV-9065 Cash report site info is too small Resolved 26/02/18 Booking Most of the addresses doesn't fit on the site info place.

Make it bigger, or make font smaller
Fixed
FV-9073 Make online booking translatable Resolved 21/02/18 Online booking   Fixed
FV-9083 Refactor Ignorable and BaseException Resolved 15/02/18 Framework   Fixed
FV-9089 Booking: move free field to first page. Resolved 20/02/18 Booking   Fixed
FV-9090 LR_GET_COORDINATES is slow Resolved 21/02/18 Database select OUT_LR_PREFIX,
OUT_LR_ID,
OUT_ADDRESS,
OUT_CITY,
OUT_ZIP,
OUT_REGION,
OUT_COUNTRY
from LR_GET_COORDINATES(50)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (LR_GET_COORDINATES NATURAL)
49 records fetched
5691 ms, 237463 read(s), 6262488 fetch(es)
Fixed
FV-9091 LR_GET_DISTANCE is slow Resolved 21/02/18 Database select OUT_LR_PREFIX,
OUT_LR_ID,
OUT_LATITUDE,
OUT_LONGITUDE,
OUT_SITE_LATITUDE,
OUT_SITE_LONGITUDE
from LR_GET_DISTANCE(50)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (LR_GET_DISTANCE NATURAL)
26 records fetched
1221 ms, 8012 read(s), 2518818 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FORMATS 1
T_ADDRESS 473024 1
T_CITY 116160
T_TRANSLATION_META 347
T_COUNTRY 347
T_REGION 18
Z_LOCATION_REQUEST 121224
Fixed
FV-9092 Slow statement in city fetch Resolved 21/02/18 Database SELECT "T_CITY"."F_CNR_ID" AS "CountryId", "T_CITY"."F_CTY_ID" AS "Id", "T_CITY"."F_CTY_NAME" AS "Name", "T_CITY"."F_ND_ID" AS "NodeId", "T_CITY"."F_RGN_ID" AS "RegionId", "T_CITY"."F_CTY_TIMEZONE" AS "TimeZone", "T_CITY"."F_CTY_VERSION" AS "Version", "T_CITY"."F_CTY_ZIP" AS "Zip" FROM (("T_CITY" INNER JOIN "T_ADDRESS" ON "T_CITY"."F_CTY_ID"="T_ADDRESS"."F_CTY_ID") INNER JOIN "T_PERSON" ON "T_PERSON"."F_PERS_ID"="T_ADDRESS"."F_PERS_ID") WHERE ( ( ( "T_PERSON"."F_PERS_ID" < ? OR "T_PERSON"."F_PERS_CREATED" >= ?) OR "T_PERSON"."F_PERSC_ID" IN (?, ?, ?)))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (T_CITY NATURAL, T_ADDRESS INDEX (FK_ADR_CTY_ID), T_PERSON INDEX (PK_T_PERSON))

param0 = bigint, "0"
param1 = timestamp, "2018-02-14T06:00:00.0000"
param2 = bigint, "-2"
param3 = bigint, "-4"
param4 = bigint, "-5"

880 records fetched
4663 ms, 517352 read(s), 3149830 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_ADDRESS 473026
T_CITY 58080
T_PERSON 473026
Fixed
FV-9093 performance SES_CREATE_SESSIONS Resolved 21/02/18 Database Procedure SES_CREATE_SESSIONS:
param0 = bigint, "1584460"
param1 = timestamp, "2018-02-15T06:00:00.0000"
param2 = timestamp, "<NULL>"

402 ms, 91 read(s), 455599 fetch(es), 187 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$INDICES 15
RDB$RELATIONS 1
RDB$RELATION_CONSTRAINTS 3
GT_IDS 90
T_FUNBOO 2
T_RESOURCE_STATE 1 1
T_SCHEDULE_SETUP 1
T_SCHEDULE_SETUP_LINE 13
T_SESSION_SETUP 64688
T_SESSION 553
Fixed
FV-9110 Performance fetching city Resolved 18/02/18 Database, Framework Statement 496415:
-------------------------------------------------------------------------------
SELECT "T_CITY"."F_CNR_ID" AS "CountryId", "T_CITY"."F_CTY_ID" AS "Id", "T_CITY"."F_CTY_NAME" AS "Name", "T_CITY"."F_ND_ID" AS "NodeId", "T_CITY"."F_RGN_ID" AS "RegionId", "T_CITY"."F_CTY_TIMEZONE" AS "TimeZone", "T_CITY"."F_CTY_VERSION" AS "Version", "T_CITY"."F_CTY_ZIP" AS "Zip" FROM (("T_CITY" INNER JOIN "T_ADDRESS" ON "T_CITY"."F_CTY_ID"="T_ADDRESS"."F_CTY_ID") INNER JOIN "T_PERSON" ON "T_PERSON"."F_PERS_ID"="T_ADDRESS"."F_PERS_ID") WHERE ( ( ( "T_PERSON"."F_PERS_ID" < ? OR "T_PERSON"."F_PERS_CREATED" >= ?) OR "T_PERSON"."F_PERSC_ID" IN (?, ?, ?)))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (T_CITY NATURAL, T_ADDRESS INDEX (FK_ADR_CTY_ID), T_PERSON INDEX (PK_T_PERSON))

param0 = bigint, "0"
param1 = timestamp, "2018-02-15T06:00:00.0000"
param2 = bigint, "-2"
param3 = bigint, "-4"
param4 = bigint, "-5"

914 records fetched
4655 ms, 517131 read(s), 3150296 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_ADDRESS 473098
T_CITY 58087
T_PERSON 473098
Fixed
FV-9111 Performance PERS_SEARCH_ID Resolved 22/02/18 Database, Framework -------------------------------------------------------------------------------
select * from PERS_SEARCH_ID(?,?,?,?,?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PERS_SEARCH_ID NATURAL)

param0 = varchar(2724), "540"
param1 = integer, "20"
param2 = smallint, "1"
param3 = smallint, "0"
param4 = smallint, "0"
param5 = smallint, "0"

20 records fetched
316 ms, 4713 read(s), 25614 fetch(es), 2440 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
GT_IDS 1211 1211
S_PERSON 1220
T_PERSON 2431
Fixed
FV-9115 Log and Show message when Mobile marshal is doing stuff at timing Resolved 19/02/18 Framework   Fixed
FV-9117 OMG_WRONG_DEPOSIT Resolved 19/02/18 Database easy stored procedure to fix a wrong deposit for a customer Fixed
FV-9121 Performance on load person, many "kiosk" persons left in huge dbs Resolved 21/02/18 Database, Framework SELECT "T_PERSON"."F_PERS_ACCEPT_MAIL_COMMERCIAL" AS "AcceptMailCommercial", "T_PERSON"."F_PERS_ACCEPT_MAIL_SCORES" AS "AcceptMailScores", "T_PERSON"."F_PERS_ACCEPT_SMS_COMMERCIAL" AS "AcceptSmsCommercial", "T_PERSON"."F_PERS_ACCEPT_SMS_SCORES" AS "AcceptSmsScores", "T_PERSON"."F_PERS_ACCEPT_SOCNET_COMMERCIAL" AS "AcceptSocialNetworkCommercial", "T_PERSON"."F_PERS_ACCEPT_SOCNET_SCORES" AS "AcceptSocialNetworkScores", "T_PERSON"."F_PERS_ALIAS" AS "Alias", "T_PERSON"."F_PERS_BIC" AS "Bic", "T_PERSON"."F_CTY_ID" AS "BirthCityId", "T_PERSON"."F_PERS_BIRTHDATE" AS "BirthDate", "T_PERSON"."F_PERS_BLOCKED" AS "Blocked", "T_PERSON"."F_PERS_CREATED" AS "Created", "T_PERSON"."F_PERS_FIRSTNAME" AS "FirstName", "T_PERSON"."F_PERS_FLAGS" AS "Flags", "T_PERSON"."F_PERS_FREE1" AS "Free1", "T_PERSON"."F_PERS_FREE2" AS "Free2", "T_PERSON"."F_PERS_GENDER" AS "Gender", "T_PERSON"."F_PERS_HEIGHT" AS "Height", "T_PERSON"."F_PERS_IBAN" AS "Iban", "T_PERSON"."F_PERS_ID" AS "Id", "T_PERSON"."F_PERS_CHARGE_ME" AS "IsChargeMe", "T_PERSON"."F_PERS_COMPLETED" AS "IsCompleted", "T_PERSON"."F_PERS_KIND" AS "Kind", "T_PERSON"."F_LAN_ID" AS "LanguageId", "T_PERSON"."F_PERS_LAST_LINEUP" AS "LastLineUp", "T_PERSON"."F_PERS_NAME" AS "Name", "T_PERSON"."F_PERS_NAME2" AS "Name2", "T_PERSON"."F_CNR_ID" AS "NationalityId", "T_PERSON"."F_PERS_NAT_NUMBER" AS "NationalNumber", "T_PERSON"."F_ND_ID" AS "NodeId", "T_PERSON"."F_PERS_NUMBER" AS "Number", "T_PERSON"."F_PERSC_ORIGINAL_ID" AS "OriginalPersonCategoryId", "T_PERSON"."F_PERS_PASSPORT" AS "Passport", "T_PERSON"."F_PERS_PASSWORD" AS "Password", "T_PERSON"."F_PERSC_ID" AS "PersonCategoryId", "T_PERSON"."F_PERS_PIN_HASH" AS "PinHash", "T_PERSON"."F_PERS_PRIVATE_MEMO_ID" AS "PrivateMemoId", "T_PERSON"."F_PERS_PUBLIC_MEMO_ID" AS "PublicMemoId", "T_PERSON"."F_PERS_PUBLIC_PICTURE" AS "PublicPicture", "T_PERSON"."F_PERS_REGISTER" AS "Register", "T_PERSON"."F_RSC_ID" AS "ResourceId", "T_PERSON"."F_PERS_VAT" AS "Vat", "T_PERSON"."F_PERS_VERSION" AS "Version", "T_PERSON"."F_PERS_VISIBILITY" AS "Visibility", "T_PERSON"."F_PERS_WEIGHT" AS "Weight" FROM "T_PERSON" WHERE ( "T_PERSON"."F_PERSC_ID" = -2) Fixed
FV-9135 performance T_PAR_RNO_UPD Resolved 21/02/18 Database TRIGGER_FINISH
T_PAR_RNO_UPD FOR T_PARTICIPANT (BEFORE UPDATE)
175 ms, 5188 read(s), 100644 fetch(es)

Fixed
FV-9144 Performance DPS_AVAILABLE II Resolved 23/02/18 Database More room for perofrmance?



select * from DPS_AVAILABLE(?,?,?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (DPS_AVAILABLE NATURAL)

param0 = bigint, "224012"
param1 = bigint, "<NULL>"
param2 = bigint, "-1"
param3 = timestamp, "<NULL>"

1 records fetched
22 ms, 1 write(s), 32929 fetch(es), 3260 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_TRANSLATION_META 1
T_DEPOSIT_KIND 4
GT_DEPOSIT 3223 6 1080 1080
Fixed
FV-9146 Membercard Encoding Should NOT be a device setting Resolved 22/02/18 Framework This should be a systemwide setting Fixed
FV-9147 Search Maximum charachters Resolved 21/02/18 Database limit the index of search Fixed
FV-9156 Performance T_NOTIFICATION loading Resolved 22/02/18 Database SELECT "T_NOTIFICATION"."F_AC_DATA" AS "ActionData", "T_NOTIFICATION"."F_NOT_CREATED" AS "Created", "T_NOTIFICATION"."F_NOT_DESC" AS "Description", "T_NOTIFICATION"."F_NOT_EXECUTED" AS "Executed", "T_NOTIFICATION"."F_NOT_EXPIRY" AS "Expiry", "T_NOTIFICATION"."F_NOT_HANDLED" AS "Handled", "quot;T_NOTIFICATION"."F_NOT_ID" AS "Id", "T_NOTIFICATION"."F_ND_ID" AS "NodeId", "T_NOTIFICATION"."F_NOTM_ID" AS "NotificationMetaId", "T_NOTIFICATION"."F_NOT_SNOOZED" AS "Snoozed", "T_NOTIFICATION"."F_NOT_UPDATED" AS "Updated", "T_NOTIFICATION"."F_US_ID" AS "UserId", "T_NOTIFICATION"."F_NOT_VERSION" AS "Version" FROM "T_NOTIFICATION" WHERE ( "T_NOTIFICATION"."F_ND_ID" = ? AND "T_NOTIFICATION"."F_NOT_EXPIRY" >= ?)

param0 = bigint, "1"
param1 = timestamp, "2018-02-15T06:00:00.0000"

11905 records fetched
59 ms, 342 read(s), 12249 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_NOTIFICATION 11905
Fixed
FV-9157 Performance Par_Records Scoregroup and year Resolved 23/02/18 Database select PAR.F_PAR_ID,
PAR.F_PERS_ID,
PAR.F_PAR_ALIAS,
PAR.F_PAR_SCORE_TIME,
PAR.F_PAR_SCORE_BEST,
PAR.F_PAR_SCORE_TOTAL,
PAR.F_PAR_SCORE_POINTS,
PAR.F_PAR_SCORE_AVG
from T_PARTICIPANT PAR where PAR.CF_PAR_SCORE_VALID and PAR.F_SCG_ID = 596448 and PAR.F_PAR_SCORE_TIME + 0 >= timestamp '2018-01-01 06:00:00.0000' and PAR.F_PAR_SCORE_TIME + 0 < timestamp '2019-01-01 06:00:00.0000' order by PAR.F_PAR_SCORE_BEST asc , PAR.F_PAR_SCORE_TIME desc
205 records fetched
263 ms, 3308 read(s), 302655 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_PARTICIPANT 299130
Fixed
FV-9163 Performance DBCOMMITRANSACTION Resolved 22/02/18 Database DBCOMMITRANSACTION (ON TRANSACTION_COMMIT)
36 ms, 4 read(s), 3191 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$RELATION_FIELDS 2269
RDB$RELATIONS 190
Fixed
FV-9164 Performance TAG_SWIPE Resolved 22/02/18 Database natural scan on T_PRODUCT for the barcode Fixed
FV-9167 Performance Massive Return of records somewhere in mobile backend Resolved 28/02/18 mobile backend It would surprise me if you actually really NEED these 11.000 records to be returned and how the mobile app will like it



select PAR.F_PAR_ID, PAR.F_PERS_ID, PAR.F_PAR_ALIAS from T_PARTICIPANT PAR where PAR.F_PAR_STATE = 3 and PAR.F_PAR_SCORE_BEST > 0
and PAR.F_PAR_ARCHIVED = 0 and PAR.F_SCG_ID = 57580 order by PAR.F_PAR_SCORE_BEST asc , PAR.F_PAR_SCORE_TIME desc
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (PAR INDEX (IDX_PAR_SCORE_BEST, FK_PAR_SCG_ID))
11141 records fetched
164 ms, 509 read(s), 11665 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FORMATS 1
T_PARTICIPANT 11148
Fixed
FV-9168 Performance MOD_BESTTIMES_RECORDS Resolved 23/02/18 mobile backend select * from MOD_BESTTIMES_RECORDS(?,?,?,?,?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MOD_BESTTIMES_RECORDS NATURAL)

param0 = varchar(80), "ESL"
param1 = bigint, "648244"
param2 = bigint, "<NULL>"
param3 = timestamp, "2018-02-01T06:00:00.0000"
param4 = timestamp, "<NULL>"
param5 = integer, "<NULL>"

10 records fetched
312 ms, 288 read(s), 1 write(s), 1897 fetch(es), 24 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FORMATS 3
T_ADDRESS 8
T_TRANSLATION_META 10
T_PARTICIPANT_2_RENTAL_OBJECT 10
T_PERSON 8
T_RENTAL_KIND 10
T_RENTAL_OBJECT 10
T_SETTING_META 2
GT_HASHSET 1 10
Fixed
FV-9169 Performance Translations Resolved 23/02/18 mobile backend execute block (IN_LAN_LOCALE varchar(50) = ?) returns ( OUT_STY_VERSION bigint, OUT_LAN_VERSION bigint, OUT_IMG_LOGO_VERSION bigint, OUT_IMG_BACKGROUND_VERSION bigint) as declare variable VAR_LAN_ID bigint; declare variable VAR_TRM_TITLE_ID bigint; declare variable VAR_TRM_CONTENT_ID bigint; begin execute procedure SYS_LOCALE_TO_LAN_ID(:IN_LAN_LOCALE) returning_values VAR_LAN_ID; select max(tr.f_tr_version) from T_TRANSLATION TR inner join T_TRANSLATION_META TRM on TRM.F_TRM_ID = TR.F_TRM_ID inner join T_LANGUAGE LAN on LAN.F_LAN_ID = TR.F_LAN_ID where LAN.F_LAN_ACTIVE = 1 and LAN.F_LAN_ID = :VAR_LAN_ID and exists (select 1 from T_TRANSLATION TR1 inner join T_TRANSLATION_META TRM1 on TRM1.F_TRM_ID = TR1.F_TRM_ID inner join T_LANGUAGE LAN1 on LAN1.F_LAN_ID = TR1.F_LAN_ID where trm1.F_TRM_CODE = 'There was an error logging in via [SOCIAL_KIND], try a different login option' and LAN1.F_LAN_ACTIVE = 1 and LAN1.F_LAN_ID = :VAR_LAN_ID) into OUT_LAN_VERSION; select f_sty_version from t_style where f_sty_id=-8 into OUT_STY_VERSION; select F_IMGF_version from T_IMAGE_FILE where F_IMG_ID = -44 /* LOGO */ into OUT_IMG_LOGO_VERSION; select F_IMGF_version from T_IMAGE_FILE where F_IMG_ID = -43 /* BACKGROUND */ into OUT_IMG_BACKGROUND_VERSION; suspend; end
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (TRM1 INDEX (IDX_TRM_CODE), TR1 INDEX (UNQ_TR_LAN_ID_TRM_ID), LAN1 INDEX (PK_T_LANGUAGE))
PLAN JOIN (LAN INDEX (PK_T_LANGUAGE), TR INDEX (FK_TR_LAN_ID), TRM INDEX (PK_T_TRANSLATION_META))
PLAN (T_STYLE INDEX (PK_T_STYLE))
PLAN (T_IMAGE_FILE INDEX (FK_IMGF_IMG_ID))
PLAN (T_IMAGE_FILE INDEX (FK_IMGF_IMG_ID))

param0 = varchar(200), "<NULL>"

1 records fetched
60 ms, 15810 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_TRANSLATION_META 3124
T_IMAGE_FILE 2
T_LANGUAGE 1
T_PERSON 1
T_STYLE 1
T_TRANSLATION 3123
T_USER 1
Fixed
FV-9170 Performance Server should not maintain search indices Resolved 22/02/18 Database Indices should not be maintained when you are running on the server Fixed
FV-9171 Performance Server should not build up location tables Resolved 22/02/18 Database   Fixed
FV-9175 Performance MOD_CALENDAR_SESSIONS Resolved 23/02/18 Database select * from MOD_CALENDAR_SESSIONS(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MOD_CALENDAR_SESSIONS NATURAL)

param0 = bigint, "13460"
param1 = timestamp, "2018-02-22T14:09:35.0003"

35 records fetched
122 ms, 339 read(s), 36976 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FORMATS 1
T_PARTICIPANT 1
T_SESSION 29233
T_SESSION_SETUP 1244
T_SETTING 4
T_SETTING_META 2
Fixed
FV-9176 performance MOD_CALENDAR_RESERVATIONS Resolved 23/02/18 Database, Web modules select * from MOD_CALENDAR_RESERVATIONS(?,?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MOD_CALENDAR_RESERVATIONS NATURAL)

param0 = bigint, "13460"
param1 = timestamp, "2018-02-22T14:09:35.0003"
param2 = varchar(80), "GER"

280 records fetched
99 ms, 229 read(s), 34987 fetch(es)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FORMATS 3
T_TRANSLATION_META 280
T_LANGUAGE 8400
T_PERSON 280
T_PROJECT 312
T_PROJECT_SCHEDULE 16139
T_PROJECT_STATE 312
T_SCHEDULE_SETUP 1
T_SCHEDULE_SETUP_LINE 1
T_SESSION_SETUP 1
T_SETTING 4
T_SETTING_META 2
T_STYLE 312
T_USER 280
Fixed
FV-9185 Performance TRM_TOUCH_RELATIONS Resolved 23/02/18 Database, WSync execute block (
in_p0 type of column T_TRANSLATION_META.F_ND_ID = ?,
in_p1 type of column T_TRANSLATION_META.F_TRM_TARGET_APPS = ?,
in_p2 type of column T_TRANSLATION_META.F_TRM_KIND = ?,
in_p3 type of column T_TRANSLATION_META.F_TRM_CODE = ?,
in_p4 type of column T_TRANSLATION_META.F_TRM_CONTEXT = ?,
in_F_TRM_ID D_PRIMARY = ?)
returns (
out_result varchar(20)
)
as
declare marker int;
begin
-- collisions ignored for now
/*if (exists(select 1 from W_TRANSLATION_META where F_TRM_ID = :in_F_TRM_ID)) then
begin
out_result = 'RECORD_COLLISION';
suspend;
exit;
end*/

select 1
from T_TRANSLATION_META
where F_TRM_ID = :in_F_TRM_ID
for update with lock
into marker;

if (marker is null) then
begin
insert into T_TRANSLATION_META (
F_ND_ID,
F_TRM_TARGET_APPS,
F_TRM_KIND,
F_TRM_CODE,
F_TRM_CONTEXT,
F_TRM_ID)
values (
:in_p0,
:in_p1,
:in_p2,
:in_p3,
:in_p4,
:in_F_TRM_ID);
end
else
begin
update T_TRANSLATION_META
set
F_ND_ID = :in_p0,
F_TRM_TARGET_APPS = :in_p1,
F_TRM_KIND = :in_p2,
F_TRM_CODE = :in_p3,
F_TRM_CONTEXT = :in_p4,
F_TRM_ID = :in_F_TRM_ID
where (F_TRM_ID = :in_F_TRM_ID) and
(
F_ND_ID is distinct from :in_p0 or
F_TRM_TARGET_APPS is distinct from :in_p1 or
F_TRM_KIND is distinct from :in_p2 or
F_TRM_CODE is distinct from :in_p3 or
F_TRM_CONTEXT is distinct from :in_p4
);
end

out_result = 'OK';
suspend;
exit;
end

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (T_TRANSLATION_META INDEX (PK_T_TRANSLATION_META))
PLAN (T_TRANSLATION_META INDEX (PK_T_TRANSLATION_META))

param0 = bigint, "1"
param1 = bigint, "-1"
param2 = smallint, "1"
param3 = varchar(2048), "тренеровка 1"
param4 = varchar(800), "<NULL>"
param5 = bigint, "3310709"

1 records fetched
600 ms, 38 read(s), 1872 fetch(es), 7 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$INDEX_SEGMENTS 144
RDB$INDICES 84
RDB$RELATION_CONSTRAINTS 146
RDB$REF_CONSTRAINTS 589
RDB$CHARACTER_SETS 1
RDB$COLLATIONS 1
T_TRANSLATION_META 1 1
T_NODE 1
X_TRANSLATION_META 1
Fixed
FV-9191 Performance DBCommitTransaction II Resolved 23/02/18 Database Use technology from FV-9185 Fixed
FV-9192 Performance INT_PAR_SCORE_TOP Resolved 23/02/18 Database   Fixed
FV-9196 Stable F4 support tool should still allow Fast 4 download Resolved 24/02/18 Support It is a bit silly to allow beta and alpha and not allow stable F4 Fixed
FV-9197 SQL engine in Cloudserver helper Resolved 24/02/18 Framework Run script on all databases Fixed
FV-9205 Performance SES_NEXT_ENABLE Resolved 24/02/18 Database Procedure SES_NEXT_ENABLE:
param0 = bigint, "596440"
param1 = timestamp, "2018-02-24T20:40:00.0000"

10 ms, 65 read(s), 1180 fetch(es), 4 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
T_FUNBOO 2
T_PARTICIPANT 1
T_SESSION_SETUP 75
T_SESSION 651 1
T_SETTING_META 1
Fixed
FV-9207 delete helper tables (s_person, s_project and z_location_request) on cloud Resolved 24/02/18 Database these tables aren't needed on the server Fixed
FV-9212 KIOSK CAMERA COUNTER should be default true Resolved 25/02/18 Kiosk   Fixed
FV-9213 Performance Welcome Emails Resolved 01/03/18   Look in Before file for sql Fixed
FV-9215 Performance Clean Automail Queue Resolved 01/03/18 Femailer   Fixed
FV-9222 Performance ConnectionPooling Resolved 28/02/18 Femailer Hi Angelina

It looks like you are permanently connecting and disconnecting the automailer from the database. Your connection and transactionmanagement can be improved a lot and this will reduce the burden on the servers. Especially on slower servers.

You can see on the screenshot that it is triggering this heartbeat every second or so?

!image-2018-02-26-08-50-42-462.png|thumbnail!
Fixed
FV-9225 Surveypage doesn't have a scrollbox on small resolutions Resolved 26/02/18 Configurator, Kiosk you can't see the full window and change all settings on low resolutions Fixed
FV-9226 Scrollviewer in SurveyQuestion Resolved 26/02/18 Configurator !image-2018-02-26-16-07-07-986.png|thumbnail! Fixed
FV-9229 Increase size of TRM_CODE Resolved 28/02/18 Database Make size of translatable names a bit bigger

not possible, index failures
Fixed
FV-9231 Enforce restrictions on upgrader to reduce mistakes Resolved 27/02/18 Upgrader make sure that upgrades fails when INet gold is active and check for activity box Fixed
FV-9232 Do not show scoreboard without participants Resolved 28/02/18 TV When participants are shown on scoreboard by page, empty pages are also shown.

You have 26 drivers and 3 page with 10 participants on each - all pages should be displayed, you have only 3 participants , but 2 empty pages still displayed.
Fixed
FV-9235 MailBanner setting is obsolete Resolved 27/02/18 Configurator It's obsolete on all race result reports Fixed
FV-9237 Do not show podium if there is no finished race Resolved 28/02/18 TV Do not show podium if there was no finished races to show.

Implement scene validator
Fixed
FV-9240 Shah Alam membercard encoding Resolved 28/02/18 Booking Client has different encodings for different cards, scanner gives me this data:

15066==313=015066=514
==249=015001=376
Fixed
FV-9243 Only store backups 3 weeks to be complient with the GDPR law Resolved 28/02/18 Framework   Fixed
FV-9244 Online webmodules listen to scoregroup 'show online' setting Resolved 28/02/18 Web modules there is a field on T_SCORE_GROUP f_scg_online something.

This field allows you to filter which scoregroup needs to show online or not.

Webmodules should listen to this.
Fixed
FV-9250 Copy passing Resolved 03/03/18 Timing Select a passing and make a copy of it.

Copy time, transponder, kart.
Fixed
FV-9251 New passing - order transponder by kart numbers Resolved 02/03/18 Timing Now it's sorted by transponder code Fixed
FV-9261 Passings list more fieds by default Resolved 03/03/18 Timing Pit marshal need to see heat name, driver and kart Fixed
FV-9262 Insert kart assignment passing Resolved 03/03/18 Timing It's crusial to be able to insert kart assignment passing to fix assignemnt sometimes Fixed
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk