4 Replies Latest reply on Jul 25, 2013 9:34 PM by Barry Mcgillin-Oracle

SQL Developer CLI (sdcli) - Report Generation on Linux

Vishal Gupta Jul 16, 2013 5:37 PM

I am trying to use the sdcli to generate user defined reports on linux. It seems to work on windows, but on linux it gives following error. Same command works fine on windows and generate the html report.

[oracle@linux3:11203_RHEL6] ./sdcli reports generate -report "Vishal/Sizes/Schema Sizes" -db 11203_RHEL6 -file vg.html -bind OWNER=%

Oracle SQL Developer

Jun 30, 2013 3:39:22 AM javax.ide.extension.spi.DefaultElementContext resolveResource

SEVERE: jar:/file:/opt/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.migration.application.jar!/META-INF/extension.xml:16: Resource not found: '${SCRATCH_COMMAND_ICON}'.

Invalid reports command: -FILE

1. Re: SQL Developer CLI (sdcli) - Report Generation on Linux

Vishal Gupta Jul 17, 2013 2:39 PM (in response to Vishal Gupta)

Anyone seen this error?
Like Show 0 Likes(0)

Actions
2. Re: SQL Developer CLI (sdcli) - Report Generation on Linux

Turloch O'Tierney-Oracle Jul 19, 2013 5:51 PM (in response to Vishal Gupta)

Hi VishalGupta,

1/Which version of SQLDeveloper are you using the recent 4.0 EA or the Production 3.2.2?
2/I have not seen the error you mention (unless there is a typing error in the command).
3/There was a problem with 3.2.2 - need to set the PATH otherwise SQLDeveloper may get confused with another version of SQLDeveloper stored in /opt and referenced elsewhere in the PATH ('which sqldeveloper' to see where it is)
4/I had to use a full path for the file name i.e. /tmp/vg.html on my test case (which did not reproduce your issue) (*)
5/'force_print' in html script output is a bug

(*)export PATH=`pwd`:$PATH ; bash ./sdcli reports generate -report z -db DB_NAME -file /tmp/zzq4.html
Oracle SQL Developer
Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.

Java asserts are enabled!
Success!

-Turloch
SQLDeveloper Team
Like Show 0 Likes(0)

Actions
3. Re: SQL Developer CLI (sdcli) - Report Generation on Linux

Vishal Gupta Jul 25, 2013 8:41 PM (in response to Turloch O'Tierney-Oracle)

Turloch,

Thanks for the reply. I was using SQL Developer 4.0 EA1. I noticed that my problem was because of the space in the report name. See following link.

SQLDev4 - sdcli - space in report name (Linux/Mac)

Regards,
Vishal Gupta
http://blog.vishalgupta.com
Like Show 0 Likes(0)

Actions
4. Re: SQL Developer CLI (sdcli) - Report Generation on Linux

Barry Mcgillin-Oracle Jul 25, 2013 9:34 PM (in response to Vishal Gupta)

Vishal,
Youre right. I just fixed this under bug 17221719
B
Like Show 0 Likes(0)

Actions

Go to original post