Highlighted
Absent Member.
Absent Member.
1882 views

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 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

Re: Error when trying to run File Data reports

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.