I found the solution, it should be like this :

If you have to connect to oracle RAC (Real Application Cluster) using JDBC with thin driver, the classic url:
jdbc:oracle:thin:@<HOST>:1521:<SID>

doesn’t work and you get the error ORA – 12505.

Instead, you must use this url:
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))

If you have an oracle client, like toad, check the tsnames.ora for the correct values of SERVICE_NAME and host.

Thanks Wilson,
Is there anyone who has done this?

One of my customer need to change the database from which the IVR application is getting data, database is oracle and they have a cluster with 3 IP address, before it was connected to server with single IP address now they have requested to make the connection to the cluster using the DNS/cluster name instead of IP address.
i am using JDBC to connect to the old database using the IP address, Port and databse name as connection string.

my old connection strring is : jdbc:oracle:thin:@200.200.200.90:1521:oradb , i want use the cluster server name instead of this .


i tried to use the DNS/cluster name (LOANDB-SCAN), [jdbc:oracle:thin:@LOANDB-SCAN:1521:oradb] instead of the IP address but its not working ?

Please advice.

Hi Shwetha ,
Could you please forward the documentation to me as well, we have a huge peripro application which we need to migrate to OD. The documentation will come handy because we are planning for a demo to the customer.
my email : arunknair82@gmail.com

Oops my bad, there wan no record to retrive and there was no has n o more in the first data block, added a hanomore unde if condition and its working fine..

Thank you team for the support.

Dear Neil,
When i reach the data node which uses the following,
getDetails.dbop
resetcollection(getdetails)
nextincollection(getdetails)
next form(playdetails)

i am getting the following error!!
15/06/2012 19:19:46:175 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Storing :enterMonth___utterance to complex: enterMonth:utterance as [02]
15/06/2012 19:19:46:175 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Storing :enterMonth___noinputcount to complex: enterMonth:noinputcount as [0]
15/06/2012 19:19:46:175 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Storing :enterMonth___confidence to complex: enterMonth:confidence as [0.949999988079071]
15/06/2012 19:19:46:176 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Storing :enterMonth___inputmode to complex: enterMonth:inputmode as [dtmf]
15/06/2012 19:19:46:176 INFO - Node Entry | session id:sess1203073 | SRPREDFINT:storeMonth | Framework | storeMonth | enterMonth___utterance | 02^0.949999988079071^0^0 | undefined
15/06/2012 19:19:46:176 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Assigning [enterMonth:value] to [eMonth]
15/06/2012 19:19:46:177 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Using SCESession 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT servlet : getDetails
15/06/2012 19:19:46:178 INFO - Node Entry | session id:sess1203073 | SRPREDFINT:getDetails | Framework | getDetails | | | undefined
15/06/2012 19:19:46:183 DEBUG - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Executing DB statement : [SELECT DISTINCT CasesTB.CID, DailyRecordTB.REC_DATE_DD, DailyRecordTB.REC_DATE_MM, DailyRecordTB.REC_DATE_YY FROM dbo.CasesTB, dbo.DailyRecordTB WHERE ( ( ( ( DailyRecordTB.EMPID = ? ) AND ( DailyRecordTB.REC_DATE_YY = (SELECT substring(CONVERT( nchar(10),GETDATE(),131),7,4)) ) ) AND ( DailyRecordTB.REC_DATE_MM = ? ) ) AND ( DailyRecordTB.CASEID = CasesTB.CID ) )]
15/06/2012 19:19:46:193 DEBUG - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Rows affected : [0]
15/06/2012 19:19:46:194 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Resetting collection [getDetails]
15/06/2012 19:19:46:194 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Next In Collection [getDetails]
15/06/2012 19:19:46:197 INFO - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : Capturing exception [javax.servlet.ServletException]. Message [ EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
]
***** Saw exception, tracing before report
javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.Data.handleRequest(Data.java:91)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
***** Saw exception, tracing before report
javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.Data.handleRequest(Data.java:91)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
15/06/2012 19:19:46:201 ERROR - In Progress | session id:sess1203073 | SRPREDFINT:getDetails | | javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
| Exception stack trace | Error processing request
EXCEPTION>
javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.Data.handleRequest(Data.java:91)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
| undefined
15/06/2012 19:19:46:203 ERROR - 9C12C6710F81BF8046F6675266F6BC13:/SRPREDFINT : session id:sess1203073 | Error processing request
EXCEPTION>
java.lang.Exception: javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:112)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
Caused by: javax.servlet.ServletException: EXCEPTION>
java.lang.IllegalStateException: EXCEPTION>
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
   at java.util.ArrayList.RangeCheck(Unknown Source)
   at java.util.ArrayList.get(Unknown Source)
   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:100)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)

   at com.avaya.sce.runtime.ComplexCollection.next(ComplexCollection.java:108)
   at com.avaya.sce.runtime.varoperations.NextInCollection.evaluate(NextInCollection.java:27)
   at com.avaya.sce.runtime.Data.evaluateActions(Data.java:192)
   at flow.getDetails.executeDataActions(getDetails.java:68)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:81)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1274)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:128)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:78)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:267)
   at com.avaya.sce.runtime.SCEServlet.doPost(SCEServlet.java:184)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionH

could you please explain Neil.

I am checking whethere there is any more records, if hasnomore then play goodbye..

Dear Neil,

I checked the Array example and i have modified my application like this,

A data node with the following items,
db1.dbop
resetcollection(getdetails)
nextincollection(getdetails)
next form(playdetails)

Another data node (playdetails) to do comparion of the data retrieved and play it

Another data node to iterate with the following items

if<getdeatils hasnomore()>
next(Play Goodbye)
nextincollection<getdetails.next()>
next form(playdetails)

Is that the correct way to do.
Do we have any other sample apps tha explain the usgae of collection using the different operation items..
Please advice.....

Dear Team,
This is my DBOP

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DbOp version="1.0">
<Datasource name="DBOPEN"/>
<DbObject name="dbo.CasesTB, dbo.DailyRecordTB" returntype="-1" selectall="false" type="table">
<DbObjectParam datatype="8" field="CID" function="" name="CID" sqltype="" tablename="CasesTB" type="" typename="DOUBLE" variable="getDetails"/>
<DbObjectParam datatype="4" field="REC_DATE_DD" function="" name="REC_DATE_DD" sqltype="" tablename="DailyRecordTB" type="" typename="INTEGER" variable="getDetails"/>
<DbObjectParam datatype="4" field="REC_DATE_MM" function="" name="REC_DATE_MM" sqltype="" tablename="DailyRecordTB" type="" typename="INTEGER" variable="getDetails"/>
<DbObjectParam datatype="4" field="REC_DATE_YY" function="" name="REC_DATE_YY" sqltype="" tablename="DailyRecordTB" type="" typename="INTEGER" variable="getDetails"/>
</DbObject>
<Operation name="Query">
<Qualifier name="distinct" value="true"/>
</Operation>
<Clause>
<Where>
<Condition name="Compound" type="Compound">
<Condition name="Compound" type="Compound">
<Condition name="Compound" type="Compound">
<Condition name="Simple" type="Simple">
<Operand datatype="8" name="EMPID" tablename="dbo.DailyRecordTB" type="column" typename="float"/>
<Operator type="Comparison" value="="/>
<Operand datatype="12" field="" name="WID" type="variable" typename=""/>
</Condition>
<Operator type="Boolean" value="AND"/>
<Condition name="Simple" type="Simple">
<Operand datatype="4" name="REC_DATE_YY" tablename="dbo.DailyRecordTB" type="column" typename="int"/>
<Operator type="Comparison" value="="/>
<Operand datatype="4" name="(SELECT substring(CONVERT( nchar(10),GETDATE(),131),7,4))" type="value" typename=""/>
</Condition>
</Condition>
<Operator type="Boolean" value="AND"/>
<Condition name="Simple" type="Simple">
<Operand datatype="4" name="REC_DATE_MM" tablename="dbo.DailyRecordTB" type="column" typename="int"/>
<Operator type="Comparison" value="="/>
<Operand datatype="12" field="" name="eMonth" type="variable" typename=""/>
</Condition>
</Condition>
<Operator type="Boolean" value="AND"/>
<Condition name="Join" type="Join">
<Operand datatype="8" name="CASEID" tablename="dbo.DailyRecordTB" type="column" typename="float"/>
<Operator type="Comparison" value="="/>
<Operand datatype="8" name="CID" tablename="dbo.CasesTB" type="column" typename="float"/>
</Condition>
</Condition>
</Where>
</Clause>
<Clause>
<Order/>
</Clause>
<SQLQuery>SELECT DISTINCT CasesTB.CID, DailyRecordTB.REC_DATE_DD, DailyRecordTB.REC_DATE_MM, DailyRecordTB.REC_DATE_YY FROM dbo.CasesTB, dbo.DailyRecordTB WHERE ( ( ( ( DailyRecordTB.EMPID = ? ) AND ( DailyRecordTB.REC_DATE_YY = (SELECT substring(CONVERT( nchar(10),GETDATE(),131),7,4)) ) ) AND ( DailyRecordTB.REC_DATE_MM = ? ) ) AND ( DailyRecordTB.CASEID = CasesTB.CID ) )</SQLQuery>
</DbOp>


I get more than 1 rows when executing this query and i store the values in complex variables.

I would like to know how i can play the values row by row one after the other.
i want to play the day, month and year in one row and if there is another row i want to play the day, month and year of that row and so on untill i finish all the rows.

The CID field will retun me numbers from 1-15 for each number i will play a staus message(prompt) first and then the remaining data.
Say if CID =1 i will play " Employee came date " then the date in the order day, month and year .
So if the employee came late for two days i need to play the status message(prompt) first and the date of the days that he came late.
How can i configure it in the data node.

Dear Neil,
I am on Avaya DD Version: 5.1 (5.1.0.1402) Build id: 201008241400.
My email address:
arunk@dataserve.com.sa
and
arunknair82@gmail.com

Thank you for your support.

Dear Neil,
I am working on the solution that you suggested, do we have a sample application that explains the substring, phrase variables and pre recorded audio files. I am trying to make it work with the items available in dialog designer rather than writing java code.

Thanks a lot for the reply Neil, i tried the third option, its working fine for me.

Now how can i do this using the second option as its more easy.
i have stored a string of digits 1234567890 in a variable , how can take the digits one by one compare it and play a corresponding wav file.
What are the items that i should you under data node and prompt node...
Please help.

Dear All,
I am developing an IVR application in DD 5.1 , all the prompt files are wav files and Arabic language, so no way to use TTS.
The caller enters the national ID number and I have stored the number entered into a variable. Now i want to playback the number entered for verification or for re entering the number again, how can i playback the number in DD, I have separate wav files for 0,1,2,3,4,5,6,7,8 ,9 and all are in arabic.

Please help.

Dear Wilson,
Do we have a sample application that uses bridged transfer in the Dialog designer cd or devconnect. I would like to know which items should be added under bridged or consulataion transfer. Also is it possbile to simulate this using Avaya App;ication simulator.

Dear Memebers,
I have an application which takes the extension number from the caller and transfers the call to that particular extension. I tried using blind transfer and its working fine.
My requirement is if the transfer fails due to busy/no answer/time out or any other reason the system should play a message to the caller that the extension he dialed is not available or busy. Also i want waiting message to played for the caller.
Which transfer should i use for this bridged or consultation transfer? What items should i add inside this. I have created transition audio for the waiting message. Should i use try catch inside the transfer block?
Please advise as i am new to dialog designer.