Dear Community,
I have recently encountered an interesting problem regarding scripting and merge functions in version 7.2.4.
I have a scheduled scriptrunner service which migrates data across 3 databases in ARIS using the built in merge functionailties.
Now, this report needs to be ran quite often, every minute to be precise, since we need our databases to be up to date all the time.
The issue is: every time the merge user logs in, the Sybase transaction log gets fed a couple of KBytes, and over 5 days, it grew to as big as 28 gigs.
This is a very serious issue, that needs to be resolved asap. So if you have encountered a similar problem, or have a method on how to reduce the log size, or even eliminate the logging entirely to the database, please chip in your knowledge.
Thanks in advance for your input!
Ákos