Hello everybody,
today I want to leave SQL fix for error message:
"There are problems on database server side:
READ_COMMITTED_SNAPSHOT is not set for current database.
On your Acumatica instance it may look liike this:
For fixing run this SQL:
ALTER DATABASE Saddleback_staging SET READ_COMMITTED...
Hello everybody,
today I want to leave a short notice on how to use Autofac in Acumatica, but with single registration. In another article I've descirbed how to use Autofac for resolving interface < -- > class implementation.
But one of my collegues Deebhan Hari pointed that...
Hello everybody,
today I want to share with you few words about debugging of Acumatica. There are plenty of wonderful posts for doing this with help of already provided PDB files of existing graphs and first of all I definetely recommend to use them.
But there are scenarios when default pdb provi...
Hello everybody,
today I want to leave a post about the following case: you need to index rows in your database by some unique value, which can be null. And you don't want index to include those values which are null.
How to achieve it? Following T-SQL can do this:
CREATE UNIQUE INDEX idx_s...
Hello everybody,
today I want to leave a notice with proposal on how to program reaction on clicking of Abort button in processing screen.
Recently it become needed for me to program some functionality to happen after user clicks on button Abort of processing screen.
In my case I needed so...
Hello everybody,
today I want to leave a short post on how to create some custom view in Acumatica Customization if that view doesn't exist:
if not exists (select * from sysobjects where name='CustomerSelector' and xtype='V')
begin
exec (
&nb...
Hello everybody,
here I want to leave a short notice on how to avoid hearing yourself if you are connected over TeamViewer to somebodies computer. By defualt TeamViewer duplicates sound that goes through sound system of computer to which you've connected.
Not many people know, that such functiona...
Hello everybody,
today I want to leave short note on how to override and call CreatePaymentProc method of Acumatica which I discovered today with Naveen from Kensium.
My favorite way of overriding methods in Acuamtica with usage of Action and passing there parameters doesn't work. That is because...
Hello everybody,
today I want to leave another portion of SQL Server optimization for Acumatica database. In case if your db become huge, and you want to make it smaller, you can try following SQL code:
DECLARE @Table NVARCHAR(128)
DECLARE @Database NVARCHAR(128)
D...