Cache InterSystems Database And SSIS

This Post is important as I got an experienced with Cache Intersystems Database and SSIS.  Most of you who don't know about Cache database, this is not relational database. This Database is based on classes and objects and it reside in memory.

CACHE DB CONNECTION :

Cache DB is connected with ODBC connection only. You will find ODBC connection in ADO.NET component.

In my Case Tables were not loading into the SSIS. And I had no clue what are the table names so I have to use SQL command. If you are also in this situation then you can use Access DB it uses an easy way to connect and load to ODBC and it can show you all the tables. Another way is to use SSMS and use link serves to get to the ODBC. I personally would prefer to use Access because of easiness.

Follow the screen shots and once you setup the connection for Cache database in SSIS, Right click the ADO component and select properties and Set the connection manager.

This is should fix the Cache and other ODBC connections to SSIS.

Database Emails

The most incentive stuff a new DBA would like to implement first is always emails. Email are very important part of SQL as it is the efficient way for DBA to know if any anything goes wrong.

But using Emails efficiently is another problem I like to share one story let give him a fake name ABC since I don't want to offend the guy lol:) . Now he planned his email in this way that he would get email of each and everything going on example he received email for each back up , differential backup and transition log. I was surprised when he complaint that his emails are too much for him. As I advised him if he can follow a reverse order example if something goes down then you received email. that going to surely reduce the frequency of sql mails.

Ok let start what to do when Database mails are not working.

First I am not explaining how to start the Database wizard I hope you already know.
What I am trying to focus is when you start thinking why your email is not working I identified those places.

First thing to check, Profile  make sure if you are using the correct profile.
Second, Check the email address, Server and Port number.
I always keep it simple espcially when I know I am in secure intranet I don't use SSL certificate but you can optional.
And one Important part if your emails are hosted that mean some third party is taking care fro Microsoft exchange then you need to provide the credentials no exception but again if you are in intranet and consider you intranet to be safe keep it anonymous.

Now let say you already check above nothing happened.
Go and check you Anti-Virus exclude MSSQL and check port number if its block or unavailable.
You can check port by telnet or ping use command line.

MIrror Suspend Error 1583

when I do resume the mirror it trys to synchronize but fails and suspends itself after around 30 seconds always with the same size of unrestored log - does this mean there is a bad part of the log?

And you dont want to break the mirror because if it  happen then  you need full backup of the live database and restore it to the mirror.

Sometimes suddenly we see that Mirror is suspended. This is a common problem,  and this error normally comes up from the when either the Data Disk or Log Disk is getting full. So Clean the Disk and Let the Mirror Continue Easily. Remember to resume the Mirror by going Task->Mirror-> Resume.


And always start trouble shooting by looking at the logs of the SQL rather than looking at google first :)

Operating System error 5

Operating System error 5, very common error normally this error is raised because user has right issue on the folders or been restricted by operating system. So contact your Network Admin and Settle all the rights issue and everything will be good to go.