Blog

How to fix the Oracle error ORA-21706: duration does not exist or is invalid?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-21706: duration does not exist or is invalid with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-21706: duration does not exist or is invalid Reason for the Error ORA-21706: duration does not exist or is invalid The duration number that is supplied by the user…

How to fix the Oracle error ORA-09922: Can’t spawn process – background log directory not created properly?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-09922: Can’t spawn process – background log directory not created properly with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-09922: Can’t spawn process – background log directory not created properly Reason for the Error ORA-09922: Can’t spawn process – background log directory not created properly…

SQL Server Error Code – 40071 this partition does not have enough vali

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 40071 and the error message description that is shown SQL Server Error Code 40071 SQL Server Error Description for the Code :40071 This partition does not have enough valid secondaries to start a DML transaction. The needed count is %ld, the current counts are %ld (main quorum) and %ld (transient quorum).

SQL Server Error Code – 15337 caution: sys.sql_dependencies shows that

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 15337 and the error message description that is shown SQL Server Error Code 15337 SQL Server Error Description for the Code :15337 Caution: sys.sql_dependencies shows that other objects (views, procedures and so on) are referencing this object by its old name. These objects will become invalid, and should be dropped and re-created…

SQL Server Error Code – 13726 setting system_versioning to on failed b

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 13726 and the error message description that is shown SQL Server Error Code 13726 SQL Server Error Description for the Code :13726 Setting SYSTEM_VERSIONING to ON failed because history table ‘%.*ls’ is referenced by one or more BLOCK security predicates. Consider removing the BLOCK security predicates referencing this table and trying again.

SQL Server Error Code – 11543 set statistics xml on and set statistics

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 11543 and the error message description that is shown SQL Server Error Code 11543 SQL Server Error Description for the Code :11543 SET STATISTICS XML ON and SET STATISTICS PROFILE ON are not allowed inside any procedure or batch that executes through an EXECUTE statement that has a WITH RESULT SETS clause.