OraFAQ Forum: Data Integration » Large LOG FIle Causing Problem?

Home » Developer & Programmer » Data Integration » Large LOG FIle Causing Problem? (12.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Large LOG FIle Causing Problem? [message #674600]

Tue, 05 February 2019 04:48

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello,

I am having a concurrent program, which I am running 2 times for different set of parameters.

Parameter Set 1 : Generates a log file which is small around 3000 lines. Program is completing successfully.

Parameter Set 2 : Generates a log file which is huge around 100 k lines. Program is completing in error with :

Cause: FDPSTP failed due to ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "APPS.ERROR_HANDLER", line 2299

There are no file read write operations happening in the code.

Any suggestions what could be the issue?

Thanks,
Vaibhav

Report message to a moderator

Re: Large LOG FIle Causing Problem? [message #674606 is a reply to message #674600]

Tue, 05 February 2019 07:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

vaibhav15211 wrote on Tue, 05 February 2019 02:48

Hello,

I am having a concurrent program, which I am running 2 times for different set of parameters.

Parameter Set 1 : Generates a log file which is small around 3000 lines. Program is completing successfully.

Parameter Set 2 : Generates a log file which is huge around 100 k lines. Program is completing in error with :

Cause: FDPSTP failed due to ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "APPS.ERROR_HANDLER", line 2299

There are no file read write operations happening in the code.

Statement below is directly contradicted by admission that LOG FILE is being populated.
Somewhere & somehow file write is happening.
BTW the code producing the LOG FILE has a bug which results in error above.

>There are no file read write operations happening in the code.

Report message to a moderator

Re: Large LOG FIle Causing Problem? [message #674608 is a reply to message #674606]

Tue, 05 February 2019 08:16

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

I used dbms_utility.format_error_backtrace to check the exact location of error and took me back to oracle ERROR_HANDLER API at below point:
Error_Handler.Debug_File := utl_file.fopen( p_output_dir
, p_debug_filename
, 'w');
I understand that the statement sounds contradicting but I am not sure why the program is completing fine when log file is small and why not when it is huge.
The code producing log file is a Oracle Standard API.

Report message to a moderator

Re: Large LOG FIle Causing Problem? [message #674609 is a reply to message #674608]

Tue, 05 February 2019 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I would look for a buggy EXCEPTION handler which silently consumes error which needs to be reported or fixed.

Report message to a moderator

Re: Large LOG FIle Causing Problem? [message #674618 is a reply to message #674609]

Wed, 06 February 2019 00:01

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Is there any way to stop generating the LOG.

Report message to a moderator

Previous Topic:	Issue while connecting to AS400 database from talend ESB
Next Topic:	Import data from other DB or excel into Oralce or export data from Oracle into other db or excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 05:04:48 CST 2024