| Author |
Message
|
| akidase |
 Posted: Fri Jan 04, 2013 7:55 am Post subject: Problem Connecting to Teradata. |
 |
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
Broker Runtime Version : 7.0.0.4
DDWVJDBC is a Teradata JDBC Configurable Service.
Let me know of any other details required.
| Code: |
2013-01-03 22:32:43.929028 10796 Error BIP2211E: Invalid configuration message containing attribute value '' 1'', which is not valid for target attribute ''maxConnectionPoolSize'', object ''JDBCProvider: DDWVJDBC''; valid values are ''> 0 < 100000''.
The message broker received a configuration message containing the attribute value '' 1'', which is not valid for the target attribute ''maxConnectionPoolSize'', on object ''JDBCProvider: DDWVJDBC''. Valid values are ''> 0 < 100000''. This can be caused by a mismatch in levels between the Message Broker Toolkit and the broker. Or it can be caused as a result of a node defined by a user, or written by a third party, where the implementation library installed at the broker does not match the node definition held at the Message Broker Toolkit.
Ensure that the levels of code installed at the Message Broker Toolkit and broker are consistent. If they are, identify the supplier of the target object and report the problem to them. If this is IBM, contact your IBM support center. |
I am unable to interpret this message returned. Could somebody help?! Thanks!
Last edited by akidase on Fri Jan 04, 2013 11:55 am; edited 1 time in total |
|
| Back to top |
|
 |
| agrawalamit166 |
| Posted: Fri Jan 04, 2013 8:11 am Post subject: |
|
|
Voyager
Joined: 17 Aug 2009
Posts: 78
Location: NY, US
|
it says max connection pool size value is more than 0 and less than 100000....
So provide some correct value.... |
|
| Back to top |
|
|
| akidase |
| Posted: Fri Jan 04, 2013 10:57 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
2013-01-03 22:32:43.929028 10796 Error BIP2211E: Invalid configuration message containing attribute value '' 1'', which is not valid for target attribute ''maxConnectionPoolSize'', object ''JDBCProvider: DDWVJDBC''; valid values are ''> 0 < 100000''.
The message broker received a configuration message containing the attribute value '' 1'', which is not valid for the target attribute ''maxConnectionPoolSize'', on object ''JDBCProvider: DDWVJDBC''. Valid values are ''> 0
Last edited by akidase on Fri Jan 04, 2013 12:19 pm; edited 2 times in total |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jan 04, 2013 11:00 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
When you "Contact your IBM support center if you are unable to determine the cause of the problem." what did they say?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| akidase |
| Posted: Fri Jan 04, 2013 11:53 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
Command was not to be enclosed in double quotes and checked for space. It worked out properly.
Now faced with the below error.
| Code: |
RecoverableException BIP6231E: An error occurred in node: 'Broker 'BK1'; Execution Group 'EG'; Message Flow MsgFlow; Node 'Java_RqRsDocInquiry'; Node Type 'JP_JavaCompute' Exception details: ' message: com.teradata.jdbc.TeraDataSource stack trace: [java.net.URLClassLoader.findClass(URLClassLoader.java:434)
com.ibm.broker.classloading.JavaResourceClassLoader.findClass(JavaResourceClassLoader.java:146)
com.ibm.broker.classloading.SharedClassLoader.findClass(SharedClassLoader.java:162)
java.lang.ClassLoader.loadClass(ClassLoader.java:660)
java.lang.ClassLoader.loadClass(ClassLoader.java:626)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createNonXAConnection(JDBCType4Connection.java:332)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1139)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:248)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:155)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1551)
xyz_JavaCompute.evaluate(JP_DocumentOfInterest_JavaCompute.java:63)
com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate(MbRuntimeJavaComputeNode.java:232)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1469)]'
An error message was generated by the node.
Contact your IBM support center if you are unable to determine the cause of the problem. |
|
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jan 04, 2013 12:00 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| akidase |
| Posted: Fri Jan 04, 2013 12:17 pm Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
This is what I have configured on the runtime using mqsicreateconfi.. command.
| Quote: |
JDBCProviders
DDWVJDBC
connectionUrlFormat=' jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=$M1$'
connectionUrlFormatAttr1=' '
connectionUrlFormatAttr2=' '
connectionUrlFormatAttr3=' '
connectionUrlFormatAttr4=' '
connectionUrlFormatAttr5=' '
databaseName=' DDWV01'
databaseType=' Teradata'
databaseVersion='12'
description=' Teradata Description'
environmentParms=' default_none'
jarsURL=' /apps/VLH0/TeraData/'
maxConnectionPoolSize='3'
portNumber='1025'
securityIdentity=' jdbcTdSecIden'
serverName=' Teradata-dns-gcc.devfg.rbc.com'
type4DatasourceClassName=' com.teradata.jdbc.TeraDataSource'
type4DriverClassName=' com.teradata.jdbc.TeraDriver '
BIP8071I: Successful command completion. |
Calling connection as
| Code: |
Connection tdConnection = getJDBCType4Connection("DDWVJDBC", JDBC_TransactionType.MB_TRANSACTION_AUTO); |
Error as below.
| Code: |
2013-01-04 18:51:17.554330 10539 RecoverableException BIP6231E: An error occurred in node: 'Broker 'BRK'; Execution Group EG; Message Flow ; Node 'Java Compute_RqRsDocInquiry'; Node Type 'JP_JavaCompute' Exception details: ' message: com.teradata.jdbc.TeraDataSource stack trace: [java.net.URLClassLoader.findClass(URLClassLoader.java:434)
com.ibm.broker.classloading.JavaResourceClassLoader.findClass(JavaResourceClassLoader.java:146)
com.ibm.broker.classloading.SharedClassLoader.findClass(SharedClassLoader.java:162)
java.lang.ClassLoader.loadClass(ClassLoader.java:660)
java.lang.ClassLoader.loadClass(ClassLoader.java:626)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createNonXAConnection(JDBCType4Connection.java:332)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1139)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:248)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:155)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1551)
JP_JavaCompute.evaluate(JP_JavaCompute.java:63)
com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate(MbRuntimeJavaComputeNode.java:232)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1469)]'
An error message was generated by the node.
Contact your IBM support center if you are unable to determine the cause of the problem. |
Faced with this exception. Any help ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Jan 05, 2013 2:30 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
I figure this to be your problem:
| Code: |
| jarsURL=' /apps/VLH0/TeraData/' |
Have fun. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| akidase |
| Posted: Mon Jan 07, 2013 1:50 pm Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
I verified that jars tdgssconfig.jar,terajdbc4.jar were found in the directory /apps/VLH0/TeraData/
And also since they were deployed , are found in runtime directory /var/mqsi/components/.. also.
Not sure what the issue is. Please help. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jan 08, 2013 5:53 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| akidase |
| Posted: Tue Jan 08, 2013 11:06 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
Problem is rectified . Template shouldn't be changed.
| Code: |
| connectionUrlFormat=' jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=$M1$' |
should be
| Code: |
| connectionUrlFormat=' jdbc:teradata://[serverName]/DATABASE=[databaseName],DBS_PORT=[portNumber],TMODE=ANSI,ACCOUNT=[user] |
|
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 08, 2013 11:37 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| akidase wrote: |
| Problem is rectified . Template shouldn't be changed. |
Not the first time that's been said in here
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| akidase |
| Posted: Tue Jan 08, 2013 11:41 am Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
I had faced an error earlier , given below.
| Code: |
| Error 8017 SQLState 28000 The UserId,Password or Account is invalid. |
So my every attempt stayed in specifying the Account name somehow. |
|
| Back to top |
|
|
|
|
