Solutions

SBM is not HTTP/2 compatible -- Submit failure - Duplicate attachments



ID:    S143012
Published:    07 October 2019
Updated:    15 May 2020

Product(s)

  • SBM
 

Description

With the introduction of Windows Server 2016, SBM can experience the following issues while HTTP/2 is enabled. HTTP/2 is used when HTTPS is used.  If you are not using HTTPS then this article does not apply.  We will update this article when we have release a version of SBM that is compatible with HTTP/2.
 
 
1. Anonymous submit to SBM shows an error like the following.

Error occurred in file: 'HtmlFormSubmit.cpp', line 585. User: Id 41, 'Anonymous Submit'
 
The transition "Submit" was not completed. Error attempting to add item to database. Database error: This operation could not be completed possibly because the database is read-only. [(|TTexcIDS_EXC_DB_IS_READ_ONLY|)] Violation of PRIMARY KEY constraint 'TKUSR_AUTH_REGRESSION'. Cannot insert duplicate key in object 'dbo.USR_TABLE'. The duplicate key value is (4). The statement has been terminated. Please contact your administrator.
 
2. Errors that may appear on the submit form when adding file attachments.
 
The attachment is added twice. The user removes the duplicate attachment, but when they go to submit it still says there are 2 attachments with the same name, and then they have to remove it again before the item will submit. 
 
3.  Error messages like this can found in Application Event log like:
 
Error occurred in file:
'ExecTransition.cpp', line 1364.
       One or more of the categories selected requires at least one attachment.  Please add the necessary attachments. 
 
4.  Users are able to submit and work in SBM most of the time, but randomly a submit or other transition will fail. When this happens, the user sees the following error in the browser:
Submit into: PROJECT-NAME

An error occurred while processing the last request.
Please contact your administrator.

The server was processing this URL when this message was created:
https://SERVER/workcenter/tmtrack.dll?shell=swc&ProjectPage&TableId=999&ProjectId=999&ContactId=0&Template=newbody&RecordId9999&TemporaryRecordID=0&FolderId=0& ProblemId=0&CopyTableId=0&CopyRecordID=0&Action=&PostTransitionId=0&&SolutionId=3&transid=493&redirecttemplate=shell/swc/dlgthanks
 
In the Event Viewer, errors such as these will appear:

The transition "Submit" was not completed.  Error attempting to add item to database.
Database error: This operation could not be completed
possibly because the database is read-only.
 [(|TTexcIDS_EXC_DB_IS_READ_ONLY|)]
Violation of PRIMARY KEY constraint 'TABLE-NAME'. Cannot insert duplicate key in object 'dbo.TABLE'. The duplicate key value is (99999).
The statement has been terminated.
 
OR

This operation could not be completed
possibly because the database is read-only.
    Violation of PRIMARY KEY constraint 'TABLE-NAME'. Cannot insert duplicate key in object 'dbo.TABLE'. The duplicate key value is (99999).
The statement has been terminated.

AND

SubmitForm deleting attachment for an existing record (1000,99999) 
 

Resolution

How-To disable HTTP/2 on Windows Server 2016 and 2019 
  1. Logon to the Windows Server
  2. Start the Windows Registry Editor.
  3. Navigate to the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters.
  4. Add 2 new REG_DWORD values, EnableHttp2Tls and EnableHttp2Cleartext, to this registry key.
  5. Set both values to 0.
  6. Reboot the desktop.
  7. You may need to open Configurator and click Apply if you get an error about connecting to License Server.
  8. Make sure all SBM services are started.
 

Applies To

SBM

Rate this Solution

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs