Error : Specified cast is not valid.

[HakanKaraoglu]

I have a method as below. However, this method gives the error I have stated below in some queries. So sometimes it works fine, sometimes it doesn't. I couldn't come up with an idea about the cause. Can you help me ?

public async Task<FeedDetail> GetFeedDetailByFeedAsync(Feed feed)
        {
            var query = await _session.CreateCriteria<FeedDetail>()
                                 .Add(Restrictions.Eq("Feed", feed))
                                 .Add(Restrictions.Eq("IsActive", true))
                                 .SetFetchMode("Feeder", FetchMode.Eager)
                                 .SetFetchMode("Feed", FetchMode.Eager)
                                 .SetFetchMode("Workspace", FetchMode.Eager)
                                 .SetFetchMode("Source", FetchMode.Eager)
                                 .SetMaxResults(1).UniqueResultAsync<FeedDetail>();

            return query;
        }

at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
at NHibernate.Type.NullableType.NullSafeGet(DbDataReader rs, String name, ISessionImplementor session)
at NHibernate.Type.NullableType.NullSafeGetAsync(DbDataReader rs, String[] names, ISessionImplementor session, Object owner, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at NHibernate.Persister.Entity.AbstractEntityPersister.HydrateAsync(DbDataReader rs, Object id, Object obj, String[][] suffixedPropertyColumns, ISet`1 fetchedLazyProperties, Boolean allProperties, Int32[] indexes, ISessionImplementor session, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.LoadFromResultSetAsync(DbDataReader rs, Int32 i, Object obj, ILoadable persister, EntityKey key, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.InstanceNotYetLoadedAsync(DbDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.GetRowAsync(DbDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session, Boolean mustLoadMissingEntity, Action`2 cacheBatchingHandler, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.GetRowFromResultSetAsync(DbDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder, Action`2 cacheBatchingHandler, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.DoQueryAsync(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollectionsAsync(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder, CancellationToken cancellationToken)
at NHibernate.Loader.Loader.DoListAsync(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder, CancellationToken cancellationToken)

[fredericDelaporte]

See #2641.

[HakanKaraoglu]

@fredericDelaporte
Thank you, but there is no solution at the moment, the issue seems open.

[fredericDelaporte]

There is a lot of possible causes with this issue. First, this seems to be an Oracle issue, calling for an Oracle fix, not a NHibernate one. And maybe your case can be fixed, I do not know. You have to analyze it thoroughly, checking your used types, whether you should use Oracle binary_double or some other type for your columns, whether Oracle setting for avoiding this exception is of any help in your case, ...

[HakanKaraoglu]

@fredericDelaporte

I saw the problem when I looked in more detail, a very long double value is written in some corrupt data, I tried to map them as follows, but it doesn't seem to work. What solution can you suggest for this issue?

Map(x => x.GeoLat, "GEOLAT").Precision(9).Scale(2);
Map(x => x.GeoLong, "GEOLONG").Precision(9).Scale(2);

[fredericDelaporte]

These columns data-types are likely something else than binary_double. Try switching them to binary_double. Normally geographical coordinates do not require a precised decimal preserving storage, so binary_double should be suitable.

[HakanKaraoglu]

thanks for your support, I will be try