Hi all experts,

i need to pass several speech application (OD) variables to another speech application, also OD application.

Is it possible?Thanks!

for mysql:

jdbc:mysql://xxx.xx.xxx.xxx:3306/database?connectTimeout=60000&socketTimeout=60000

I Wilson,

The Datasource name is "EVO_TRAZAS" (i guess nothing special to use this name, isn't it?)

I could check the exception error in Experience portal when i test the application in Production enviroment, seems like there is a network problem....


Activity Message: IO Error: The Network Adapter could not establish the connection
Variable Name: Exception stack trace
Variable Value: EXCEPTION> java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.tomcat.dbcp.dbcp2.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:169) at org.apache.tomcat.dbcp.dbcp2.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:1038) at org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:628) at org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:542) at org.apache.tomcat.dbcp.dbcp2.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:913) at com.avaya.sce.runtime.jdbc.Database.open(Database.java:93) at com.avaya.sce.runtime.connectivity.db.DbQuery.executeSQL(DbQuery.java:196) at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:134) at com.avaya.sce.runtime.Data.evaluateActions(Data.java:228) at flow.LOG_ENTRANCECopy.executeDataActions(LOG_ENTRANCECopy.java:118) 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.doGet(SCEServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) 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:52) 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:728) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1458) at com.avaya.sce.runtime.SubflowReturn.handleRequest(SubflowReturn.java:120) 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.doGet(SCEServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) 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:52) 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:728) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1458) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:133) 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.doGet(SCEServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) 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:52) 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:728) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1458) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:133) 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.doGet(SCEServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) 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:52) 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:728) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1458) at com.avaya.sce.runtime.Subflow.handleRequest(Subflow.java:35) 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.doGet(SCEServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) 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:52) 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:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) at org.apache.catalina.core.StandardEngineValve.invoke(Standa...

Hi Experts

I'm completly desperate about this problem...i need to migrate my OD application from OD6.0, EPM6 and tomcat7 to OD 7.2 and EPM 7.2.3, tomcat8 (in Linux)

In my OD app I have 2 BD connections, one to SQL Server and second to Oracle Exadata.
when I check the validate page to validate the db connection pool, success from SQL Server, but fail with Oracle exadata, whith this error:

There is a problem finding the context information for the data source you selected.
For Tomcat, make sure the context XML file is in the <TOMCAT_HOME>/conf/Catalina/localhost directory,
and the context information for the data source exists in the file;
for other application server, make sure you have defined the data sources in the admin console.

I check the JDBC connection is OK in context.xml file in META-INF folder, and no other context.xml in Catalina\localhost directory..in fact I create new connection in the new ODv7.2 to same Oracle DB and the problem persists...

Also I check with several Oracle drivers ojdb8, ojdbc7, ojdbc14...none of them solve the problem...

Could you help me?

THANKS IN ADVANCE

Hi Experts!

I am unable to see EPM Application Detail Reports, the application configuration is OK configured to report all in EMP, but still no results.

I have activated the report.log and trace.log in Tomcat application server, and see some errors al last:

27/08/2019 13:01:01:264 INFO - In Progress | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_SetCTI | | Error DB | ddLastExceptio
n:message | RegisterPool failed | undefined
27/08/2019 13:01:01:264 INFO - In Progress | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_SetCTI | | Error DB | ddLastExceptio
n:message | RegisterPool failed | undefined
27/08/2019 13:01:01:264 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : Using SCESession CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR
_PRO_V1 servlet : CA_IV_Transfer
27/08/2019 13:01:01:264 INFO - Node Entry | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_Transfer | Framework | CA_IV_Transfer
| | | undefined
27/08/2019 13:01:01:264 INFO - Node Entry | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_Transfer | Framework | CA_IV_Transfer
| | | undefined
27/08/2019 13:01:01:264 INFO - In Progress | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_Transfer | | Transfer | Numero_A_Tra
nsferir | 7216536 | undefined
27/08/2019 13:01:01:264 INFO - In Progress | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:CA_IV_Transfer | | Transfer | Numero_A_Tra
nsferir | 7216536 | undefined
27/08/2019 13:01:01:300 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : Using SCESession CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR
_PRO_V1 servlet : FIN
27/08/2019 13:01:01:301 INFO - Node Entry | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:FIN | Framework | FIN | | | undefined
27/08/2019 13:01:01:301 INFO - Node Entry | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:FIN | Framework | FIN | | | undefined
27/08/2019 13:01:01:301 INFO - Application Exit | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:FIN | Framework | Application Exiting
| | | undefined
27/08/2019 13:01:01:301 INFO - Application Exit | session id:BKAVAEPMPPROGS1-2019239110029-3 | AvantCARD_SS_IR_PRO_V1:FIN | Framework | Application Exiting
| | | undefined
27/08/2019 13:01:01:309 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : Removing session from AvayaSessionTermination Servlet
27/08/2019 13:01:01:310 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : Termination URL reply : <?xml version="1.0" encoding="UTF-8"?>
<vxml version="2.1" xmlns="http://www.w3.org/2001/vxml" xml:lang="en-us">
</vxml>

27/08/2019 13:01:01:310 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : HTTP Session lost removing SCESession CD11664A31F344C05646D27EA351
05D7
27/08/2019 13:01:01:310 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : SCESession Removed
27/08/2019 13:01:01:310 INFO - CD11664A31F344C05646D27EA35105D7:/AvantCARD_SS_IR_PRO_V1 : ** Popped Stack Frame [/AvantCARD_SS_IR_PRO_V1]
27/08/2019 13:02:01:480 ERROR - BatchLogWriter:EPMWebServicesClientBaseImpl:logBatchAxis2() - ReportBatch FAILED with status = Error initializing database, l
og entry size: 21 to URL: https://10.100.1.83/axis2/services/VPAppLogService from AE server: bkapactomcprogs1 First SID: BKAVAEPMPPROGS1-2019239110029-3 Last
SID: BKAVAEPMPPROGS1-2019239110029-3 logBatchWSTimeout: 60000
27/08/2019 13:02:01:480 ERROR - BatchLogWriter:logBatch() - Send batch FAILED, size: 21 return status: Error initializing database, ADD https://10.100.1.83/a
xis2/services/VPAppLogService to the lastErrorTimeMap


Is something related to VPAppLogService , wich I think is important to Report all the info of the IVR application to EPM.

I also configured in EPM server, EPM Configuration, the user and password for EPM web service authentication...but still not working

Please could you Help me? any Ideas?

Thanks!

Hi All,

Thanks a lot for your help, all you said give me an idea...

Just i changed this line in ddlog4j.properties:

log4j.rootLogger=error, stdout

to

log4j.rootLogger=error, TINEM_CitaPrevia_4

and it start to print in trace.log.

Again, THANKS!

Hi George,

no, in fact, my Project folder name is "INEM_CitaPrevia_8_TODOS_v29"

should I have to change it in ddlog4j properties, in your opinion?

Hi VasilyL, first thanks for your reply,

yes, I changed using "chmod 777" the trace and report.log.

Also changed my ddlog4j properties like this:

log4j.rootLogger=error, stdout

log4j.logger.Dialog.Designer.TraceWriter.INEM_CitaPrevia_4= debug, TINEM_CitaPrevia_4
log4j.logger.Dialog.Designer.ReportWriter.INEM_CitaPrevia_4= debug, RINEM_CitaPrevia_4

# Console
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{dd/MM/yyyy HH:mm:ss:SSS} %5p - %m%n

# Report File.
log4j.appender.RINEM_CitaPrevia_4=org.apache.log4j.DailyRollingFileAppender
log4j.appender.RINEM_CitaPrevia_4.File=${dd.apphome}/data/log/report.log
log4j.appender.RINEM_CitaPrevia_4.DatePattern='.'yyyy-MM-dd
log4j.appender.RINEM_CitaPrevia_4.layout=org.apache.log4j.PatternLayout
log4j.appender.RINEM_CitaPrevia_4.layout.ConversionPattern=%d{dd/MM/yyyy HH:mm:ss:SSS} %5p - %m%n
log4j.appender.RINEM_CitaPrevia_4.Encoding=UTF-8
# Trace File.
log4j.appender.TINEM_CitaPrevia_4=org.apache.log4j.DailyRollingFileAppender
log4j.appender.TINEM_CitaPrevia_4.File=${dd.apphome}/data/log/trace.log
log4j.appender.TINEM_CitaPrevia_4.DatePattern='.'yyyy-MM-dd
log4j.appender.TINEM_CitaPrevia_4.layout=org.apache.log4j.PatternLayout
log4j.appender.TINEM_CitaPrevia_4.layout.ConversionPattern=%d{dd/MM/yyyy HH:mm:ss:SSS} %5p - %m%n
log4j.appender.TINEM_CitaPrevia_4.Encoding=UTF-8


also restart tomcat in order to make this settings on...but but trace log still empty, I have no more ideas...:(

Hi Wilson,

Finally i could releae the ports using <merge>.

Thanks a lot for your help.

Thanks Wilson!

Made the changes, but trace and report log still empty.

I've made a doc in order to clarify the situation...

Hi experts,

I have an application that was made years ago,for VoicePortal 5.1, which was prepared to writing in trace.log file the tomcat application directory.

Few days ago, we have migrated the application to Experience Portal 7.2, but i not be able to enable logs in trace.log file in Tomcat for this application...

I change the ddrt.properties, to enable:


#Wed Dec 05 15:41:48 CET 2018^M
frameworkreporting=enabled
localddtrace=enabled
localapptrace=enabled
localreportlog=enabled
showxml=enabled
showcaughtexceptions=disabled
showxmlroot=always


I also enable in Experience Portal Reporting Parameters for the application, but still not Works...
what else should i do?

Any help is much appreciated.
Thanks a lot.
David.

WilsonYu wrote:<join> sets up a conference call with the EP port. That's how it works. Can't change the specs.

Hi again WilsonYu.
Yes, join is good if you want to conference with EP, but I need to release EP ports.
If I use redirect, I only can use it like this:
<redirect connectionid="out_connectionid" dest="'13001'"/>

where 13001 is a VDN, but taking in account my code I post before, I can't do:
<redirect connectionid="out_connectionid" dest="in_connectionid"/>
it result an error

I need to join my CCXML incoming call with the new call i create, but after this join, need to relelase both ports in EPM.

does it make sense for you what I need? do you think is posible?

Thanks a lot for your help WilsonYu. Sorry for disturb you

Thanks WilsonYu,

I try what you told me, and is correct, i can use redirect in the connection.connected transition, but it doenst work as I expected.

What I need is to join the two calls, but outside of CCXML...releasing resources in Experience Portal (Telephony ports and Call Classification licenses).

Good Morning Experts!

I hope you can help me with a CCXML doubts. I have implemented a CCXML application that firts recieve the inbound call. In the alerting transition of the inbound call, I create a new call, and if this new call is a live person, i need to join both, but outside of CCXML...what i mean is I need to reléase resources in Experience Portal (Telephony ports and Call Classification licenses)

Is this posible? I try the <redirect> and <merge>...but the only one it Works is the <join> one, but the <join> still mantain the resources on Experience Portal...

Part of my code:

<transition event="connection.alerting" state="init" >
<assign name="in_connectionid" expr="event$.connectionid"/>
<createcall dest="phone"
connectionid="out_connectionid"
timeout="30000"
callerid="session.connections[event$.connectionid].remote"
hints="hints" />

</transition>

<transition event="connection.signal" >

<if cond="event$.info.callprogress == 'live_voice'">
<log expr="' *** Got a live one\n CALLPROGRESS=' +event$.info.callprogress "/>

<accept connectionid="in_connectionid" />

<assign name="VxmlTst" expr="app_uri + 'prompts/livevoice.wav'"/>
<dialogstart dialogid="dialogid" src="VxmlTst" connectionid ="in_connectionid" type="'audio/wav'"/>

<redirect connectionid="in_connectionid" dest="in_connectionid"/>
</transition>

Many Thanks

Hi Experts,

I hope you can help me, please. i am trying the use of some public Rest WEb Service in OD 7.2, but no works for me.
I have tested with JSON and XML as Output format, without results.
Attached the example.

The console gives me everytime, "connection timeout". I try also some other rest web services, it Works on Explorer and Chrome, but no when try Simulation in OD, i'm getting frustrated.

Could you give me more ideas?

27/11/2018 17:02:42:427 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :session___videowidth to complex: session:videowidth as [unknown]
27/11/2018 17:02:42:427 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :session___vpcalledextension to complex: session:vpcalledextension as [unknown]
27/11/2018 17:02:42:428 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :session___vpcoveragereason to complex: session:vpcoveragereason as [unknown]
27/11/2018 17:02:42:428 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :session___vpcoveragetype to complex: session:vpcoveragetype as [unknown]
27/11/2018 17:02:42:428 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :session___vprdnis to complex: session:vprdnis as [unknown]
27/11/2018 17:02:42:428 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :shareduui___id to complex: shareduui:id as [unknown]
27/11/2018 17:02:42:428 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Storing :shareduui___value to complex: shareduui:value as [unknown]
27/11/2018 17:02:42:492 INFO - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Starting REST web service operation [testws]
27/11/2018 17:02:42:542 DEBUG - C5086433BD804F7CD112BEEE51A3362C:/Corredores : Web Service Request -> http://httpbin.org/response-headers?key=0
27/11/2018 17:03:03:541 ERROR - C5086433BD804F7CD112BEEE51A3362C:/Corredores : AXISFAULT during web service call: Connection timed out: connect
27/11/2018 17:03:03:541 ERROR - C5086433BD804F7CD112BEEE51A3362C:/Corredores : EXCEPTION: Connection timed out: connect