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 6 months ago #231

  • hpalacio
  • hpalacio's Avatar
Image showing MR Trace enable button.
Attachments:
Last Edit: 3 years 6 months ago by hpalacio.
The administrator has disabled public write access.

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

Infact I do run it correctly as you have suggested - but still no messages in the console window.

I have attached the image of the console - the way it looks AFTER running the script button with the MR tracing enabled.

I will try to attach the image as a doc file in the next message.

Thanks,
Rizwan
Last Edit: 3 years 6 months ago by Rizwan Qazi. Reason: Update
The administrator has disabled public write access.

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

Attaching the screen shot.

Attachment screen_04_08_2011_11_43_AM.doc not found

Attachments:
The administrator has disabled public write access.

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

  • hpalacio
  • hpalacio's Avatar
I was hoping you could get more output, because I haven't been able to get any output within my Windows virtual machine. I have a support case to improve logging for MR Trace in SQL Developer 3.0.

In the mean time, Can you try running in SQL Developer 2.x version? You can install next to version 3.0 and enable logging with the same procedure.
The administrator has disabled public write access.

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

Makes sense.

Thanks very much for your time.

Regards,
Rizwan
The administrator has disabled public write access.

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

Here is the console debug output for SQL Developer 2.1 on my windows machine.

Before that:
The file generated at the server is named:
lcd1_dev_ora_30766_METHODR_20110408173824.trc

Here is the query that is fired to check the file.
Seems like there the two names do not match. There is an extra DEV in the file name string constructed in the query.



select
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST','LCD1_DEV'||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST','LCD1_DEV'||'_DEV_ora_30766_METHODR_20110408173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',lower('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',lower('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',upper('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',upper('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',initcap('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',initcap('LCD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc'),
null)))) BFILE_COLUMN
from dual

C:\\>C:\\sqldeveloper-2.1.1.64.45\\sqldeveloper\\bin\\sqldeveloper.exe
FINEST [17:38:04:375][ExtensionAddin.initialize()]: Enter
INFO [17:38:04:390][PropertiesWrapper.load()]: Loading properties file 'C:\\Docum
ents and Settings\\rqazi\\.method-r\\mrtrace\\mrtrace.properties'.
props[fetch_enabled] = true
props[file_size_limit] = 0
props[default_metadata_description] =
props[prompt_for_metadata] = true
props[version] = 1.0.2.0
props[default_metadata_author] = rqazi
props[trace_file_directory] = C:\\mrtrace
props[default_metadata_project] =
props[first_run] = true
Loading xml to properties object.
WARNING [17:38:04:406][LicenseManager.validateLicense()]: Exception occurred dur
ing license validation: C:\\Documents and Settings\\rqazi\\.method-r\\mrtrace\\licens
e.xml (The system cannot find the file specified)
FINE [17:38:04:406][Serializer.deserialize()]: File read: C:\\Documents and Setti
ngs\\rqazi\\.method-r\\mrtrace\\trial.data
FINE [17:38:04:406][LicenseManager.initTrialLicense()]: This trial will expire i
n 22 days
FINE [17:38:04:406][LicenseManager.initialize()]: License type: TRIAL_VALID
FINEST [17:38:04:421][ExtensionAddin.initialize()]: Exit. Elapsed = 46 ms
FINEST [17:38:07:859][ExtensionIdeListener.mainWindowOpened()]: Enter
FINEST [17:38:07:859][ExtensionController.printDockStatus()]: Dock status = 0 (U
NKNOWN)
FINEST [17:38:07:859][ExtensionController.dockAndShow()]: DockStation.dock()
FINEST [17:38:07:875][ExtensionController.dockAndShow()]: isShowingByDefault=fal
se, isMinimizedByDefault=false, isRaisedByDefault=false
FINEST [17:38:07:875][ExtensionController.dockAndShow()]: DockUtil.showDockable
FINEST [17:38:08:000][TraceFetcherMainPanel.initialize()]: Enter
FINE [17:38:08:125][Serializer.deserialize()]: File read: C:\\Documents and Setti
ngs\\rqazi\\.method-r\\mrtrace\\columns.data
FINE [17:38:08:140][PopulateTableWorker.doInBackground()]: Trace file directory
is 'C:\\mrtrace'
FINE [17:38:08:140][Serializer.deserialize()]: File read: C:\\Documents and Setti
ngs\\rqazi\\.method-r\\mrtrace\\cmds.data
FINEST [17:38:08:140][TraceFetcherMainPanel.initialize()]: Exit. Elapsed = 125 m
s
FINEST [17:38:08:140][PopulateTableWorker.createRecordList()]: Enter
FINEST [17:38:08:156][PopulateTableWorker.createRecordList()]: Adding file: DMS1
_DEV_ora_1057_METHODR_20110406200555.trc
FINEST [17:38:08:156][ExtensionController.printDockStatus()]: Dock status = 43 (
UNKNOWN)
FINEST [17:38:08:156][ExtensionIdeListener.mainWindowOpened()]: Exit. Elapsed =
297 ms
FINEST [17:38:08:156][PopulateTableWorker.createRecordList()]: Adding file: DMS1
_DEV_ora_6543.trc
FINEST [17:38:08:171][PopulateTableWorker.createRecordList()]: Exit. Elapsed = 3
1 ms
Finished parsing = 0
UsersCache.fillIn() time = 390 ret==null?: false
Finished parsing = 0
Finished parsing = 0
1...?aux tok2?, parse time = 188
FINEST [17:38:18:265][ExtensionCommandListener.mrTraceStart()]: Enter
InsightableOracleDatabase.fetch() time = 313
Code completion time = 1329
FINE [17:38:23:875][MetadataDialog.handleOk()]: User pressed OK button
FINE [17:38:23:875][ExtensionAdapter.start()]: User submitted metadata.
FINER [17:38:23:875][DBAdapter.getSystemMetadata()]: Execute query: select host_
name node_name, instance_name instance, version oracle_release from sys.v_$insta
nce
FINER [17:38:23:937][DBAdapter.getSystemMetadata()]: Execute query: select platform_name from sys.v_$database
FINER [17:38:23:984][DBAdapter.getSystemMetadata()]: Execute query: select value cpu_count from sys.v_$parameter where name = 'cpu_count'
FINE [17:38:24:046][ExtensionAdapter.start()]: Adding system information to trace metadata record.
FINEST [17:38:24:046][TraceManager.initialize()]: Enter
CONFIG [17:38:24:062][TraceManager.queryUdumpDirectory()]: executing query: select directory_name from all_directories where directory_name = 'METHODR_UDUMP_DEST'
FINER [17:38:24:109][TraceManager.queryUdumpDirectory()]: The query returned the
string: METHODR_UDUMP_DEST
FINE [17:38:24:109][TraceManager.initialize()]: UDUMP directory exists.
FINE [17:38:24:171][TraceManager.initialize()]: Session permissions are valid.
FINER [17:38:24:171][TraceManager.initialize()]: connection name: lcd2_dev_os
FINER [17:38:24:171][TraceManager.initialize()]: dbmajorver: 10
FINER [17:38:24:171][TraceManager.initialize()]: dbminorver: 2
FINER [17:38:24:171][TraceManager.initialize()]: trcFileId: METHODR_201104081738
24
FINEST [17:38:24:171][TraceManager.initialize()]: Exit. Elapsed = 125 ms
FINEST [17:38:24:171][TraceManager.enableTracing()]: Enter
FINEST [17:38:24:218][TraceManager.enableTracing()]: Exit. Elapsed = 31 ms
FINEST [17:38:24:218][ExtensionCommandListener.mrTraceStart()]: Exit. Elapsed = 5953 ms
FINEST [17:38:24:406][ExtensionCommandListener.mrTraceStop()]: Enter
FINE [17:38:24:406][ExtensionAdapter.stop()]: Stop trace manager then download t
race file.
FINEST [17:38:24:406][TraceManager.disableTracing()]: Enter
FINEST [17:38:24:437][TraceManager.disableTracing()]: Exit. Elapsed = 31 ms
CONFIG [17:38:24:437][TraceManager.queryInstanceName()]: executing query: select
INSTANCE_NAME from sys.v_$instance
FINE [17:38:24:484][TraceManager.queryInstanceName()]: instance name = LCD1_DEV
FINER [17:38:24:484][TraceManager.generateTracefileName()]: Generating trace file name.
CONFIG [17:38:24:484][TraceManager.generateTracefileName()]: executing query: select cast(spid AS VARCHAR2(15))
from sys.v_$session s, sys.v_$process p,
(select sid from sys.v_$mystat where rownum = 1) sid where s.paddr = p.addr

and s.sid = sid.sid
FINE [17:38:24:546][TraceManager.generateTracefileName()]: spid = 30766
CONFIG [17:38:24:546][TraceManager.generateTracefileName()]: executing query: se
lect dbms_utility.port_string from dual
FINE [17:38:24:593][TraceManager.generateTracefileName()]: platform name = x86_6
4/Linux 2.4.xx
INFO [17:38:24:593][TraceManager.queryBfile()]: Query database for BFILE locator
object.
CONFIG [17:38:24:593][TraceManager.queryBfile()]: executing query: select
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST','LCD1_DEV'||'_DEV_ora_
30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST','LCD1_DEV'||'_DEV_ora_30766_METHODR_2011040
8173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',lower('LCD1_DEV')|
|'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',lower('LCD1_DEV')||'_DEV_ora_30766_METH
ODR_20110408173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',upper('LCD1_DE
V')||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',upper('LCD1_DEV')||'_DEV_ora_30766_
METHODR_20110408173824.trc'),
decode(dbms_lob.fileexists(bfilename('METHODR_UDUMP_DEST',initcap('L
CD1_DEV')||'_DEV_ora_30766_METHODR_20110408173824.trc')),
1,bfilename('METHODR_UDUMP_DEST',initcap('LCD1_DEV')||'_DEV_ora_
30766_METHODR_20110408173824.trc'),
null)))) BFILE_COLUMN
from dual
WARNING [17:38:24:640][TraceManager.queryBfile()]: ResultSet.getBFILE() returned
NULL.
FINEST [17:38:24:656][ExtensionCommandListener.mrTraceStop()]: Exit. Elapsed = 2
50 ms
FINEST [17:38:24:656][ExtensionAdapter.downloadThread()]: Enter
FINEST [17:38:24:656][ExtensionAdapter.downloadThread()]: Exit. Elapsed = 0 ms
FINE [17:39:07:937][PopulateTableWorker.doInBackground()]: Trace file directory
is 'C:\\mrtrace'
FINEST [17:39:07:937][PopulateTableWorker.createRecordList()]: Enter
FINEST [17:39:07:937][PopulateTableWorker.createRecordList()]: Adding file: DMS1
_DEV_ora_1057_METHODR_20110406200555.trc
FINEST [17:39:07:937][PopulateTableWorker.createRecordList()]: Adding file: DMS1
_DEV_ora_6543.trc
FINEST [17:39:07:937][PopulateTableWorker.createRecordList()]: Exit. Elapsed = 0
ms
The administrator has disabled public write access.