Monday, July 13, 2009

ORA-20100: Error: FND_FILE FAILURE unable to create file in the directory,/usr/tmp.

Concurrent requests are failed with the below error:

ORA-20100: Error: FND_FILE failure. Unable to create file, o0040178.tmp in thedirectory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1

Upon checking below settings there is no issue :

1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter are valid and pointing to directory where there is enough space and users have written permission.
2. FND_FILE.PUT_LINE is able to create new files in the temporary directory.

FND_FILE.PUT_LINE Checking method:

SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

This should dump a file on APPLPTMP. If this test works, it would indicate that FND_FILE is ok and the problem is possibly with the Application.

You may want to leave only one entry on utl_file_dir for this test.

finally I checked the utl_file_dir, but there is no entry like /usr/tmp path in that list
SQL> connect / as sysdbaSQL> show parameter UTL_FILE_DIR

just I added /usr/tmp for the UTL_FILE_DIR & restarted the applications & database.

now the issue is resolved & concurrent requests are working fine

36 comments:

Anonymous said...

Hmm it appears like your site ate my first comment (it was super long) so
I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying your blog.
I as well am an aspiring blog blogger but I'm still new to everything. Do you have any tips and hints for rookie blog writers? I'd certainly appreciate it.


my web blog; danonjewellery-banned-dnvhagfcha.posterous.com

Anonymous said...

While we're dabbling in the market of Design Being married Ring, Heart is an effective choice for jewelry because of its durability and beauty. Sterling silver could be marked with words for example sterling, silver, ster, or.925 to demonstrate the coffee quality

Feel free to surf to my site - http://www.efatum.com/index.php?do=/profile-281/info/

Anonymous said...

Hurrah! After all I got a blog from where I can actually obtain valuable
information concerning my study and knowledge.


Feel free to visit my blog :: xerox phaser 8560 Toner Cartridges

Anonymous said...

are made up of gray-white. Panel control is
the basis of a curriculum vitae, listing, take out, treatment of paper
jam button and many other indications on the within.
This HP LaserJet printer is not as.

My web site: xerox Phaser 8560 Drivers

Anonymous said...

I have a grinding noise that is keeping me from publishing anything from the Cyan toner.

Could this coincide instance?

Review my website - ezpt.kr

Anonymous said...

Thanks for your facts.
No problem installingl the vist64 motorist.


Also visit my web-site; xerox phaser 8560 ink

Anonymous said...

I genuinely adored this radiant post. Please proceed this incredible do
business.

my web-site; xerox phaser 8560 Driver

Anonymous said...

Overall investment in solar nebula theory energy increasing by the day.
The irony is that cap-and-trade is a market-based approach to environmental
protection, which harnesses the power of special interest groups.
The solar nebula theory energy is at the heart of hog country.

5 million impairments so far, the scheme, which began at the beginning
of the year with $2. But surely wind and solar parks that provide the village's electricity. The turbine uses the flow of water that comes from the line of Judd [Nuffbaum] with Redwood Capital. The demand has picked up recently.

my web site - sharpsolar.biz

Anonymous said...

Anti skin industries exercise can be effective with the proper diet and
nutritional supplements. But then again, if you focus on a diet which
burns body fat.

My web blog: skinnytaste

Anonymous said...

What's up, yup this paragraph is actually good and I have learned lot of things from it about blogging. thanks.

my weblog ... http://kathw89cga.soup.io

Anonymous said...

I feel this is among the such a lot vital information for me.
And i'm happy studying your article. But want to statement on some normal things, The site taste is perfect, the articles is in reality nice : D. Excellent process, cheers

Here is my website ... hultquist copenhagen

Anonymous said...

exactly how can i do this on a mac.

Feel free to surf to my webpage :: xerox Phaser 8560 Printer

Anonymous said...

Hello! I know this is kinda off topic but I was wondering which blog platform
are you using for this website? I'm getting tired of Wordpress because I've had issues with
hackers and I'm looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform.

my page; Private Cloud Computing

Anonymous said...

http://hapna.com/pre/buypropeciaonline/#19634 propecia cost on nhs - propecia results after 1 year

Anonymous said...

My pc (window 7) doesnot other than the CD vehicle drivers to
set up.

Also visit my site - xerox phaser 8560 ink

Anonymous said...

Note that the above mentioned easy gig bags for archtop guitars tabs for beginners, there isn't much to adjust. In standard tuning it is the last thing the strings rest upon and can affect the sound as well and is also made of varied materials. You'll learn the secrets
of your favorite songs on gig bags for archtop guitars.

Note: the editor would like to have shipped - give me a call.
If you're looking to improve your sound and technique.

Look into my website :: www.hasenchat.net

Anonymous said...

I wonder if your soldering iron wrong in size hot for your solder.


Also visit my homepage: http://www.friendturf.Com/Jada93A

Anonymous said...

though that should have a lot more deeper attention and I'll manage them in different post: 3D printing, and mobile app.

My web-site; xerox Phaser 8560mfp ink

Anonymous said...

Hey There. I found your blog using msn. This is an extremely well written article.

I will be sure to bookmark it and return to read more
of your useful info. Thanks for the post.
I'll certainly comeback.

my blog post: best hosting companies

Anonymous said...

Greetings! Very helpful advice within this article!
It's the little changes that will make the biggest changes. Thanks for sharing!

Feel free to visit my webpage - Hultquist earrings

Anonymous said...

Hello there, just became aware of your blog through Google, and found that it is really informative.

I am gonna watch out for brussels. I will appreciate
if you continue this in future. Many people will be benefited from
your writing. Cheers!

my web-site cheap pilgrim Jewellery

Anonymous said...

Amazing! Its in fact remarkable paragraph, I have got much clear idea about from this post.


Also visit my blog - pilgrim jewellery denmark [http://www.squidoo.com]

Anonymous said...

are made up of gray-white. Panel control is the basis of a curriculum vitae, list, eliminate, care of paper jam
button and numerous various other indications on
the in. This HP LaserJet printer is not as.

Here is my web blog: xerox phaser 8560 Printer (jiyon.com)

Anonymous said...

Great article. Keep up to date the great work.

Here is my web page ... danon Jewellery Uk

Anonymous said...

Thanks for the marvelous posting! I definitely enjoyed reading it, you can be a great author.
I will make sure to bookmark your blog and will often come back later in life.
I want to encourage one to continue your great posts, have a nice afternoon!


Check out my web page ... acne ()

Anonymous said...

We're a group of volunteers and starting a new scheme in our community. Your web site provided us with valuable information to work on. You have done an impressive job and our whole community will be grateful to you.

my website: viewdetails ()

Anonymous said...

I adore the Circle Chain Braclet- so simple yet so perfect!


my page :: sterling silver jewellery

oakleyses said...

nike air max, gucci handbags, ugg boots, louis vuitton outlet, polo ralph lauren, christian louboutin outlet, christian louboutin uk, cheap oakley sunglasses, nike free, tory burch outlet, burberry pas cher, polo outlet, jordan shoes, sac longchamp pas cher, oakley sunglasses, replica watches, louis vuitton, longchamp outlet, oakley sunglasses, nike free run, christian louboutin shoes, ray ban sunglasses, oakley sunglasses wholesale, louis vuitton outlet, nike air max, louis vuitton, louboutin pas cher, tiffany jewelry, prada handbags, nike roshe, oakley sunglasses, air max, prada outlet, ugg boots, nike outlet, tiffany and co, ray ban sunglasses, longchamp outlet, chanel handbags, michael kors pas cher, longchamp pas cher, jordan pas cher, replica watches, polo ralph lauren outlet online, uggs on sale, longchamp outlet, kate spade outlet, christian louboutin

oakleyses said...

ray ban uk, coach purses, polo lacoste, sac vanessa bruno, nike tn, hogan outlet, michael kors, michael kors outlet online, converse pas cher, nike air max uk, kate spade, michael kors outlet, hollister pas cher, uggs outlet, coach outlet, north face, michael kors outlet, north face uk, nike air max uk, ray ban pas cher, uggs outlet, nike air force, ralph lauren uk, mulberry uk, lululemon canada, nike free uk, true religion jeans, guess pas cher, replica handbags, timberland pas cher, nike blazer pas cher, coach outlet store online, michael kors outlet online, burberry handbags, abercrombie and fitch uk, michael kors, nike air max, michael kors outlet, vans pas cher, oakley pas cher, true religion outlet, hollister uk, nike roshe run uk, sac hermes, true religion outlet, new balance, michael kors outlet online, burberry outlet, true religion outlet

oakleyses said...

timberland boots, instyler, wedding dresses, mcm handbags, beats by dre, ghd hair, converse, oakley, herve leger, nike huaraches, hollister, valentino shoes, nfl jerseys, mac cosmetics, vans, abercrombie and fitch, insanity workout, mont blanc pens, hollister clothing, reebok outlet, bottega veneta, louboutin, lululemon, p90x workout, baseball bats, nike roshe run, celine handbags, vans outlet, converse outlet, north face outlet, hermes belt, new balance shoes, north face outlet, ray ban, longchamp uk, jimmy choo outlet, babyliss, ralph lauren, gucci, chi flat iron, soccer jerseys, asics running shoes, iphone cases, ferragamo shoes, hollister, nike trainers uk, soccer shoes, nike air max, giuseppe zanotti outlet, nike air max

oakleyses said...

canada goose, moncler outlet, canada goose outlet, toms shoes, montre pas cher, louis vuitton, moncler, canada goose, swarovski, juicy couture outlet, louis vuitton, replica watches, links of london, moncler, canada goose uk, moncler uk, hollister, wedding dresses, thomas sabo, karen millen uk, canada goose outlet, barbour uk, louis vuitton, ugg uk, ugg,ugg australia,ugg italia, moncler outlet, doudoune moncler, ugg,uggs,uggs canada, canada goose, supra shoes, coach outlet, canada goose outlet, ugg pas cher, ugg, pandora uk, louis vuitton, canada goose jackets, juicy couture outlet, moncler, marc jacobs, louis vuitton, pandora jewelry, lancel, swarovski crystal, pandora jewelry, pandora charms, barbour, moncler

chenlili said...

michael kors outlet
fitflops outlet
coach outlet online
pandora uk
ugg clearance
north face uk
michael kors taschen
ferragamo shoes
nba jerseys
ralph lauren outlet
201712.9chenjinyan

chenmeinv0 said...

kevin durant shoes
ray ban sunglasses
ugg boots
michael kors canada
nike tn
mizuno wave
jordan
montre
ugg boots
vans
2018.1.26xukaimin

tamer said...

الصيانة المنزلية بجدة والمدينة المنورة للقيام بكافة ما يبحث عنه عملائنا من أعمال تمديد الغاز المركزي والسباكة والكهرباء والنجارة والدهانات وفني تركيب الدش بأمهر المتخصصين وأقل التكاليف وسرعة للتواصل مع عملائنا الكرام بجدة والمدينة.

سباك بالمدينة المنورة
كهربائي بالمدينة المنورة
دهان بالمدينة المنورة
نجار بالمدينة المنورة
معلم سباك بجدة
معلم كهربائي بجدة
معلم دهان بجدة

tamer said...

جميع خدمات وأعمال الصيانة المنزلية لعملائنا بجدة والمدينة المنورة لأعمال صيانة أعطال الكهرباء وصيانة السباكة وأعمال السباكة والنجارة والكهرباء والدهانات للمنازل والفنادق والمنتجعات السياحية والمستشفيات والمدارس والمكاتب والمنشأت بأنواعها بأفضل متخصصين فى مجالات أعمال الصيانة المنزلية وتمديدات الغاز المركزي وتوفير كافة مستلزمات الكهرباء وتوفيرمستلزمات الصحي للسباكة وتركيب الدش وبرمجة الرسيفرات وتركيب الشاشات، من خلال ارقام سباك ودهان وكهربائي ونجار وفني دش بجدة والمدينة المنورة أفضل متخصصين بأرخص أسعار.

فني سباكة بالمدينة المنورة
فنى كهربائي بالمدينة المنورة
معلم بوية بالمدينة المنورة
رقم سباك بجدة
فني دش بجدة
رقم كهربائي بجدة
رقم دهان بجدة
معلم جبس بورد بجدة
رقم فني دش بجدة
نجار بجدة

tamer said...

شركة تيجان من أفضل الشركات التى تقوم بنقل الأثاث والعفش باحدث الاجهزة كما نقوم بشراء الأثاث
شركة نقل عفش بالمدينة المنورة
شركة تنسيق حدائق بالمدينة المنورة
شركة شراء اثاث مستعمل بالمدينة المنورة
افضل شركة مكافحة حشرات بالمدينة المنورة مكافحة القوارض والزواحف والحشرات الطائرة باستخدام أقوى المبيدات الفعالة المصرح بها من وزارة الصحة السعودية، خدماتنا لمكافحة الحشرات طوال ال 24 ساعة وأحدث معدات رش المبيدات الحشرية، مبيدات أمنة لن تغادر المنزل وليس لها أي أثار صحية على الأطفال أو الذين يعانون من أمراض الحساسية
شركة مكافحة حشرات بالمدينة المنورة
شركة مكافحة النمل الابيض بالمدينة المنورة
شركة مكافحة حشرات بالمدينة المنورة
شركة تركيب طارد الحمام بالمدينة المنورة