Question

Duplicate Quick report parameter

  • 23 June 2023
  • 5 replies
  • 77 views

Userlevel 3
Badge +10

What could be the reason for the duplicate report parameter? This report is migrated from Apps9 to Apps10 like for like. However Apps10 shows duplicate parameter, but works fine in Apps9.

I also see this error when trying to run the report.

 

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Ifs.Application.InfoServicesFramework.InfoServicesService.ParseParameters(CrystalQuickReportParametersTable parameters)
   at Ifs.Application.InfoServicesFramework.InfoServicesService.ExecuteCrystalQuickReport(Double quickReportId, CrystalQuickReportParametersTable parameters)
   at Ifs.Application.InfoServicesFramework.InfoServicesService.ExecuteAndViewCrystalQuickReport(Double quickReportId)
   at Ifs.Application.InfoServicesFramework.InfoServicesService.OpenPublicQuickReport(String quickReportId, Dictionary`2 reportParameters)
   at Ifs.Application.InfoServicesFramework.InfoServicesService.ExecuteAndViewQuickReport(String quickReportId, Dictionary`2 reportParameters)
   at Ifs.Application.QuickReporting.QuickReportUtility.ExecuteAndViewQuickReport(IFndExplorer explorer, QuickReport quickReport)
   at Ifs.Application.QuickReporting.QuickReportOverview.commandViewReport_Execute(Object sender, FndCommandExecuteEventArgs e)
   at Ifs.Fnd.Windows.Forms.FndCommand.OnExecute(Component component)
   at Ifs.Fnd.Windows.Forms.FndContextMenuStrip.ExecuteCommand(ToolStripMenuItem menuItem, EventArgs e)
   at Ifs.Fnd.Windows.Forms.FndToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   --- End of inner exception stack trace ---

 


5 replies

Userlevel 7
Badge +18

Hope R&D Solution 269618  may fix this issue.

Solution 269618 - SQL quick report saved parameters getting duplicated when saved from two different user sessions.

But before that, please create a support ticket, then IFS Support team will investigate the issue and give a proper solution with considering this solution.

 

Best Regards

-Kelum 

Userlevel 4
Badge +8

It seems like you are referring to a Crystal Quick Report. I’d then suggest to first open the corresponding .rpt in Crystal Designer and try previewing it. Probably there you’ll find the problematic duplicate filed too. 

Userlevel 7
Badge +19

Hi @bhavesh ,

What is the UPD version in APPs 10?

Userlevel 7
Badge +19

Hello @bhavesh ,

If you encounter the issue in UPD20, then it’s due a to bug. 

Userlevel 4
Badge +8

Hello @Minoshini Fonseka 

Yes, it’s a bug in UPD20, and I’ve already created a case.

The bug is with the context mapping between bind parameters of the SQL and the hWind objects (parameters from the param dialog). 

We are desperately awaiting for a resolution.

Cheers.

/Manulak

Reply