How can we help you today? How can we help you today?

Trigger generates error

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: 
CREATE TRIGGER &#91;trg_CurrentAccount&#93;&#91;dbo&#93;.&#91;trg_CurrentAccount&#93; ON &#91;dbo&#93;.&#91;E_Sold_Policies&#93;
    AFTER INSERT, UPDATE
AS
    BEGIN

I hope you can fix this.
dsp
0

Comments

2 comments

Sort by
  • StephanieHerr
    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.
    StephanieHerr
    0
  • dsp
    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
    0

Add comment

Please sign in to leave a comment.