Menu ▾ ▴

#186 Trouble excluding tables

N/A
open
nobody
None
5
2015-01-22
2014-12-16
Stan Jackson
No

Hi there,

I am having trouble excluding tables from schemaspy.

I am using schemaSpy_5.0.0. I am using the oracle thin jdbc driver. I am also using schemaSpyGUI20090302.

I want to exclude all tables that begin with 'OCT' and all tables that begin with 'SYS_NT'.

I am using the -I "(OCT.) | (SYS.)".

The run complains about processing tables whose name begins with 'OCT' and it fails on table 'SYS_NT5fmf/nY0awngQ4NdAwr/Mw=='.

I have used schemaSpy successfully with many other Oracle databases, but have never had to exclude families of tables before today.

Any guidance would be appreciated.

The schemaspy output is included below...

Thanks,
-Stan

This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "C:\Apps\SchemaSpy\schemaSpy_5.0.0.jar" -dp "C:\Apps\SchemaSpy\ojdbc6.jar" -t orathin -db ospltdev -s DEV_OSMTS6 -host usadc-sdbxt21.quintiles.net -port 1521 -u dev_osmts6 -connprops "C:\Apps\SchemaSpy\schemaSpyGUI20090302\properties\orathin.properties" -connprops "-gv C:\Apps\SchemaSpy\dot.exe -o dev_osmts6 -s DEV_OSMTS6 -noviews" -I "(OCT.) | (SYS.)" -o "C:\Apps\SchemaSpy\schemaSpyGUI20090302\dev_osmts6" -hq

Failed to query Graphviz version information
with: dot -V
java.io.IOException: Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified
14:05:34.885 WARNING: SchemaAnalyzer.analyze - Unrecognized option(s): -connprops -gv C:\Apps\SchemaSpy\dot.exe -o dev_osmts6 -s DEV_OSMTS6 -noviews
Using database properties:
[C:\Apps\SchemaSpy\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/orathin.properties
Gathering schema details......................................................................................................................................................................................................................................14:07:37.111 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:37.111 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_BOOLEAN" where 0 = 1
.14:07:38.508 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:38.508 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_CODE" where 0 = 1
.14:07:39.302 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:39.302 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_CODELIST" where 0 = 1
.14:07:40.132 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:40.133 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_CUSTOM" where 0 = 1
.14:07:40.912 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:40.912 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_DECIMAL" where 0 = 1
.14:07:41.384 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:41.384 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_INTEGER" where 0 = 1
.14:07:41.749 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:41.749 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_META_PROPERTY" where 0 = 1
.14:07:42.134 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:42.134 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG" where 0 = 1
.14:07:42.518 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:42.518 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_BOOLEAN" where 0 = 1
.14:07:43.085 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:43.085 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_CODE" where 0 = 1
.14:07:43.393 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:43.394 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_CODELIST" where 0 = 1
.14:07:44.180 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:44.180 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_CUSTOM" where 0 = 1
.14:07:44.568 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:44.568 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_DECIMAL" where 0 = 1
.14:07:44.876 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:44.876 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_GROUP" where 0 = 1
.14:07:45.337 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:45.338 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_INTEGER" where 0 = 1
.14:07:45.657 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:45.657 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_TEXT" where 0 = 1
.14:07:45.947 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:45.947 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_RG_VPD" where 0 = 1
.14:07:46.362 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:46.362 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_TEXT" where 0 = 1
.14:07:46.688 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table

14:07:46.688 WARNING: Table.initColumnAutoUpdate - SQL: select * from DEV_OSMTS6."OCT_VPD" where 0 = 1
................................................................................................net.sourceforge.schemaspy.model.Table$1ColumnInitializationFailure: Failed to collect column details for table 'SYS_NT5fmf/nY0awngQ4NdAwr/Mw==' in schema 'DEV_OSMTS6'
at net.sourceforge.schemaspy.model.Table.initColumns(Table.java:295)
at net.sourceforge.schemaspy.model.Table.<init>(Table.java:88)
at net.sourceforge.schemaspy.model.Database$TableCreator.createImpl(Database.java:1003)
at net.sourceforge.schemaspy.model.Database$TableCreator.create(Database.java:999)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:259)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
Caused by: java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1185)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jdbc.driver.OracleDatabaseMetaData.getColumnsWithWildcards(OracleDatabaseMetaData.java:331)
at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:125)
at net.sourceforge.schemaspy.model.Table.initColumns(Table.java:281)
... 7 more

E=1I=1

Discussion

Log in to post a comment.