Red Gate forums :: View topic - Trigger generates error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Trigger generates error

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
dsp



Joined: 30 Jan 2010
Posts: 17

PostPosted: Mon Mar 08, 2010 9:20 pm    Post subject: Trigger generates error Reply with quote

Hello,
I just installed SQL Source Control EAP 1.1.0.11 and tried to add a database to our team server. After committing the changes I received the following error:

Failed to update:
Quote:
#oEc.#8Jf: Errors occured whilst parsing file C:\Users\danny\AppData\Local\Red Gate\SQL Source Control 0\Transients-TFS\ae8a33f1-d80e-4c6b-a86f-1b9076626d12\Tables\dbo.E_Sold_Policies.sql
'line 56:41: expecting "on", found '[dbo]''
'line 57:18: unexpected token: [",",<641>,line=57,col=18] [char=4283]'
'line 57:18: unexpected token: [",",<641>,line=57,col=18] [char=4283]'
'line 58:3: unexpected token: ["AS",<638>,line=58,col=3] [char=4293]'
'line 58:3: unexpected token: ["AS",<638>,line=58,col=3] [char=4293]'
---> #Eyg.#Lyg: Errors occured whilst parsing file C:\Users\danny\AppData\Local\Red Gate\SQL Source Control 0\Transients-TFS\ae8a33f1-d80e-4c6b-a86f-1b9076626d12\Tables\dbo.E_Sold_Policies.sql
'line 56:41: expecting "on", found '[dbo]''
'line 57:18: unexpected token: [",",<641>,line=57,col=18] [char=4283]'
'line 57:18: unexpected token: [",",<641>,line=57,col=18] [char=4283]'
'line 58:3: unexpected token: ["AS",<638>,line=58,col=3] [char=4293]'
'line 58:3: unexpected token: ["AS",<638>,line=58,col=3] [char=4293]'
---> line 56:41: expecting "on", found '[dbo]'
--- End of inner exception stack trace ---
at #oEc.#7Jf.#t.#B3.#sKf()
at #oEc.#7Jf.#gKf(Action action)
--- End of inner exception stack trace ---

Server stack trace:
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.#t.#izb.#j5f()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)


I located the mentioned file and found at line 56 the following:
Code:
CREATE TRIGGER [trg_CurrentAccount][dbo].[trg_CurrentAccount] ON [dbo].[E_Sold_Policies]
    AFTER INSERT, UPDATE
AS
    BEGIN


I hope you can fix this.
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Tue Mar 09, 2010 6:56 pm    Post subject: Reply with quote

2 Things:

1) Could you please check for updates to make sure you have the latest version? To do this, please click Help > Check for Updates... near the Red Gate logo on the SQL Source Control tab. The latest version is 0.3.0.1, which was released on March 8th.

2) Could you please email SQLSourceControlSupport@red-gate.com with the file located at C:\Users\danny\AppData\Local\Red Gate\SQL Source Control 0\Transients-TFS\ae8a33f1-d80e-4c6b-a86f-1b9076626d12\Tables\dbo.E_Sold_Policies.sql? This way, we can try to reproduce it locally so we can provide a fix for you. Our internal reference number for this issue is SOC-802.
Back to top
View user's profile Send private message
dsp



Joined: 30 Jan 2010
Posts: 17

PostPosted: Tue Mar 09, 2010 7:59 pm    Post subject: Trigger generates error Reply with quote

1. Yes, it is the latest version (I downloaded it yesterday), and I checked it, it is 0.3.0.1.
2. The file I sent by email.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
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 cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group