Hi Sir,

It's going to webservice application. After that its playing default technical difficulty message in AEP.
I have attached the java file and log files

Kindly check the log files and guide me for resolving this issue.

I forgot to inlude the below code:

public String getWebAppEntryPoint(com.avaya.sce.runtimecommon.SCESession mySession) {
String entryPoint = mySession.getParameter("module.WFO_DLG.entrypoint");
if (entryPoint != null)
return checkEntryPoint(entryPoint, mySession);
return(checkEntryPoint("http://rtauedccf01:29286/cf/startcall?", mySession));
}

Hi Sir,
Thanks for giving me an example application.
I have tried to below example , Without parameter its working, When i pass parameters with this url its showing badfetch error

I have attached my source code for your refernce

@Override
public String updateWebAppEntryPoint(SCESession mySession, String appName, String moduleName, String oldEntryPoint)
{
IVariableField field = mySession.getVariableField(IProjectVariables.ACCOUNT);

oldEntryPoint = "http://192.168.168.60:8080/WFO_TEST_APP/VerifyDetails?";

LoggerUtil.writeTrace(mySession, ITraceInfo.TRACE_LEVEL_DEBUG, ">>> SUBDIALOG URL " +oldEntryPoint+ "?ACCOUNT_NUMBER=" + field.getStringValue());
return (oldEntryPoint + "?ACCOUNT_NUMBER=" + field.getStringValue());

}

Kindly give me some solution for this problem.

Hi Sir,

Thanks for your reply .

I have already tried this in VXML Subdialog. Subdialog without parameter its working.(http://CFServer:29286/cf/startcall?)

But I need to send this url with parameter, When i am trying this i am getting runtime error.

(http://CFServer:29286/cf/startcall?BROWSERNAME=AVP&AGENTID=5677&LANGCODE=3&CDN=9&CUSTNO=9884528207)

Kindly give me some solution to reslove this problem.

Dear sir,

Thanks for your prompt reply. I will explain you my requirements clearly which will enable to guide me appropriately.

The requirement from my customer is to call the WFO customer service feedback ivr url it is basically another ivr application given by Avaya WFO itself. When a customer completes the discussion with agent, agent will transfer the call to experience portal for customer to fill up the survey inputs. The survey application is given WFO. I have an application that works intermediate that redirects call to WFO survey application.

Agent->Exp portal->My application (Developed in OD To receive UUI and process)->call Avaya WFO survey application RL with desired parameters)

The WFO survey application source is code is not with us the only way we can call the URL.

For example
1. I have developed one same surple application in AAOD
2. I am fetching UUI in this application
3. Manipulating this UUI to getting values and assigned this values to WFO url parameter
4. I need to REDIRECT this url from my AAOD application (http://CFServer:29286/cf/startcallBROWSERNAME=AVP&AGENTID=1234&TRANSCODE=15&LANGCODE=2&CASENBR=AB88775)
5. It's a third party WFO survey application placed in external server. I can't use this as reuseable module

When i am redirecting WFO url from my application . I am getting an error
(java.lang.IllegalStateException: Cannot forward after response has been committed)

I hope given enough details about the problem. Appreciate if any one can guide me to achieve thsi functionality.

Hi Sir,

I would like to call a vxml application with URL below:

http://CFServer:29286/cf/startcall?BROWSERNAME=AVP

Someone please help

Hi

setSQLQuery("SELECT STUDENT_DATA.ID, STUDENT_DATA.NAME FROM AVAYA.STUDENT_DATA");

// List variable that may be used
java.util.List list;

// Parameters
com.avaya.sce.runtime.connectivity.db.DbQueryParam parameter;
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ID",0,12, "select:ID"));
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("NAME",0,12, "select:NAME"));

This select query contains 10 values... How can i retrieve all the value ?

Ok . Thank you

In insert query is it possible to insert the values directly. without using parameter?

like

/}}END:CLASS:CONSTRUCTOR

setSQLQuery("INSERT INTO USE.FEEDBACKIVR ( QUESTIONNO) VALUES ( '1' )");

Hi,

Is it possible to execute database queries without dragging and dropping the Database Operation node in Orchestration Designer?

I have created a separate JAVA file to do this (without using the DBOP node), and am able to set and get the connection parameters using the ConnectionProperties class. But I am unable to execute the query and see the effect in the table. I also get no errors. Any help will be greatly appreciated. Thanks in advance.

In database manually editing data source is possible?

Thank you so much Wilsonyu . your answer is really helpful to solve my issue.
It's working.

Thanks.
I am using different table it contains different column name. It shows bind variable does not exist error.

setSQLQuery("INSERT INTO USE.FEEDBACKRESULT ( CLID, RESULT, UCID, STARTDATE, ENDDATE ) VALUES ( ?, ?, ?, ?, ? )");
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("CLID",0,12, "InsertDB:CLID"));

//}}END:CLASS:CONSTRUCTOR

setSQLQuery("INSERT INTO USE.FEEDBACKIVR ( QUESTIONNO) VALUES ( ? )");
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("QUESTIONNO",0,12, "Ins:ques"));

Thanks.
Inside the INSERT DBOP file after //END CLASS CONSTRUCTOR, i have written manual insert query with different table name.. it's not working.
If possible please post me sample code.

Inside select dbop file is it possible to add an INSERT query after the //END CLASS CONSTRUCTOR line? Only select seems to work inside the select DBOP file. Is this the case or am I missing something? :?