This document was generated from CDN thread
Created by: Janine Graves on 15-12-2006 05:28:45 PM
when I run the importLogs.bat script (CVP Studio 3.1), it imports the code, but I get an error message that says:
"The log(s) could not be imported because an error occurred: Data truncation: Data too long for column 'value' at row 1
Press any key to continue . . ."
What can I do to prevent this?
ALSO, when I try to run the getVersions script, I get the following. Why can't it find my CVP.war file? Is it because there's a blank space in the directory name (Tomcat 1.4)? I've tried quotes, but that doesn't work.
-----
getVersions.bat C:\Cisco\CVP\Tomcat 4.1\webapps
Cisco CVP VoiceXML Server v3.1 Files
-----
Cisco CVP VoiceXML Server v3.1: Unable to obtain version because the file "C:\Cisco\CVP\Tomcat\CVP.war" does not exist.
CVP API: Unable to obtain version because the manifest of the JAR file "C:\Cisco
\CVP\Server\lib\framework.jar" does not properly contain a version number.
CVP Administration: 3000
CVP SNMP: 3000
CVP Elements / Say It Smart Plugins
-----
Core CVP Elements: 3000
CVP Say It Smart Plugins: 3000
Installed Gateway Adapters
-----
cisco_dtmf_01: 3002
cisco_nuance_01: 3002
cisco_osr_02: 3002
cisco_wvs_01: 3001
Press any key to continue . . .
Thanks, Janine
Subject: RE: Admin script problems.
Replied by: null on 20-12-2006 02:53:40 AM
Janine,
Activity logs consist of lines of comma-separated textual data. Activity logs are designed to be imported into a database, and Cisco supply a Java utility to do that. When first used, this utility creates a table called "activity_log" in a pre-created database with the following design:
[code:1:ee016de7cd]
Column Name Data Type Length Allow Nulls?
-----
session_id varchar 100 no
activity_time datetime no
element varchar 100 yes
category varchar 50 yes
action varchar 50 yes
value varchar 100 yes
[/code:1:ee016de7cd]
You just need to make the value column a lot wider. I can't remember exactly what I use, but since I have a lot of custom logging, and some of these are a bit long, I think I use 200.
If you created this database in Microsoft SQL Server 2000, you can go into SQL Enterprise Manager and just open up the "design" tool on the database and change the width of the column.
If you used MySQL, you may have to do it through a SQL statement - sorry, I don't know the syntax.
Do you know what I'm talking about?
Regards,
Geoff
Subject: RE: Admin script problems.
Replied by: null on 20-12-2006 03:05:25 AM
Hi Janine,
I can make it find the WAR file, but it still gives an error.
First of all, from a DOS window, I try this:
[code:1:d492a69b30]
C:\Cisco\CVP\Server\admin>dir "c:\Cisco\CVP\Tomcat 4.1\webapps"
Volume in drive C has no label.
Volume Serial Number is A0CD-17B6
Directory of c:\Cisco\CVP\Tomcat 4.1\webapps
12/11/2006 05:11p <DIR> .
12/11/2006 05:11p <DIR> ..
12/11/2006 05:07p 697 admin.xml
12/11/2006 05:11p <DIR> CVP
12/11/2006 05:08p 4,258,006 CVP.war
12/11/2006 05:07p <DIR> examples
12/11/2006 05:07p 435 manager.xml
12/11/2006 05:07p <DIR> ROOT
12/11/2006 05:07p <DIR> webdav
3 File(s) 4,259,138 bytes
[/code:1:d492a69b30]
That shows you that "c:\Cisco\CVP\Tomcat 4.1\webapps" will find the CVP.war file.
Now I run the command:
[code:1:d492a69b30]
C:\Cisco\CVP\Server\admin>getVersions.bat "c:\Cisco\CVP\Tomcat 4.1\webapps"
Cisco CVP VoiceXML Server v3.1 Files
-----
Cisco CVP VoiceXML Server v3.1: Unable to obtain version because the manifest of the JAR file "C:\Cisco\CVP\Tomcat 4.1\webapps\CVP.war" does not properly contain a version number.
CVP API: Unable to obtain version because the manifest of the JAR file "C:\Cisco\CVP\Server\lib\framework.jar" does not properly contain a version number.
CVP Administration: 3000
CVP SNMP: 3000
CVP Elements / Say It Smart Plugins
-----
Core CVP Elements: 3000
CVP Say It Smart Plugins: 3000
Installed Gateway Adapters
-----
cisco_dtmf_01: 3002
cisco_nuance_01: 3002
cisco_osr_02: 3002
cisco_wvs_01: 3001
Press any key to continue . . .
[/code:1:d492a69b30]
Looks like we both need help. 😉
Regards,
Geoff
Subject: RE: Admin script problems.
Replied by: Janine Graves on 28-12-2006 02:29:12 AM
Thanks Geoff,
I'll try changing the size of the 'value' column in the db table. The only issue I have is that the importlogs script creates the table (all I do is create the db), so shouldn't it create the field of the correct size? I'm not even doing any custom logging.
Janine
Subject: RE: Admin script problems.
Replied by: null on 03-01-2007 01:40:29 AM
Yes, it creates the table the first time it's called. But it knows if it's done this and won't do it again. So it's perfectly fine to come in through another channel (like SQL Enterprise) and change the database.
Irrespective of custom logging, the column is too short.
Regards,
Geoff
Subject: RE: Admin script problems.
Replied by: Vance Vagell on 17-01-2007 05:57:07 PM
Hi Janine and Geoff,
Geoff -- thank you for providing insightful workarounds for Janine and other users to try. We understand that the default column widths may be insufficient for some applications. That said, this administrative script does not exist in newer Audium Call Services versions.
Janine -- as of Call Services 3.6.x you now have the ability to create custom loggers that log directly to the database of choice. In short, these custom loggers will be notified whenever a logging event it is interested in occurs. The logger then has full control (as with all custom components) of how to act on that information. Additionally, the default activity logs in Call Services 3.6.x are still comma-delimited so that you can create a custom database and import script if that is still the best route for your project.
Should either of you have any followup questions, please let us know.
Regards,
Vance