My Oracle Support Banner

"This is a writable tree with No root." Error When Create or Delete Reports Server or Reports Tools in Reports 12c (Doc ID 2147435.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Reports Developer - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Reports 12c, attempting to create/delete Reports Tools or standalone Reports Server fails with error:

ERROR

wls:/base_domain/serverConfig/> createReportsServerInstance(instanceName='rep_server',machine='AdminServerMachine')
Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Traceback (innermost last):
File "", line 1, in ?
File "/C:/oracle/Middleware/Oracle_Home/ReportsServerComponent/plugins/wlst/repserver-wlst-dependencies.jar!/wlstScriptDir/OracleReportsServer.py", line 22, in createReportsServerInstance
File "/C:/oracle/Middleware/Oracle_Home/ReportsServerComponent/plugins/wlst/repserver-wlst-dependencies.jar!/wlstScriptDir/reports_server_handler.py", line 152, in reportsServer_createReportsServerInstance
File "", line 164, in cd
File "", line 553, in raiseWLSTExceptionWLSTException: Error occurred while performing cd : Attribute oracle.reports:Type=ReportsServerComponent,Name=ReportsServerComponentManager not found. Use ls('a') to view the attributes wls:/base_domain/editCustom/oracle.reports>


STEPS
The issue can be reproduced at will with the following steps:


wls:/offline> connect ("weblogic","########","########:7001")
Connecting to t3://hostname:7001 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "base_domain".

wls:/base_domain/serverConfig/> createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')
or
wls:/base_domain/serverConfig/> createReportsServerInstance(instanceName='rep_server',machine='AdminServerMachine')
or
wls:/base_domain/serverConfig/> deleteReportsToolsInstance(instanceName='reptools1')

 

1) Already tried solution in:

  <Note:2098157.1> Error "This is a writable tree with No root." while Executing createReportsServerInstance Command in Reports 12c

That is, added the missing component "Oracle Reports Server - 12.2.1 [ReportsServerComponent]" to this Domain (running again the configuration wizard config.sh/cmd and selecting update domain).

2) Also, confirmed that commands are run in Administrator mode.

3) The problem happens in one particular environment. Other 12c environments/installs work fine.


Samples:

Administrator: Command Prompt - wlst.cmd
===========================================

wls:/base_domain/serverConfig/> createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')
Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Starting an edit session ...
Started edit session, be sure to save and activate your changes once you are done.
Error occurred while performing invoke : Problem finding error class; nested exception is:
java.lang.ClassNotFoundException: Failed to load class oracle.sysman.oii.oiil.OiilNativeException
Use dumpStack() to view the full stacktrace :
createReportsToolsInstance() failed.
Edit session has been stopped successfully.
wls:/base_domain/serverConfig/> dumpStack()
This Exception occurred at Thu Mar 03 08:33:16 GMT+12:00 2016.
java.rmi.UnmarshalException: Problem finding error class; nested exception is:
java.lang.ClassNotFoundException: Failed to load class oracle.sysman.oii.oiil.OiilNativeException
at weblogic.rjvm.ResponseImpl.getThrowable(ResponseImpl.java:214)
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:257)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:290)
at javax.management.remote.rmi.RMIConnectionImpl_12210_WLStub.invoke(Unknown Source)
at weblogic.management.remote.common.RMIConnectionWrapper$16.run(ClientProviderBase.java:1263)

........

 

Administrator: Command Prompt - wlst.cmd
===========================================

wls:/base_domain/serverConfig/> createReportsServerInstance(instanceName='rep_server',machine='AdminServerMachine')
Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Traceback (innermost last):
File "<console>", line 1, in ?
File "/C:/oracle/Middleware/Oracle_Home/ReportsServerComponent/plugins/wlst/repserver-wlst-dependencies.jar!/wlstScriptDir/OracleReportsServer.py", line 22, in createReportsServerInstance
File "/C:/oracle/Middleware/Oracle_Home/ReportsServerComponent/plugins/wlst/repserver-wlst-dependencies.jar!/wlstScriptDir/reports_server_handler.py", line 152, in reportsServer_createReportsServerInstance
File "<iostream>", line 164, in cd
File "<iostream>", line 553, in raiseWLSTExceptionWLSTException: Error occurred while performing cd : Attribute oracle.reports:Type=ReportsServerComponent,Name=ReportsServerComponentManager not found. Use ls('a') to view the attributes wls:/base_domain/editCustom/oracle.reports>

 

Administrator: Command Prompt - wlst.cmd
===========================================

C:\oracle\Middleware\Oracle_Home\oracle_common\common\bin>wlst.cmd
>connect("weblogic","xxxxxx","hostname:7001")
>deleteReportsToolsInstance(instanceName='reptools1')

Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Traceback (innermost last):
File "<console>", line 1, in ?
File "/C:/oracle/Middleware/Oracle_Home/ReportsToolsComponent/plugins/wlst/reptools-wlst-dependencies.jar!/wlstScriptDir/OracleReportsTools.py", line 32, in deleteReportsToolsInstance
File "/C:/oracle/Middleware/Oracle_Home/ReportsToolsComponent/plugins/wlst/reptools-wlst-dependencies.jar!/wlstScriptDir/reports_tools_handler.py", line 158, in reportsTools_deleteReportsToolsInstance
File "<iostream>", line 164, in cd
File "<iostream>", line 553, in raiseWLSTExceptionWLSTException: Error occurred while performing cd : Attribute oracle.reports:Type=ReportsToolsComponent,Name=ReportsToolsComponentManager not found. Use ls('a') to view the attributes wls:/base_domain/editCustom/oracle.reports>

 

Changes

 New Reports/Forms 12c Installation.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.