Update in Exact Online administratie werkt door in andere Exact Online administratie

Vragen
,
1

Als ik de volgende code uitvoer, dan verschijnt de nieuwe waarde van notes altijd in de administratie met divisie 2221353, terwijl de update zowel via use als via where gestuurd wordt naar de administratie met divisie 2883824.

Hoe pas ik de contactpersoon aan in divisie 2883824 en niet in 2221353?

set log-native-calls-to-disk true

use 2221353

select /*+ http_disk_cache(false) http_memory_cache(false) */ division
,      id
,      notes
,      fullname
,      accountname
,      modified
,      created
from   Exactonlinerest..contacts ctt
where  notes is not null
and    notes like 'EOL%'
and    division = 2221353
order
by     modified desc

update Exactonlinerest..contacts
set    notes = trim(regexp_replace(notes, '^(EOL ID: ([0-9a-f-]*)(|\n))*', '', 1, 0, 'm'))
where  notes is not null
and    notes like 'EOL%'
and    division = 2221353

--
-- Check that no row matches anymore.
--
select /*+ http_disk_cache(false) http_memory_cache(false) */ division
,      id
,      notes
,      fullname
,      accountname
,      modified
,      created
from   Exactonlinerest..contacts ctt
where  notes is not null
and    notes like 'EOL%'
and    division = 2221353
order
by     modified desc

use 2883824

update exactonlinerest..contacts
set    notes = 'EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413'
where  division = 2883824 
and    id = '5f44ca5d-35e0-4d3e-9991-85f8b7f54833'

use 2221353

--
-- And there is a row again.
--
select /*+ http_disk_cache(false) http_memory_cache(false) */ division
,      id
,      notes
,      fullname
,      accountname
,      modified
,      created
from   Exactonlinerest..contacts ctt
where  notes is not null
and    notes like 'EOL%'
and    division = 2221353
order
by     modified desc
2

Dit probleem is bestudeerd aan de hand van de meegestuurde native call log uit log-native-calls-to-disk.

Het blijkt uit de call log en uit de inhoud van sessionios@datadictionary dat de API-calls toch echt naar de juiste Exact Online-administratie gaan, maar dat somehow Exact zelf beslist dat de mutatie in een andere administratie moet plaatsvinden.

Het probleem lijkt beperkt tot een beperkt aantal contactpersonen en treedt ook niet op bij tests met een andere administratie. Een ticket is ingediend bij Exact Online hierover met nummer 04135564.

3

Native Call Log Part 1

--
-- use 2221353
-- 
-- select /*+ http_disk_cache(false) http_memory_cache(false) */ division
-- ,      id
-- ,      notes
-- ,      fullname
-- ,      accountname
-- ,      modified
-- ,      created
-- from   Exactonlinerest..contacts ctt
-- where  notes is not null
-- and    notes like 'EOL%'
-- and    division = 2221353
-- order
-- by     modified desc
--

--
-- 2023-02-13T13:02:40.4639776Z
-- Select Contacts from 2221353
--

{"Url":"https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL')%20and%20Notes%20ne%20null","Success":true,"CallDirection":0,"Id":1,"DateRegisteredUtc":"2023-02-13T13:02:40.4639776Z","RequestBodyAsString":"","ResponseBodyAsString":"{\r\n\"d\" : {\r\n\"results\": [\r\n{\r\n\"__metadata\": {\r\n\"uri\": \"https://start.exactonline.nl/api/v1/2221353/crm/Contacts(guid'b1cf1874-babe-48e3-8810-10ae1992b413')\", \"type\": \"Exact.Web.Api.Models.Contact\"\r\n}, \"ID\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"Account\": \"30987701-f82a-453b-bc2e-e8eb42f669d6\", \"AccountIsCustomer\": true, \"AccountIsSupplier\": false, \"AccountMainContact\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"AccountName\": \"ACME\", \"AddressLine2\": null, \"AddressStreet\": null, \"AddressStreetNumber\": null, \"AddressStreetNumberSuffix\": null, \"BirthDate\": null, \"BirthName\": \"John Doe\", \"BirthNamePrefix\": null, \"BirthPlace\": null, \"BusinessEmail\": \"facturen@ACME.nl\", \"BusinessFax\": null, \"BusinessMobile\": null, \"BusinessPhone\": null, \"BusinessPhoneExtension\": null, \"City\": null, \"Code\": \"             70290\", \"Country\": \"NL \", \"Created\": \"\\/Date(1600344095630)\\/\", \"Creator\": \"27939401-ea94-4eed-a9e5-bddc6eb13666\", \"CreatorFullName\": \"Big Creator\", \"CustomField\": null, \"Division\": 2221353, \"Email\": \"facturen@ACME.nl\", \"EndDate\": null, \"FirstName\": null, \"FullName\": \"John Doe\", \"Gender\": \"M\", \"HID\": 2125474, \"IdentificationDate\": null, \"IdentificationUser\": null, \"IdentificationDocument\": null, \"Initials\": null, \"IsAnonymised\": 0, \"IsMailingExcluded\": false, \"IsMainContact\": true, \"JobTitleDescription\": null, \"Language\": \"NL        \", \"LastName\": \"John Doe\", \"MarketingNotes\": null, \"MiddleName\": null, \"Mobile\": null, \"Modified\": \"\\/Date(1676296899940)\\/\", \"Modifier\": \"949522c4-7c12-443a-937c-0a88284c8bfb\", \"ModifierFullName\": \"ServiceAccount\", \"Nationality\": null, \"Notes\": \"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413\", \"PartnerName\": null, \"PartnerNamePrefix\": null, \"Person\": \"048782fb-8212-4c48-ab2b-85c038320f84\", \"Phone\": null, \"PhoneExtension\": null, \"Picture\": null, \"PictureName\": null, \"PictureUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"PictureThumbnailUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"Postcode\": null, \"SocialSecurityNumber\": null, \"StartDate\": \"\\/Date(1600300800000)\\/\", \"State\": null, \"Title\": null, \"LeadPurpose\": null, \"LeadSource\": null, \"AllowMailing\": null\r\n}\r\n]\r\n}\r\n}","StartUtc":"2023-02-13T13:02:40.2453913Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":215,"ProcessId":28464,"Uid":"f8d3889f-a1d0-43a4-adcf-d86131a48fa9","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"GET","MessageCode":"itgenoda435","CallUid":"7f528712-35c1-4bf6-9d83-656f9da3e5f6","ResponseStatus":"OK","PartitionCode":"2221353","DataContainerId":"https://start.exactonline.nl/64309169","UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 5\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 23.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: 2299\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL') and Notes ne null\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader Content-Length: 2299\r\nHeader Content-Type: application/json;charset=utf-8\r\nHeader DataServiceVersion: 2.0;\r\nHeader Date: Mon, 13 Feb 2023 13:02:40 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret2; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret3; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 59\r\nHeader X-RateLimit-Minutely-Reset: 1676293380000\r\nHeader X-RateLimit-Remaining: 4550\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Authorization=Bearer secret,Host=start.exactonline.nl,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=2.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4550,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=59,X-RateLimit-Minutely-Reset=1676293380000,Connection=keep-alive,Content-Length=2299,Cache-Control=no-cache, no-store,Content-Type=application/json;charset=utf-8,Date=Mon, 13 Feb 2023 13:02:40 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret2; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret3; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}

--
-- update Exactonlinerest..contacts
-- set    notes = trim(regexp_replace(notes, '^(EOL ID: ([0-9a-f-]*)(|\n))*', '', 1, 0, 'm'))
-- where  notes is not null
-- and    notes like 'EOL%'
-- and    division = 2221353
--
-- 2023-02-13T13:02:42.7917897Z
-- Select Contacts from 2221353 for update
--

{"Url":"https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL')%20and%20Notes%20ne%20null","Success":true,"CallDirection":0,"Id":2,"DateRegisteredUtc":"2023-02-13T13:02:42.7917897Z","RequestBodyAsString":"","ResponseBodyAsString":"{\r\n\"d\" : {\r\n\"results\": [\r\n{\r\n\"__metadata\": {\r\n\"uri\": \"https://start.exactonline.nl/api/v1/2221353/crm/Contacts(guid'b1cf1874-babe-48e3-8810-10ae1992b413')\", \"type\": \"Exact.Web.Api.Models.Contact\"\r\n}, \"ID\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"Account\": \"30987701-f82a-453b-bc2e-e8eb42f669d6\", \"AccountIsCustomer\": true, \"AccountIsSupplier\": false, \"AccountMainContact\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"AccountName\": \"ACME\", \"AddressLine2\": null, \"AddressStreet\": null, \"AddressStreetNumber\": null, \"AddressStreetNumberSuffix\": null, \"BirthDate\": null, \"BirthName\": \"John Doe\", \"BirthNamePrefix\": null, \"BirthPlace\": null, \"BusinessEmail\": \"facturen@ACME.nl\", \"BusinessFax\": null, \"BusinessMobile\": null, \"BusinessPhone\": null, \"BusinessPhoneExtension\": null, \"City\": null, \"Code\": \"             70290\", \"Country\": \"NL \", \"Created\": \"\\/Date(1600344095630)\\/\", \"Creator\": \"27939401-ea94-4eed-a9e5-bddc6eb13666\", \"CreatorFullName\": \"Big Creator\", \"CustomField\": null, \"Division\": 2221353, \"Email\": \"facturen@ACME.nl\", \"EndDate\": null, \"FirstName\": null, \"FullName\": \"John Doe\", \"Gender\": \"M\", \"HID\": 2125474, \"IdentificationDate\": null, \"IdentificationUser\": null, \"IdentificationDocument\": null, \"Initials\": null, \"IsAnonymised\": 0, \"IsMailingExcluded\": false, \"IsMainContact\": true, \"JobTitleDescription\": null, \"Language\": \"NL        \", \"LastName\": \"John Doe\", \"MarketingNotes\": null, \"MiddleName\": null, \"Mobile\": null, \"Modified\": \"\\/Date(1676296899940)\\/\", \"Modifier\": \"949522c4-7c12-443a-937c-0a88284c8bfb\", \"ModifierFullName\": \"ServiceAccount\", \"Nationality\": null, \"Notes\": \"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413\", \"PartnerName\": null, \"PartnerNamePrefix\": null, \"Person\": \"048782fb-8212-4c48-ab2b-85c038320f84\", \"Phone\": null, \"PhoneExtension\": null, \"Picture\": null, \"PictureName\": null, \"PictureUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"PictureThumbnailUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"Postcode\": null, \"SocialSecurityNumber\": null, \"StartDate\": \"\\/Date(1600300800000)\\/\", \"State\": null, \"Title\": null, \"LeadPurpose\": null, \"LeadSource\": null, \"AllowMailing\": null\r\n}\r\n]\r\n}\r\n}","StartUtc":"2023-02-13T13:02:42.6215407Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":216,"ProcessId":28464,"Uid":"84df3fac-5350-441f-aa6c-0367b6ad3618","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"GET","MessageCode":"itgenoda435","CallUid":"8eb60afa-e96c-47af-a2c6-89e6921ea63d","ResponseStatus":"OK","PartitionCode":"2221353","DataContainerId":"https://start.exactonline.nl/64309169","UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 5\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 23.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: 2299\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL') and Notes ne null\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader Content-Length: 2299\r\nHeader Content-Type: application/json;charset=utf-8\r\nHeader DataServiceVersion: 2.0;\r\nHeader Date: Mon, 13 Feb 2023 13:02:42 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret4; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret5; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 58\r\nHeader X-RateLimit-Minutely-Reset: 1676293380000\r\nHeader X-RateLimit-Remaining: 4549\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Authorization=Bearer secret,Host=start.exactonline.nl,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=2.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4549,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=58,X-RateLimit-Minutely-Reset=1676293380000,Connection=keep-alive,Content-Length=2299,Cache-Control=no-cache, no-store,Content-Type=application/json;charset=utf-8,Date=Mon, 13 Feb 2023 13:02:42 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret4; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret5; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}

--
-- Perform actual update for selected (single) ID.
--
-- 2023-02-13T13:02:43.1004913Z
-- Update Contact b1cf1874-babe-48e3-8810-10ae1992b413 on 2221353
-- Value set: {\"Notes\":null}
--

{"Url":"https://start.exactonline.nl/api/v1/2221353/crm/Contacts(guid'b1cf1874-babe-48e3-8810-10ae1992b413')","Success":true,"CallDirection":0,"Id":3,"DateRegisteredUtc":"2023-02-13T13:02:43.1004913Z","RequestBodyAsString":"{\"Notes\":null}","ResponseBodyAsString":"","StartUtc":"2023-02-13T13:02:42.8003893Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":216,"ProcessId":28464,"Uid":"eef05b58-97f6-427f-907d-b4f3758ed683","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"PUT","MessageCode":"itgenoda435","CallUid":"509cce10-4bd8-4829-b1b6-a5160dc75626","ResponseStatus":"NoContent","PartitionCode":"2221353","DataContainerId":"https://start.exactonline.nl/64309169","Parameters":[{"Name":"NOTES","DotnetDataType":"string","IsDefaultValue":false,"ExcludeFromLogging":false}],"UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 50\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 57.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Content-Length: 14\r\nRequest header Content-Type: application/json; charset=utf-8\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: -1\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2221353/crm/Contacts(guid'b1cf1874-babe-48e3-8810-10ae1992b413')\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader DataServiceVersion: 1.0;\r\nHeader Date: Mon, 13 Feb 2023 13:02:42 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret7; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret6; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 57\r\nHeader X-RateLimit-Minutely-Reset: 1676293380000\r\nHeader X-RateLimit-Remaining: 4548\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Content-Type=application/json; charset=utf-8,Authorization=Bearer secret,Host=start.exactonline.nl,Content-Length=14,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=1.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4548,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=57,X-RateLimit-Minutely-Reset=1676293380000,Connection=keep-alive,Cache-Control=no-cache, no-store,Date=Mon, 13 Feb 2023 13:02:42 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret7; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret6; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}

--
-- Check that no row matches anymore.
--
-- select /*+ http_disk_cache(false) http_memory_cache(false) */ division
-- ,      id
-- ,      notes
-- ,      fullname
-- ,      accountname
-- ,      modified
-- ,      created
-- from   Exactonlinerest..contacts ctt
-- where  notes is not null
-- and    notes like 'EOL%'
-- and    division = 2221353
-- order
-- by     modified desc
--
--
-- 2023-02-13T13:02:50.0904219Z
-- Select Contacts from 2221353
--

{"Url":"https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL')%20and%20Notes%20ne%20null","Success":true,"CallDirection":0,"Id":4,"DateRegisteredUtc":"2023-02-13T13:02:50.0904219Z","RequestBodyAsString":"","ResponseBodyAsString":"{\r\n\"d\" : {\r\n\"results\": [\r\n\r\n]\r\n}\r\n}","StartUtc":"2023-02-13T13:02:49.8158804Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":217,"ProcessId":28464,"Uid":"1551b8c7-0b73-4023-adc3-87fa9c11e189","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"GET","MessageCode":"itgenoda435","CallUid":"291e3e76-b146-4963-9d12-03519329e837","ResponseStatus":"OK","PartitionCode":"2221353","DataContainerId":"https://start.exactonline.nl/64309169","UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 5\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 23.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: 35\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL') and Notes ne null\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader Content-Length: 35\r\nHeader Content-Type: application/json;charset=utf-8\r\nHeader DataServiceVersion: 2.0;\r\nHeader Date: Mon, 13 Feb 2023 13:02:49 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret11; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret8; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 56\r\nHeader X-RateLimit-Minutely-Reset: 1676293380000\r\nHeader X-RateLimit-Remaining: 4547\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Authorization=Bearer secret,Host=start.exactonline.nl,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=2.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4547,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=56,X-RateLimit-Minutely-Reset=1676293380000,Connection=keep-alive,Content-Length=35,Cache-Control=no-cache, no-store,Content-Type=application/json;charset=utf-8,Date=Mon, 13 Feb 2023 13:02:49 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret11; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret8; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}
4

Native Call Log Part 2

--
-- UPDATE 2 (directly using ID, so no select).
--
-- use 2883824
-- 
-- update exactonlinerest..contacts
-- set    notes = 'EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413'
-- where  division = 2883824 
-- and    id = '5f44ca5d-35e0-4d3e-9991-85f8b7f54833'
--

--
-- 2023-02-13T13:03:03.7311402Z
-- Update Contact 5f44ca5d-35e0-4d3e-9991-85f8b7f54833 on 2883824.
-- Value set: {\"Notes\":\"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413\"}
--

{"Url":"https://start.exactonline.nl/api/v1/2883824/crm/Contacts(guid'5f44ca5d-35e0-4d3e-9991-85f8b7f54833')","Success":true,"CallDirection":0,"Id":5,"DateRegisteredUtc":"2023-02-13T13:03:03.7311402Z","RequestBodyAsString":"{\"Notes\":\"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413\"}","ResponseBodyAsString":"","StartUtc":"2023-02-13T13:03:03.3707227Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":218,"ProcessId":28464,"Uid":"a1b08130-8dc1-4cf4-bb73-05452eab62eb","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"PUT","MessageCode":"itgenoda435","CallUid":"7915a2e6-ff34-40d8-9bb1-8df8a7bfb451","ResponseStatus":"NoContent","PartitionCode":"2883824","DataContainerId":"https://start.exactonline.nl/64309169","Parameters":[{"Name":"NOTES","DotnetDataType":"string","Value":"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413","IsDefaultValue":false,"ExcludeFromLogging":false}],"UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 50\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 57.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Content-Length: 56\r\nRequest header Content-Type: application/json; charset=utf-8\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: -1\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2883824/crm/Contacts(guid'5f44ca5d-35e0-4d3e-9991-85f8b7f54833')\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader DataServiceVersion: 1.0;\r\nHeader Date: Mon, 13 Feb 2023 13:03:03 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret12; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2883824; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret9; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 59\r\nHeader X-RateLimit-Minutely-Reset: 1676293440000\r\nHeader X-RateLimit-Remaining: 4579\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Content-Type=application/json; charset=utf-8,Authorization=Bearer secret,Host=start.exactonline.nl,Content-Length=56,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=1.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4579,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=59,X-RateLimit-Minutely-Reset=1676293440000,Connection=keep-alive,Cache-Control=no-cache, no-store,Date=Mon, 13 Feb 2023 13:03:03 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret12; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2883824; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret9; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}

--
-- use 2221353
-- 
-- --
-- -- And there is a row again with the original value for Notes in division 2221353.
-- --
-- select /*+ http_disk_cache(false) http_memory_cache(false) */ division
-- ,      id
-- ,      notes
-- ,      fullname
-- ,      accountname
-- ,      modified
-- ,      created
-- from   Exactonlinerest..contacts ctt
-- where  notes is not null
-- and    notes like 'EOL%'
-- and    division = 2221353
-- order
-- by     modified desc
--
-- 2023-02-13T13:03:11.5060884Z
-- Select Contacts from 2221353
--

{"Url":"https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL')%20and%20Notes%20ne%20null","Success":true,"CallDirection":0,"Id":6,"DateRegisteredUtc":"2023-02-13T13:03:11.5060884Z","RequestBodyAsString":"","ResponseBodyAsString":"{\r\n\"d\" : {\r\n\"results\": [\r\n{\r\n\"__metadata\": {\r\n\"uri\": \"https://start.exactonline.nl/api/v1/2221353/crm/Contacts(guid'b1cf1874-babe-48e3-8810-10ae1992b413')\", \"type\": \"Exact.Web.Api.Models.Contact\"\r\n}, \"ID\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"Account\": \"30987701-f82a-453b-bc2e-e8eb42f669d6\", \"AccountIsCustomer\": true, \"AccountIsSupplier\": false, \"AccountMainContact\": \"b1cf1874-babe-48e3-8810-10ae1992b413\", \"AccountName\": \"ACME\", \"AddressLine2\": null, \"AddressStreet\": null, \"AddressStreetNumber\": null, \"AddressStreetNumberSuffix\": null, \"BirthDate\": null, \"BirthName\": \"John Doe\", \"BirthNamePrefix\": null, \"BirthPlace\": null, \"BusinessEmail\": \"facturen@ACME.nl\", \"BusinessFax\": null, \"BusinessMobile\": null, \"BusinessPhone\": null, \"BusinessPhoneExtension\": null, \"City\": null, \"Code\": \"             70290\", \"Country\": \"NL \", \"Created\": \"\\/Date(1600344095630)\\/\", \"Creator\": \"27939401-ea94-4eed-a9e5-bddc6eb13666\", \"CreatorFullName\": \"Big Creator\", \"CustomField\": null, \"Division\": 2221353, \"Email\": \"facturen@ACME.nl\", \"EndDate\": null, \"FirstName\": null, \"FullName\": \"John Doe\", \"Gender\": \"M\", \"HID\": 2125474, \"IdentificationDate\": null, \"IdentificationUser\": null, \"IdentificationDocument\": null, \"Initials\": null, \"IsAnonymised\": 0, \"IsMailingExcluded\": false, \"IsMainContact\": true, \"JobTitleDescription\": null, \"Language\": \"NL        \", \"LastName\": \"John Doe\", \"MarketingNotes\": null, \"MiddleName\": null, \"Mobile\": null, \"Modified\": \"\\/Date(1676296962593)\\/\", \"Modifier\": \"949522c4-7c12-443a-937c-0a88284c8bfb\", \"ModifierFullName\": \"ServiceAccount\", \"Nationality\": null, \"Notes\": \"EOL ID: b1cf1874-babe-48e3-8810-10ae1992b413\", \"PartnerName\": null, \"PartnerNamePrefix\": null, \"Person\": \"048782fb-8212-4c48-ab2b-85c038320f84\", \"Phone\": null, \"PhoneExtension\": null, \"Picture\": null, \"PictureName\": null, \"PictureUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"PictureThumbnailUrl\": \"https://start.exactonline.nl//docs/images/placeholder_contact_myeol.png\", \"Postcode\": null, \"SocialSecurityNumber\": null, \"StartDate\": \"\\/Date(1600300800000)\\/\", \"State\": null, \"Title\": null, \"LeadPurpose\": null, \"LeadSource\": null, \"AllowMailing\": null\r\n}\r\n]\r\n}\r\n}","StartUtc":"2023-02-13T13:03:11.198131Z","TableFullQualifiedName":"ExactOnlineREST.CRM.Contacts","MachineNameFull":"MYPC","UserLogonCodeWithDomain":"azuread\\mypc","ManagedThreadId":222,"ProcessId":28464,"Uid":"b5b1d336-03f5-472a-b0e6-2fab5f5218d3","GuiModuleName":"Invantive Query Tool","GuiModuleVersion":"22.1.134","GuiOsUser":"azuread\\mypc","GuiUser":"azuread\\mypc","MessageText":"GET","MessageCode":"itgenoda435","CallUid":"cf3bbaa3-13aa-4a9b-9f44-e955f287f2bd","ResponseStatus":"OK","PartitionCode":"2221353","DataContainerId":"https://start.exactonline.nl/64309169","UserLogOnCode":"ServiceAccounts","RequestContents":"Automatic decompression: GZip, Deflate\r\nMaximum automatic redirections: 5\r\nMaximum response headers length: 64\r\nProtocol version: 1.1\r\nTimeout: 23.000 ms\r\nContinue Timeout: 350 ms\r\nRead/write Timeout: 300.000 ms\r\nSend chunked: False\r\nRequest header Accept: application/json\r\nRequest header Accept-Encoding: gzip, deflate\r\nRequest header Authorization: Bearer secret\r\nRequest header Host: start.exactonline.nl\r\nRequest header User-Agent: USERAGENT\r\n","ResponseContents":"Content length: 2299\r\nIs from cache: False\r\nProtocol version: 1.1\r\nResponse URI: https://start.exactonline.nl/api/v1/2221353/crm/Contacts?$select=*&$filter=startswith(Notes,'EOL') and Notes ne null\r\nHeader Cache-Control: no-cache, no-store\r\nHeader Connection: keep-alive\r\nHeader Content-Length: 2299\r\nHeader Content-Type: application/json;charset=utf-8\r\nHeader DataServiceVersion: 2.0;\r\nHeader Date: Mon, 13 Feb 2023 13:03:11 GMT\r\nHeader Expires: -1\r\nHeader Pragma: no-cache\r\nHeader Referrer-Policy: strict-origin-when-cross-origin\r\nHeader Set-Cookie: ASP.NET_SessionId=secret13; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret10; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly\r\nHeader Strict-Transport-Security: max-age=31536000 ; includeSubDomains ; preload\r\nHeader X-Content-Type-Options: nosniff\r\nHeader X-RateLimit-Limit: 5000\r\nHeader X-RateLimit-Minutely-Limit: 60\r\nHeader X-RateLimit-Minutely-Remaining: 59\r\nHeader X-RateLimit-Minutely-Reset: 1676293440000\r\nHeader X-RateLimit-Remaining: 4546\r\nHeader X-RateLimit-Reset: 1676332800000\r\nHeader X-Xss-Protection: 1; mode=block\r\n","RequestHttpHeaders":"Accept=application/json,User-Agent=USERAGENT,Authorization=Bearer secret,Host=start.exactonline.nl,Accept-Encoding=gzip, deflate","ResponseHttpHeaders":"Pragma=no-cache,DataServiceVersion=2.0;,X-Xss-Protection=1; mode=block,X-Content-Type-Options=nosniff,Referrer-Policy=strict-origin-when-cross-origin,X-RateLimit-Limit=5000,X-RateLimit-Remaining=4546,X-RateLimit-Reset=1676332800000,X-RateLimit-Minutely-Limit=60,X-RateLimit-Minutely-Remaining=59,X-RateLimit-Minutely-Reset=1676293440000,Connection=keep-alive,Content-Length=2299,Cache-Control=no-cache, no-store,Content-Type=application/json;charset=utf-8,Date=Mon, 13 Feb 2023 13:03:11 GMT,Expires=-1,Set-Cookie=ASP.NET_SessionId=secret13; SameSite=lax; path=/; secure; HttpOnly; SameSite=Lax,ExactServer{949522c4-7c12-443a-937c-0a88284c8bfb}=Division=2221353; SameSite=lax; path=/; secure; HttpOnly,ExactOnlineClient=secret10; SameSite=lax; expires=Mon, 31-Dec-2198 23:00:00 GMT; path=/; secure; HttpOnly,Strict-Transport-Security=max-age=31536000 ; includeSubDomains ; preload"}
5

Er is een verdere analyse uitgevoerd samen met Exact.

Conclusie is dat dit niet een probleem is in de Invantive software of de Exact Online API. Het probleem is los te reproduceren in Exact Online. Het probleem treedt tot nu toe alleen op in Contactpersonen.

Exact Support gaat uitzoeken wat de oorzaak is.

6

De uiteindelijke oorzaak bleek een bug in Exact Online te zijn, mogelijk gerelateerd aan nieuwe functionaliteit voor Exact Online Premium. Exact Online Development zal hiervoor een fix uitbrengen.

7

Deze vraag is automatisch gesloten na 2 weken inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.