-
Bug
-
Resolution: Fixed
-
High
-
11.2.1
-
None
-
1
-
Severity 1 - Critical
-
No
Issue Summary
When importing Stories in Jira Align, it triggers the Whoops Page during the file validation.
Steps to Reproduce
- Using the Import template provided by Jira Align itself
- Import the Stories in the Jira Align
Expected Results
The stories are imported successfully
Actual Results
It triggered a "Whoops Page" during the file validation in Jira Align.
Checking the Jira Align logs it is observed the following error:
{
Exception: System.Data.OleDb.OleDbException (0x80040E07): Conversion failed when converting the nvarchar value 'LF 24Q1' to data type int.
at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
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 427
at AgileCraft.Legacy.AdodbRecordSet.Requery() in C:\projects\alignweb\AgileCraft.Legacy\Adodb\AdodbRecordSet.vb:line 397
at AgileCraft.Legacy.PageFunctions.GetRSParamsCursor(String query, AdodbConnection conn, IEnumerable`1 sqlParams, Boolean bServerSide, String timeout) in C:\projects\alignweb\AgileCraft.Legacy\OOFunctions\OOFunctionsSql.vb:line 214
Level: Error
MessageTemplate: SQLError
Properties: { [+]
}
RenderedMessage: SQLError
Timestamp: 2024-09-05T15:33:47.8579998-04:00
}
Exception: System.Data.OleDb.OleDbException (0x80040E07): Conversion failed when converting the nvarchar value 'LF 24Q1' to data type int.
Checking the file columns and template was observed that the column "Release/Program Increment" on the Stories sheet is not accepting "varchar" entries, as shown below:
It was observed that the column "Release" is accepting the Release ID (int) instead:
| 
Workaround
As a workaround, it was found two suggestions:
1) Deleting the values in the Release Column
OR
2) Use the Release IDs in the Release Column instead of the Release Name
