W
Wim
Guest
Hello Mani, We are facing the following issue: There is an object called ‘vehicletyres’ with approx 500.000 records. During an object script trigger that was created to run in order to update a specific field, we noticed an error on one of three (different) expression fields in the same object that the system also updates due to running the objectscript update trigger. There is a ‘lock table is full message’ that occurs when we want to delete the three expression field that we don’t need anymore. Now surveying the documentation we saw the possibility of transaction isolation and we were hoping that this would solve the lock table message. You are right; we are in need of a solution, but the transaction isolation function is completely new for us. Maybe the –L parameter can also be ingreased, but we dont no where the file is where the –L can be set. Hopefully you can help. Thanks in advance. Wim Hassink Van: Mani Kumar [mailto:bounce-makumar@community.progress.com] Verzonden: zaterdag 26 maart 2016 17:43 Aan: TU.Rollbase@community.progress.com Onderwerp: RE: [Technical Users - Rollbase] transacion isolation level: Suggested Answer Update from Progress Community RE: transacion isolation level Mani Kumar Hi, You can set this in the databases.xml file as below: com.ddtek.jdbc.ddcloud.DDCloudDriver jdbc:datadirect:ddcloud://service.datadirectcloud.com:443; databaseName=RB_DBO root my_password TxIsolation="2" refers to the isolation transaction level in rollbase. Please be sure about the usage and functioning of each level before you change or refer related databases manual for respective details (Request not to change this value if you are not completely aware of it) Also, can you share the stack and scenario to reproduce for our further investigation? Regards, Mani Did this answer your question? Verify it as the answer or Reject it as the answer View online You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here . Flag this post as spam/abuse.
Continue reading...
Continue reading...