
Making software work for you
|
| View previous topic :: View next topic |
| Author |
Message |
| mr_mcfisto
| | Joined: 11 Feb 2009 | | Posts: 2 | |
|
Posted: Wed Feb 11, 2009 10:17 am Post subject: 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 FilesGroff AutomationCrystal DeliveryCrystalCMD.exe" "SOURCEREPORT" "O:GoldMineReportsDaily FiguresOrder Intake Report.rpt" "CONNECTION" "MIAD" "MIAD" "TIe7ehNTfGgh01xld3txrg==" "TIe7ehNTfGgh01xld3txrg==" "EXPORTDIRECTORY" "D:Crystal Delivery ReportsOrder 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. |
|
| Back to top |
|
 |
| robinagnew
| | Joined: 19 Feb 2009 | | Posts: 2 | |
|
Posted: Thu Feb 19, 2009 4:59 am Post subject: |
|
|
| 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. |
|
| Back to top |
|
 |
| robinagnew
| | Joined: 19 Feb 2009 | | Posts: 2 | |
|
Posted: Mon Mar 02, 2009 9:18 am Post subject: solution |
|
|
| I have got a solution - th file locks so - give the file a new anme everytime. Do this by putting [#] in the filename. |
|
| Back to top |
|
 |
| pmow
| | Joined: 03 Mar 2009 | | Posts: 3 | |
|
Posted: Tue Mar 03, 2009 9:58 am Post subject: Re: solution |
|
|
| robinagnew wrote: | | 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. |
|
| Back to top |
|
 |
| bigdave
| | Joined: 08 Mar 2009 | | Posts: 1 | |
|
Posted: Sun Mar 08, 2009 11:56 pm Post subject: |
|
|
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. |
|
| Back to top |
|
 |
| pmow
| | Joined: 03 Mar 2009 | | Posts: 3 | |
|
Posted: Tue Mar 10, 2009 8:27 am Post subject: |
|
|
| bigdave wrote: | ...
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. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You can delete your posts in this forum You cannot vote in polls in this forum
|
|