Zurück
-
Titel
Error: “ Error running statement: exec QBM_PJobCreate_HOTemplate_B 'SAPUserInSAPRole', '1=1', @Columns = 'DisplayValue''” -
Beschreibung
Steps to reproduce- have 12M SAPUserInSAPRole
- migrate from 9.1.x to 9.2.1
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 --- -
Ursache
This is a product defect (464312 ). -
Lösung
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. -
Änderungsanforderung
464312