Random SQL-errors from journaltransactions

[adrianm]

I randomly get some internal error message when posting journal transactions (like 1 in 20 or so). Error is on different requests every time.

The same request works fine with 2 or 3 retries.

How do we proceed?

Visma.Net: POST: https://integration.visma.net/API/controller/api/v2/journaltransaction
Headers: {
    Accept: application/json
    Authorization: <hidden>
    Accept-Encoding: gzip    Accept-Encoding: deflate
    Request-Id: |gF8GNmNHyO4=.c7571599_14.
    Content-Type: application/json; charset=utf-8
    Content-Length: 2014
}
{"transactionDate":{"value":"2023-09-01T00:00:00"},"financialPeriod":{"value":"202309"},"ledger":{"value":"1"},"currencyId":{"value":"SEK"},"description":{"value":"hidden"},"createVatTransaction":{"value":true},"skipVatAmountValidation":{"value":true},"journalTransactionLines":[{"operation":"Insert","accountNumber":{"value":"1513"},"transactionDescription":{"value":"hidden"},"debitAmountInCurrency":{"value":5172}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":3136},"vatCodeId":{"value":"04"}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":1720},"vatCodeId":{"value":"04"}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":316},"vatCodeId":{"value":"04"}}]}
Response: 400 Bad Request
Headers: {
    Date: Tue, 05 Sep 2023 11:42:50 GMT
    Server: Nginx
    Strict-Transport-Security: max-age=31536000; includeSubDomains    Strict-Transport-Security: max-age=31536000; includeSubDomains
    ipp-request-id: 02a7a1a9-ccca-49ed-9237-149d395daaad
    X-Content-Type-Options: application/json
    Pragma: no-cache
    X-Handled-By: Visma-PX.Export/AuthenticationManagerModule
    Referrer-Policy: origin-when-cross-origin
    VnfInstanceId: ERP_SE_REAL_0045
    Cache-Control: no-cache
    X-XSS-Protection: 1;mode=block
    Set-Cookie: <crumbs>;  path=/;  secure;  expires=Mon, 04-Sep-2023 11:42:49 GMT;  HttpOnly
    Connection: close
    Transfer-Encoding: chunked
    Content-Type: application/json; charset=utf-8
    Expires: -1
}
{"message":"VismaId: 02a7a1a9-ccca-49ed-9237-149d395daaad. Error creating journal transaction. Cannot insert the value NULL into column 'LedgerID', table 'ERP_SE_REAL_0045.dbo.GLTran'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}

[Yıldırım]

Since when are you experiencing this ? What token are you using ? Do you make a parallel or consecutive (short interval) calls to the same endpoint ?
Please send your application details and companyID to us.