database - Trigger on db1.table1 fails immediately fails when it references db2.table2 -


i working system (i not developer) uses half dozen databases, on same sybase ase 15.7 server.

the 2 important databases need access transactions , configuration. both updated in real-time, , in real-time can capture data want. here's super-simplified example of trigger:

use transactions go create trigger mytrigger on userlog insert  begin -- -- stuff here within transaction database, no problems. -- .......  -- now, try access configuration database, , boom, fails insert mylog (somedata) select userdata  configuration.dbo.userconfiguration ...blah...  end

my trigger fails when table referenced outside of transactions database, not @ other time.

btw, i'm logged in systems admin when create trigger.

as noted in sybase documentation, triggers part of transactions , if serious error occurs in trigger, transaction rolled back. see occurring.

i suspect error due 1 of 3 possible causes:

  1. security grants tables in 'other' database kind
  2. security-limitation configured @ time database built
  3. a sybase restriction cannot overcome

regarding #1, i've granted select public , 'dbo' on userconfiguration table. dbo user creating userlog in transactions. i'm not sure grant applying correctly since every user scoped specific database, not global user.

regarding #2, can't figure out if there possible limitations configured in, , not overcome.

regarding #3, sybase documentation states trigger should able reference tables in other databases.

lastly, since cannot see error being raised or trap it, have nothing go on tackle problem. don't want insert own records monitored table because it's not table. i've hunted around kind of error log don't see such thing. there one? i've researched trying set equivalent of try-catch blocks, blocks prevent error bubbling up, sybase appears not have such controls.

does have ideas how might progress forward here?

my trigger going populate table of own in real-time , needs select 'inserted' object, , tables in 2 databases.


Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more