Hi Wilson

Thanks

That was helpful

/Jan

Hi

Maybe I don't explain this to well.

In a OD application I execute a guery agenst a SQL database and sometimes the response is very slow

I like to set a max timer at 2 seconds.

If the response time is more than 2 seconds the OD flow continues.

I use OD 7.2.1 and OD 8.0

I have a problem with timeout in dboperations.

When i start a query and the database server is slow it is handle by the Epm browser fetch timeout. ( 15 Sec. )

I have tryed to test with the "Tomcat Context Parameters" in JDBC Data Sources.

I cant get it to work.

Can you give me a hint how to set a 2 sec. timeout ?

Regards

Jan

Hi

I need help on this issue

It came after upgrade to AOD 8.0 it works fine in AOD 7.2.3

java.lang.ClassCastException: org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue


Regards
Jan


05/07/2021 09:21:53:436 DEBUG - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : session id:sess7704839 | Aaep8xTdcModuleYouSee00:Subflow10039-ActimoWebserviceLookup | ***** Actimo rest header is -> | ModuleVariables:ActimoRestBodyData : { "ApiKey":"123456789abcdfe123456789abcdef", "Name": "DigitalHelp.InternTelefoni.Mobil", "Data": [ { "Name": "TELEFONNUMMER", "Value":"20202020" } ] }
05/07/2021 09:21:53:442 INFO - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : Starting REST web service operation [ActimoGetVideoIdByPhonenumber]
05/07/2021 09:21:53:493 DEBUG - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : Collecting [https://etrayapi.tdk.dk/eTrayWsService/API/Interfaces.svc/call] from:ModuleVariables:ActimoUrl
05/07/2021 09:21:53:493 DEBUG - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : Adding HTTP header [Host: https://etrayapi.tdk.dk/eTrayWsService/API/Interfaces.svc/call]
05/07/2021 09:21:53:493 DEBUG - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : Web Service Request -> https://etrayapi.tdk.dk/eTrayWsService/API/Interfaces.svc/call
05/07/2021 09:21:53:528 ERROR - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : EXCEPTION: org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue
05/07/2021 09:21:53:532 ERROR - In Progress | session id:sess7704839 | Aaep8xTdcModuleYouSee00:Subflow10039-ActimoWebserviceLookup | | org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue | Exception stack trace | EXCEPTION>
java.lang.ClassCastException: org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.addCustomHeaders(HTTPSenderImpl.java:884)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.executeMethod(HTTPSenderImpl.java:845)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.sendViaPost(HTTPSenderImpl.java:212)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:121)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:403)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:234)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:431)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:399)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:150)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:533)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:509)
at com.avaya.sce.runtime.connectivity.restws.Axis2RestStub.run(Axis2RestStub.java:187)
at com.avaya.sce.runtime.connectivity.restws.Axis2RestStub.execute(Axis2RestStub.java:154)
at com.avaya.sce.runtime.connectivity.restws.CallService.execute(CallService.java:530)
at com.avaya.sce.runtime.Data.evaluateActions(Data.java:228)
at flow.subflow.Subflow10039.ActimoWebserviceLookup.executeDataActions(ActimoWebserviceLookup.java:90)
at com.avaya.sce.runtime.Data.handleRequest(Data.java:121)
at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96)
at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:247)
at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1454)
at com.avaya.sce.runtime.Data.handleRequest(Data.java:184)
at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96)
at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:247)
at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1598)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
| undefined
05/07/2021 09:21:53:533 ERROR - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : session id:sess7704839 |
EXCEPTION>
java.lang.ClassCastException: org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.addCustomHeaders(HTTPSenderImpl.java:884)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.executeMethod(HTTPSenderImpl.java:845)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.sendViaPost(HTTPSenderImpl.java:212)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:121)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:403)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:234)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:431)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:399)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:150)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:533)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:509)
at com.avaya.sce.runtime.connectivity.restws.Axis2RestStub.run(Axis2RestStub.java:187)
at com.avaya.sce.runtime.connectivity.restws.Axis2RestStub.execute(Axis2RestStub.java:154)
at com.avaya.sce.runtime.connectivity.restws.CallService.execute(CallService.java:530)
at com.avaya.sce.runtime.Data.evaluateActions(Data.java:228)
at flow.subflow.Subflow10039.ActimoWebserviceLookup.executeDataActions(ActimoWebserviceLookup.java:90)
at com.avaya.sce.runtime.Data.handleRequest(Data.java:121)
at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96)
at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:247)
at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1454)
at com.avaya.sce.runtime.Data.handleRequest(Data.java:184)
at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96)
at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:247)
at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1598)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)

05/07/2021 09:21:53:537 INFO - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : Capturing exception [java.lang.ClassCastException]. Message [org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue]
05/07/2021 09:21:53:537 ERROR - 72AA451B205742D3CCD01BFCA798CCA0:/Aaep8xCcAdmin17xFrontend00 : java.lang.ClassCastException: org.apache.commons.httpclient.Header cannot be cast to org.apache.axis2.context.NamedValue
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.addCustomHeaders(HTTPSenderImpl.java:884)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.executeMethod(HTTPSenderImpl.java:845)
at org.apache.axis2.transport.http.impl.httpclient3.HTTPSenderImpl.sendViaPost(HTTPSenderImpl.java:212)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:121)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:403)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:234)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:431)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:399)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:150)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:533)
at org.apache.axis2.client.ServiceClient.sendReceive(ServiceClient.java:509)
at com.avaya.sce.runtime.connectivity.restws.Axis2RestStub.run(Axis2RestStub.java:187)

Hi Wilson

Found this in a Servlet node

* The user should override updateBranches() to determine which Goto that the
* framework will activate. If there is not at least one enabled Goto item,
* the framework will throw a runtime exception.<BR>

Would be very useful to have more than one "Branches".

So could you please investigate and provide an example.

Regards

Jan

Hi

No worries

We found the issue with "merge"

<merge connectionid1="in_connectionid" connectionid2="out_connectionid"/>

That did the trick

Regards

Jan

OK

I think I found a way to do it my self using CCXML "Join"

But when using "Join" call is bridged in AAEP

I need to find a way to use CCXML "Merge"

Can you help me with an example?

Regards

Jan

Hi Wilson

Not sure I get it

Could you provide an example with AAI.

My goal is to control the number shown when transfer to external number like a cellphone.

Regards

Jan

Hi

How do I override the from.uri in a transfer node

The default is the caller id as the number I call from

I tried a "External property" Name AVAYA_SIPHEADER.session.connection.protocol.sip.passertedid.uri
Value sip:70345678@aurasip.avaya.com

I hope this is possible some how

Regards

Jan

Hi Dev

My question is what is best practise when using a servlet in OD

*1 : How to create more than one exit point in a servlet

*2 : How to log from a servlet

I have attached a project "Aaod8xSevletTest00" with a servlet node.

Regards

Jan

Thanks Wilson

That was helpful

*1 Could you provide a document that explains the use of the "JSON Parser" ?

*2 I have this output with Square brackets [ ]
I need to get the "False" value of the "Value" in array with "name" = "Key1"

How do I do that?

[
{
"id": 8,
"name": "Menu01",
"parameterGroupRefId": 15,
"childrenGroups": [],
"parameters": [
{
"parameterGroupRefId": 15,
"id": 18,
"name": "Key0",
"componentType": "text",
"dataType": "openInput",
"defaultValue": "0",
"value": "True",
"parameterOptionDefault": [],
"parameterOptionSelected": [],
"valueToUse": "True"
},
{
"parameterGroupRefId": 15,
"id": 19,
"name": "Key1",
"componentType": "text",
"dataType": "openInput",
"defaultValue": "0",
"value": "False",
"parameterOptionDefault": [],
"parameterOptionSelected": [],
"valueToUse": "False"
}
],
"groupEmpty": false
}
]


Regards
Jan

Hi DevConnect

I have not been able to find any thing in developer guide.

I need guidance how to use JSON Parser in OD

I have this example:

{
"phoneNumbers": [
{
"type" : "iPhone",
"number": "0123-4567-8888"
},
{
"type" : "home",
"number": "0123-4567-8910"
}
]
}

Is it possible to get the number key where "type" is "home"

Path Constant in JSON Parser

Something like phoneNumbers/"type"="home"/number

Result = 0123-4567-8910

Please advice

Regards
Jan

Hi Wilson

I added the certificate into the default truststore file as you told me. ( Still don't work out )

Let's say we have 10 certificates in default truststore file.

Does it send all 10 certificate from default truststore file as a client certificate?

We only wants to send one client certificate to the rest server.

Remember this is a 2 way SSL connection from AAOD to a restserver.

/Jan

Thanks Wilson

I have uploaded my certificate to Eclipse OD Preference

How do I send that specific client certificate with my REST Request

Please see the attached PDF

Hi Wilson
Thanks for your answer.
I have a few questions more.
I like to test this in OD simulation.
I have attached a PDF file with some screenshots.

I have tested this OK with Postman.

*1 Is a .p12 certificate supported?

*2 I have created a project "JptsnTestJson00" to test a client certificate with a rest.
If you look into the pdf I am not able to Add my project in "Application Configuration"
Do I need some configuration to point out my workspace ?

Please advice