Archives
SQL Server Error Code – 807 (no disk or the wrong disk is in the dri
In this blog post, you’ll learn more about the SQL Server Error Code 807 and the error message description that is shown SQL Server Error Code 807 SQL Server Error Description for the Code :807 (no disk or the wrong disk is in the drive)
SQL Server Error Code – 3401 errors occurred during recovery while ro
In this blog post, you’ll learn more about the SQL Server Error Code 3401 and the error message description that is shown SQL Server Error Code 3401 SQL Server Error Description for the Code :3401 Errors occurred during recovery while rolling back a transaction. The transaction was deferred. Restore the bad page or file, and re-run recovery.
SQL Server Error Code – 3992 transaction count has been changed from
In this blog post, you’ll learn more about the SQL Server Error Code 3992 and the error message description that is shown SQL Server Error Code 3992 SQL Server Error Description for the Code :3992 Transaction count has been changed from %d to %d inside of user defined routine, trigger or aggregate ?%.*ls?. This is not allowed and user transaction will be rolled back. Change…
How to fix the Oracle error ORA-08263: ora_addr: cannot free listener address?
In this post, you’ll learn more about the Oracle ErrorORA-08263: ora_addr: cannot free listener address with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-08263: ora_addr: cannot free listener address Reason for the Error ORA-08263: ora_addr: cannot free listener address The listener nameserver entry could not be freed How to fix the Error ORA-08263: ora_addr:…
How to fix the Oracle error ORA-16625: cannot reach database “string”?
In this post, you’ll learn more about the Oracle ErrorORA-16625: cannot reach database “string” with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-16625: cannot reach database “string” Reason for the Error ORA-16625: cannot reach database “string” The command could not be executed because the database noted in the error text was not reachable from…
How to fix the Oracle error DRG-11321: triggers detected on $I. OPTIMIZE REBUILD not supported?
In this post, you’ll learn more about the Oracle ErrorDRG-11321: triggers detected on $I. OPTIMIZE REBUILD not supported with the details on why you receive this error and the possible solution to fix it. Oracle Error Description DRG-11321: triggers detected on $I. OPTIMIZE REBUILD not supported Reason for the Error DRG-11321: triggers detected on $I. OPTIMIZE REBUILD not supported Cause: OPTIMIZE REBUILD is not supported…
NULLIF function in SQL Server
The NULLIF function in SQL Server returns a NULL value if the two input expressions return the same value else the first value (expression) is returned. For example , assume that you want to compare two columns (Address1 and Address2) in the Address table and want to return NULL if both are same to indicate there is NO change and if the addresses are different…
InterSystems IRIS General Error Code – 16003
In this post, you’ll learn about the General error code 16003 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 16003 Reason for the Error code 16003 in InterSystems IRIS DBMS HTTP POST has no content.
InterSystems IRIS TSQL Code 15415 User is a member of more than one group.
In this post, you’ll learn about the SQL error code 15415 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 15415 Reason for the Error code 15415 in InterSystems IRIS DBMS User is a member of more than one group. sp_changegroup is set up for backward compatibility and expects membership in…
InterSystems IRIS TSQL Code 21131 There are existing subscriptions to hete
In this post, you’ll learn about the SQL error code 21131 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 21131 Reason for the Error code 21131 in InterSystems IRIS DBMS There are existing subscriptions to heterogeneous publication ‘%s’. To add new articles, first drop the existing subscriptions to the publication.