HULFT Integrate

On the HULFT Integrate page, you can check event logs (execution logs) of scripts that perform data integration.

You can utilize the event logs for the following purposes:

  • Recording and managing execution history of scripts

  • Improving performance of scripts

  • Investigating the causes of failures

By enabling this function for specific situations, you can record information that can be useful regardless of whether you are in the development or operation phase.

To check the event logs for HULFT Integrate, select > SERVICE EVENTS > HULFT Integrate in the navigation menu.

= Remarks =
  • The user who creates a job becomes the user who executes the job (script).

  • For the names and functions of basic UI elements and other items of HULFT Square, refer to the following topic:

HULFT Integrate

On the HULFT Integrate page, you can check and export the event logs of Data Integration.

(1) Event log list

Event logs are displayed in tabular form.

Selecting copies the execution ID.

The status is indicated as follows:

:

This icon indicates that Data Integration is running.

:

This icon indicates that Data Integration ended successfully.

:

This icon indicates that Data Integration ended in an error.

= Remarks =

The maximum number of logs displayed in the event log list is 10,000. If the number of logs exceeds 10,000, please use a filter to narrow down the results.

(2) Action menu

Select this icon to perform operations for event logs.

Selecting shows the menu of operations below.

Detail

Displays detailed information about the selected event log.

Export

Exports the selected event log in CSV file format.

For details on exported logs, refer to Export from Monitoring.

Cancel script

Stops a script that is running.

This is displayed only when a script is running.

Log type

Event logs can be broadly categorized into two types: logs that you check on the Monitoring page and logs that are output as audit logs.

In addition, the Monitoring page provides three forms of output: event log list, details screen, and exported CSV file.

Which fields you can check varies depending on the form of output. If you want to check all the fields, export the logs from Monitoring.

Some fields have a different name in each form of output. For details on names, refer to the mapping table below.

(A)Export from Monitoring

(B)

No.

(C)

No.

(D)

No.

 

(B)Audit log

 

(C)Event log list

 

(D)Event log details screen

No.

Field name

 

No.

Field name

 

No.

Field name

 

No.

Field name

1

sequenceNumber

2

 

 

 

1

Date

 

1

Exec ID

 

1

Date

2

execId

 

1

 

 

2

Sequence No

 

2

Status

 

2

Log level

3

time

1

 

1

 

3

Log level

 

3

Project

 

3

Log type

4

logType

4

 

3

 

4

Log type

 

4

Version

 

4

Event type

5

eventType

5

 

4

 

5

Event type

 

5

Script

 

5

Operation name

6

resultStatus

9

2

7

 

6

Operation module

 

6

Profile

 

6

Message

7

operationId

 

 

 

 

7

Operation type

 

7

Service

 

7

Result status

8

operationModule

6

 

 

 

8

Operation name

 

8

Executed by

 

 

 

9

operationType

7

 

 

 

9

Result status

 

 

 

 

 

 

10

operationName

8

 

5

 

10

Project name

 

 

 

 

 

 

11

messageLevel

3

 

2

 

11

Project version

 

 

 

 

 

 

12

messageText

16

 

6

 

12

Script name

 

 

 

 

 

 

13

messageErrorCode

17

 

 

 

13

Executed by

 

 

 

 

 

 

14

messageErrorType

18

 

 

 

14

Profile name

 

 

 

 

 

 

15

messageErrorDetail

19

 

 

 

15

Integrate service name

 

 

 

 

 

 

16

projectId

 

 

 

 

16

Message

 

 

 

 

 

 

17

projectVersion

11

4

 

 

17

Error code

 

 

 

 

 

 

18

projectName

10

3

 

 

18

Error type

 

 

 

 

 

 

19

scriptId

 

 

 

 

19

Error detail

 

 

 

 

 

 

20

scriptVersion

 

 

 

 

 

 

 

 

 

 

 

 

21

scriptName

12

5

 

 

 

 

 

 

 

 

 

 

22

userId

 

 

 

 

 

 

 

 

 

 

 

 

23

userAccountId

 

 

 

 

 

 

 

 

 

 

 

 

24

executedBy

13

8

 

 

 

 

 

 

 

 

 

 

25

profileId

 

 

 

 

 

 

 

 

 

 

 

 

26

profileName

14

6

 

 

 

 

 

 

 

 

 

 

27

instanceId

 

 

 

 

 

 

 

 

 

 

 

 

28

instanceName

15

7

 

 

 

 

 

 

 

 

 

 

29

instancePodName

 

 

 

 

 

 

 

 

 

 

 

 

 

The fields that are displayed on each page are described below.

ClosedExport from Monitoring

On the HULFT Integrate page, when you select Export from the action menu in the event logs, a CSV file is output.

Field name

Description

sequenceNumber

The sequence number for each event is displayed.

execId

The execution ID is displayed.

time

The date and time when an event occurred is displayed.

Note

Unix time is used for the date and time.

logType

The log type is displayed.

execution

This represents events for script execution.

script

This represents events for scripts. These events occur in parent scripts and child scripts.

operation

This represents events for operations by connectors.

eventType

The event type is displayed.

start

This represents the start of the event.

processing

This represents that the event is being processed.

end

This represents the end of the event.

resultStatus

The status of operation results is displayed.

operationId

The operation ID, including operations by connectors, is displayed.

operationModule

The name of the executed component is displayed.

operationType

The type of executed operation is displayed.

operationName

The user-defined operation name is displayed.

messageLevel

The log level is displayed.

For details, refer to Log levels.

messageText

The log message is displayed.

messageErrorCode

An error code is displayed when a script fails.

messageErrorType

The error type is displayed when a script fails.

messageErrorDetail

Error details are displayed when a script fails.

projectId

The ID of the project to which the script belongs is displayed.

projectVersion

The version of the project to which the script belongs is displayed.

projectName

The name of the project to which the script belongs is displayed.

scriptId

The script ID is displayed.

scriptVersion

The script version is displayed.

scriptName

The script name is displayed.

userId

The user ID of the user who executes the script is displayed.

userAccountId

The ID of the account to which the user who executes the script belongs is displayed.

executedBy

The name of the user who executes the script is displayed.

profileId

The ID of the profile with which the script is executed is displayed.

profileName

The name of the profile with which the script is executed is displayed.

instanceId

The instance ID of the HULFT Integrate service is displayed.

instanceName

The instance name of the HULFT Integrate service is displayed.

instancePodName

The instance Pod name of the HULFT Integrate service is displayed.

ClosedAudit log

If Audit Log is set to On, logs are automatically stored in the workspace specified for Workspace to save to.

For details about output of audit logs, refer to Audit Log.

Field name

Description

Date

The date and time when an event occurred is displayed.

Note

Unix time is used for the date and time.

Sequence No

The sequence number for each event is displayed.

Log level

The log level is displayed.

For details, refer to Log levels.

Log type

The log type is displayed.

execution

This represents events for script execution.

script

This represents events for scripts. These events occur in parent scripts and child scripts.

operation

This represents events for operations by connectors.

Event type

start

This represents the start of the event.

processing

This represents that the event is being processed.

end

This represents the end of the event.

Operation module

The name of the executed component is displayed.

Operation type

The type of executed operation is displayed.

Operation name

The user-defined operation name is displayed.

Result status

The status of operation results is displayed.

Project name

The name of the project to which the script belongs is displayed.

Project version

The version of the project to which the script belongs is displayed.

Script name

The script name is displayed.

Executed by

The name of the user who executes the script is displayed.

profileId

The ID of the profile with which the script is executed is displayed.

Profile name

The name of the profile with which the script is executed is displayed.

Integrate service name

The instance name of the HULFT Integrate service is displayed.

Message

The log message is displayed.

Error code

An error code is displayed when a script fails.

Error type

The error type is displayed when a script fails.

Error detail

Error details are displayed when a script fails.

ClosedEvent log list

When you open the HULFT Integrate page, event logs are displayed as a list.

Field name

Description

Exec ID

The execution ID is displayed.

Status

The status of operation results is displayed.

Project

The name of the project to which the script belongs is displayed.

Version

The version of the project to which the script belongs is displayed.

Script

The script name is displayed.

Profile

The name of the profile with which the script is executed is displayed.

Service

The instance name of the HULFT Integrate service is displayed.

Executed by

The name of the user who executes the script is displayed.

ClosedEvent log details screen

On the HULFT Integrate page, select Detail from the action menu in the event log to display the details about the event log.

Field name

Description

Date

The date and time when an event occurred is displayed.

Note

Unix time is used for the date and time.

Log level

The log level is displayed.

For details, refer to Log levels.

Log type

The log type is displayed.

execution

This represents events for script execution.

script

This represents events for scripts. These events occur in parent scripts and child scripts.

operation

This represents events for operations by connectors.

Event type

The event type is displayed.

start

This represents the start of the event.

processing

This represents that the event is being processed.

end

This represents the end of the event.

Operation name

The user-defined operation name is displayed.

Message

The log message is displayed.

Result status

The status of operation results is displayed.