Bugs item #2515816, was opened at 2009-01-17 15:16
Message generated for change (Comment added) made by felsteadd
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: Other
Group: 0.85
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Dewi Felstead (felsteadd)
Assigned to: Nobody/Anonymous (nobody)
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: Dewi Felstead (felsteadd)
Date: 2009-01-18 07: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 04: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
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
nant-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nant-developers
