Trigger generates error

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Trigger generates error

Postby dsp » Mon Mar 08, 2010 9:20 pm

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:
#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: Select all
CREATE TRIGGER [trg_CurrentAccount][dbo].[trg_CurrentAccount] ON [dbo].[E_Sold_Policies]
    AFTER INSERT, UPDATE
AS
    BEGIN


I hope you can fix this.
dsp
 
Posts: 17
Joined: Sat Jan 30, 2010 7:46 pm

Postby sherr » Tue Mar 09, 2010 6:56 pm

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.
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Trigger generates error

Postby dsp » Tue Mar 09, 2010 7:59 pm

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.
dsp
 
Posts: 17
Joined: Sat Jan 30, 2010 7:46 pm


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests