Description
 

This page provide solution to the Oracle schema extraction error:

Extracting: Oracle not wrapped valid functions...
Error on: Oracle not wrapped valid functions: wrong columns number! expected: 21 found: 22
An Error has occurred during command processing
Error running CAST database extractor!
An exception has occurred during source package file creation
An Error has occurred during command processing

java.lang.IllegalMonitorStateException:
                at java.lang.Object.wait(Object.java:-2)
                at com.castsoftware.extractor.exporter.IdentificationGroupExporter.executeQuery(IdentificationGroupExporter.java:356)
                at com.castsoftware.extractor.exporter.IdentificationGroupExporter.exportType(IdentificationGroupExporter.java:151)
                at com.castsoftware.extractor.exporter.IdentificationGroupExporter.run(IdentificationGroupExporter.java:71)
                at com.castsoftware.extractor.exporter.Exporter.exportSlice(Exporter.java:511)
                at com.castsoftware.extractor.exporter.Exporter.export(Exporter.java:359)
                at com.castsoftware.extractor.exporter.DatabaseExporter.exportServer(DatabaseExporter.java:356)
                at com.castsoftware.extractor.cli.DatabaseExtractor.process(DatabaseExtractor.java:419)
                at com.castsoftware.cli.CommandLineApplication.processWithOldLogging(CommandLineApplication.java:1100)
                at com.castsoftware.cli.CommandLineApplication.parseAndRun(CommandLineApplication.java:941)
                at com.castsoftware.cli.CommandLineApplication.access$0(CommandLineApplication.java:887)
                at com.castsoftware.cli.CommandLineApplication$2.call(CommandLineApplication.java:870)
                at com.castsoftware.cli.CommandLineApplication$2.call(CommandLineApplication.java:1)
                at com.castsoftware.util.logger.Logging.execute(Logging.java:491)
                at com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:354)
                at com.castsoftware.cli.CommandLineApplication.launch(CommandLineApplication.java:864)
                at com.castsoftware.cli.CommandLineApplication$1.call(CommandLineApplication.java:810)
                at com.castsoftware.cli.CommandLineApplication$1.call(CommandLineApplication.java:1)
                at com.castsoftware.util.logger.Logging.execute(Logging.java:491)
                at com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:383)
                at com.castsoftware.cli.CommandLineApplication.run(CommandLineApplication.java:804)
                at com.castsoftware.extractor.cli.DatabaseExtractor.main(DatabaseExtractor.java:440)

 

This error can be seen in the extraction log. To see the log location, refer the section Possible location for logs of the page : Delivery Manager Tool - Logs  

Observed in CAST AIP
Release
Yes/No
8.0.x (error) 
7.3.x, x<2(tick)
7.2.x, x<4(tick)
7.0.x(error)
Observed on RDBMS
This section is not applicable for this page(DMT)

 

RDBMS
Yes/No
Oracle ServerNA
Microsoft SQL ServerNA
CSS2NA
CSS1NA
Step by Step Scenario
Use Delivery Manager Tool and package Oracle Schema
Action Plan

This issue is encountered when extraction is done with user having All views rights instead of DBA views.

Workaround is to

  1. Use DBA views, which also improve performance.

Refer the release notes - Required RDBMS rights for packaging a database > Oracle server

Impact on Analysis Results and Dashboard

Impact of Error : Extraction is not successful
Impact of Workaround : No impact

Notes/comments

Issue is fixed in 7.2.4 and ported to 7.3.2

Related Pages