CommandLine Main:Unhandled Exception

• 
  Hi Yann,
  
  I believe whatever utility that you use to launch SQL Doc needs to specify a working directory. When you launch from command prompt or from Windows, this is usually fed to the program's running environment automatically. But that doesn't mean to say CruiseControl or whatever will.

  Brian Donahue February 17, 2012 10:12

  - 0 +
• 
  Yann
  
  Could you also post the command line and the parameters you are using?
  
  David Atkinson
  Red Gate

  David Atkinson February 17, 2012 11:37

  - 0 +
• 
  I'm sorry, i couldn't answer quickly.
  
  David
  We're actually using the following command line :
  sqldoc.exe" /project:"D:\ContinuousIntegration\SqlDoc\nightly.sqldoc"
  
  Brian
  I guess I have to specify the working directory if i'm using SQLDoc via CruiseControl. Is there a specific parameter ?

  Yann Kahloun July 04, 2012 05:17

  - 0 +
• 
  I would recommend you put the .sqldoc file in source control, so it is checked out automatically as part of your CI process. This means it can be invoked in relative terms.
  
  You might want to try using the following switch to ensure the documentation output goes somewhere relative to the checkout folder.
  
  /outputfolder:<outputfolder>
  
  i.e., to put it in the current folder, and assuming you've put nightly.sqldoc in the root source control folder that is checked out by your CI process:
  
  sqldoc.exe /project:nightly.sqldoc /outputfolder:.
  
  Let me know if this fixes the problem.
  
  David

  David Atkinson July 04, 2012 05:39

  - 0 +
• 
  Hi,
  
  We tried the "ouputfolder" tag already and CruiseControl's still failing.
  Here's the other two things we tried :
  1/ Automated task using Windows Task Planner :
  Once we set an execution repository, the job is fine.
  2/ Using CCNet, we tried to override the default execution repository but the issue is still the same.
  
  Now, the issue seems to be more likely related to CCNet than to SqlDoc2.

  Yann Kahloun July 04, 2012 08:10

  - 0 +
• 
  Another thing worth trying is running the CruiseControl service with administrator privileges, as there is a known issue with SQL Doc which means it requires permissions to write temporary files to its installation folder. This is something we eventually plan to fix.
  
  Does the sqldoc command line work when you run it from a command prompt?
  
  David

  David Atkinson July 04, 2012 09:29

  - 0 +
• 
  I tried to run it using simple command line and it worked.
  Your last answer seems to be the way to solve my problem.
  
  Considering I'm not the CruiseControl owner, I can't change the user it is running with. Anyway, we found a workaround (using Windows Task Planner). It is not perfect, but that will have to do.
  
  Seems like we have to wait for that temp files issue you are talking about. Can you tell us more about it ?

  Yann Kahloun July 04, 2012 09:40

  - 0 +
• 
  All I can say is that the issue has internal ID SDOC-1481
  
  I can't say when this will be fixed, but hopefully it won't be too long!

  David Atkinson July 04, 2012 09:57

  - 0 +

Add comment

Please sign in to leave a comment.