View Full Version: Crystal Delivery 8.0.0.2 'Value cannot be null' Error

kgroff >>Program Help >>Crystal Delivery 8.0.0.2 'Value cannot be null' Error


<< Prev | Next >>

mr_mcfisto- 02-11-2009
Crystal Delivery 8.0.0.2 'Value cannot be null' Error
I have tried to search the forum without any results. I have also tried to find an older verion of the program to test before submitting to the forum, but again was out of luck. I really hope you can help. I have been using CD 8.0.0.1 with success for various reports, all created using Crystal v9. However I have some new reports which fail every time. I have now upgraded to CD 8.0.0.2 hoping to overcome this error. The error I have is: Value cannot be null. Parameter name: fileName I schedule the report, complete each tab, there are no parameters. The command line looks like: "C:\Program Files\Groff Automation\Crystal Delivery\CrystalCMD.exe" "SOURCEREPORT" "O:\GoldMine\Reports\Daily Figures\Order Intake Report.rpt" "CONNECTION" "MIAD" "MIAD" "TIe7ehNTfGgh01xld3txrg==" "TIe7ehNTfGgh01xld3txrg==" "EXPORTDIRECTORY" "D:\Crystal Delivery Reports\Order Intake Report.pdf" The report is scheduled to run every 1 Days, Mon-Fri I have an ODBC Source setup up to the SQL server which is the source data for the report. This is tested and working fine. I am able to View the report within Crystal Delivery and the report outputs correctly with current data. At this stage the system is in Manual Mode and once the report is scheduled, I am clicking the Export button to force an export which generates the error. I get the same results if the system is in Auto Mode. The debugging info is: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ArgumentNullException: Value cannot be null. Parameter name: fileName at System.IO.FileInfo..ctor(String fileName) at CrystalDelivery.frmMain.ExportReport(String txtID) at CrystalDelivery.frmMain.ForcedExport(Int32 intSelectedRow) at CrystalDelivery.frmMain.tsbExport_Click(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripButton.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.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.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) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Crystal Delivery Assembly Version: 8.0.0.2 Win32 Version: 8.0.0.2 CodeBase: file:///C:/Program%20Files/Groff%20Automation/Crystal%20Delivery/Crystal%20Delivery.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- CrystalDecisions.Shared Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.Shared/10.5.3700.0__692fbea5521e1304/CrystalDecisions.Shared.dll ---------------------------------------- CrystalDecisions.CrystalReports.Engine Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/10.5.3700.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CommLayer Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CommLayer/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CommLayer.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ClientDoc Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ClientDoc/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ClientDoc.dll ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataSetConversion Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataSetConversion/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataSetConversion.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataDefModel Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataDefModel/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.Controllers Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.Controllers/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.Controllers.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ReportDefModel Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ReportDefModel/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ReportDefModel.dll ---------------------------------------- CrystalDecisions.KeyCode Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.KeyCode/10.5.3700.0__692fbea5521e1304/CrystalDecisions.KeyCode.dll ---------------------------------------- System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- CrystalDecisions.Windows.Forms Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms/10.5.3700.0__692fbea5521e1304/CrystalDecisions.Windows.Forms.dll ---------------------------------------- CrystalDecisions.ReportSource Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportSource/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportSource.dll ---------------------------------------- CustomMarshalers Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINNT/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll ---------------------------------------- CrystalDecisions.ReportAppServer.XmlSerialize Assembly Version: 10.5.3700.0 Win32 Version: 10.5.1.2285 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.XmlSerialize/10.5.3700.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.XmlSerialize.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. I have tried to turn off the Email File option under Export Directory and then click Export and it seems to complete, I don't get any errors, a blank email is sent to me, but no PDF file is created. There's no PDF file created in either instance. I have also tried different output formats and non work - giving the same results. I have also tried different output folders on the local drive. Fingers crossed you can help. I will install an older version if that would fix the problem.

robinagnew- 02-19-2009

I am having a similar problem. It works for the first time logged in. Then it locks the file and brings up this error on the second running.

robinagnew- 03-02-2009
solution
I have got a solution - th file locks so - give the file a new anme everytime. Do this by putting <#> in the filename.

pmow- 03-03-2009
Re: solution
I have got a solution - th file locks so - give the file a new anme everytime. Do this by putting <#> in the filename. This did not work for me. I was also not getting the error on the 2nd run, I got it every single time. What I noticed was that another connection (to the same SQL server, incidentally) was being used for the report. Also, the connection was "Trusted" where the report that worked did not have this setting. So I "replaced" the data source in Crystal 2008. It may be different in older versions of Crystal Reports, but In Field Explorer, look under "Database Fields" and right-click. Select "replace data source". In the next screen, select the old source and new source, and presto.

bigdave- 03-09-2009

I have been suffering this problem since version 8.0.0.1 and was hoping for a fix in 8.0.0.2. Reading the posts above, I was able to work out that two of my report entries were set to use the same export file name and were configured to run at similar times. This will obviously create a file lock issue when the first report runs and generates the export file followed by the second report trying to open the same file in read/write mode. The locked file is enough to crash the program and spit the misleading "filename cannot be null" message. So, I have now given each report a unique export file name and will know tommorow whether this has cured the issue as it is always on Tuesday that this happens for me. Looking back to the original post, if you look at the file path for the export file, it appears to be missing a backslash after D: Also, I always use underscores to separate names within filenames as not all software supports spaces within filenames.

pmow- 03-10-2009

... So, I have now given each report a unique export file name and will know tommorow whether this has cured the issue as it is always on Tuesday that this happens for me. ... Interesting. That was one of the things I checked for. I even checked the config files for those jobs. It may be the same error message, but different issues.

Forumer™ is Voted #1 Free Forum Hosting provider
Build your own community today with the largest message board hosting company.