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
Release | Yes/No |
---|---|
8.0.x | |
7.3.x, x<2 | |
7.2.x, x<4 | |
7.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | NA |
Microsoft SQL Server | NA |
CSS2 | NA |
CSS1 | NA |
This issue is encountered when extraction is done with user having All views rights instead of DBA views.
Workaround is to
- Use DBA views, which also improve performance.
Refer the release notes - Required RDBMS rights for packaging a database > Oracle server
Impact of Error : Extraction is not successful
Impact of Workaround : No impact
Issue is fixed in 7.2.4 and ported to 7.3.2