Informix - Problem description
Problem IT12936 | Status: Closed |
A 4GL WEB SERVICE RETURNING AN ARRAY OF DATETIME VALUES DOESN'T HANDLE NULL PROPERLY AND MAY CRASH | |
product: | |
IBM INFORMIX 4G / 5724C6680 / 750 - Informix 7.50 | |
Problem description: | |
You have defined a 4GL Web Service that returns an array of DATETIME values as in: #test.4cf - Adapt to your setup [SERVICE] TYPE = publisher INFORMIXDIR = /opt/IBM/4gl/7.51.UC1 DATABASE = sysutils CLIENT_LOCALE = en_US.819 DB_LOCALE = en_US.819 INFORMIXSERVER = your_informix_server HOSTNAME = your_axis_hostname PORTNO = your_axis_port I4GLVERSION = 7.51.xC1 WSHOME = /opt/IBM/4gl/7.51.UC1/AXIS2C WSVERSION = 1.5 TMPDIR = /your_working_dir/tmp SERVICENAME = test_dt [FUNCTION] NAME = test_dt_arr [INPUT] [END-INPUT] [OUTPUT] [ARRAY] NAME = dt_arr TYPE = DATETIME YEAR TO SECOND [END-ARRAY] [END-OUTPUT] [END-FUNCTION] [DIRECTORY] NAME = . FILE = test_dt.4gl [END-DIRECTORY] [END-SERVICE] #test_dt.4gl function test_dt_arr() define dt_arr dynamic array of datetime year to second allocate array dt_arr[8] #return some values, mostly NULL INITIALIZE dt_arr[1] TO NULL INITIALIZE dt_arr[2] TO NULL INITIALIZE dt_arr[3] TO NULL LET dt_arr[4] = CURRENT INITIALIZE dt_arr[5] TO NULL INITIALIZE dt_arr[6] TO NULL INITIALIZE dt_arr[7] TO NULL LET dt_arr[8] = CURRENT return dt_arr end function When calling the service,, the reply will be a fault message, either: Server There was an error in the web service -4998 Operation failed while converting data from the SQL format to the XSD format or, in some cases : Server There was an error in the web service -4986 Communication between fgld daemon and application server was closed. which happens if the child fgld servicing the request crashes. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all 7.50.xC6 and 7.51.xC1 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to 7.51.xC2 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.12.2015 29.06.2016 29.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |