SSRS System.InvalidCastException - at OracleDataReader.GetDecimal(Int32 i)

, (DELV_RECEIPT.INV_LBS/ITEM_UOM_XREF.CONV_TO_LBS) AS UOM_QTY

Severity    Code    Description Project File    Line    Suppression State
Warning     [rsErrorReadingDataSetField] The dataset ‘dsIngredientCosts’ contains a definition for the Field ‘UOM_QTY’. The data extension returned an error during reading the field. System.InvalidCastException: Specified cast is not valid.
   at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
   at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
   at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.GetValue(Int32 fieldIndex)
   at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetFieldValue(Int32 aliasIndex)      C:\Users\bl0040\Documents\Visual Studio 2015\Projects\SSRS\Project_ssrs2016\Subscription Reports\Feed Ingredient Weekly Price Avg.rdl   0

Severity    Code    Description Project File    Line    Suppression State
Warning     [rsMissingFieldInDataSet] The dataset ‘dsIngredientCosts’ contains a definition for the Field ‘UOM_QTY’. This field is missing from the returned result set from the data source.       C:\Users\bl0040\Documents\Visual Studio 2015\Projects\SSRS\Project_ssrs2016\Subscription Reports\Feed Ingredient Weekly Price Avg.rdl   0

+------------+---------------+-------------+---------------+-----------+
| Source     | TABLE_NAME    | COLUMN_NAME | DataSize      | COLUMN_ID |
+------------+---------------+-------------+---------------+-----------+
| ORACLE     | DELV_RECEIPT  | INV_LBS     | NUMBER (7,0)  | 66        |
+------------+---------------+-------------+---------------+-----------+
| ORACLE     | ITEM_UOM_XREF | CONV_TO_LBS | NUMBER (9,4)  | 3         |
+------------+---------------+-------------+---------------+-----------+
| SQL SERVER | DELV_RECEIPT  | INV_LBS     | numeric (7,0) | 66        |
+------------+---------------+-------------+---------------+-----------+
| SQL SERVER | ITEM_UOM_XREF | CONV_TO_LBS | numeric (9,4) | 3         |
+------------+---------------+-------------+---------------+-----------+

   , CAST(DELV_RECEIPT.INV_LBS/ITEM_UOM_XREF.CONV_TO_LBS AS NUMERIC(9,4)) AS UOM_QTY

public static Decimal MyGetDecimal(this OracleDataReader reader, int i)
        return reader.GetDecimal(i);
    catch (System.InvalidCastException)

SSRS System.InvalidCastException - at OracleDataReader.GetDecimal(Int32 i)

3 个回答