View Issue Details

IDProjectCategoryView StatusLast Update
0005850SymmetricDSBugpublic2023-09-13 17:25
Reporterprogmomen Assigned To 
Priorityhigh 
Status closedResolutionopen 
Product Version3.14.7 
Summary0005850: Db2DdlReader - Failed to read table
DescriptionI'm trying to build the sym tables using ./symadmin create-sym-tables in DB2 (Redhat) 11.5.4
But I keep getting NullPointerException during startup.

Db2DdlReader - Failed to read table: SYM_EXTENSION. Error: null
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.NullPointerException
        at org.jumpmind.db.model.Table.findColumn(Table.java:694)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:658)
        at org.jumpmind.db.platform.db2.Db2DdlReader.readTable(Db2DdlReader.java:99)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:553)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:535)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:492)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:535)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:319)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:346)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:334)
        at org.jumpmind.symmetric.service.impl.ExtensionService.refresh(ExtensionService.java:87)
        at org.jumpmind.symmetric.service.impl.ClientExtensionService.refresh(ClientExtensionService.java:45)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.autoConfigRegistrationServer(AbstractSymmetricEngine.java:502)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:483)
        at org.jumpmind.symmetric.SymmetricAdmin.createSymTables(SymmetricAdmin.java:736)
        at org.jumpmind.symmetric.SymmetricAdmin.executeWithOptions(SymmetricAdmin.java:340)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:153)
        at org.jumpmind.symmetric.SymmetricAdmin.main(SymmetricAdmin.java:136)
Steps To ReproduceAfter view some threads here I tried:
- Using JDBC*.jar driver that came with DB2 package
- Increasing the bufferpool size
- creating new bufferpool and moving some tablespaces there

But the error still occurs
TagsNo tags attached.

Activities

progmomen

2023-05-22 08:53

reporter  

symmetric.log (666,607 bytes)

progmomen

2023-05-22 08:55

reporter   ~0002328

I also checked the user permission with a DB2 client (Toad) and I can access and read the sym tables that have been created

emiller

2023-05-24 17:48

developer   ~0002332

Try replacing the existing JDBC driver in the lib directory with the JDBC driver from your server, then restart SymmetricDS.

Issue History

Date Modified Username Field Change
2023-05-22 08:53 progmomen New Issue
2023-05-22 08:53 progmomen File Added: symmetric.log
2023-05-22 08:55 progmomen Note Added: 0002328
2023-05-24 17:48 emiller Status new => feedback
2023-05-24 17:48 emiller Note Added: 0002332
2023-09-13 17:25 emiller Status feedback => closed