Archives

How to fix the Oracle error PRKC-01002: All the submitted commands did not execute successfully?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorPRKC-01002: All the submitted commands did not execute successfully with the details on why you receive this error and the possible solution to fix it. Oracle Error Description PRKC-01002: All the submitted commands did not execute successfully Reason for the Error PRKC-01002: All the submitted commands did not execute successfully Cause: Either a node failed in…

How to fix the Oracle error PLS-01418: Subquery cannot include set operators in ANSI’s grammar?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorPLS-01418: Subquery cannot include set operators in ANSI’s grammar with the details on why you receive this error and the possible solution to fix it. Oracle Error Description PLS-01418: Subquery cannot include set operators in ANSI’s grammar Reason for the Error PLS-01418: Subquery cannot include set operators in ANSI’s grammar Subquery cannot include set operators in…

How to fix the Oracle error NNL-01003: NON LEAF responses received: number?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorNNL-01003: NON LEAF responses received: number with the details on why you receive this error and the possible solution to fix it. Oracle Error Description NNL-01003: NON LEAF responses received: number Reason for the Error NNL-01003: NON LEAF responses received: number Cause: Control program statistic description How to fix the Error NNL-01003: NON LEAF responses received:…

How to fix the Oracle error DRG-10874: savescore must be true to use topn in ctxfiltercache?

AbundantCode 1 year ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorDRG-10874: savescore must be true to use topn in ctxfiltercache with the details on why you receive this error and the possible solution to fix it. Oracle Error Description DRG-10874: savescore must be true to use topn in ctxfiltercache Reason for the Error DRG-10874: savescore must be true to use topn in ctxfiltercache Cause: savescore must…

MariaDB Error 1855 – ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS

AbundantCode 1 year ago in MariaDB 0

In this post, you’ll learn more about the MariaDB Error 1855 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS with the details of the error message and why you receive this error Maria DB Error Description MariaDB Error 1855 – ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS with the sqlState HY000 Error Description for the MariaDB Error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS Cannot replace hidden FTS_DOC_ID with a user-visible one

SQL Server 2014 Tutorial – List all the databases in SQL Server using Query

AbundantCode 1 year ago in SQL Server 1

Problem Statement You need to list all the databases that are present in the current SQL Server instance. Solution The list of all the databases from the SQL Server instance can be obtained from the sys.databases object as shown below. 1. Open SQL Management Studio and connect to the SQL Server instance with your login details. 2. Click the “New Query” button and enter the…

SQL Server Error Code – 22995 a value for the parameter @retention can

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 22995 and the error message description that is shown SQL Server Error Code 22995 SQL Server Error Description for the Code :22995 A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.

SQL Server Error Code – 41138 cannot accept always on availability gro

AbundantCode 1 year ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 41138 and the error message description that is shown SQL Server Error Code 41138 SQL Server Error Description for the Code :41138 Cannot accept Always On Availability Groups operation operation on database ‘%.*ls’ of availability group ‘%.*ls’.  The database is currently processing another operation that might change the database state. Retry the…