ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified 00604. 00000

Problem:

While connecting to an Oracle database with SQL Developer or JDeveloper, you might got this error:

Error:

An error was encountered performing the requested operation:
ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified 00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement            (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack            can be corrected, do so; otherwise contact Oracle Support. Vendor code 604

Solution:

The solution for this problem is simple, but I had to go through a number of websites to find its solution. So here it is:

1. If you are using SQL Developer:

Goto SQL Developer directory and there will be another SQL Developer directory, open it. Open bin folder, and you will find sqldeveloper.conf file in it.

Add 2 entries in sqldevelper.conf file:

AddVMOption -Duser.language=en
AddVMOption -Duser.region=US

Save the file and reopen SQL developer application, connect the database. Hope it will resolve your problem.

2. For JDeveloper, you have to perform the same procedure as described in (1), but in jdev.conf file.

Windows Update not working on newly installed Windows system.

Hi All,

You may experience this type of problem, where windows update was not working. You can follow below steps to ensure everything is correct and on its way.

1. First of all, check all Services related to Windows Update, like Windows Update Service, Cryptographic, BITS etc, are running.

2. Secondly, make sure your internet is properly working and you are able to browse windows update website in your browser. (http://www.update.microsoft.com/windowsupdate/)

3. Make sure you have installed all the latest drivers on your PC/Laptop, especially Operating System enhancements drivers, etc. This is an important step because it can prevent Windows Update from downloading updates.

4. Check the Software Distribution folder, whether it has the downloaded updates. The folder must be present in Windows directory.

5. If the downloaded updates are there, then check the Update History, available in Windows Update form.

6. Also check the WindowsUpdate.log file in Windows directory for errors. If there is an error in the log, try to search this error on the internet.

7. If log error shows error code : 8009017, then go to this microsoft page and reset Windows Update components by following the steps written there.

I hope this post will help you resolve the Windows Update problems. Must tell me the results by commenting on the blog.

Have a nice day.

God Bless.

Configure Office 365 Email on Android Mobile App

While Office 365 does not officially support open source mail clients, this article will provide you with settings that may help you set up your mail client to access Office 365 Exchange.

If your email client supports Exchange Web Services (EWS), use the following settings:

Field	Value
Email Address	(YOUR EMAIL ADDRESS)
Username	(YOUR EMAIL ADDRESS)
Domain	Leave Blank
Exchange Server	outlook.office365.com
Server Address	https://outlook.office365.com
EWS Server	https://outlook.office365.com/ews/exchange.asmx
Outlook Web Access	https://outlook.office365.com

If your email client does not support Exchange Web Services (EWS), you will need to configure your client to use traditional POP/IMAP + SMTP. Use the following settings:

User Settings:

Email Address	(YOUR EMAIL ADDRESS)
Username	(YOUR EMAIL ADDRESS)

Inbound Servers:

Type	Server Address	Port
POP Server (SSL)	outlook.office365.com	995
IMAP Server (SSL)	outlook.office365.com	993

Outbound Servers:

Type	Server Address	Port
SMTP Server (SSL)	smtp.office365.com	587

Unexpected Error occurred in the Oracle Data Provider for .NET

While working with Oracle Data Provider with Visual studio you can get the following error:

The description for Event ID 0 from source devenv cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
An unexpected error occurred in the Oracle Data Provider for .NET.  The data provider 'Oracle Data Provider for .NET' failed to load.  The {18147ff9-1f37-4425-865b-5066a33701de} service could not be found.
the message resource is present but the message is not found in the string/message table

Solution:

The simple solution to this problem is to check your "Server Explorer" in Visual Studio, remove all connections, and then restart Visual studio.

Hopefully your problem will be solved.

iREPORT (Jasper Reports): Working with date and time

Date and time handling is slightly complex in all Programming Languages, since each area has different date/time format and each language has its own way of handling these objects. In iReport, many developers finds difficulty in formatting, treating date and time in day-to-day operations. I am listing here some of the useful tricks/methods to be used in iReport:

1. To get the current date and time:

new Date()

2. To get the current date only (Today in .Net):

 new Date( (new Date()).getYear(),(new Date()).getMonth(), (new Date()).getDate())

3. To check if a variable / date is null?:

$F{ThisDate} == null

4. In development, there arise some situations in which we have to use the current date if a date is null, then use a variable and assign it the following expression:

$F{ThisDate} == null ? new Date( (new Date()).getYear(),(new Date()).getMonth(), (new Date()).getDate()): $F{ThisDate}

5. To get the difference between two dates (including start and end date) in "No. of Days" unit:

(int) ((($F{OutTime}==null? (new Date( (new Date()).getYear(),(new Date()).getMonth(), (new Date()).getDate())).getTime(): (new Date($F{OutTime}.getYear(),$F{OutTime}.getMonth(), $F{OutTime}.getDate()).getTime())) - (new Date($F{InTime}.getYear(),$F{InTime}.getMonth(), $F{InTime}.getDate())).getTime())/ (1000 * 60 * 60 * 24))+1

where, getTime translates the date into milliseconds which allows to add subtract days.
To convert the result from milliseconds to days we divide the result by  (1000 * 60 * 60 * 24).
To include the start date in difference we added 1. In beginning of the expression, we used "(int)" to  cast the output to integer value.

I hope that the above information may be useful to you. Please feel free to comment, if you find any correction or you have a better solution.

Thanks!

Angular JS: Initializing a controller with a server side run-time value

This problem may look too much difficult for newbies to Angular JS. I was also stucked for some days, googled different websites, but no website could give me any working solution to my problem. Atlast I asked my senior and he helped me to solve this difficult problem in just few minutes.

Problem:

The problem was that I was using multiple partial views on my MVC view. I was trying to use Angular JS for just one of the partial view, whereas, all other views were using server side MVC controller. I had to pass a parameter from server side to my angular JS controller, so that it can get the data based on the parameter.

Solution:

First I tried ngInit approach, but it didn't worked. Every time data function was executing first and then initialize function was executing, as a result undefined parameter was passing to my controller function.

My senior advised me to initialize global variable in javascript on view with the value that I want to pass as a parameter, like this:

//script start

var globalValue = @MyValue;

//script end


then in the angular js controller use this global value like this:

$scope.GetFunctionData(globalValue).then( function() {
.
.
.
}


That's all!

Please write to me whether this solution worked for you. Stay blessed :)

Visual Studio Error: Unable to embed resource : Not enough memory to complete the operation

Error:

While building your project in VS 2010, you could get the following error:

Visual Studio Error: Unable to embed resource : Not enough memory to complete the operation

Solution:

This is a common issue in VS 2010, which have been discussed on a lot of forums, but I think nobody is assure about the solution. I get this error today, and took about half an hour to try to resolve it but I got no fruitful result. 

The main reason behind this problem is lack of memory and the project size expansion. Therefore, the Windows runs out of the memory. The quick and temporary solution is to select all files or at least the big-ones (specially the Crystal Reports) from your project using the solution explorer, check if their properties are set as Embedded Resource, change it to Content, then try to run the project. Don't change the files on which you are currently working on. This will prevent VS to embed unnecessary files. But remember, you will have to re-embed these files while building the final version like setup or publishing the project.