Running the ReportCenter Java Task › Check the Timeframe and Prompt Generator Services

Check the Timeframe and Prompt Generator Services

When the ReportCenter Java Task starts, a timer is set a few minutes after initialization to start the Timeframe and Prompt Generator services.

• The Timeframe service updates the database time frame table with the correct relative day numbers.
• The Prompt Generator service reads your database tables and generates HFS prompt files reflecting the resources in there.

Although you do not need these services until you have collected enough data to report on, verify their successful completion the first time you start the task.

Successful completion indicates that the setup (including database read and update permissions, and directory and file permissions) is correct. If they failed, you have an opportunity to correct these things.

After the task is active a few minutes, review the log.

When the task is initialized and ready for work, the following appears:

********************************
Adaptor initialisation complete.
********************************
Server socket for port nnnn opened

When the Timeframe service runs, the following appears:

Timeframe table update beginning  
Updating 'TODAY': Sday=nnnnn Eday=nnnnn
...
Updating 'ALL MONTHS IN DATABASE': Sday=nnnnn Eday=nnnnn
Timeframe table update finished

When the Prompt Generator service runs, the following appears:

Prompt generator starting   
Generating prompt name1 using SQL: 
...
Generating prompt nameN using SQL:
Prompt generator finished

Investigate any run-time and SQL errors. Most problems at this stage are caused by database setup errors and insufficient database or HFS security. After you correct the errors, stop and restart the task.