[nant-dev] [ nant-Bugs-2515816 ] Nant fails with internal error

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Bugs item #2515816, was opened at 2009-01-17 16:16
Message generated for change (Comment added) made by drieseng
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=402868&aid=2515816&group_id=31650

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: Third party libraries
Group: 0.85
>Status: Closed
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: Dewi Felstead (felsteadd)
>Assigned to: Gert Driesen (drieseng)
Summary: Nant fails with internal error

Initial Comment:
We are experiencing build issues with Nant 0.85 when we add the solution file to Visual Source Safe 2005.

Basically all works fine until we add our .NET (C#) solution to source control. Once we do that and check out a copy for edit the build starts failing. A version of the solution with source control bindings removed works fine (no other difference between the 2 solutions - just one has VSS bindings and one does not.

Could this be a file / folder permissions issue? We have made sure that we check out all solution files for edit (make writable) before we attempt to run the build.

----------------------------------------------------------------------

>Comment By: Gert Driesen (drieseng)
Date: 2009-01-18 09:54

Message:
Hi Dewi,

Your build log clearly shows that the error is caused by the
XmlSqlQueryTask.
The input file that it uses - and that was generated earlier on in the
build? - apparently causes a SQL error.

It is only reported as an INTERNAL ERROR because that task does not
perform error handling, and as such the exception bubbles up to NAnt.

----------------------------------------------------------------------

Comment By: steven maglio (smaglio81)
Date: 2009-01-18 09:54

Message:
Hmmm ... That's very interesting. Because the <foreach> loop is the one
that causes the problem it makes me think that the <xmlsqlquery> statement
is the task which is causing the problem.

Unfortuanelty, I have never seen that task before. Is it part of the
nant-extensions package? I haven't really used that package before.

I'm about to crawl into bed. I'll try to look into this more tomorrow.

PS
I may be distracted. I'm working on a Unity project at the moment, and I
have found speedbumps
(http://www.codeplex.com/unity/SourceControl/PatchList.aspx).

----------------------------------------------------------------------

Comment By: Dewi Felstead (felsteadd)
Date: 2009-01-18 08:24

Message:
Hi, Thanks for the reply - the account use to run nant is a local admins
account and using explorer all files can be accessed / viewed corrected.
The db.schema.refelect target can be seen below:

  <target name="db.schema.reflect" depends="db.init, tasks.load">
    <mkdir dir="${db.schema.xml.dir}"
unless="${directory::exists(db.schema.xml.dir)}" />

    <foreach item="File" property="query.file" in="${db.dir}\schema">
      <xmlsqlquery connection="Data Source=${ini.dbserver}; Initial
Catalog=${ini.dbname}; Integrated Security=SSPI"
                   query="${query.file}"

out="${db.schema.xml.dir}\${path::get-file-name-without-extension(query.file)}.xml"
/>
    </foreach>

    <exec program="${ini.msbuildpath}">
      <arg value="${build.rel.path}\Database.proj" />
      <arg value="/t:AfterBuild" />
      <arg value="/p:TargetServer=${ini.dbserver}" />
      <arg value="/p:TargetDatabase=${ini.dbname}" />
    </exec>
  </target>

As I mentioned in my initial post the whole thing works fine until I add
the solution to source control using VSS. After that the db.schema.reflect
bit fails consistently - I have identified that commenting out the foreach
loop enables to the build to succeed but then files are missing that are
required to build to solution file.

----------------------------------------------------------------------

Comment By: steven maglio (smaglio81)
Date: 2009-01-18 05:47

Message:
I wrote a reply question to this before reading the build.log file
(below).

But after reading the log file I was curious as to the error statement,
"System.Data.SqlClient.SqlException: Incorrect syntax near '4'."

What does db.schema.reflect do? And is there any place in it's code that
have the number 4?

---------------------------------------------------------------------

I'm not the developer of NANT (drieseng,
http://www.ohloh.net/p/nant/contributors), but I am curious that you
mentioned permissions issues.

Could you open a windows explorer window under the account that your nant
script run's under to test the permissions?

Our systems team showed me a way to use IE in order to do this:

(In Windows XP/Server 2003)
Start Menu > Programs > Internet Explorer (right click on this option and
choose "Run As ...").
Then log in with the account and in the location bar ...
file:///<path to directory>
example: file:///D:/Working_Area/felsteadd/Projects/TeamTrack

When running under that account are you able to access the proper
folders/files?

(I sure hope this looks right. There doesn't seem to be a preview
submission option on these replys.)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=402868&aid=2515816&group_id=31650