Sequence Check don't respect inactive record of ad_table
Description
1. go to Table and Column duplicate a record, example A_Asset 2. inactive new record just create at step 1 3. run Sequence Check 4. get issue "org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block" reason: Sequence Check don't respect inactive record, so make exception "More than one row returned by a subquery used as an expression" when update Sequence
1. go to Table and Column duplicate a record, example A_Asset
2. inactive new record just create at step 1
3. run Sequence Check
4. get issue "org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block"
reason: Sequence Check don't respect inactive record, so make exception
"More than one row returned by a subquery used as an expression" when update Sequence