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 when trying to run File Data reports

We are running NFR Engine 2.0.1.8, PosgreSQL 9.2.1, agent 2.0.1.18.
We are receiving the below error when trying to run File Data reports (date-age, owner detail, filename extension). A directory data summary or permissions report run on the same volume works fine. We are receiving the same error when running against a Netware and OES2 server. File system data scans are running successfully.

Any ideas on what could be the issue?

Exception of type 'System.Web.HttpUnhandledException' was thrown.

Npgsql.NpgsqlException:
function owner_detail_report(integer, text) does not exist
Severity: ERROR
Code: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
at Npgsql.ForwardsOnlyDataReader.NextResult()
at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at SRS.DataAccessLayer.OwnerDetailReportAdapter.ReadData(List`1 lstData)
at SRS.DataAccessLayer.OwnerDetailReportAdapter.GetGenericFileDataForScan2(Int32 reportid, String ownerIdList)
at SRS.Reports.FileSystem.OwnerDetailUnformattedReport.OnDataSourceDemanded(EventArgs e)
at DevExpress.XtraReports.UI.XtraReportBase.FillDataSource()
at DevExpress.XtraReports.UI.XtraReport.FillDataSources()
at DevExpress.XtraReports.UI.XtraReport.OnBeforePrint(PrintEventArgs e)
at DevExpress.XtraReports.UI.XtraReport.CreateDocumentCore(Single progressRange, Boolean buildPagesInBackground)
at DevExpress.XtraReports.Web.ReportViewer.ForcePSDocument()
at DevExpress.XtraReports.Web.BookmarkFiller`1.Fill(T parent)
at DevExpress.XtraReports.Web.ReportDocumentMap.FillDocumentMap()
at DevExpress.XtraReports.Web.ReportDocumentMap.EnsurePreRender()
at DevExpress.Web.ASPxClasses.ASPxWebControl.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  • 0
    On 8/23/2013 11:26 AM, franciske wrote:
    >
    > We are running NFR Engine 2.0.1.8, PosgreSQL 9.2.1, agent 2.0.1.18.
    > We are receiving the below error when trying to run File Data reports
    > (date-age, owner detail, filename extension). A directory data summary
    > or permissions report run on the same volume works fine. We are
    > receiving the same error when running against a Netware and OES2 server.
    > File system data scans are running successfully.
    >
    > Any ideas on what could be the issue?
    >
    > Exception of type 'System.Web.HttpUnhandledException' was thrown.
    >
    > Npgsql.NpgsqlException:
    > function owner_detail_report(integer, text) does not exist
    > Severity: ERROR
    > Code: 42883
    > Hint: No function matches the given name and argument types. You might
    > need to add explicit type casts.
    > at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
    > at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
    > at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
    > at Npgsql.ForwardsOnlyDataReader.NextResult()
    > at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration,
    > CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock
    > threadBlock, Boolean synchOnReadError)
    > at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
    > at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
    > at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    > at SRS.DataAccessLayer.OwnerDetailReportAdapter.ReadData(List`1
    > lstData)
    > at
    > SRS.DataAccessLayer.OwnerDetailReportAdapter.GetGenericFileDataForScan2(Int32
    > reportid, String ownerIdList)
    > at
    > SRS.Reports.FileSystem.OwnerDetailUnformattedReport.OnDataSourceDemanded(EventArgs
    > e)
    > at DevExpress.XtraReports.UI.XtraReportBase.FillDataSource()
    > at DevExpress.XtraReports.UI.XtraReport.FillDataSources()
    > at DevExpress.XtraReports.UI.XtraReport.OnBeforePrint(PrintEventArgs
    > e)
    > at DevExpress.XtraReports.UI.XtraReport.CreateDocumentCore(Single
    > progressRange, Boolean buildPagesInBackground)
    > at DevExpress.XtraReports.Web.ReportViewer.ForcePSDocument()
    > at DevExpress.XtraReports.Web.BookmarkFiller`1.Fill(T parent)
    > at DevExpress.XtraReports.Web.ReportDocumentMap.FillDocumentMap()
    > at DevExpress.XtraReports.Web.ReportDocumentMap.EnsurePreRender()
    > at DevExpress.Web.ASPxClasses.ASPxWebControl.OnPreRender(EventArgs e)
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Control.PreRenderRecursiveInternal()
    > at System.Web.UI.Page.ProcessRequestMain(Boolean
    > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >
    >

    franciske,

    We've got some updated code which may solve this issue. Please send an
    email to filereporter@novell.com so that we can send you the latest
    Engine code. If the issue persists after updating the Engine we'll of
    course investigate further.

    --
    - NFMS Support Team