sql server 2008 - Invalid Object Name for Table which is successfully updated in the same Stored Procedure -


we seeing 'interesting behavior our sql sever database. have merge statement selects table x. in match clauses there subselect table x. when execute stored procedure sql server tools works fine. when executed ipc (an etl tool) exception invalid object name 'x'.

so far nothing special understand there can lots of things wrong permissions , stuff.

the strange thing: merge statement in try block , in catch block error message gets written table x via update statement! how possible when sql server complains can't find table x?

also works fine stored procedure constructed in same way (via code generation) on different set of tables.

the code looks this

    merge ...     using     (select ...     dbo.x     ...     when not matched target      , not exists (select 1 dbo.x q2 ...)     insert (...     )     values (...     )     when matched , q.action='d'     delete     when matched , not exists (select 1 dbo.x q3 ...)     update      set       ...      output $action @l_summaryofchanges;     -- query results of table variable.     select action, count(*) countperchange     @l_summaryofchanges     group action;   end try   begin catch     update dbo.x     set last_error_msg=error_message(), error_counter=error_counter+1     sync_id=@l_syncid   end catch

any ideas going on?invalid object name 'sync$_tabteiledaten'.

we found it. gbn's question triggered realization usage of x had nothing exception. in fact on target table of merge trigger referencing x different schema without specifying schema.

may benefit way debugged shit:

  • we duplicated x new name (y) , still got error message saying 'invalid object name 'x'. @ point thought might reference view or ..
  • we removed columns (there lots of) merge statement, except necessary due not null constraints. problem persisted
  • we removed 1 of branches of merge statement @ time. problem persisted.
  • we removed complete merge statement. error gone. @ point realized fishy might go on target table.
  • on inspection found trigger hell.

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more