Reports Administration and Call Recording

Posted Thu, 06/24/2010 - 11:41 by birvin
birvin's picture

 Is there any documentation about Report Administration and Call Recording?

I made a few calls to one of my applications.  From Management Console, I clicked on Report Administration and selected the Call Detail Report with all of the fields.  I selected a date range and ran the report.  I was expecting to see the calls that I made within the date range, but instead, the report was blank.  It had all of the headers that I selected, but there was no data.  Any help would be greatly appreciated.

‹ Problems getting started with StarPound Email not picked up ›
epetrova's picture

sorry but documentation about

by epetrova - 06/24/2010 - 11:44

sorry but documentation about Report Adminisrration is under progress

Thanks,
Evgenia

birvin's picture

 Is there configuring I need

by birvin - 06/24/2010 - 12:22

 Is there configuring I need to do to get my calls to show up in the Report?

epetrova's picture

You don't need to do any

by epetrova - 07/02/2010 - 10:27

You don't need to do any configuring.
you just need to select what report you what to have.

Thanks,
Evgenia

birvin's picture

 Now when I try to run the

by birvin - 07/07/2010 - 10:37

 Now when I try to run the Call Details report, I get the following error:

Can't generate report: class net.sf.jasperreports.engine.util.JRFontNotFoundException : Font 'Times New Roman' is not available to the JVM. See the Javadoc for more details.

 

This is a snippet from the server.log:

 

 

or quserSessionId=ac3df31c0a04042300540703fba4820a

2010-07-07 05:30:28,463 INFO  [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/admin]] Connecting to HTTPSession=F311624E43CE90A70DA368620EAFDABF QuserSession=ac3df31c0a04042300540703fba4820a

2010-07-07 05:30:32,503 INFO  [org.starpound.reports.SessionListener] Session: F311624E43CE90A70DA368620EAFDABF created

2010-07-07 05:30:38,225 INFO  [org.starpound.reports.ui.ReportView] com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

 

** BEGIN NESTED EXCEPTION **

 

java.io.EOFException

 

STACKTRACE:

 

java.io.EOFException

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

        at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)

        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1147)

        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

@                                                                                                                              

 

 

maartendm's picture

You should install the fonts

by maartendm - 07/07/2010 - 15:21

You should install the fonts on your linux machine.

wwang's picture

There is a ticket for

by wwang - 07/12/2010 - 10:07

There is a ticket for it:

http://trac.starpoundtech.net/starpound-core/ticket/700

You can try the workaround:

Edit file: <starpound_root>/server/default/defploy/starpound-agserver/ReportsEAR.ear/ReportsWAR.war/reports/default/style.jrtx

and change the font.

For HTML reports font set to "Serif"
For PDF reports font set to "Helvetica"

 

 

birvin's picture

 Thanks.  I actually loaded

by birvin - 07/13/2010 - 16:29

 Thanks.  I actually loaded fonts on my linux machine and that fixed the problem.

But I'm still not getting data in my reports.  I'm running the Call Detail Report for a date range that I know calls were made.  Below is the report:

Call Detail         Run Date:   07/13/2010 11.49.36     Report Start: 07/10/2010 00.00.00   Report End: 07/13/2010 23.59.59     Interval
Period Org NameCall IDCaller IdDialed #ExtensionApplicationStart
TimeStart
TypeEnd
TimeCall
DurationIVR
DurationVXML
DurationQueueQueued
TimeWait
TimeAnswered
ByAbandoned
TimeAbandonedHold
DurationTalk TimeAnswered
In              Total     0   

The formatting is off a little.

Am I missing something?

epetrova's picture

does your StarServer running

by epetrova - 08/05/2010 - 09:33

does your StarServer running as well? and what version of SP do you have? and do you launch the Reports Administration from the organization for which calls were recorded?

Thanks,
Evgenia

birvin's picture

I believe the StatServer is

by birvin - 08/05/2010 - 11:40

I believe the StatServer is running.  How could I verify that it's running?  The version of SP is 1.3.0RC1-33.0.006.  I only have an organization called Incomm.  So everything that has been configured so far has been configured for the Incomm organization.

 

Brian

epetrova's picture

to run StatServer you need to

by epetrova - 08/05/2010 - 11:55

to run StatServer you need to execute StatServer.sh file from the directory that you define for Starserver during SP installation (by defauld, this is the same directory as Jboss_home directory /StarPound/StatServer

to find out iif the StarServer is running you can execute the following command in the command line:

ps -ef | grep java

You will see 2 java process: Jboss and StatServer.

After try to make calls and report again.

 

Thanks,
Evgenia

birvin's picture

Thanks for your help Evgenia!

by birvin - 08/05/2010 - 12:35

Thanks for your help Evgenia!  That worked.  It turns out that all I had to do is start the StatServer.

 

Brian