DB configurator in linux Error

while running :
dbConfigurator.sh -a catalog -d oracle -c mywebMethodserver -l “jdbc:wm:oracle://DBSERVERIP:PORT;serviceName=ABCD;sysLoginRole=sysdba” -u ABCD_MWS_OWNER -p XXXXXXXX

getting below error :

user log: ./…/logs/dcc.log

developer log: ./…/logs/log-20210304020653.txt

dcc version: 10.5.0.0000-0169

executing action: catalog

processing products:

processing components: [mywebMethodserver]

java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]No more data available to read.

at com.softwareag.dcc.db.JDBCConnectionFactory.getConnection(JDBCConnectionFactory.java:18)

at com.softwareag.dcc.db.DBMS.getConnection(DBMS.java:78)

at com.softwareag.dcc.db.DBMS.getAllInstalledComponents(DBMS.java:54)

at com.softwareag.dcc.app.CatalogAction.getComponents(CatalogAction.java:32)

at com.softwareag.dcc.app.CatalogAction.execute(CatalogAction.java:24)

at com.softwareag.dcc.app.Runner.catalog(Runner.java:142)

at com.softwareag.dcc.app.Runner.run(Runner.java:46)

at com.softwareag.dcc.cli.Main.(Main.java:89)

at com.softwareag.dcc.cli.Main.main(Main.java:135)

Caused by: java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]No more data available to read.

at com.wm.dd.jdbc.oraclebase.ddcj.a(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcj.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcj.a(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcj.a(Unknown Source)

at com.wm.dd.jdbc.oracle.net8.ddj.a(Unknown Source)

at com.wm.dd.jdbc.oracle.OracleImplConnection.a(Unknown Source)

at com.wm.dd.jdbc.oracle.OracleImplConnection.ag(Unknown Source)

at com.wm.dd.jdbc.oracle.OracleImplConnection.b(Unknown Source)

at com.wm.dd.jdbc.oracle.OracleImplConnection._(Unknown Source)

at com.wm.dd.jdbc.oraclebase.BaseConnection.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.BaseConnection.l(Unknown Source)

at com.wm.dd.jdbc.oraclebase.BaseConnection.c(Unknown Source)

at com.wm.dd.jdbc.oraclebase.BaseConnection.a(Unknown Source)

at com.wm.dd.jdbc.oraclebase.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.softwareag.dcc.db.JDBCConnection.(JDBCConnection.java:23)

at com.softwareag.dcc.db.JDBCConnectionFactory.getConnection(JDBCConnectionFactory.java:15)

… 8 more

error.message: java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]No more data available to read.

error.stackTrace: [Ljava.lang.StackTraceElement;@5c5eefef

any setting change needed ?

Can you try putting all the parameter values in double quotes ? , For example …

dbConfigurator.sh -a “catalog” -d “oracle” -c “mywebMethodserver “ -l “jdbc:wm:oracle://DBSERVERIP:PORT;serviceName=ABCD;sysLoginRole=sysdba” -u “ABCD_MWS_OWNER“-p “XXXXXXXX”

1 Like

no luck! tried all values in “”

Ok , can you try using default JDBC parameters ?, i.e do not use any extra arguments like sysLogniRole and also paste full error text after removing that argument

What DCC version are you using ?

jdbc:wm:oracle://:<1521|port>;serviceName=[;=…]

1 Like

Hi Avik,

please have a look at the wM Installation Guide for who to use the DCC in CLI mode.
I think there are additional user/password parameters to be specified when creating new database users via this command:
One set for the user to be created (-u/-p) and one set for the DBA admin user under which the regular user will be created.

I prefer using the GUI mode (even on Linux/Unix-Systems) so I have never used the CLI mode here.

Regards,
Holger

When I am using the TCP port then its working fine
./dbConfigurator.sh -a catalog -d oracle -pr TN -l “jdbc:wm:oracle://DBSERVER:TCPPORT;serviceName=ABCD” -u ABCD_TN_USER -p ############

but when using TCPS port then its not working
./dbConfigurator.sh -a catalog -d oracle -pr TN -l “jdbc:wm:oracle://DBSERVER:TCPSPORT;serviceName=ABCD” -u ABCD_TN_USER -p ############

then only getting connection error

java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]No more data available to read.
at com.softwareag.dcc.db.JDBCConnectionFactory.getConnection(JDBCConnectionFactory.java:18)
at com.softwareag.dcc.db.DBMS.getConnection(DBMS.java:78)
at com.softwareag.dcc.db.DBMS.getAllInstalledComponents(DBMS.java:54)
at com.softwareag.dcc.app.CatalogAction.getComponents(CatalogAction.java:32)
at com.softwareag.dcc.app.CatalogAction.execute(CatalogAction.java:24)
at com.softwareag.dcc.app.Runner.catalog(Runner.java:142)
at com.softwareag.dcc.app.Runner.run(Runner.java:46)
at com.softwareag.dcc.cli.Main.(Main.java:89)
at com.softwareag.dcc.cli.Main.main(Main.java:135)

Need to know how should I form the url for TCPS port here?

Hi AVik

What version of DCC are you using ? There is a similar problem described in Data Direct Driver documentation which was resolved in Data Direct Driver version 5.1.3 and later

https://knowledgebase.progress.com/articles/Knowledge/000055933

I am unable to check the version at this moment. but I am trying to figure it out.
also I have one more observation, while running this command then getting no suitable driver found error:

./dbConfigurator.sh -a catalog -d oracle -pr TN -l “jdbc:datadirect:oracle://DBHOST:DBTCPSPORT;serviceName=ABCD” -u USER-p PASS

java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:datadirect:oracle://DBHOST:DBTCPSPORT;serviceName=ABCD
at com.softwareag.dcc.db.JDBCConnectionFactory.getConnection(JDBCConnectionFactory.java:18)
at com.softwareag.dcc.db.DBMS.getConnection(DBMS.java:78)
at com.softwareag.dcc.db.DBMS.getAllInstalledComponents(DBMS.java:54)
at com.softwareag.dcc.app.CatalogAction.getComponents(CatalogAction.java:32)
at com.softwareag.dcc.app.CatalogAction.execute(CatalogAction.java:24)
at com.softwareag.dcc.app.Runner.catalog(Runner.java:142)
at com.softwareag.dcc.app.Runner.run(Runner.java:46)
at com.softwareag.dcc.cli.Main.(Main.java:89)
at com.softwareag.dcc.cli.Main.main(Main.java:135)

how to set the suitable driver here ?
I can see below driver is already residing inside …/…/mws105/common/lib/ext

-rw-r-----. 1 b2bt b2bt 27130770 Nov 11 2019 dd-cjdbc.jar

Looks like you have incorrect JDBC URL . The correct one should have this format “jdbc:wm:oracle://:<1521|port>;serviceName=[;=…]"

1 Like

please find the version of dd-cjdbc.jar

Manifest-Version: 1.0
Bundle-Description: Datadirect Driver
Bundle-ManifestVersion: 2
Bundle-Name: dd-cjdbc
Bundle-NativeCode: lib/DDJDBCAuth05.dll;processor=x86,lib/DDJDBCx64Aut
h05.dll;processor=x86_64,*
Bundle-SymbolicName: com.softwareag.ext.dd.cjdbc
Bundle-Vendor: Software AG
Bundle-Version: 6.0.0.0001-0002

so what is this driver version ?
Bundle-Version: 6.0.0.0001-0002 or Manifest-Version: 1.0?

if it is 6.0 then we are using greater than 5.1.3. so it should work

just need to know how to form the url for TPCS?

Hi Avik,

driver version is 6.0.0 then (newer than 5.1.3 mentioned earlier here by @Manish_Negandhi).

I am not sure about TCPS, but you might want to consider opening an Incident via Empower eService and/or a feature request via Brainstorm (reachable via Empower as well) to get this checked.

Regards,
Holger

its working fine

please find below action details

  1. download the .jks file of the DB host and place it in a path of server, in our case we placed it in /tmp folder
  2. then compose the jdbc url in following way
    ./dbConfigurator.sh -a catalog -d oracle -pr TN -v latest -l “jdbc:wm:oracle://DBHOST:TCPSPORT;serviceName=ABCD;EncryptionMethod=SSL;ValidateServerCertificate=true;EncryptionType=AES256;EncryptionLevel=accepted;TrustStore=/tmp/ABCD.jks;TrustStorePassword=XXXXXX;HostNameInCertificate=DBHOST;CryptoProtocolVersion=TLSv1.1,TLSv1.2” -u ABCD_USER -p XXXXXXX
1 Like