cant display teradata output

Q&A
1

When I test my connector two items come back.

But they don’t showup in my display page and I just get this.
What does no tasks mean? Thanks for helping! I really appreciate this community and try to give back. -Jim

image

—connector failed somehow -------log-----------
SEVERE: THREAD_ID=565 | HOSTNAME=MKTG-857723-W4 | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 32, connectorDefinitionName = teraaaa] failed. The failure will be handled.
2015-09-18 16:02:35.010 -0500 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=565 | HOSTNAME=MKTG-857723-W4 | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : “PROCESS_DEFINITION_ID=5902139805010001861 | PROCESS_NAME=teradataGetDataAndDisplay | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=14 | ROOT_PROCESS_INSTANCE_ID=14 | FLOW_NODE_DEFINITION_ID=6665392071157956704 | FLOW_NODE_INSTANCE_ID=32 | FLOW_NODE_NAME=getData | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=teraaaa | CONNECTOR_INSTANCE_ID=14 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.ExceptionInInitializerError”
org.bonitasoft.engine.core.connector.exception.SConnectorException: PROCESS_DEFINITION_ID=5902139805010001861 | PROCESS_NAME=teradataGetDataAndDisplay | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=14 | ROOT_PROCESS_INSTANCE_ID=14 | FLOW_NODE_DEFINITION_ID=6665392071157956704 | FLOW_NODE_INSTANCE_ID=32 | FLOW_NODE_NAME=getData | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=teraaaa | CONNECTOR_INSTANCE_ID=14 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: java.lang.ExceptionInInitializerError

2

What does no tasks mean?

This means there are no discernible tasks for the process that can be executed, normally if everything is working you will see Next Step etc.

Here as you say it looks like a connector has failed, now you just have to figure out where it has failed.

For this I use a logging mechanism as follows:

import java.util.logging.Logger; Logger logger= Logger.getLogger("org.bonitasoft");

Boolean debug = true; // NOTE: change to false when not debugging
String thisTrace = "yourModuleName: "; // NOTE: use your connector name - you can then search for this in the Log

if(debug){ logger.severe(thisTrace+"yourText "+yourVariable);} // add this all over your code as necessary to isolate your issue.

// for example
// if(debug){ logger.severe(thisTrace+"getDataFromDatabase - resultSet: "+resultSet.toString());}

You might want to delete the current connector/or code and restart the code and build it up until you work out what is happening.

regards

3

If I test the connector, it works , but if I hit RUN, I get Class Not Found…

org.bonitasoft.engine.connector.ConnectorException: java.lang.ClassNotFoundException: com.teradata.jdbc.TeraDriver

If I search around, I see these jars.
./workspace/tomcat/lib/tdgssconfig.jar
./workspace/tomcat/lib/terajdbc4.jar

When I test, I noticed that I MUST specify terajdbc4 or I get Class Not Found (same error).

So my question is, during RUN mode, do I have to set this jar in somewhere??
It doesn’t find it…

Thanks for helping. I did try the logger and I appreciate that! I can make a movie if needed or show more log details.

-Jim

4

I got it…
It was in the config . The terajdbc4.jar wasn’t checked…

Complete Hello World Teradata posted on youtube.

Thanks Sean. Here is what the output looks like .
Jim

5

Excellent, glad you got it working, I’m travelling a lot at the moment so unable to reply quickly…

regards