Databases and other data stores which treat the integrity of data as paramount often include the ability to handle transactions to maintain the integrity of data. A single transaction consists of one or more independent units of work, each reading and/or writing information to a database or other data store.
Hi,
We recover a large amount of data from an external database (SQLServer, about 1 million rows in JDBC). However, we have treatment time issue. This process takes more than 30 minutes whereas on a "classic" SQL Server Management Studio type request takes less than a minute.
In one of the projects, when we have ECP with 10 ECP application servers, from time to time we faced the issue when our journals fail to purge, due to open transactions. While we have about 100-150 GB journal files per day, it quite quickly became a big issue, and with mirroring a very big issue. Mostly we just rebooted our ECP Data server, so it searches rollbacks any transactions, but such process is too long, may steal a few hours. I did not find any way, how to get the list of the open transactions from one place from ECP Data Server. We just migrated our Data server to 2018.1.
I have a question about the %OnSave method of a class. We have a class that has two properties that are classes.
Class A
Class B
Class C
Class A.PropertyB as Class B
ClassA.PropertyC as Class C
Classes B and C also need to point back to Class A - it's just the way it is. We need to be able to use any one of these classes and get to the others (it's actually even more complicated than this, as Classes B and C also have a PropertyC and PropertyB as well, respectively) :
If I wanted to build a web-based dashboard that monitored various HIE transactions where would I start?
Examples of measures would be Provide & Registers by Facility, Patient Views by facility or even PHR related data.
I have a successful POC that uses nodejs, html and SQL but I think it makes more sense to use Intersystems technology all the way around, I just don't know where to begin.
will InterSystems fix the Transaction-Handling for the .Net Connection Provider?
Nor the Property IsTransactionAcvtive nor TransactionLevel is set on the Connection when using BeginTransaction.
Latest PreView will give me problem as InterSystems removed removed the TStart() Option to create the Transaction that way which gave back a TransactionObject whith working versions...
When performing an update transaction on patient data in GUI Apex 5.8 cache2017, we randomly get a ‘Database Connection Lost’ error. Subsequently the application quits and the incomplete transaction is rolled back.
We have confined its not a network issue as we can still query the database using CHUI Apex when these events occur.
The system I am working on processes large numbers of records. Inserts, updates and so forth. There are multiple processes that can potentially work on the same table at the same time.
It is an almost impossible task to try and time these processes to not run at the same time, due to volumes, SLAs, etc.
Every now and then there are a few locking issues, Not many considering the volumes. It is just a bit of a nuisance as we need to reprocess these records later.
By views