Home » Developer & Programmer » Data Integration » Large LOG FIle Causing Problem? (12.1.2)
Large LOG FIle Causing Problem? [message #674600] Tue, 05 February 2019 04:48 Go to next message
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
Re: Large LOG FIle Causing Problem? [message #674606 is a reply to message #674600] Tue, 05 February 2019 07:48 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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.
Re: Large LOG FIle Causing Problem? [message #674608 is a reply to message #674606] Tue, 05 February 2019 08:16 Go to previous messageGo to next message
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.
Re: Large LOG FIle Causing Problem? [message #674609 is a reply to message #674608] Tue, 05 February 2019 08:24 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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.
Re: Large LOG FIle Causing Problem? [message #674618 is a reply to message #674609] Wed, 06 February 2019 00:01 Go to previous message
vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad
Member
Is there any way to stop generating the LOG.
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:
  


Current Time: Sun Dec 08 07:11:40 CST 2019