Versions Compared

Old Version 17

changes.mady.by.user Jesper André Grønkjær Lyngesen Pedersen

Saved on

compared with

New Version 18

changes.mady.by.user Lene Andersen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejs
{
  "version": "42e17e1cb3ea8d8abd21d87252b14a136020e7c0",
  "registry.db": "OK: 0 entries currently enqueued for repository deletion.",
  "sdm.db": "OK: Database connnection available.",
  "repository.db": "OK"
}

Bemærk at det er angivet hvor mange dokumenter der pt. ligger i kø til sletning.

...

Code Block
languagejs
{
  "version": "42e17e1cb3ea8d8abd21d87252b14a136020e7c0",
  "registry.db": "ERROR: 7 entries could not be deleted from repository.",
  "sdm.db": "OK: Database connnection available.", 
  "repository.db": "OK" 
}

Konfiguration

...

PropertyBeskrivelse
datasource.nxrg.jndi.nameJNDI navnet på den datasource der giver adgang til NXRG databasen.
datasource.openxds.jndi.nameJNDI navnet på den datasource der giver adgang til OpenXDS databasen.

datasource.sdm.jndi.name

JNDI navnet på den datasource der giver adgang til SDM databasen (v2_Person tabellen).
deletion.document.cleanup.specificationsKomma-separeret liste af oprydningskriterier. Angiver hvilke dokumenttyper der slettes, og hvornår de slettes. Et oprydningskriterium har formen <code-name>#<code-scheme>#<months-to-keep>, hvor <code-name> og <code-scheme> angiver dokumenttypen der skal slettes, og <months-to-keep> angiver hvor mange måneder der skal gå, før sletningen udføres. Værdien af <months-to-keep> skal være et positivt heltal. De to andre værdier kan være vilkårlige strenge, så længe de ikke indeholder kommaer.
deletion.batchsizeAntal dokumenter der forsøges slettet i registry per dokumenttype i en kørsel af jobbet.
deletion.repository.batchsizeAntal dokumenter der forsøges slettet i repository i en kørsel af jobbet.
deletion.max.attemptsAntal gange sletning fra repository'et forsøges, før sletningen markeres som 'fejlet'.
deletion.in.clause.max.sizeMaksimal størrelse på in-clause i sql-queries.
deletion.save.status90.docs

Angiver en periode tilbage i tiden hvor dokumenter hørende til personer med status 90 kan slettes.

Eksempler på værdier er:

"2Y"    (for 2 år)

"12M"  (for 12 måneder)

"90D"  (for 90 dage)

allowed.execution.time.minutes

Antal minutter, som en oprydningsiteration (et request til /cleanup) maksimalt må køre. Servicen indeholder checkpoints på passende steder, hvor køretiden tjekkes, og kørslen afsluttes hvis den maksimale køretid er overskredet.

Hvis køretiden overskrides, vil dette fremgå af response-body'en og applikationsloggen.

deletion.log.remaining.interval

Angiver en periode - hvor tit "beregning af resterende data" skal køres. Hvis parameteren ikke er angivet, er den standard til perioden på 1 time. Formatering er i standard java.time.Duration.

Eksempler på værdier er:

"PT1H" (for 1 time )

"PT15M" (for 15 minutter )

...

Code Block
2022-02-28 14:40:01,019 [INFO] dk.nsp.xdscleanup.ws.CleanupServlet - Attempting to run XDS Cleanup.
2022-02-28 14:40:01,020 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Performing iteration of XDS Cleanup ...
2022-02-28 14:40:01,020 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Preparing registry deletion.
2022-02-28 14:40:01,029 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleting DocumentEntries. Deletion parameters: [ typeCode: TypeCode[codeName=39289-4,codeScheme=2.16.840.1.113883.6.1], latestStartTime: 2021-12-28T13:40:01.020Z, batchSize: 3 ]
2022-02-28 14:40:01,497 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleted DocumentEntries are: [ DocumentEntry[entryId=1,entryUuid=urn:uuid:03437e9f-24ee-4ca3-81b5-bd9222b0a221,uniqueId=7365138326801008407.4732229697929786785.1638782612783], DocumentEntry[entryId=2,entryUuid=urn:uuid:523eb18f-10a3-4ec8-8518-1e33b6c54a54,uniqueId=6313982942207370191.4718769210813691557.1638782616933], DocumentEntry[entryId=3,entryUuid=urn:uuid:050fc787-17a1-4c07-91eb-adb61fefc31e,uniqueId=7503668617814493420.8306293344729713893.1638782619079] ]
2022-02-28 14:40:01,497 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted DocumentEntries is: 3
2023-05-02 10:23:34,348 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - status90DeletionDate found in database is: 2021-07-02
2023-05-02 10:23:34,348 [INFO] dk.nsp.xdscleanup.sdm.dao.impl.SdmDaoImpl - deletionStatus90StartDate used in SQL is: 2022-05-02
2023-05-02 10:23:34,350 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of cpr numbers belonging to citizens with status=90 is: 2
2023-05-02 10:23:34,370 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleted DocumentEntries belonging to citizens with status=90 are: [ DocumentEntry[entryId=3,entryUuid=urn:uuid:050fc787-17a1-4c07-91eb-adb61fefc31e,uniqueId=7503668617814493420.8306293344729713893.1638782619079], DocumentEntry[entryId=78,entryUuid=urn:uuid:10000000-0000-0000-0000-000000000002,uniqueId=4793974228853511084.5371166327631397721.1644933987570], DocumentEntry[entryId=4,entryUuid=urn:uuid:0ca2e230-580e-474e-b476-fdc93e2404ba,uniqueId=5332548703973764893.7687975263626378293.1638782620291], DocumentEntry[entryId=77,entryUuid=urn:uuid:10000000-0000-0000-0000-000000000001,uniqueId=4690391827874153470.1037422710690395462.1644933979255] ]
2023-05-02 10:23:34,371 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted DocumentEntries belonging to citizens with status=90 is: 4 2022-02-28 14:40:01,498 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Preparing repository deletion.
2022-02-28 14:40:01,499 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleting documents. Deletion parameters: [ batchSize: 6 ] 
2022-02-28 14:40:01,508 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Attempting to delete Documents: [ DeletedDocumentEntry[entryId=1,entryUuid=urn:uuid:03437e9f-24ee-4ca3-81b5-bd9222b0a221,uniqueId=7365138326801008407.4732229697929786785.1638782612783], DeletedDocumentEntry[entryId=2,entryUuid=urn:uuid:523eb18f-10a3-4ec8-8518-1e33b6c54a54,uniqueId=6313982942207370191.4718769210813691557.1638782616933], DeletedDocumentEntry[entryId=3,entryUuid=urn:uuid:050fc787-17a1-4c07-91eb-adb61fefc31e,uniqueId=7503668617814493420.8306293344729713893.1638782619079] ]
2022-02-28 14:40:01,509 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Attempting deletion for 3 Documents.
2022-02-28 14:40:01,548 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Documents deleted are: [ DeletedDocumentEntry[entryId=1,entryUuid=urn:uuid:03437e9f-24ee-4ca3-81b5-bd9222b0a221,uniqueId=7365138326801008407.4732229697929786785.1638782612783], DeletedDocumentEntry[entryId=2,entryUuid=urn:uuid:523eb18f-10a3-4ec8-8518-1e33b6c54a54,uniqueId=6313982942207370191.4718769210813691557.1638782616933], DeletedDocumentEntry[entryId=3,entryUuid=urn:uuid:050fc787-17a1-4c07-91eb-adb61fefc31e,uniqueId=7503668617814493420.8306293344729713893.1638782619079] ]
2022-02-28 14:40:01,548 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted Documents is: 3
2022-02-28 14:40:01,548 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Documents not deleted are: [  ]
2022-02-28 14:40:01,548 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of not deleted Documents is: 0
2022-02-28 14:40:01,548 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Marking successful deletion.
2022-02-28 14:40:01,557 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - XDS Cleanup iteration finished!

I dette eksempel køres med batchSize for registry 3 og batchsize 6 for repository, og det ses at der slettes tre DocumentEntries i registry'et, og derefter tre tilsvarende Documents i repository'et.


En logning, hvor der slettes dokumenter for afdøde personer kan se sådan her ud:

Code Block
2023-05-02 10:22:50,477 [INFO] dk.nsp.xdscleanup.ws.CleanupServlet - Attempting to run XDS Cleanup.
2023-05-02 10:22:50,477 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Performing iteration of XDS Cleanup ...
2023-05-02 10:22:50,477 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Preparing registry deletion.
2023-05-02 10:22:50,482 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleting DocumentEntries. Deletion parameters: [ typeCode: TypeCode[codeName=39289-4,codeScheme=2.16.840.1.113883.6.1], latestStartTime: 2021-05-02T08:22:50.477Z, batchSize: 5000 ]
2023-05-02 10:22:50,614 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleted DocumentEntries are: [  ]
2023-05-02 10:22:50,614 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted DocumentEntries is: 0
2023-05-02 10:22:50,615 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleting DocumentEntries. Deletion parameters: [ typeCode: TypeCode[codeName=39290-2,codeScheme=2.16.840.1.113883.6.1], latestStartTime: 2020-05-02T08:22:50.477Z, batchSize: 5000 ]
2023-05-02 10:22:50,617 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleted DocumentEntries are: [  ]
2023-05-02 10:22:50,617 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted DocumentEntries is: 0
2023-05-02 10:22:50,621 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - status90DeletionDate found in database is: 2021-06-30
2023-05-02 10:22:50,621 [INFO] dk.nsp.xdscleanup.sdm.dao.impl.SdmDaoImpl - deletionStatus90StartDate used in SQL is: 2022-05-02
2023-05-02 10:22:50,627 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of cpr numbers belonging to citizens with status=90 is: 1
2023-05-02 10:22:50,647 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleted DocumentEntries belonging to citizens with status=90 are: [ DocumentEntry[entryId=76,entryUuid=urn:uuid:10000000-0000-0000-0000-000000000000,uniqueId=4682766369101783014.222192126889641226.1644933984067] ]
2023-05-02 10:22:50,647 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted DocumentEntries belonging to citizens with status=90 is: 1
2023-05-02 10:22:50,647 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Preparing repository deletion.
2023-05-02 10:22:50,647 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Deleting documents. Deletion parameters: [ batchSize: 10000 ]
2023-05-02 10:22:50,649 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Attempting to delete Documents: [ DeletedDocumentEntry[entryId=1,entryUuid=urn:uuid:10000000-0000-0000-0000-000000000000,uniqueId=4682766369101783014.222192126889641226.1644933984067] ]
2023-05-02 10:22:50,649 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Attempting deletion for 1 Documents.
2023-05-02 10:22:50,657 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Documents deleted are: [ DeletedDocumentEntry[entryId=1,entryUuid=urn:uuid:10000000-0000-0000-0000-000000000000,uniqueId=4682766369101783014.222192126889641226.1644933984067] ]
2023-05-02 10:22:50,657 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of deleted Documents is: 1
2023-05-02 10:22:50,657 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Documents not deleted are: [  ]
2023-05-02 10:22:50,657 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Number of not deleted Documents is: 0
2023-05-02 10:22:50,657 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Marking successful deletion.
2023-05-02 10:22:50,663 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - Residual Documents Update for Repository: '0' documents left to be deleted
2023-05-02 10:22:50,663 [INFO] dk.nsp.xdscleanup.service.impl.CleanupServiceImpl - XDS Cleanup iteration finished! Time spent: 0 seconds.