Cisco: Scheduled DCNM Reports are failing to run in the web gui

Article Number: 512361Article Version: 3 Article Type: Break Fix



Connectrix MDS-Series Data Center Network Manager

Symptom 1. Report jobs run in the DCNM web gui as a single report, manual execution are created normally without issues.

Symptom 2. However, when using scheduled jobs for a specific date, time, or frequency do not produce report outputs at all.

Symptom 3. Customer is using Oracle database for DCNM instance.

Symptom 4. San startup logs ( default path C:Program FilesCisco Systemsdcmjboss-as-7.2.0.Finalstandalonelogsanstartup ) show the following error:

ERROR [org.quartz.impl.jdbcjobstore.JobStoreCMD] (MSC service thread 1-1) ClusterManager: Error managing cluster: Failed to obtain DB connection from data source ‘QUARTZ_NO_TX’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:jboss/datasources/QuartzNoTxDS’ java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasource/QuartzNoTxDS

Symptom 5. the following string in the file C:Program FilesCisco Systemsdcmjboss-as-7.2.0.Finalstandaloneconfigurationstandalone-san.XML uses OID based connection which will cause failure for DCNM quartz scheduler to connect to database:

Example:

-<datasource use-java-context=”true” use-ccm=”false” pool-name=”QuartzNoTxDS” jndi-name=”java:jboss/datasources/QuartzNoTxDS” enabled=”true”>

<connection-url>jdbc:oracle:thin:@ldap://oidgprod:389/dcdcnms,cn=OracleContext,dc=world</connection-url>

Cisco Bug ID CSCvg55209 Quartz Scheduler – Oracle OID connection string support

Set path to Oracle directly without OID in the string.

.p

Related:

ASP.net C# SQL Injection Prevention

The following is the simple code that select value from a table and shows it into a grid view on a click. protected void Button1_Click(object sender, EventArgs e) { DB db = new DB(); string que = “SELECT * FROM Exp1 WHERE ID = ‘” + TextBox1.Text + “‘”; ds = db.getdata(que); GridView1.DataSource …

Related:

What is meant publishername in IBM CDC

Hi Team,

What should be used for “publishername” here .
Is it source server , target server name , Source Datasource , Target Datastore,
My source is IBM Iseries.

if (accessServer != null && accessServer.isOpen()) {
Publisher publisher = accessServer.getPublisher(publishername);
if (publisher==null) {
System.out.println(“Could not access publisher ” + publishername);
System.exit(0);
}
try {
publisher.connect();

Getting below error while trying to stop a subscription in normal mode.

subscription.endReplicationSpecifiable(new Integer(2).byteValue(),tagval,new Integer(0).byteValue(),””);

Supplying the publisher and subscription names in argumnents

java -cp “api.jar” StartStopMirroring C:/Users/AccessServer.cfg.txt DMIRROR_T TEST20 end

Error:

com.datamirror.ea.api.ApiException: RA MSG 2055 Unrecognized message received from client
at com.datamirror.ea.api.publisher.DefaultSubscription.endReplicationSpecifiable(DefaultSubscription.java:357)
at api.sample.StartStopMirroring.endMirroring(StartStopMirroring.java:326)
at api.sample.StartStopMirroring.main(StartStopMirroring.java:141)

Related:

Datacap – 0KB Files in CPE

We had some issues with CPE (datasource connectivity, etc). On testing Datacap, I noticed sporadically that when it would export a document to CPE, we’d see one entry in CPE with the image/medadata, and another with the same metadata and a 0KB file.

Anyone seen similar? If so, is there a configuration fix to prevent that in the case of CPE issues?

Related:

IIB unable to connect to Oracle via JDBCProvider configurable service

Hi,

My IIB (10.0.0.9) is not able to connect to the Oracle database (hosted on a different server) via the configured JDBC provider. The error message is as below:

( TESTNODE_XXX.default ) An error occurred in node: ‘Broker ‘TESTNODE_XXX’; Execution Group ‘default’; Message Flow ‘dbtest’; Node ‘Java Compute’; Node Type ‘Dbtest_JavaCompute’ There was a problem establishing a connection to the given database URL: ‘jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=hxxx) (PORT=2484))(CONNECT_DATA= (SERVICE_NAME=sxxx)))’ Exception details: ‘ error message: Io exception: The Network Adapter could not establish the connection, vendor’s error code: 17002, stack trace: [oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:454)
oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:298)
oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:473)
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:160)
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:134)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(JDBCType4Connection.java:235)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4DatabaseManager.getThreadOwnedConnections(JDBCType4DatabaseManager.java:320)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:261)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:153)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
java.lang.reflect.Method.invoke(Method.java:620)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1555)
Dbtest_JavaCompute.evaluate(Dbtest_JavaCompute.java:27)
com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate(MbRuntimeJavaComputeNode.java:364)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1452)]’

However I can connect to this database using the same connection string in SqlDeveloper, and also tested the connection url with a small java code:

Class.forName(“oracle.jdbc.OracleDriver”);
String conStr = “jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps)(HOST=hxxx)(PORT=2484))(CONNECT_DATA= (SERVICE_NAME=sxxx)))”;

Connection con = DriverManager.getConnection(conStr, “user”, “pwd”);
System.out.println(“connection is null? ” + (con == null));

Could you please point out where the issue could be?

FYI:
IIB: 10.0.0.9,
Oracle: 12.1.0.2.0,
ojdbc8

Thanks

Related:

Why I got DSRA9542W message when my JCC drvier version matches with DB2 server version and also right driver version reported in WSAS log?

I found DSRA9542W reported in WSAS log, but from same process’s log, I can find right JCC driver version that I configured the datasource to use is printed and the driver version matches with DB2 Server version. My driver is IBM Data Server Driver for JDBC and SQLJ V4.18.60(DB2 Using IBM JCC Driver).
From trace.log, can find below error triggered the issue:
DB2UniversalU > getJccSpecialRegisterProperties Entry
com.ibm.db2.jcc.am.mf@6b8ecbaf
DB2UniversalU

Related:

Unable to connect datasource to Oracle in Cell Scope for WAS ND

I am trying to connect to Oracle Database (12c) and have created a Datasource at Cell level scope which has both the nodes of cluster. However, when I am testing the Data source connection it is showing the below error:

**java.sql.SQLException: java.lang.NoSuchMethodError: oracle/i18n/text/converter/CharacterConverterOGS.getInstance(I)Loracle/sql/converter/CharacterConverters;. 😀 for further details.**

However, when I am creating Data Source at node level, it is working fine. This shows this not problem of drivers since it is connecting for individual nodes.

So, how do I make it to work at Cell scope as well?

Related: