Welcome, Guest
Username: Password: Remember me

TOPIC: Trace files are not being downloaded to the client

Re:Trace files are not being downloaded to the client 3 years 7 months ago #238

The following returns valid results:

select
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',lower('lcd1') ||'_dev_ora_30766_METHODR_20110408173824.trc')), 1,
bfilename('METHODR_UDUMP_DEST',lower('lcd1')||'_dev_ora_30766_METHODR_20110408173824.trc'))
from dual;


Name lcd1_dev_ora_30766_METHODR_20110408173824.trc
Data Length 4682
File Exists true
Directory Alias METHODR_UDUMP_DEST
The administrator has disabled public write access.

Re:Trace files are not being downloaded to the client 3 years 7 months ago #241

Support,

Any solutions for me...?

Is it a bug that will be fixed? Or is there a workaround for me?

I really need to to test it out so that I can start using MR Trace at work.

Thanks for the help.
Rizwan
The administrator has disabled public write access.

Re:Trace files are not being downloaded to the client 3 years 7 months ago #242

  • hpalacio
  • hpalacio's Avatar
Rizwan,

I apologize for the delayed response. Yes this is a bug that we are currently working on. It happens when building the trace file name on instances that have an underscore in it name. A workaround could be to rename the instance.

Harold

Edit:
As an end user you may not have permissions to rename an instance. If you do then you will already know to take caution as this will affect other areas such as the connection string.
Last Edit: 3 years 7 months ago by hpalacio. Reason: adding cautionary statement
The administrator has disabled public write access.

Re:Trace files are not being downloaded to the client 3 years 7 months ago #243

Thanks for the reply. I will wait for the fix.
The administrator has disabled public write access.

Re:Trace files are not being downloaded to the client 2 years 10 months ago #287

I have same problem - maybe new version since this post?
I have tried both sql-developer 2.1.1.64.45 and 3.0.04.34.
I can only get debug-info from v2. Here's something I think looks suspicius:
Jan 26, 2012 12:52:53 PM com.methodr.trace.manager.TraceUtil getBfile
INFO: Executing '/resources/files/get_bfile.sql' :
declare
v_dirname varchar2(100) := ?;
v_instance varchar2(100) := ?;
v_subfilename varchar2(100) := ?;
v_bfile BFILE;
begin
v_bfile := CASE WHEN dbms_lob.fileexists(bfilename(v_dirname,v_instance||v_subfilename)) = 1
THEN bfilename(v_dirname,v_instance||v_subfilename)
WHEN dbms_lob.fileexists(bfilename(v_dirname,lower(v_instance)||v_subfilename)) = 1
THEN bfilename(v_dirname,lower(v_instance)||v_subfilename)
WHEN dbms_lob.fileexists(bfilename(v_dirname,upper(v_instance)||v_subfilename)) = 1
THEN bfilename(v_dirname,upper(v_instance)||v_subfilename)
WHEN dbms_lob.fileexists(bfilename(v_dirname,initcap(v_instance)||v_subfilename)) = 1
THEN bfilename(v_dirname,initcap(v_instance)||v_subfilename)
ELSE NULL
END;
--end;
? := v_bfile;
end;

Jan 26, 2012 12:52:53 PM com.methodr.trace.manager.TraceUtil getBfile
WARNING: BFILE not returned

thanks for any help
rgds Peter Binderup
The administrator has disabled public write access.

Re:Trace files are not being downloaded to the client 2 years 10 months ago #288

  • hpalacio
  • hpalacio's Avatar
Hi Peter,

Can you send an email to to open a support case? In addition could you provide the MR Trace version number. The latest version is 2.0.0.43.

Thanks,
Harold
The administrator has disabled public write access.