APAR status
Closed as program error.
Error description
When trying to add a condition (SQL QUERY) into a condition node in a workflow we got the error ?BMXAA4049E ? La valeur pécifiée :CLASSIFICATIONID IN ? dépasse la longueur maximale du champ. ? see the screenshot attached to this PMR. When we looked at the field which is concerned ( by clicking Alt+F1), we found that the field Expression in the condition node is equivalent to the attribute SHOWWFCONDITION.USERSQL which length is 4000, and the length of the sql statement we put in the field is much less than 3000 character  !! Here is the statement we tried to put in the field   :CLASSIFICATIONID IN ('COMMUNICATION','BCI','OT','DÉCOMPTES','ACHAT','STOCK','INTERFA CE','AUT RES','TC','REMORQUES','CONVENTIONNEL','ENCAISSEMENT','INTERFACE' ,'ESCALE S','IMPORT TC','EXPORT TC','IMPORT REMORQUES','EXPORT REMORQUES','IMPORT CONVENTIONNEL','EXPORT CONVENTIONNEL','GL','AP','AR','FA','TVA','E-CASH','E-MATCHER','P A','GA', 'RHS','CTCS','SPACE','SIGNAL','SHIPS','EPORTAL','APPLICATION','P C','IMPR IMANTE','SCANNER','WORD','EXCEL','POWER POINT','ACCESS','VISIO','PROJECT','ANTIVIRUS','ACROBAT','MOUVEME NTS','FA CTURE ANP','NETIX SERVER','TRADUCTION','NETIX CLIENT','BDD','PROGRAMME','LENTEUR LIGNE','PANNE LIGNE','PROBLEME DE ROUTAGE','PROBLEME ROUTEUR','JUNIPER','FAX','TELEPHONIE','LAN','PESAGE','ESCALE_GES TION','O UTLOOK','NAVIGATION','PROFIL_PROBLEME','CAMÉRA','CONNEXION','ATT ACHEMENT ','HYDROCARBURES','PRESTATIONS DIVERSES','DROITS DE PORT','ANNULATION','PARAMÉTRAGES','DÉPOTAGE TC','TRANSBORDEMENT','ETATS','RDT','VMT','DGPS','CONTRÔLEUR DE COMMUNICATION','TALLYSHEET','AUTRES','MESSAGERIE WEB','NAVIGATION','TERMINAL','BLACK BERRY','VP','OUTLOOK','WINDOWS','MANIFESTE','DONNÉES NAVIRE','SYNCHRONISATION BACKUP','BSAFE','IMPRIMANTES','POSTE','CÂBLAGE','PROBLÈME DE PHOTOCOPIEUR','AUTOCOM','POSTE TÉLÉPHONE','CÂBLAGES','VHF','UHF','TETRA','CAMÉRA','CONNEXION',' RADIO',' INDICATEURS','LOGICIEL','CODEC','PORTAIL INTRANET','MAJ DES RUBRIQUES','ACCÈS NAFIDATY','ACCÈS','CA','STOCKS','RENDEMENT','TC CHARGE ET DÉCHARGE','SÉJOUR TC','LAN ELÉMENTS ACTIFS','LAN ELÉMENTS PASSIFS','DNS','DHCP','GPO','RÉPLICATION','OS','SERVEUR EXCHANGE','FRONTAL','RELAI MAIL','FILTRAGE URL','FILTRAGE ANTI VIRAL','FIREWALL','PROXY','CONSOLE','MAJ','GPO AV','SYNCHRONISATION','SITE WEB','TPM','HELPDESK','AUTHENTIFICATION_CONNEXION','DROIT_ACCÈS' ,'POINT_ ACCÈS','PROBLÈME DE CONNEXION AU SIG','PROBLÈME DU LOGICIEL SIG','PROBLÈME DE CONNEXION','PROBLÈME DE GÉNÉRATION DE TB','PROBLÈME CTRLGEST COMMERCIAL','PROBLÈME CTRLGEST FINANCIER','PROBLÈME CTRLGEST RH','PROBLÈME CTRLGEST EXPLOITATION', 'PROBLÈME CTRLGEST EXPLOITATION') Then client went to the Database Config application and try to increase the attribute SHOWWFCONDITION.USERSQL from 4000 to 32000 ALN but still the same problem. client environment is the following: TAMIT 7.1 AND TSRM 7.1 7.1.1.4-TIV-MBS-FP0004 DB2 UDB 9.1.400.359 Websphere 6.1.0.23 Windows 2003 Enterprise edition SP2 64 bits =============================================================== STEP BY STEP by L2 Support used to replicate this behaviour on BS 7116. Reproduced on BS 7114 - 7115 - 7116 ---------------------------------------------------------------- 1. Go to the Database Config application and try to increase the attribute SHOWWFCONDITION.USERSQL from 4000 to 32000 ALN. 2.Configure the changes with Admin Mode 3. Open workflow designer and bring up a workflow with a condition node i.e INC process 5. Try adding the following condition (SQL QUERY) into a condition node: HASSLA, you get the following error message although SHOWWFCOND.USERSQL have been increased. ERROR: BMXAA4049E - The value specified :SLARECORDS.SLANUM IN ... exceeds the maximum field length. A full step by step with screenshots is attached to IssueDB. ---------------------------------------------------------------- ANALYSIS FROM L2 SUPPORT I have looked into this and i initially thought when the client explained the problem, when making changes to SHOWCONDITION.USERSQL, Maximo hasn't made the changes in other maxobject to make this work because USERSQL is SAMEASOBJECT as EXPBUILDER, so i checked in the backend by running select * from maxattribute where sameasobject = 'EXPBUILDER' and sameasattribute = 'USERSQL'; then i found out the attributename = USERSQL belongs to SHOWWFCONDITION - SHOWWFACTION - WFEXPBUILDER - WFASSIGNMENT AND OF COURSE EXPBUILDER , and i checked into DB and in front-end , for all of them length are changed to 32000, so note sure why it is failing. Looked inot CAST , found nothing relevant to SHOWCON DITION.USERSQL, found in IssueDB so many similar error messages but not relevant here.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: all * **************************************************************** * PROBLEM DESCRIPTION: When trying to add a condition (SQL * * QUERY) into a condition * * * * node in a * * * * workflow we got the error ?BMXAA4049E ? * * La valeur p cifi e * * * * :CLASSIFICATIONID IN ? d passe la * * longueur maximale du champ. ? * * * * see the * * * * screenshot attached to this PMR. * * * * When we looked at the field which is * * concerned ( by clicking * * * * Alt+F1), we * * * * found that the field Expression in the * * condition node is * * * * equivalent to * * * * the attribute SHOWWFCONDITION.USERSQL * * which length is 4000, and * * * * the * * * * length of the sql statement we put in * * the field is much less * * * * than 3000 * * * * character !! * * * * Here is the statement we tried to put * * in the field * * * * :CLASSIFICATIONID * * * * IN * * * * ('COMMUNICATION','BCI','OT','D * * COMPTES','ACHAT','STOCK','INTERFA * * * * CE','AUT * * * * RES','TC','REMORQUES','CONVENTIONNEL',' * * ENCAISSEMENT','INTERFACE' * * * * ,'ESCALE * * * * S','IMPORT TC','EXPORT TC','IMPORT * * REMORQUES','EXPORT * * * * REMORQUES','IMPORT * * * * CONVENTIONNEL','EXPORT * * * * CONVENTIONNEL','GL','AP','AR','FA','TVA * * ','E-CASH','E-MATCHER','P * * * * A','GA', * * * * 'RHS','CTCS','SPACE','SIGNAL','SHIPS',' * * EPORTAL','APPLICATION','P * * * * C','IMPR * * * * IMANTE','SCANNER','WORD','EXCEL','POWER * * * * POINT','ACCESS','VISIO','PROJECT','ANTI * * VIRUS','ACROBAT','MOUVEME * * * * NTS','FA * * * * CTURE ANP','NETIX * * SERVER','TRADUCTION','NETIX * * * * CLIENT','BDD','PROGRAMME','LENTEUR * * LIGNE','PANNE * * * * LIGNE','PROBLEME DE * * * * ROUTAGE','PROBLEME * * * * ROUTEUR','JUNIPER','FAX','TELEPHONIE',' * * LAN','PESAGE','ESCALE_GES * * * * TION','O * * * * UTLOOK','NAVIGATION','PROFIL_PROBLEME', * * 'CAM RA','CONNEXION','ATT * * * * ACHEMENT * * * * ','HYDROCARBURES','PRESTATIONS * * DIVERSES','DROITS DE * * * * PORT','ANNULATION','PARAM TRAGES','D * * POTAGE * * * * TC','TRANSBORDEMENT','ETATS','RDT','VMT * * ','DGPS','CONTR LEUR DE * * * * COMMUNICATION','TALLYSHEET','AUTRES','M * * ESSAGERIE * * * * WEB','NAVIGATION','TERMINAL','BLACK * * * * BERRY','VP','OUTLOOK','WINDOWS','MANIFE * * STE','DONN ES * * * * NAVIRE','SYNCHRONISATION * * * * BACKUP','BSAFE','IMPRIMANTES','POSTE',' * * C BLAGE','PROBL ME DE * * * * PHOTOCOPIEUR','AUTOCOM','POSTE * * * * T L PHONE','C * * BLAGES','VHF','UHF','TETRA','CAM * * RA','CONNEXION',' * * * * RADIO',' * * * * INDICATEURS','LOGICIEL','CODEC','PORTAI * * L INTRANET','MAJ DES * * * * RUBRIQUES','ACC S * * * * NAFIDATY','ACC * * S','CA','STOCKS','RENDEMENT','TC CHARGE * * * * ET D CHARGE','S JOUR TC','LAN EL MENTS * * ACTIFS','LAN EL MENTS * * * * PASSIFS','DNS','DHCP','GPO','R * * PLICATION','OS','SERVEUR * * * * EXCHANGE','FRONTAL','RELAI * * MAIL','FILTRAGE URL','FILTRAGE ANTI * * * * VIRAL','FIREWALL','PROXY','CONSOLE','MA * * J','GPO * * * * AV','SYNCHRONISATION','SITE * * * * WEB','TPM','HELPDESK','AUTHENTIFICATION * * _CONNEXION','DROIT_ACC S' * * * * ,'POINT_ * * * * ACC S','PROBL ME DE CONNEXION AU * * SIG','PROBL ME DU LOGICIEL * * * * SIG','PROBL ME DE CONNEXION','PROBL ME * * DE G N RATION DE * * * * TB','PROBL ME * * * * CTRLGEST COMMERCIAL','PROBL ME CTRLGEST * * FINANCIER','PROBL ME * * * * CTRLGEST * * * * RH','PROBL ME CTRLGEST EXPLOITATION', * * 'PROBL ME CTRLGEST * * * * EXPLOITATION') * * * * Then client went to the Database Config * * * * application and try to increase the * * * * attribute SHOWWFCONDITION.USERSQL from * * 4000 to 32000 ALN but * * * * still the same problem. * * * * client environment is the following: * * * * TAMIT 7.1 AND TSRM 7.1 * * * * 7.1.1.4-TIV-MBS-FP0004 * * * * DB2 UDB 9.1.400.359 * * * * Websphere 6.1.0.23 * * * * Windows 2003 Enterprise edition SP2 64 * * bits * * * * ======================================= * * ======================== * * * * STEP BY STEP by L2 Support used to * * replicate this behaviour on * * * * BS 7116. Reproduced on BS 7114 - 7115 * * - 7116 * * * * --------------------------------------- * * ------------------------- * * * * 1. Go to the Database Config * * application and try to increase * * * * the attribute SHOWWFCONDITION.USERSQL * * from 4000 to 32000 ALN. * * * * 2.Configure the changes with Admin Mode * * * * 3. Open workflow designer and bring up * * a workflow with a * * * * condition node i.e INC process * * * * 5. Try adding the following condition * * (SQL QUERY) into a * * * * condition node: HASSLA, you get the * * following error message * * * * although SHOWWFCOND.USERSQL have been * * increased. * * * * ERROR: * * * * BMXAA4049E - The value specified * * :SLARECORDS.SLANUM * * * * IN ... exceeds the maximum field * * length. * * * * A full step by step with screenshots is * * attached to IssueDB. * * * * --------------------------------------- * * ------------------------- * * * * ANALYSIS FROM L2 SUPPORT * * * * I have looked into this and i initially * * thought when the client * * * * explained the problem, when making * * changes to * * * * SHOWCONDITION.USERSQL, Maximo hasn't * * made the changes in other * * * * maxobject to make this work because * * USERSQL is SAMEASOBJECT as * * * * EXPBUILDER, so i checked in the backend * * by running * * * * select * from maxattribute where * * sameasobject = 'EXPBUILDER' and * * * * sameasattribute = 'USERSQL'; * * * * then i found out the attributename = * * USERSQL belongs to * * * * SHOWWFCONDITION - SHOWWFACTION - * * WFEXPBUILDER - WFASSIGNMENT AND * * * * OF COURSE EXPBUILDER , and i checked * * into DB and in front-end , * * * * for all of them length are changed to * * 32000, so note sure why it * * * * is failing. Looked inot CAST , found * * nothing relevant to SHOWCON * * * * DITION.USERSQL, found in IssueDB so * * many similar error messages * * * * but not relevant here. * * * * LOCAL FIX: * * * * N/A * * * **************************************************************** * RECOMMENDATION: * * * * * * * **************************************************************** BMXAA4049E - THE VALUE SPECIFIED :SLARECORDS.SLANUM IN ... EXCEEDS THE MAXIMUM FIELD LENGTH.
Problem conclusion
A couple fields in objects are not increased in size accordingly to accommodate the large size data. These fields are set to sameas expbuilder.usersql: showwfcondition.condition and wfcondition.condition The fix for this APAR is contained in the following maintenance package: | release\fix pack | REL 7.1.1.8 - BS
Temporary fix
Comments
APAR Information
APAR number
IZ77850
Reported component name
MAXIMO SYS CONF
Reported component ID
5724R46S1
Reported release
711
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-06-21
Closed date
2010-07-06
Last modified date
2010-07-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
MAXIMO SYS CONF
Fixed component ID
5724R46S1
Applicable component levels
R711 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"711","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
06 July 2010