Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…

MS Access Error: 3162: “You tried to assign the Null value to a variable that is not a Variant data type.”

Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…

Show carrier’s current and previous rates information by destination

Background: After rate sheets applied in the billing system provided by the partners/carriers, executive likes to sort out the destination and carrier with their latest applied rates along with their very previous rates with the below format: Carrier Name | Destination | Prefix | Applied Date | Applied Rate | Previous Date | Previous Rate…

CDR cross check to resolute dispute with parties

In telecommunication sometimes it needs to analyze traffic to resolute dispute with parties; in this case either parties or both will provide their CDRs and will cross-check them. CDR cross-checking criteria: CDR should be matched with respect to call: start_time, a_party, b_party and duration Some cases partners have differences in the call pattern for a_party…

MS Access Tutorial: Displaying an alert message when recordset returns no value

Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…