Informix - Problem description
Problem IT20536 | Status: Closed |
ERROR 32504 'REMOTE OPERATION NOT ALLOWED' WHEN DOING A REMOTE QUERY AFTER ANOTHER SESSION CHANGED INDENTITIES | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Error -32504 could be expected in a session if the user changed identities using the "set session to '%user%'" statement, but there is a possibility that the error would appear in a session, even if it has not executed the "set session" statement. If a separate session has changed identities and has not terminated properly (e.g: close database), the internal flag that indicates an identity change may be left set, which will cause the -32504 error in any session reusing that memory block. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Systems where users use the set session authorization in * * their sql code. When the server re-uses rstcb structures, * * old information might be found which leads to the incorrect * * sql error code. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.05.2017 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |