• State Not Answered
  • Replies replies
    10
  • Subscribers subscribers
    28
  • Views views
    229
  • Users 0 members are here

Sybase and PostgreSQL drivers fail to initialize after IDM 4.9 upgrade.

Franco Gozalvez

Hi,

We're having trouble when upgrading IDM 4.8.5 to 4.9. The upgrade itself goes well, but the Sybase and PostgreSQL drivers won't initialize. This is a Production environment hosted in a Windows Server 2019. QA environment is hosted with the same OS and working properly, not facing the same issues.

Here's the stack error:

Sybase:

[11/23/24 15:37:48.591]:Eventos ST:Loading descriptors.
[11/23/24 15:37:48.591]:Eventos ST:Loaded.
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'jdbc-class'                               Value:  'com.sybase.jdbc4.jdbc.SybDriver'
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'jdbc-driver-descriptor'                   Value:  null
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'database-descriptor'                      Value:  null
[11/23/24 15:37:48.591]:Eventos ST:Searching for driver descriptor file matching 'com.sybase.jdbc4.jdbc.SybDriver'.
[11/23/24 15:37:48.591]:Eventos ST:Descriptor file '_sybase_jconnect_7.xml' successfully loaded.
[11/23/24 15:37:48.591]:Eventos ST:Third-Party JDBC Driver is "Sybase jConnect 7"
[11/23/24 15:37:48.591]:Eventos ST:Applying declared imports to driver descriptor '_sybase_jconnect_7.xml'.
[11/23/24 15:37:48.591]:Eventos ST:Applying import '_sybase_ase_codes.xml'.
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'sync-filter'                              Value:  'list'
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'sync-schema'                              Value:  null
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'sync-tables'                              Value:  [dbo.utb]
[11/23/24 15:37:48.591]:Eventos ST:Driver is schema-aware.
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'force-username-case'                      Value:  null
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'server'                                   Value:  'jdbc:sybase:Tds:xxx.xxx.xxx.xx:xxxx/xxxxx'
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'user'                                     Value:  'xxxxxxx'
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'connection-properties'                    Value:  ''
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'reuse-statements'                         Value:  [descriptor-dependent]
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'use-manual-transactions'                  Value:  [descriptor or metadata-dependent]
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'transaction-isolation-level'              Value:  [descriptor-dependent]
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'use-single-connection'                    Value:  [descriptor-dependent]
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'max-conn-retry'                           Value:  -1
[11/23/24 15:37:48.591]:Eventos ST:Parameter:  'preserve-sql-whitespace'                  Value:  false
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'minimal-metadata'                         Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'handle-stmt-results'                      Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'connection-tester-class'                  Value:  'com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionTester'
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'connection-init'                          Value:  'SET CHAINED OFF'
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'enable-refs'                              Value:  true
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'enable-meta-identifiers'                  Value:  true
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'left-outer-join-operator'                 Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'include-table-filter'                     Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'exclude-table-filter'                     Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'function-return-method'                   Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'state-dir'                                Value:  '.'
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'supports-schemas-in-metadata-retrieval'   Value:  [descriptor-dependent]
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'column-position-comparator'               Value:  'com.novell.nds.dirxml.driver.jdbc.util.config.comp.StringByteComparator'
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'time-syntax'                              Value:  '1'
[11/23/24 15:37:48.607]:Eventos ST:Parameter:  'enable-locking'                           Value:  false
[11/23/24 15:37:48.607]:Eventos ST:Unhandled Exception:  java.lang.NoClassDefFoundError: Could not initialize class com.sybase.jdbc4.jdbc.SybDriver
[11/23/24 15:37:48.607]:Eventos ST:java.lang.NoClassDefFoundError: Could not initialize class com.sybase.jdbc4.jdbc.SybDriver
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim.loadJDBCDriver(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim.init(Unknown Source)
	at com.novell.nds.dirxml.engine.Driver.startShim(Driver.java:1685)
	at com.novell.nds.dirxml.engine.Driver.initialize(Driver.java:330)
	at com.novell.nds.dirxml.engine.Driver.<init>(Driver.java:296)
	at com.novell.nds.dirxml.engine.DriverEntry.run(DriverEntry.java:626)
	at java.base/java.lang.Thread.run(Unknown Source)

PostgreSQL:

[11/23/24 15:41:58.506]:RRHH PT:DatabaseBuilder: Trying to instantiate DatabaseBuilder object from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.506]:RRHH PT:DatabaseBuilder: Instantiated object 'com.microfocus.database.builder.ZoomDBBuilder@3148c640' from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: Setting base directory to 'U:\NetIQ\IDM\NDS\DIBFiles\.\jdbc_ae77d4c9-64ba-450e-b387-6fee5260b637_0.zoomdb'.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.dir.permission.set' is not set.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: Setting permission to value '700'.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.scan.interval' is not set.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: Setting to default value '15' seconds.
[11/23/24 15:41:58.506]:RRHH PT:ZoomDBBuilder: Instantating object for datatbase 'zoomdb'.
[11/23/24 15:41:58.522]:RRHH PT:MapHandler: Instance of MapImpl not found. Instantiating...
[11/23/24 15:41:58.522]:RRHH PT:MapHandler: Instantiated MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.522]:RRHH PT:MapImpl: Opening MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.553]:RRHH ST:Received state change event.
[11/23/24 15:41:58.553]:RRHH ST:Transitioned from state '%+C%14CStarting%-C' to state '%+C%14CRunning%-C'.
[11/23/24 15:41:58.553]:RRHH ST:Successfully processed state change event.
[11/23/24 15:41:58.569]:RRHH PT:DatabaseBuilder: Trying to instantiate DatabaseBuilder object from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.569]:RRHH PT:DatabaseBuilder: Instantiated object 'com.microfocus.database.builder.ZoomDBBuilder@6100e417' from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: Setting base directory to 'U:\NetIQ\IDM\NDS\DIBFiles\.\jdbc_ae77d4c9-64ba-450e-b387-6fee5260b637_1.zoomdb'.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.dir.permission.set' is not set.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: Setting permission to value '700'.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.scan.interval' is not set.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: Setting to default value '15' seconds.
[11/23/24 15:41:58.569]:RRHH PT:ZoomDBBuilder: Instantating object for datatbase 'zoomdb'.
[11/23/24 15:41:58.569]:RRHH PT:MapHandler: Instance of MapImpl not found. Instantiating...
[11/23/24 15:41:58.569]:RRHH PT:MapHandler: Instantiated MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.569]:RRHH PT:MapImpl: Opening MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.616]:RRHH PT:DatabaseBuilder: Trying to instantiate DatabaseBuilder object from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.616]:RRHH PT:DatabaseBuilder: Instantiated object 'com.microfocus.database.builder.ZoomDBBuilder@623d6ed5' from class 'com.microfocus.database.builder.ZoomDBBuilder'.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: Setting base directory to 'U:\NetIQ\IDM\NDS\DIBFiles\.\jdbc_ae77d4c9-64ba-450e-b387-6fee5260b637_2.zoomdb'.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.dir.permission.set' is not set.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: Setting permission to value '700'.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: ZoomDBBuilder property 'database.zoomdb.scan.interval' is not set.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: Setting to default value '15' seconds.
[11/23/24 15:41:58.616]:RRHH PT:ZoomDBBuilder: Instantating object for datatbase 'zoomdb'.
[11/23/24 15:41:58.616]:RRHH PT:MapHandler: Instance of MapImpl not found. Instantiating...
[11/23/24 15:41:58.616]:RRHH PT:MapHandler: Instantiated MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.616]:RRHH PT:MapImpl: Opening MapImpl 'com.microfocus.database.zoomdb.hashmap.HashMapImpl@map_status'.
[11/23/24 15:41:58.663]:RRHH PT:Connecting to database...
[11/23/24 15:41:58.663]:RRHH PT:BEGIN Open connection 'dedicated0'.
[11/23/24 15:41:58.663]:RRHH PT:END   Open connection.
[11/23/24 15:41:58.663]:RRHH PT:Unhandled Exception:  java.lang.NoClassDefFoundError: Could not initialize class com.sybase.jdbc4.jdbc.SybDriver
[11/23/24 15:41:58.663]:RRHH PT:java.lang.NoClassDefFoundError: Could not initialize class com.sybase.jdbc4.jdbc.SybDriver
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Unknown Source)
	at java.sql/java.sql.DriverManager.isDriverAllowed(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionImpl.newConnection(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionImpl.setConnection(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionImpl.open(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionManager.newConnection(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionManager.newPublicationConnection(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationShim.initialConnect(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationShim.start(Unknown Source)
	at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationProxy.start(Unknown Source)
	at com.novell.nds.dirxml.engine.Publisher.run(Publisher.java:607)
	at java.base/java.lang.Thread.run(Unknown Source)

The postgresql driver error is interesting, because nowhere inside the driver the sybase class is mentioned or called in any way or form.

Thanks in advance!

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.