Archives

Azure Recipe #1 – Query Performance Insight and Long Running Queries

Problem You have a SQL Azure database and you wish to identify which queries in your database takes more time to execute. Solution You can use Query Performance Insights in Azure to identify the slow running queries in SQLAzure. The Query Performance Insight provides intelligent query analysis for both single and pooled databases. It is a nice tool that lets you to find queries to…

InterSystems IRIS General Error Code – 701

In this post, you’ll learn about the General error code 701 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 701 Reason for the Error code 701 in InterSystems IRIS DBMS LDAP error(%1): %2

InterSystems IRIS General Error Code – 5984

In this post, you’ll learn about the General error code 5984 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 5984 Reason for the Error code 5984 in InterSystems IRIS DBMS In order to run pages in this application we need an authenticated user.

How to fix the Oracle error ORA-27434: cannot alter chain step job string.string.string?

In this post, you’ll learn more about the Oracle ErrorORA-27434: cannot alter chain step job string.string.string with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-27434: cannot alter chain step job string.string.string Reason for the Error ORA-27434: cannot alter chain step job string.string.string A step job of a running chain cannot be altered, only stopped…

How to fix the Oracle error ORA-48260: Function string not found?

In this post, you’ll learn more about the Oracle ErrorORA-48260: Function string not found with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-48260: Function string not found Reason for the Error ORA-48260: Function string not found A reference to a function that is not valid was found How to fix the Error ORA-48260: Function…

How to fix the Oracle error SQL*Loader-00529: OCI return status: invalid handle?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00529: OCI return status: invalid handle with the details on why you receive this error and the possible solution to fix it. Oracle Error Description SQL*Loader-00529: OCI return status: invalid handle Reason for the Error SQL*Loader-00529: OCI return status: invalid handle The message describes the status code returned by an OCI call. How to fix the…

How to fix the Oracle error NID-00133: Database should have only consistent datafiles?

In this post, you’ll learn more about the Oracle ErrorNID-00133: Database should have only consistent datafiles with the details on why you receive this error and the possible solution to fix it. Oracle Error Description NID-00133: Database should have only consistent datafiles Reason for the Error NID-00133: Database should have only consistent datafiles The database has one or more datafiles that are marked FUZZY in…

MariaDB Error 1382 – ER_RESERVED_SYNTAX

In this post, you’ll learn more about the MariaDB Error 1382 ER_RESERVED_SYNTAX with the details of the error message and why you receive this error Maria DB Error Description MariaDB Error 1382 – ER_RESERVED_SYNTAX with the sqlState HY000 Error Description for the MariaDB Error ER_RESERVED_SYNTAX The ‘%s’ syntax is reserved for purposes internal to the MariaDB server