svn integration

Topics: Installing BugNET
Feb 6, 2013 at 2:00 AM
Hello everybody,

hopefully somebody is out there who can help me...
I have bugnet 1.2.231.0 and visualsvn 2.5.8 installed.
I can access subversion from the bugnet ui.
I have the tortoise client configured like descriped on the bugnetproject webpage.

when I am doing a commit of changes I am receiving an error message in the logfile.
It says that the service request has too many arguments. But from my opinion it is ok. I have no idea what is wrong and where to change something.

any ideas?
Thanks in advance
Alex
INFO - Starting post-commit...
INFO - Executing IssueTrackerIntegration.UpdateIssueTrackerFromRevision("C:\Repositories\repos", "47")
INFO - Running svnlook...
DEBUG - Running Commandline: svnlook info -r 47 "C:\Repositories\repos"
DEBUG - svnlook output: svnlook info -r 47 "C:\Repositories\repos"
akn
2013-02-06 02:33:47 +0100 (Mi, 06 Feb 2013)
57
icdbinterface einchecken


View Issue IderiApps-10


DEBUG - Looking for search pattern in revision:47 and repository:C:\Repositories\repos...
INFO - Found 3 matches...
INFO - Getting svn log message.
DEBUG - Running Commandline: svnlook log -r 47 "C:\Repositories\repos"
INFO - Logging in to BugNET webservices...
INFO - Logging in to BugNET webservices...
INFO - Login successful...
INFO - Creating new issue revision...
DEBUG -
Revision:47 Id:10 Repository:repos Author:akn
DateTime:2013-02-06 02:33:47 +0100 (Mi, 06 Feb 2013)
LogMessage:icdbinterface einchecken


View Issue <a href="IssueDetail.aspx?id=10#top"><b>IderiApps-10</b></a>


ERROR - An error occurred adding a new issue revision to BugNET: Server was unable to process request. ---> Database Error ---> Procedure or function BugNet_IssueRevision_CreateNewIssueRevision has too many arguments specified.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at BugNET.SubversionHooks.WebServices.BugNetServices.CreateNewIssueRevision(Int32 revision, Int32 issueId, String repository, String revisionAuthor, String revisionDate, String revisionMessage, String changeset, String branch)
at BugNET.SubversionHooks.IssueTrackerIntegration.UpdateIssueTrackerFromRevision(String repository, String revision)
INFO - Finished IssueTrackerIntegration.UpdateIssueTrackerFromRevision
Feb 6, 2013 at 2:44 PM
The issue is when you install BugNET for the first time the BugNet_IssueRevision_CreateNewIssueRevision stored procedure is not the most current version based on the updated to version 1.2. The below query should fix this issue, you will need to run it against your bugnet database.
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[BugNet_IssueRevision_CreateNewIssueRevision]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_IssueRevision_CreateNewIssueRevision]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[BugNet_IssueRevision_GetIssueRevisionsByIssueId]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_IssueRevision_GetIssueRevisionsByIssueId]
GO

CREATE PROCEDURE [dbo].[BugNet_IssueRevision_CreateNewIssueRevision]
    @IssueId int,
    @Revision int,
    @Repository nvarchar(400),
    @RevisionDate nvarchar(100),
    @RevisionAuthor nvarchar(100),
    @RevisionMessage ntext,
    @Changeset nvarchar(100),
    @Branch nvarchar(255)
AS

INSERT BugNet_IssueRevisions
(
    Revision,
    IssueId,
    Repository,
    RevisionAuthor,
    RevisionDate,
    RevisionMessage,
    DateCreated,
    Changeset,
    Branch
) 
VALUES 
(
    @Revision,
    @IssueId,
    @Repository,
    @RevisionAuthor,
    @RevisionDate,
    @RevisionMessage,
    GETDATE(),
    @Changeset,
    @Branch
)

RETURN SCOPE_IDENTITY()

GO

CREATE PROCEDURE [dbo].[BugNet_IssueRevision_GetIssueRevisionsByIssueId] 
    @IssueId Int
AS

SELECT *
FROM BugNet_IssueRevisions
WHERE IssueId = @IssueId
GO
Feb 6, 2013 at 5:24 PM
Hi,

thank you very much. This solved the problem with the exception.

Unfortunatelly the result is quite different then expected.
Now I can see the comment which I have added in tortoise displayed under the revions tab in bugnet.
That's fine.

I thought I will see the diffs in bugnet. Is this possible? I though I have seen this somewhere in a demo or a screenshot, but can not remember where.
This would be perfect. Is the only thing which I like currently where much in trac.

I hope this is possible in bugnet to?

thanks
Alex