GIM Manager Help

Important

Starting with Genesys Info Mart Manager release 8.5.014.02 and Genesys Info Mart release 8.5.014.14 on August 30, 2019, Genesys Info Mart is part of 9.0. This document is valid only for the 8.5 releases of this product before Genesys Info Mart was part of 9.0. For 8.5 releases of Genesys Info Mart Manager after August 30, 2019, see the Current version of this document.

The Genesys Info Mart Manager (GIM Manager) provides an interface that you can use to manage Genesys Info Mart jobs.

Tip

Watch the Genesys Info Mart Manager "how to" videos:

Genesys Info Mart Manager provides the following views to monitor and manage jobs:

Job History view, where you can view detailed historical information about jobs.
ETL Status view, which displays information about latency for each functional area.

If more than one Genesys Info Mart Server is available to manage, choose a server from the drop-down list box.

Tip

In Genesys Info Mart Manager 8.5.007 and later, if no servers are available, some buttons are disabled.

For additional information about deploying and accessing Genesys Info Mart Manager, see the Genesys Info Mart Deployment Guide. For additional information about managing and monitoring jobs with Genesys Info Mart Manager, see the Genesys Info Mart Operations Guide.

How do I view job history?

To view detailed information about jobs, click Job History. You can customize and filter the display:

To Control What Information is Displayed About Each Job

To sort the data in the list view, click the column headings. For example, to sort by duration, click the Duration column heading. Click again to sort in reverse order.
To choose what columns appear in the list view, click Select Columns. In addition to the default columns, you can, for example, add a column to show the End Time, Job Version, or Job ID.

Tip

Changes you make to column visibility and data sort order are not preserved when you reload/refresh the browser page.

To Refresh the Data in the List View

In Genesys Info Mart Manager 8.5.007 and later, Genesys Info Mart Manager automatically refreshes the data in the list view. To enable, disable, or configure this feature, click GIM Manager Settings. In the GIM Manager Settings dialog, you can configure the following options:

Enable auto-refresh—Select this option to enable auto-refresh (enabled by default).
Auto-refresh frequency—Enter the number of seconds Genesys Info Mart Manager should wait before refreshing job history and status information. Enter any whole number between 1 and 60; the default is 30 seconds.
Auto-refresh idle timeout—Enter the number of minutes that Genesys Info Mart Manager can be idle before the auto-refresh option is temporarily suspended. Enter any whole number between 1 and 60; the default is 30 minutes.

If Genesys Info Mart Manager is inactive for a period of time, the auto-refresh option is temporarily suspended. Click Refresh List to resume auto-refresh. You can manually refresh data at any time by clicking Refresh List.

Important

In Genesys Info Mart Manager 8.5.004 and earlier, data in the list view is not automatically refreshed. If you are waiting for a job status to change, periodically click Refresh.

To Control (filter) What Jobs Appear in the Job History List View

Genesys Info Mart Manager offers two filtering tools: the Quick Filter filters the jobs already listed in the Genesys Info Mart Manager view, while the Filter dialog retrieves fresh, filtered data from the Genesys Info Mart Server:

Click Show Quick Filter to display the Quick Filter field. In the Quick Filter field, type one or more characters. As you type, the list of jobs automatically updates to show only those jobs that contain the text you type. This filter checks all visible columns, so you can easily filter by job name, status, duration, job ID, or start/end times. Often a few characters is enough to usefully filter the view; for example, type Ext to show only JobExtractICON jobs.
Click Filter to open the Filter dialog box. On the Filter dialog box, you can enter a value in the Show jobs from this many past days field, which controls how many days' worth of data is displayed. This value works in parallel with any one of the following three filtering options:
- Show a specified number of jobs: Enter the maximum number of jobs to display. For example, enter 10 to display 10 jobs with the most recent start times.
- Show jobs with a specified status: Select an option from the list to display only jobs that have the selected status. For example, select Running to display only jobs that are currently running.
- Show all jobs: Show all jobs from the specified past number of days.
For example, to view all of the jobs that failed in the last week, enter 7 in the Show jobs from this many past days field, and select FAILED from the Show jobs with a specified status list.

Tip
Selections you make in the Filter dialog box persist between sessions. Also, the Quick Filter and Filter features interact with each other. Thus, if you set options in the Filter dialog box, you can further refine the filter by entering a value in the Quick Filter field.

How do I start or stop jobs?

You can easily start and stop jobs using Genesys Info Mart Manager:

To Start a Job

To start a Genesys Info Mart job:

Click Run Job to open the Run Job dialog box.
On the Run Job dialog box, select a job to run. Job_AggregateGIM can optionally accept parameters using the Job Parameters field; for all other jobs, leave the Job Parameters field blank.
Click OK to start the job.

Note that the job may not run immediately (for example, the job cannot run while other jobs are running). In this case, the status will change to Scheduled, and the job will run as soon as conditions permit.

Tip

If you want to stop Job_AggregateGIM, you must first ensure that the run-aggregates configuration option in the Genesys Info Mart application is set to false.

To Stop a Job

To stop a currently running job, or cancel the Run Job command for a job that has not yet started (in other words, a job that has a status of Scheduled), first click Job History and select the job, then click Stop Job.

The data in the list view is automatically refreshed when you stop a job by clicking Stop Job.

To Re-aggregate Data

Run Job_AggregateGIM, and in the Job Parameters field, enter:
-insertPendingAgg <AGR_SET>:<START>:<END>
where:

<AGR_SET> indicates what set to aggregate (ALLSETS, or an aggregate set name). Aggregate set name is formatted as follows: <HIERARCHY_NAME>-<AGG_LEVEL>[.Flavor])
where:
- <HIERARCHY_NAME> is the name of the hierarchy to be aggregated.
- <AGG_LEVEL> is the aggregation level (SUBHOUR, HOUR, DAY, MONTH, QUARTER, YEAR).
- [.Flavor] indicates what data to include (Online or Offline).
<START> is a value (YYYY-MM-DD) from the DATE_TIME table that indicates the beginning of the reporting interval.
<END> is a value (YYYY-MM-DD) from the DATE_TIME table that indicates the end of the reporting interval.

Re-aggregation is possible only if Job_AggregateGIM is already running. As a result, if you attempt to pass re-aggregation job parameters when Job_AggregateGIM is not running, Genesys Info Mart simply starts aggregation, ignoring the job parameters. In this case, you can re-aggregate by issuing the command to run the job, with the re-aggregation parameters, a second time.

Important

A request to re-aggregate data for a specific time range first deletes aggregated data from that time range (to prevent duplicate data from being written to Info Mart). Before you issue a re-aggregation command, make sure that facts for your selected time range exist in the Info Mart database and have not been purged. Otherwise, you could be left with no aggregates at all for that time range.

How do I view ETL status?

To view information about latency for each functional area, click ETL Status.

Latency, which is expressed in the hh:mm:ss format, reflects the time elapsed since the occurrence of the last contact center event for which reporting data has been successfully stored in the Info Mart database. Latency of a few minutes indicates a typical value in a normal operational environment. Immediately after the maintenance job runs, you may notice that latency values are higher than what you usually see for your environment. If there is no activity for a particular data domain over a number of ETL cycles, the latency indicated for that type of data will noticeably increase.

Genesys Info Mart Manager displays the latency for the following functional areas, but only if they are configured on the Genesys Info Mart Server: Extract, Voice Transform, Multimedia Transform, Outbound Contact Transform, Callback Transform, Media Neutral SM Transform, Elasticsearch, and Aggregation.

In Genesys Info Mart Manager 8.5.004 and earlier, the data displayed represents the status of jobs in the most recent cycle. To display the most recent data at any time, click Refresh List.

Sort Order

To sort the data in the list view, click the column headings. For example, to sort by latency, click the Latency column heading. Click again to sort in reverse order.

How do I see the Help in another language?

You can select the language used by the Genesys Info Mart Manager GUI. Select the language in the Preferences menu (click your user name in the menu bar, and choose System Preferences > Locale or User Preferences > Locale). If the language you want is not listed, see Installing Language Packs for information about how to install localization toolkits for the Genesys Info Mart Manager GUI.
Genesys Info Mart Manager uses the time zone setting, date format, and number format that you select in Genesys Administrator Extension preferences.

Important

Localizing the GUI does not translate job names or job statuses; they appear in English on the Genesys Info Mart Manager interface and Help.

What do error messages mean?

Genesys Info Mart Manager displays an error if it cannot connect to Genesys Info Mart, or if there is a serious problem with Genesys Info Mart.

Error messages persist, even if the condition that caused them is corrected, until manually closed. To close an error message, click x to the right of the message.

The following table lists Genesys Info Mart Manager Error messages, and how to resolve them.

Genesys Info Mart Manager Error Messages

Error	Resolution
`Request has failed with status: <error status text>`	Ensure that the installed release of Genesys Info Mart is compatible with the installed release of Genesys Info Mart Manager.
`Connection to <Genesys Info Mart server name> could not be established. Reason - <error reason text>`	Ensure that the Info Mart server is running, and check for network problems.
`GIM Server error: <error text>`	Genesys Info Mart encountered an error while executing a request from Genesys Info Mart Manager. Ensure that the installed release of Genesys Info Mart is compatible with the installed release of Genesys Info Mart Manager.
`InfoMart database schema version is out-of-date. Consider running Job_MigrateGIM. Error ID: 55-20152`	The Info Mart database schema version is out-of-date; run Job_MigrateGIM. For more information, see the IDB Schema Compatibility section in the Genesys Info Mart Deployment Guide.
`Exclusive access to InfoMart database could not be acquired. Error ID: 55-20154`	The specified Genesys Info Mart Server cannot acquire a master lock on the Info Mart database. See the Standby and Disaster Recovery section in the Genesys Info Mart Operations Guide.

Contents

GIM Manager Help

How do I view job history?