• State Not Answered
  • Replies replies
    4
  • Subscribers subscribers
    3
  • Views views
    221
  • Users 0 members are here
  • Locked Locked
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Error during report definition creation

MigrationDeletedUser
Hello

I have occured strange error during creation of new report definition.
When I click OK after specifying report name, type, target paths/identities the "Report Definitions" site prints error.
I can make this site usable again by deleting records from database tables "report_definiotion_targets" and "report_definitions". But, when I try to create any new report definition error is the same.




An unexpected error was encountered.

Please retry the operation, and if the error persists, contact the system administrator.


Error Message:


System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.id as id3_1_, this_.report_type as report2_3_1_, this_.report_name as report3_3_1_, this_.create_time as create4_3_1_, this_.modify_time as modify5_3_1_, this_.report_parameters as report7_3_1_, this_.description as descript8_3_1_, this_.creator as creator3_1_, this_.priority as priority3_1_, this_.fsf_policies as fsf11_3_1_, reportsche2_.Id as Id6_0_, reportsche2_.start_date as start2_6_0_, reportsche2_.time_offset as time3_6_0_, reportsche2_.recurrence as recurrence6_0_, reportsche2_.day_of_week as day5_6_0_, reportsche2_.monthly_recurrence as monthly6_6_0_, reportsche2_.day_of_month as day7_6_0_, reportsche2_.month_ordinal as month8_6_0_, reportsche2_.month_ordinal_day as month9_6_0_, reportsche2_.report_definition_id as report10_6_0_ FROM report_definitions this_ left outer join report_schedule reportsche2_ on this_.id=reportsche2_.report_definition_id ]
[SQL: SELECT this_.id as id3_1_, this_.report_type as report2_3_1_, this_.report_name as report3_3_1_, this_.create_time as create4_3_1_, this_.modify_time as modify5_3_1_, this_.report_parameters as report7_3_1_, this_.description as descript8_3_1_, this_.creator as creator3_1_, this_.priority as priority3_1_, this_.fsf_policies as fsf11_3_1_, reportsche2_.Id as Id6_0_, reportsche2_.start_date as start2_6_0_, reportsche2_.time_offset as time3_6_0_, reportsche2_.recurrence as recurrence6_0_, reportsche2_.day_of_week as day5_6_0_, reportsche2_.monthly_recurrence as monthly6_6_0_, reportsche2_.day_of_month as day7_6_0_, reportsche2_.month_ordinal as month8_6_0_, reportsche2_.month_ordinal_day as month9_6_0_, reportsche2_.report_definition_id as report10_6_0_ FROM report_definitions this_ left outer join report_schedule reportsche2_ on this_.id=reportsche2_.report_definition_id] ---> System.InvalidCastException: Specified cast is not valid.
 at NpgsqlTypes.NpgsqlTimeStampTZ.op_Explicit(NpgsqlTimeStampTZ timestamp)
 at NpgsqlTypes.NpgsqlTypesHelper.<TypeInfoList>b__10(Object timestamptz)
 at NpgsqlTypes.NpgsqlBackendTypeInfo.ConvertToFrameworkType(Object providerValue)
 at Npgsql.ForwardsOnlyDataReader.GetValue(Int32 Index)
 at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
 at NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session)
 at NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session)
 at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
 at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
 at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
 at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
 at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
 at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
 --- End of inner exception stack trace ---
 at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
 at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
 at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session)
 at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
 at NHibernate.Impl.CriteriaImpl.List(IList results)
 at NHibernate.Impl.CriteriaImpl.List()
 at WebUI.app.Reports.ReportDefinitions.LoadGridData()
 at DevExpress.Web.ASPxGridView.ASPxGridView.OnInit(EventArgs e)
 at System.Web.UI.Control.InitRecursive(Control namingContainer)
 at System.Web.UI.Control.InitRecursive(Control namingContainer)
 at System.Web.UI.Control.InitRecursive(Control namingContainer)
 at System.Web.UI.Control.InitRecursive(Control namingContainer)
 at System.Web.UI.Control.InitRecursive(Control namingContainer)
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.HandleError(Exception e)
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest()
 at System.Web.UI.Page.ProcessRequest(HttpContext context)
 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
 at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean
  • 0
    On 3/12/2013 4:36 AM, kkubeckibil wrote:
    >
    > Hello
    >
    > I have occured strange error during creation of new report definition.
    > When I click OK after specifying report name, type, target
    > paths/identities the "Report Definitions" site prints error.
    > I can make this site usable again by deleting records from database
    > tables "report_definiotion_targets" and "report_definitions". But, when
    > I try to create any new report definition error is the same.
    >
    >
    >
    >
    > Code:
    > --------------------
    >
    > An unexpected error was encountered.
    >
    > Please retry the operation, and if the error persists, contact the system administrator.
    >
    >
    > Error Message:
    >
    >
    > System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> NHibernate.Exceptions.GenericADOException: could not execute query
    > [ SELECT this_.id as id3_1_, this_.report_type as report2_3_1_, this_.report_name as report3_3_1_, this_.create_time as create4_3_1_, this_.modify_time as modify5_3_1_, this_.report_parameters as report7_3_1_, this_.description as descript8_3_1_, this_.creator as creator3_1_, this_.priority as priority3_1_, this_.fsf_policies as fsf11_3_1_, reportsche2_.Id as Id6_0_, reportsche2_.start_date as start2_6_0_, reportsche2_.time_offset as time3_6_0_, reportsche2_.recurrence as recurrence6_0_, reportsche2_.day_of_week as day5_6_0_, reportsche2_.monthly_recurrence as monthly6_6_0_, reportsche2_.day_of_month as day7_6_0_, reportsche2_.month_ordinal as month8_6_0_, reportsche2_.month_ordinal_day as month9_6_0_, reportsche2_.report_definition_id as report10_6_0_ FROM report_definitions this_ left outer join report_schedule reportsche2_ on this_.id=reportsche2_.report_definition_id ]
    > [SQL: SELECT this_.id as id3_1_, this_.report_type as report2_3_1_, this_.report_name as report3_3_1_, this_.create_time as create4_3_1_, this_.modify_time as modify5_3_1_, this_.report_parameters as report7_3_1_, this_.description as descript8_3_1_, this_.creator as creator3_1_, this_.priority as priority3_1_, this_.fsf_policies as fsf11_3_1_, reportsche2_.Id as Id6_0_, reportsche2_.start_date as start2_6_0_, reportsche2_.time_offset as time3_6_0_, reportsche2_.recurrence as recurrence6_0_, reportsche2_.day_of_week as day5_6_0_, reportsche2_.monthly_recurrence as monthly6_6_0_, reportsche2_.day_of_month as day7_6_0_, reportsche2_.month_ordinal as month8_6_0_, reportsche2_.month_ordinal_day as month9_6_0_, reportsche2_.report_definition_id as report10_6_0_ FROM report_definitions this_ left outer join report_schedule reportsche2_ on this_.id=reportsche2_.report_definition_id] ---> System.InvalidCastException: Specified cast is not valid.
    > at NpgsqlTypes.NpgsqlTimeStampTZ.op_Explicit(NpgsqlTimeStampTZ timestamp)
    > at NpgsqlTypes.NpgsqlTypesHelper.<TypeInfoList>b__10(Object timestamptz)
    > at NpgsqlTypes.NpgsqlBackendTypeInfo.ConvertToFrameworkType(Object providerValue)
    > at Npgsql.ForwardsOnlyDataReader.GetValue(Int32 Index)
    > at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
    > at NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session)
    > at NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session)
    > at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
    > at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
    > at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
    > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
    > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
    > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
    > --- End of inner exception stack trace ---
    > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
    > at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
    > at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session)
    > at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
    > at NHibernate.Impl.CriteriaImpl.List(IList results)
    > at NHibernate.Impl.CriteriaImpl.List()
    > at WebUI.app.Reports.ReportDefinitions.LoadGridData()
    > at DevExpress.Web.ASPxGridView.ASPxGridView.OnInit(EventArgs e)
    > at System.Web.UI.Control.InitRecursive(Control namingContainer)
    > at System.Web.UI.Control.InitRecursive(Control namingContainer)
    > at System.Web.UI.Control.InitRecursive(Control namingContainer)
    > at System.Web.UI.Control.InitRecursive(Control namingContainer)
    > at System.Web.UI.Control.InitRecursive(Control namingContainer)
    > at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    > at System.Web.UI.Page.HandleError(Exception e)
    > at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    > at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    > at System.Web.UI.Page.ProcessRequest()
    > at System.Web.UI.Page.ProcessRequest(HttpContext context)
    > at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    > at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean
  • 0 in reply to 
    Hi

    I am getting the same error, was a fix for this found?

    Thanks
  • 0 in reply to 
    On 4/16/2013 4:16 AM, gvdwest wrote:
    >
    > Hi
    >
    > I am getting the same error, was a fix for this found?
    >
    > Thanks
    >
    >
    gdvwest,

    We are still investigating the issue. We never heard from the original
    poster on this, I don't think -- could you email filereporter@novell.com
    with your report parameters and a copy of your Engine log file? We may
    want to do some other testing in your environment as well so that we can
    pin down the problem. Thanks!

    --
    - NFMS Support Team
  • 0 in reply to 
    I am seeing this same error. Has a fix been found yet?

    I cannot even log into File Reporter. The error pops up at first page generation.

    - Todd Farrow

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.