Diagnostics and Troubleshooting

This chapter covers the following topics:

Failover and Load Balancing Behavior

Oracle Advanced Outbound Telephony provides the following failover and load balancing actions:

Setup 1:

More than one dial server configured within the same server group.

Failure Situation 1:

One dial server goes down.

Fail over Action 1:

On the next agent request, Oracle Advanced Outbound Telephony automatically logs in the agent to the functioning dial server and begins to service the agent through the new dial server.

Setup 2:

One or more dial server configured within the same server group.

Failure Situation 2:

UWQ server goes down and then comes back up.

Fail over Action 2:

If the agents do not shut down their UWQ Clients (Forms desktops), then when the UWQ server comes back up, the agents will automatically (without having to make a request) be logged into the same UWQ server and dial server as they were before the UWQ server went down.

If the agents shut down their UWQ Clients (Forms desktops), then they will need to log back in when the UWQ server comes back up. The agents will be logged into the same UWQ server and dial server as they were before the UWQ server went down.

Setup 3:

Another physical server box is configured within ICSM and has been designated as a warm hardware backup; one or more dial servers are configured in the server group.

Failure Situation 3:

The dial server is not responding and appears to be down; ICSM is not getting a heartbeat from server box.

Fail over Action 3:

ICSM will start another instance of the dial server on the warm backup server box. On the next agent request, Oracle Advanced Outbound Telephony will automatically login the agent to the other dial server and begins to service the agent through the new dial server.

Setup 4:

Another physical server box is configured within ICSM, and has been designated as a warm hardware backup; one or more dial servers are configured in the server group.

Failure Situation 4:

The dial server is not responding and appears to be down (possibly due to a network glitch), then the dial server seems to become available again and reappears.

Fail over Action 4:

ICSM will start another instance of the dial server on the warm backup server box. On the next agent request, Oracle Advanced Outbound Telephony will automatically login the agent to the duplicated dial server and begin to service the agent through the duplicated dial server. When the machine running the original dial server appears on the network again, the original dial server will recognize that a duplicate dial server (same ID) is running and will automatically shut itself down.

Load Balancing:

Each dial server maintains and calculates the Oracle Advanced Outbound Telephony runtime parameter - Major Load Factor (MLF). The calculation is based on the number of agent logins. New agents will be logged into servers with lower MLF. Agents will be logged in at a grainularity of ten - meaning Oracle Advanced Outbound Telephony will determine which server currently has the lowest MLF and the next ten agents who log in will be placed on that server. After the tenth agent logs in, Oracle Advanced Outbound Telephony will again evaluate each server's MLF.

Diagnostic Tools

There are a number of tools you can use to diagnose problems with Oracle Advanced Outbound Telephony, including:

Using Oracle ICSM to Diagnose Issues

With Oracle Interaction Center Server Manager (ICSM), you can:

Starting and Stopping Servers With ICSM

Follow the steps below to start or stop your servers with Oracle ICSM.

Login

Self-Service Login URL

Responsibility

Call Center HTML Administration

Steps

  1. Click ICSM > Server Groups.

    The Server Group List page appears.

  2. Click a server group name.

    The Server Group Details page appears, displaying a summary view table of all servers in that group.

  3. From the list to the left of the Submit button:

    1. Select Start to start the selected server

    2. Select Stop to stop the selected server.

  4. Click Submit.

    It may take several minutes to start or stop the server processes. To view the current status during startup or shutdown, refresh the browser several times.

    As the server processes are starting up, "Starting" is displayed in the Stop/Start column. As the server processes are shutting down up, “Stopping" is displayed in the Stop/Start column. The status of each server process is displayed in the Servers area in the Status column.

Setting Server Log Levels With ICSM

You can use the database logging function to obtain information about when servers are started or stopped, and the reasons why they started or stopped.

Login

HTML Login URL

Responsibility

Call Center HTML Administration

Steps

  1. Click ICSM > Server Groups.

    The Server Group List page appears, displaying a summary view table of any existing server groups.

  2. From the Server Group Name column, click the server group that contains the server on which you want to set log levels.

    The Server Group Details page appears for the selected server group, displaying a summary view table of any servers in that server group.

  3. From the Server Name column, click the server on which you want to set log levels.

    The Server Details page appears for the selected server.

  4. From the Server Details page, click the Parameters hyperlink.

    The Server Details page refreshes to display a summary view table for parameter settings.

  5. In the Parameter Value field for OAO_LOG_LEVEL, type one of the following levels:

    • error - shows server errors.

    • warn - shows server warnings and errors

    • info - shows events, warnings, and errors

    • all - shows all server activity

      The log level can be changed while the server is running, but you must wait for the time period specified in the OAO_ REFRESH_INTERVAL parameter before the information in the log begins reflecting the new log level.

  6. Click Update.

  7. Click Done.

Setting Trace File Options With ICSM

You can use the server trace function to obtain detailed information about server activity. By default the trace function is not activated.

Use the steps below to activate the trace function.

Login

HTML Login URL

Responsibility

Call Center HTML Administration

Steps

  1. From the Oracle Call Center Technology page, click the ICSM tab.

    The Server Group List page appears, displaying a summary view table of any existing server groups.

  2. From the Server Group Name column, click the server group that contains the server on which you want to run the tracing function.

    The Server Group Details page appears for the selected server group, displaying a summary view table of any servers in that server group.

  3. From the Server Name column, click the server on which you want to run the tracing function.

    The Server Details page appears for the selected server.

  4. From the Server Details page, click the Advanced hyperlink.

    The Server Details page refreshes to display a Java Options field, a Server Arguments field, and a summary view table of any existing trace files for the selected server.

  5. In the Java Options field, type the following:

    -ms128m -mx256m -DAFLOG_MODULE=iec% -DAFLOG_ENABLED=FALSE -DAFLOG_LEVEL=STATEMENT -DAFLOG_FILENAME=prs.log

    The –ms and –mx VM parameters should be set depending on the number of agents you expect to service. These are the minimum and maximum values for the Virtual Machine. These values cannot be changed dynamically; you will need to restart the server for changes to take effect.

    Oracle recommends you set these parameters to -ms128m -mx256m. Refer to the Before You Begin section of this guide, for information on what values to enter for these parameters.

    The -DAFLOG_LEVEL parameter can have values (in increasing order of severity):

    • STATEMENT

    • PROCEDURE

    • EVENT

    • EXCEPTION

    • ERROR

    • UNEXPECTED

  6. In the Server Arguments field, type the following:

    -AFLOG_ENABLED TRUE

    Note: You will need to bounce the server to start or stop the tracing process.

  7. Click Update.

  8. Click Done.

Checking Server Log Messages With ICSM

Follow the steps below to check the server log messages.

Login

HTML Login URL

Responsibility

CRM HTML Administration

Steps

  1. Click the Settings tab.

  2. Click the System subtab.

  3. From the side panel, click Debug Logging > Messages.

    The Debug Log Viewer page appears.

  4. In the Module field, type iec% to only see Oracle Advanced Outbound Telephony logs.

Checking Server Parameter Settings With ICSM

Follow the steps below to check server parameter settings.

Login

HTML Login URL

Responsibility

Call Center HTML Administration

Steps

  1. Click ICSM > Server Groups.

    The Server Group List page appears, displaying a summary view table of any existing server groups.

  2. From the Server Group Name column, click the server group that contains the server on which you want to set log levels.

    The Server Group Details page appears for the selected server group, displaying a summary view table of any servers in that server group.

  3. From the Server Name column, click the server on which you want to set log levels.

    The Server Details page appears for the selected server.

  4. From the Server Details page, click the Parameters hyperlink.

    The Server Details page refreshes to display a summary view table of the parameter settings for the selected server.

  5. Verify that the parameter settings are correct.

    For a detailed list of the necessary parameters for Oracle Advanced Outbound Telephony servers, refer to the Implementing the Oracle Advanced Outbound Telephony Servers section.

Using the Oracle Advanced Outbound Telephony HTML Admin Console to Diagnose Issues

You can use the Oracle Advanced Outbound Telephony HTML Administration console to:

Checking Campaign Activity Parameters in Oracle Advanced Outbound Telephony

Follow the steps below to check campaign activity parameters in the Oracle Advanced Outbound Telephony HTML Admin console.

Login

HTML Login URL

Responsibility

Oracle Advanced Outbound Telephony Administrator

Steps:

  1. From the View field, select My Campaign Activities to check the parameters for a campaign activity you created in Oracle Marketing.

  2. From the Name column of the summary view table on the Campaign Activities page, click the name of the campaign activity you want to check.

    Note: If you do not see the desired campaign activity displayed, check Oracle Marketing to ensure the campaign activity is configured properly.

    The Call Center Campaign Activity Details page appears, displaying a Call Center Parameters area.

  3. In the Calendar field, verify the correct the user defined calendar is associated with the selected campaign activity (if you want one to be).

  4. Do you want the CTI Disabled checkbox selected?

    Checking this box disables computer telephony for the selected campaign activity. With CTI disabled, only manual dialing is allowed.

  5. Is the On Hold checkbox selected?

    Selecting the On Hold checkbox will place on hold a campaign activity with a status of Active.

  6. Once you have made changes, click Update.

    You return to the Call Center Campaign Activity Details page and a confirmation note is displayed, stating that the configuration was successful.

Checking Target Group Parameters in Oracle Advanced Outbound Telephony

Follow the steps below to check target group parameters in the Oracle Advanced Outbound Telephony HTML Admin console.

Login

HTML Login URL

Responsibility

Oracle Advanced Outbound Telephony Administrator

Steps

  1. From the View field, select My Campaign Activities.

  2. From the Name column of the summary view table on the Campaign Activities page, click the name of the campaign activity containing the target group you want to check.

    The Call Center Campaign Activity Details page appears, displaying a Call Center Parameters area.

  3. From the side navigation bar, click Campaign Activity Target Groups.

    The Interaction Center Campaign Activity Target Groups page appears, displaying a summary view table of the target group associated to the selected campaign activity.

  4. From the Name column of the summary view table, click the name of the target group for which you want to check parameters.

    The Interaction Center Campaign Activity Target Group Details page appears.

  5. From the drop-down list in the Dialing Method field, verify your dialing method selection or select to default to the campaign activity's dialing method.

  6. From the drop-down list in the Target Group Priority field, check the priority assigned to the target group.

    Note: Priorities determine the relative priority of a target group or subset in comparison to other target groups and subsets.

    Note: Highest through Medium level priorities are preemptive; all target groups with priorities in this range will be exhausted in priority sequence before the next priority level is used. Low and Lowest priorities are used in round-robin fashion; each of these target groups will release its quantum of records, then the next target group in the same priority level will be used.

    Note: At this time, Oracle Marketing does not support multiple target groups.

  7. From the drop-down list in the Recycling Algorithm field, verify you have selected the recycling algorithm you want to use for the target group.

  8. From the drop-down list in the Record Filter field, check that you have selected the record filter rule you want to use with the target group.

  9. From the drop-down list in the Validation Rule field, check that you have selected the validation rule you want to use with the target group.

  10. From the drop-down list in the Calendar field, verify that you have selected the user defined calendar you want to use with the target group (if you want to use one).

  11. From the drop-down list in the Release Strategy field, verify you have selected the correct release strategy to use with the target group.

    Note: The quantum release strategy supports proportional calling across all target groups and subsets associated with the campaign strategy and it is considered the baseline strategy for an Oracle Advanced Outbound Telephony service. This means that when Oracle Advanced Outbound Telephony is distributing customer records to agents, it releases a quantum number of records from each target group or subset before it goes on to the next target group or subset in the campaign.

    Note: The Quota Release Strategy stops releasing records from a target group or subset when a pre-defined limit has been reached. This strategy disburses records from a target group or subset based on the quota that is assigned to a target group or subset.

  12. Check the number of records you set as your limit in either the Quantum or Quota field.

    Note: If you selected Quota in step 11, you must select the hour and minute reset period from the drop-down list in each respective field. These fields specify the hours and minutes before the quota value is reset to zero (0).

  13. Once you have made your changes, click Update.

    The Interaction Center Campaign Activity Target Group Details pages updates to reflect the new dialing parameters and displays a confirmation stating that the dialing parameters have been configured successfully.

Using the Oracle Marketing HTML Admin Console to Diagnose Issues

You can use the Oracle Marketing HTML Administration console to:

Checking Campaign Activity and Target Group Parameters

Follow the steps below to check campaign activity and target group parameters in Oracle Marketing.

Login

HTML Login URL

Responsibility

Oracle Marketing Super User

Steps

  1. Click the Campaign tab.

    The Campaigns page appears, displaying a summary view table of all existing campaigns.

  2. From the table, select the campaign containing the campaign activity in which you want to view parameters.

    The Campaign Details page appears.

  3. From the side navigation panel, click Execution.

    The Campaign Details - Campaign Activity page appears, displaying a summary view table of all campaign activities associated with the selected campaign.

  4. From the summary view table, click the campaign activity in which you want to view parameters.

    The Campaign Activity – Details page appears.

  5. Verify the campaign activity parameters.

    For more information on campaign activity, refer to the Oracle Marketing User Guide.

  6. From the side navigation panel, click Execution > Target Group.

    The Campaign Activity Details - Target Group page appears.

  7. Verify the target group parameters.

    For more information on target group parameters, refer to the Configuring an Oracle Marketing List, and Configuring an Oracle Marketing Target Group topics in this guide.

Checking the Agent to Campaign Activity Assignment

Follow the steps below to check the agent to campaign activity assignment in Oracle Marketing.

Login

HTML Login URL

Responsibility

Oracle Marketing Super User

Steps

  1. From the Oracle Marketing homepage, click the Administration tab.

  2. Click the Sales subtab.

  3. From the side panel under Call Center, click the Agent Assignments hyperlink.

    The Resource Assignment window appears.

  4. In the Campaign Name field, type the name or a partial name of the appropriate campaign activity. You can use the % sign to substitute for missing characters.

  5. Click Go.

  6. From the list, select the appropriate campaign activity and click OK.

    The campaign activity name populates the Campaign Name field. and the Current Resource Assignments table refreshes to display all the agents currently assigned to the selected campaign activity.

  7. Verify that the correct agents are assigned.

Using Java Console Logs to Diagnose Issues

The Java Console is a pop-up window that you can configure to appear whenever you launch an Oracle Forms session.

You can use the Java console logs to track application trace messages, to verify server information from the agent side, and to diagnose problems when dealing with multiple servers.

Troubleshooting Oracle Advanced Outbound Telephony

The following are the most commonly experienced errors with Oracle Advanced Outbound Telephony:

Servers Won't Start

Reason:

No database connection.

Check:

Check the .dbc file. Make sure that NUM_CONNECTIONS in dbc file is set high enough.

Reason:

ICSM setup is incorrect.

Check:

Check server arguments (ICSM - Advanced link).

Reason:

Server or plugin parameters are incorrect.

Check:

Verify the server parameters are correct

Ensure the values set in ICSM (Advanced link) are correct

Ensure Java arguments set to at least “-ms256m mx256m”

Ensure server node is running (ICSM).

Start the server at the local node using a local script.

Validation Failed

Reason:

Oracle Marketing Source Type does not exist or Oracle Marketing Source Type does not have required columns

Check:

Check the logs files for the following error messages:

Solution:

Create or update the Oracle Marketing list source type. Ensure all the required fields are present.

Reason:

Insufficient Table Space

Check:

Check the log files the following error message:

Solution:

Ask your DBA to extend the table space specified in the error message.

Validation Doesn't Fail, but no Records are Returned

Reason:

Check:

Solutions:

Can't See Oracle Advanced Outbound Telephony Media Node

Reason:

The agent's profile options are not set correctly

Check:

The profile settings for the agent.

  1. Self-Service Login URL (Forms).

  2. Select System Administrator responsibility.

  3. Click Profile > System.

  4. Type agent's user ID and click Find.

Solution:

Ensure the following profile options are set:

No Campaign Activities Appear

Reason:

The agent, or group to which the agent belongs, is not assigned to a campaign activity

Check:

Ensure that the agent (or group that the agent belongs to) is assigned to a campaign activity

Reason:

The concurrent manager has not been started

Check:

Ensure the concurrent manager is running

Queue Count Doesn't Update

Reason:

The concurrent manager is not running.

Check:

Ensure the concurrent manager has been started.

Note: The queue count only changes when the concurrent manager is running. The count only reflects changes in:

Central Server Isn't Pulling Records

Reason:

Server Time Zone is not configured.

Check:

Check the log messages for any error messages with title “Calendar Error”.

Solution:

Configure Server Time Zone in the Oracle Advanced Outbound Telephony Administration console.

Reason:

Country calendar does not exist.

Check:

Check the country calendar in the Oracle Advanced Outbound Telephony Administration console.

Solution:

Create the country calendar.

No More Callable Records for an Agent

Check:

Agent Cannot Make Progressive Calls

Reasons:

Check:

Check for these errors in dial server trace file:

Solution:

Oracle Telephony Manager Cannot Get Media Items From Oracle Advanced Outbound Telephony

Reason:

Middleware configuration error.

Solution:

If middleware is CT_CONNECT, make sure "enable server application data" in CT_CONNECT configuration is selected.

Oracle Telephony Manager Received Two Media Items for the Same Oracle Advanced Outbound Telephony Call

Reason:

Middleware configuration error.

Solution:

If middleware is CT_CONNECT, make sure "enable server application data" in CT_CONNECT configuration is selected.

Media Items Were Not Closed

Reason:

Middleware configuration error.

Solution:

If middleware is CT_CONNECT, make sure "enable server application data" in CT_CONNECT configuration is selected.

Oracle Advanced Outbound Telephony Fails in the Dial Server, but no "Enabler Related Errors" Are Generated

Check:

Oracle Advanced Outbound Telephony Central Server Troubleshooting

This topic group contains information to help you resolve common problems with the AO Central Server.

The following topics are included:

Cannot Start the Server

  1. No database connection

    Check the .dbc file, make sure that NUM_CONNECTIONS in dbc file is high enough.

  2. ICSM setup is incorrectly

    Check server arguments.

  3. Server or plugin parameters are incorrect.

    • Check if the parameters have been added

    • Check if the values set in ICSM (Advanced link) are correct

    • Make sure the server node is running (ICSM). If the server is not running, try to start the server again from ICSM

    • Try to start the server at the local node using a local script.

  4. DB Server Time Zone is incorrect.

    Correct the DB Server Time Zone using the AO Administrator utility, under the Administration Tab.

  5. Another OCS is running.

    Use ICSM to check/change server status.

AOCS Starts but Does not get Records

  1. Make sure the activity has been marked for Telemarketing.

  2. Make sure the activity has a status of 'LOCKED'.

  3. Make sure the target group has been generated for the activity using lists that have been generated using one of the two supported source types.

  4. Make sure the target group has a status of 'LOCKED' in order to validate target group.

  5. Make sure that the list is executing.

Oracle Advanced Outbound Telephony Dial Server Troubleshooting

This topic group contains information to help you resolve common problems with the AO Dial Server.

The following topics are included:

Server Does Not Start

  1. No database connection

    Check the dbc file

  2. ICSM setup is incorrect

    Check server arguments

  3. Server parameters are incorrect

  4. Another Dial Server is running with the same server id

    Use ICSM to check/change server status

Agent Was Not Able to Log in

  1. Make sure that the agent is assigned the System Profile for AO

    Use the System Administrator Responsibility, and click System, then Profile. Set the AO profile parameters to Yes.

  2. Make sure that the agent is assigned to one of the running campaign activities.

  3. Make sure that there are valid executing campaign activities.

Agent Cannot Get Work

  1. Check if the agent/campaign activity association is set.

  2. Check if the campaign activity/target group is in the correct state and that the calendar is callable.

  3. Check the number of available records in this target group.

  4. Records may not be in cache, check if Central Server has been started; check the execution interval of the Refresh plugin.

  5. Wait and test again.

Dials Cannot be Placed

  1. Make sure that the correct extension was provided.

  2. Make sure that the middlewares in your server group are configured correctly (use the Call Center HTML Administrator responsibility, "Middleware" tab).

    Check the IP address and the port of Telephony Adapter Server.

    Make sure that the middleware parameters are set for Oracle Advanced Outbound Telephony use (including setting the "Use with Oracle Advanced Outbound Telephony" parameter to Yes.

  3. Make sure that the Telephony Adapter Server is up.

Receiving Too Few Records for Target Group

  1. Check to ensure there is a country calendar defined for each country code used in the target group.

  2. Check to ensure each target groups source type matches the source type defined for the target group.

Receiving no Records

  1. Check to ensure the source type defined for the target group matches the source type defined for the target groups.

  2. If list validation fails, you should check the AO central server log files (via Oracle Call Center Technology Admin - ICSM tab). If you see a message indicating that the database view is missing, you must go into the Oracle Marketing Administration console and select data source types for Organization Contacts and Person List, then click Update.

Failed Validation

Oracle Marketing source types do not exist or do not have the required columns

Use the steps below to diagnose this problem:

Login

HTML Login URL

Responsibility

Call Center HTML Administration

Steps

  1. Click the ICSM tab.

    The Server Group List page appears, displaying a summary view table os any existing server groups.

  2. From the top bar, click Logs.

    The Summary Report for Servers page appears, displaying a summary view table of all the servers in the group.

  3. From the list of servers, locate the appropriate server and click the hyperlink to display the log error messages.

    The Detail Report page appears, displaying a summary view table of all the error messages for the selected server.

  4. In the Title column of the summary view table, search for error messages titled "Validation Error".

  5. Click the Record ID hyperlink to display the error message in the Message Description text box.

  6. Check for the following error messages:

    • ORA-00942: table or view does not exist

      Source type view XXX has not been created in Oracle Marketing

    • Ora-00904: invalid column name

      Source type view XXX is missing one or more columns

If you locate these error messages, you must create or update the Oracle Marketing Source type view. Follow the steps in the Defining List Source Types topic to do so.

Target Group Stuck in Validating Status

If a target group stays in the 'Validating' status for an extended period of time, it is likely the case that validation has failed, but was unable to update the status to "Failed Validation". This usually occurs when there is a tablespace issue and the error message could not be logged. After the tablespace is increased, the target group will automatically resume validation.

Check:

Check your table space sizes.

Solution:

Although the exact tablespace configuration will depend on what applications are running in the database and needs to be reviewed by a dba, Oracle recommends the following sizes for a sytem configured exclusively for AO:

No Longer Seeing IEO Log Messages

If you stop seeing new error messages (beyond a specific date) in the IEO Log Viewer, it is very likely that you need to extend your tablespace. This is especially true if you are running into other errors that cannot be explained since other parts of the application may be failing, but are unable to log the errors due to the tablespace issues.

Check:

Check your table space sizes.

Solution:

Although the exact tablespace configuration will depend on what applications are running in the database and needs to be reviewed by a dba, Oracle recommends the following sizes for a sytem configured exclusively for AO: