-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Low
-
None
-
Affects Version/s: 10.133.1
-
Component/s: Product - Settings|Setup - Roles
-
None
-
Severity 3 - Minor
-
No
-
None
Issue Summary
This is reproducible (yes) / (no)
Trying to Delete a role will generate a blank and not treated error page.
Even though the Role is deleted as expected it throws this error number in a blank page and a SQL error in the logs
Steps to Reproduce
- Go to Administration > roles
- Pick a role
- Hit delete
- You will note the Generic error blank page
Expected Results
Role deleted + Success message and the page returning to /RoleSetupNew
Actual Results
The below exception is thrown in the c:\log\alignsupporttest-ASPNET-20240523.log file:
{ [-]
Exception: System.InvalidOperationException: Command parameter[1] '' is invalid.
---> System.Data.OleDb.OleDbException: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at AgileCraft.Legacy.AdodbRecordSet.GetReadOnlyDataSet(DbProviderFactory dbProviderFactory, String connectionString, String sql, DbParameter[] parameters, AdodbCommand command) in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbRecordSet.vb:line 424
at AgileCraft.Legacy.AdodbRecordSet.Requery() in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbRecordSet.vb:line 394
at AgileCraft.Legacy.AdodbCommand.Execute(Int32& recordsAffected, IEnumerable`1 parameters, Object options) in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbCommand.vb:line 36
at AgileCraft.Legacy.PageFunctions.DbExecParamsConnectionTiming(Object sql, Object sqlParams, Object objConnExec, Object bCaptureTime) in C:\projects\alignweb\AgileCraft.Legacy\OOFunctions\OOFunctionsSql.vb:line 283
Level: Error
MessageTemplate: SQLError
Properties: { [-]
ExceptionDetail: { [-]
HResult: -2146233079
InnerException: { [-]
ErrorCode: -2147217887
Errors: [ [+]
]
HResult: -2147217887
Message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Source: Microsoft OLE DB Driver for SQL Server
StackTrace: null
Type: System.Data.OleDb.OleDbException
}
Message: Command parameter[1] '' is invalid.
Source: System.Data
StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at AgileCraft.Legacy.AdodbRecordSet.GetReadOnlyDataSet(DbProviderFactory dbProviderFactory, String connectionString, String sql, DbParameter[] parameters, AdodbCommand command) in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbRecordSet.vb:line 424
at AgileCraft.Legacy.AdodbRecordSet.Requery() in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbRecordSet.vb:line 394
at AgileCraft.Legacy.AdodbCommand.Execute(Int32& recordsAffected, IEnumerable`1 parameters, Object options) in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbCommand.vb:line 36
at AgileCraft.Legacy.PageFunctions.DbExecParamsConnectionTiming(Object sql, Object sqlParams, Object objConnExec, Object bCaptureTime) in C:\projects\alignweb\AgileCraft.Legacy\OOFunctions\OOFunctionsSql.vb:line 283
TargetSite: Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)
Type: System.InvalidOperationException
}
HttpRequestId: e8bf8625-f89a-4167-8aac-9f17e5ef403a
HttpRequestRawUrl: /RoleSetUpNew
HttpRequestType: POST
HttpRequestUrl: https://alignsupporttest.jiraalign.com/RoleSetUpNew.aspx
SQL: Delete from tblRoleHierarchyRelation where RoleID = ?
UserName: 1202
correlationid: Nxdv/8tGjcBCnhyLayso9hkk7gMnvaMVybRyoisrlcQ=
customer_db: alignsupporttest
error_id: 184
logfrom_location: Website-ASPNET
server: PA-US-02-WEB-GH
version: 10.133.1.44550
}
RenderedMessage: SQLError
Timestamp: 2024-05-23T10:04:41.8050858-04:00
}Show as raw texthost = PA-US-02-WEB-GHsource = c:\log\alignsupporttest-ASPNET-20240523.logsourcetype = aspnet
Workaround
No Workaround
