IBM Support

Remedy gateway ARS ERROR 313 Data types are not appropriate for relational operation

Troubleshooting


Problem

We continue to get this error in the Remedy gateway logs: "ARS ERROR 313: Data types are not appropriate for relational operation." What does this error mean?

Symptom

Jan 30 13:09:34 2012:[DEBUG]: Cache lookup via ServerName and ServerSerial (Primary).

Jan 30 13:09:34 2012:[ERROR]: ARS ERROR 313: Data types are not appropriate for relational operation -

Jan 30 13:09:34 2012:[DEBUG]: Failed to find an entry for given cache lookup.

Cause

There is a data type mismatch between the Object Server and Remedy

Resolving The Problem

This appears to be a data type mismatch within Remedy configuration.

The Remedy error guide states:

The data types of the fields used in a relational operation are not consistent with the operations allowed for that operation. See the Form and Application Objects Guide for information about the allowed data types of operations.

This may require Remedy admin expertise to resolve. Ensure that integer fields in the Object Server are mapped to integer fields in Remedy, and varchar fields in the Object Server are mapped to character fields in Remedy. Only if the gateway mapping includes a CONVERT TO directive can the field types differ.

[{"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Remedy ARS Gateway","Platform":[{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF010","label":"HP-UX"},{"code":"PF002","label":"AIX"}],"Version":"7.4.0;7.3.1;7.3.0;8.1.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21579890

Page Feedback