Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- Technology and Support
- DevNet
- DevNet Collaboration
- Collaboration Knowledge Base
- Erro something SPLIT variable when try INSERT on database.
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
48
Views
0
Helpful
0
Comments
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 01-24-2014 03:58 PM
This document was generated from CDN thread
Created by: Pedro Rego on 22-05-2012 04:59:15 PM
Insert Database SQL Server,
When we try a insert a value, the insert is not completed on application created on call studio.
The Activitylog and Erro_log show me problems during this event.
The orignal variable value "FIXED" a sample for CALLID_BD = 1234567890123456789Z123456789012 The inserts on database Works fine.
When we try use the variable CALLID_BD = 1234567890123456789Z123456789012 with anykind of letter like "Z" in the middle of string we
receive the erros describes bellow.
It seems have a SPLIT on my orginal value starting to Z showed on Erro_log
The database configuration is in the end this email.
INSERT INTO IVRDATA VALUES(
{Data.Element.Application_Modifier_01.CALLID_DB},
{Data.Element.Application_Modifier_01.data},
{Data.Element.start time1.start_time1},
{Data.Element.end time1.end_time1},
'{Data.Element.MENU principal.Label}',
'{Data.Element.MENU principal.Description}',
'{Data.Element.MENU principal.PVErificacione}'
)
ORIGNAL 1234567890123456789Z123456789012
SHOWED ON LOG Z123456789012
Erro_log
Root Cause: com.audium.server.AudiumException: Incorrect syntax near 'Z123456789012'.
at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:239)
at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:387)
at com.audium.server.controller.Controller.goToAction(Controller.java:2959)
at com.audium.server.controller.Controller.goToElement(Controller.java:2691)
at com.audium.server.controller.Controller.continueCall(Controller.java:2511)
at com.audium.server.controller.Controller.goToElement(Controller.java:2742)
at com.audium.server.controller.Controller.continueCall(Controller.java:2511)
at com.audium.server.controller.Controller.doPost(Controller.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)
Acitivity
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,newcall,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,ani,1063
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,areacode,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,exchange,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,dnis,5553
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,uui,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,iidigits,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,parameter,callid=8036BC87AAF6B1FB01000101C0A80ABF
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,parameter,var1=
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,CVP Subdialog Start_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.234,CVP Subdialog Start_01,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.234,Application_Modifier_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,custom,CALLID_DB,1234567890123456789Z123456789012
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,custom,data,22-5-2012
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,custom,START,000200
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,Description,passou no menu principal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,PVErificacione,62
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,Label,Menu Principal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.254,MENU principal,interaction,audio_group,initial_audio_group
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.766,MENU principal,interaction,utterance,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.770,MENU principal,interaction,inputmode,dtmf
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.770,MENU principal,interaction,interpretation,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.774,MENU principal,interaction,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,value,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,selection,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,value_confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,exit,option1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,end time1,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,end time1,custom,END,000400
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,end time1,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,Database_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,Database_01,element,error,A built-in element encountered an exception of type com.audium.server.AudiumException.
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,Database_01,exit,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,,element,error,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.894,Database_01,interaction,audio_group,initial_audio_group
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.406,Database_01,interaction,utterance,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.410,Database_01,interaction,inputmode,dtmf
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.410,Database_01,interaction,interpretation,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.414,Database_01,interaction,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,how,hangup
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,result,normal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,duration,7
contex.xml
<!-- The contents of this file will be loaded for each web application -->
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Manager pathname="" />
<Resource name="jdbc/SicrediCiscoReports"
type="javax.sql.DataSource"
username="sicredi"
password="123456"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://192.168.9.162:1433;databasename=SicrediCiscoReports"
maxActive="8"
maxIdle="4"/>
</Context>
Created by: Pedro Rego on 22-05-2012 04:59:15 PM
Insert Database SQL Server,
When we try a insert a value, the insert is not completed on application created on call studio.
The Activitylog and Erro_log show me problems during this event.
The orignal variable value "FIXED" a sample for CALLID_BD = 1234567890123456789Z123456789012 The inserts on database Works fine.
When we try use the variable CALLID_BD = 1234567890123456789Z123456789012 with anykind of letter like "Z" in the middle of string we
receive the erros describes bellow.
It seems have a SPLIT on my orginal value starting to Z showed on Erro_log
The database configuration is in the end this email.
INSERT INTO IVRDATA VALUES(
{Data.Element.Application_Modifier_01.CALLID_DB},
{Data.Element.Application_Modifier_01.data},
{Data.Element.start time1.start_time1},
{Data.Element.end time1.end_time1},
'{Data.Element.MENU principal.Label}',
'{Data.Element.MENU principal.Description}',
'{Data.Element.MENU principal.PVErificacione}'
)
ORIGNAL 1234567890123456789Z123456789012
SHOWED ON LOG Z123456789012
Erro_log
Root Cause: com.audium.server.AudiumException: Incorrect syntax near 'Z123456789012'.
at com.audium.server.action.database.DatabaseAction.doAction(DatabaseAction.java:239)
at com.audium.server.voiceElement.ActionElementBase.service(ActionElementBase.java:387)
at com.audium.server.controller.Controller.goToAction(Controller.java:2959)
at com.audium.server.controller.Controller.goToElement(Controller.java:2691)
at com.audium.server.controller.Controller.continueCall(Controller.java:2511)
at com.audium.server.controller.Controller.goToElement(Controller.java:2742)
at com.audium.server.controller.Controller.continueCall(Controller.java:2511)
at com.audium.server.controller.Controller.doPost(Controller.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)
Acitivity
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,newcall,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,ani,1063
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,areacode,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,exchange,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,dnis,5553
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,uui,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,iidigits,NA
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,parameter,callid=8036BC87AAF6B1FB01000101C0A80ABF
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,,start,parameter,var1=
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:04.593,CVP Subdialog Start_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.234,CVP Subdialog Start_01,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.234,Application_Modifier_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,custom,CALLID_DB,1234567890123456789Z123456789012
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,custom,data,22-5-2012
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,Application_Modifier_01,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,custom,START,000200
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,start time1,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,Description,passou no menu principal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,PVErificacione,62
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.250,MENU principal,custom,Label,Menu Principal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:05.254,MENU principal,interaction,audio_group,initial_audio_group
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.766,MENU principal,interaction,utterance,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.770,MENU principal,interaction,inputmode,dtmf
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.770,MENU principal,interaction,interpretation,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.774,MENU principal,interaction,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,value,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,selection,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,data,value_confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,MENU principal,exit,option1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.875,end time1,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,end time1,custom,END,000400
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,end time1,exit,done
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.890,Database_01,enter,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,Database_01,element,error,A built-in element encountered an exception of type com.audium.server.AudiumException.
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,Database_01,exit,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:10.140,,element,error,
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:06.894,Database_01,interaction,audio_group,initial_audio_group
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.406,Database_01,interaction,utterance,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.410,Database_01,interaction,inputmode,dtmf
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.410,Database_01,interaction,interpretation,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:08.414,Database_01,interaction,confidence,1
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,how,hangup
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,result,normal
192.168.9.186.1337718424562.0.TesteLION,05/22/2012 17:27:11.062,,end,duration,7
contex.xml
<!-- The contents of this file will be loaded for each web application -->
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Manager pathname="" />
<Resource name="jdbc/SicrediCiscoReports"
type="javax.sql.DataSource"
username="sicredi"
password="123456"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://192.168.9.162:1433;databasename=SicrediCiscoReports"
maxActive="8"
maxIdle="4"/>
</Context>
Labels:
Getting Started
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
Customers Also Viewed These Support Documents