Error: “ Error running statement: exec QBM_PJobCreate_HOTemplate_B 'SAPUserInSAPRole', '1=1', @Columns = 'DisplayValue''” (4376855)

Error: “ Error running statement: exec QBM_PJobCreate_HOTemplate_B 'SAPUserInSAPRole', '1=1', @Columns = 'DisplayValue''”

Steps to reproduce

• have 12M SAPUserInSAPRole
• migrate from 9.1.x to 9.2.1

Expected result

Successful migration


Actual result

Timeout


Error message/log file/console log

2024-08-25 07:59:58.2377 ERROR (VI.FormBase.ExceptionMgr  ) : Processing step 'SAP SAPUserInSAPRole_DisplayValue (insert job for DisplayValue)' failed. System.Exception: Processing step 'SAP SAPUserInSAPRole_DisplayValue (insert job for DisplayValue)' failed. ---> System.Exception: 1 - Sql command failed. ---> VI.Base.ViException: Error running statement:
        exec QBM_PJobCreate_HOTemplate_B 'SAPUserInSAPRole', '1=1', @Columns = 'DisplayValue'

        , @GenProcID = '65687707-5dc3-4269-976b-13505e30e9a9'

        , @AdditionalObjectKeysAffected = default

       ---> VI.DB.DatabaseException: Database error -2: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Operation cancelled by user. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Operation cancelled by user. ---> System.ComponentModel.Win32Exception: The wait operation timed out

   --- End of inner exception stack trace ---

This is a product defect (464312 ).

WORKAROUND:

None.

STATUS:

This will be fixed in a future release of the product. If you require this immediately corrected, please contact support for a hotfix referencing the defect ID 464312.

464312