Skip to Content

Logging and error functions in Jitterbit Integration Studio

Logging and error functions can and should be used to provide appropriate reactions to script actions.

GetLastError

Declaration

string GetLastError()

Syntax

GetLastError()

Description

Returns the last error reported in a script or transformation. It can be used with the ResetError and Eval functions for error handling.

Note that the GetLastError function does not carry the error message over into another operation. To do that, Jitterbit variables are available that contain that information for use between operations:

  • $jitterbit.operation.error
  • $jitterbit.operation.previous.error
  • $jitterbit.operation.last_error

See also the RaiseError function.

Examples

// Discard previous errors
ResetLastError();
error = "";

// On failure, put the last error into a variable
Eval(orderType = DBLookup("<TAG>endpoint:database/My Database</TAG>",
  "SELECT ORDER_TYPE FROM PO_HEADER WHERE PO_NUMBER = " + PO_NUM),
  error = GetLastError());

// If an error, raise it with the error in the message
If(Length(error) > 0,
  RaiseError("Failed to lookup Order Type: "
    + error), orderType);

RaiseError

Declaration

void RaiseError(string message)

Syntax

RaiseError(<message>)

Required parameters

  • message: A string message

Description

Causes a script or transformation to fail, and the contents of the parameter message to be displayed in the error log.

The entire text written to the error log will be:

Fatal Error <message> This error was raised by a call to the RaiseError function.

Warning

The RaiseError function should be used as a last-resort, as it raises a fatal error. If a script raises it, there is no control by the calling program on what is produced to the client. Jitterbit does not have a "raise-and-capture" exception mechanism, and raising this error will result in a Server Error with a Status of 500. Instead, programs should test for inputs and outputs and handle conditions defensively.

Examples

message = "The source field "
  + "'Price' has an invalid value. Exiting.";
RaiseError(message);

ResetLastError

Declaration

void ResetLastError()

Syntax

ResetLastError()

Description

Sets the last error to an empty string. This is identical to calling SetLastError(""). See also the function SetLastError.

Examples

// Reset the last error
ResetLastError();

SetLastError

Declaration

void SetLastError(string message)

Syntax

SetLastError(<message>)

Required parameters

  • errorMessage: A string message

Description

Sets a user-defined last error. The message will be logged as a warning and the GetLastError function will return the message unless another error occurs. See also the function ResetLastError, which performs the same action of setting the last error but without logging a message.

Examples

// Sets the last error to a message
message = "Invalid value: source field 'Price'";
SetLastError(message);

WriteToOperationLog

Declaration

string WriteToOperationLog(string message)

Syntax

WriteToOperationLog(<message>)

Required parameters

  • message: A string message

Description

Writes a message to the operation log.

Examples

// Write a message to the Operation Log
WriteToOperationLog("The source field 'Price' has an invalid value.");