Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Message: "Msg 7343, Level 16, State 4, Line 2" when updating

Hi,
I'm trying to update a custom field in the Opportunities table, using the following SQL:

Update [S_FORCE]...[Opportunity] set [Won_Lost__c] = 5 where [Id] = '006U0000003DXXXXXX'

and i get the following error:

OLE DB provider "DBAmp.DBAmp" for linked server "S_FORCE" returned message "Error 1 : Please update closed reason".
Msg 7343, Level 16, State 4, Line 3
The OLE DB provider "DBAmp.DBAmp" for linked server "S_FORCE" could not UPDATE table "[S_FORCE]...[Opportunity]".

I know the user id has full read write access to the table and field, I have set the Linked Server up as:

EXEC master.dbo.sp_addlinkedserver @server = N'S_FORCE', @srvproduct=N'DB Amp', @provider=N'DBAmp.DBAmp'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'S_FORCE',@useself=N'False',@locallogin=NULL,@rmtuser=N'xxxxxxxxxx',@rmtpassword='########'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'collation compatible', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'data access', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'dist', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'pub', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'rpc', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'rpc out', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'sub', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'connect timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'collation name', @optvalue=null
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'lazy schema validation', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'query timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'use remote collation', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'S_FORCE', @optname=N'remote proc transaction promotion', @optvalue=N'true'

does anyone have any ideas?

Thanks
1 person has
this question
+1
Reply