IJ45154: ERRO BMXAA6992E WHEN LOADING FLAT FILE WITH NO DATA

APAR status

• Closed as program error.

Error description

• When loading flat file wiht NO data , just header and
  attributtes customer is reporting an issue
  Customer is TPAE 7.6.1.2-IFIX20220216-1819
  Stepps
  
  Navigate to MXPERSON object structure, make sure is enabled for
  flat file processing. Export one record and delete a data from
  it , leave just a header information suche external system, and
  attributs
  
  and try to process inbound  in preview move , you would see
  error an in a log
  
  19 Jan 2023 12:51:08:622 [DEBUG] [MXServer] [CID-UIASYNC-36140]
  FlatFileLoaderImpl.java: Initial lstOneRecord is null. No more
  data. Commit() & Close().
  19 Jan 2023 12:51:08:622 [INFO] [MXServer] [CID-UIASYNC-36140]
  BMXAA6719I - USER = (MAXADMIN) SPID = (177) app (null) object
  (MAXUSER) : select * from maxuser  where userid =  'MXINTADM'
  and status in (select value from synonymdomain where domainid =
  'MAXUSERSTATUS' and maxvalue = 'ACTIVE') OPTION (FAST 1000)
  
  19 Jan 2023 12:51:08:622 [INFO] [MXServer] [CID-UIASYNC-36140]
  BMXAA6719I - USER = (MAXADMIN) SPID = (153) app (null) object
  (PERSON) : select * from person  where personid =  'MXINTADM'
  OPTION (FAST 1000)
  
  19 Jan 2023 12:51:08:622 [INFO] [MXServer] [CID-UIASYNC-36140]
  BMXAA6719I - USER = (MAXADMIN) SPID = (68) app (null) object
  (EMAIL) : select * from email  where personid= 'MXINTADM'  and
  isprimary=1 OPTION (FAST 1000)
  
  19 Jan 2023 12:51:08:637 [INFO] [MXServer] [CID-UIASYNC-36140]
  BMXAA6719I - USER = (MAXADMIN) SPID = (172) app (null) object
  (PHONE) : select * from phone  where personid= 'MXINTADM'  and
  isprimary=1 OPTION (FAST 1000)
  
  19 Jan 2023 12:51:08:637 [DEBUG] [MXServer] [CID-UIASYNC-36140]
  FileLoaderProcess.java commit(): isFileExtract is TRUE.
  19 Jan 2023 12:51:08:637 [DEBUG] [MXServer] [CID-UIASYNC-36140]
  FileLoaderProcess.java commit(): isFileExtract is TRUE.
  19 Jan 2023 12:51:08:637 [DEBUG] [MXServer] [CID-UIASYNC-36140]
  FileLoaderProcess.java commit(): fromClient is TRUE.
  19 Jan 2023 12:51:08:637 [DEBUG] [MXServer] [CID-UIASYNC-36140]
  FileLoaderProcess.java commit(): calling createDBExtractEntry().
  
  19 Jan 2023 12:51:08:637 [INFO] [MXServer] [CID-UIASYNC-36140]
  BMXAA1470E - A transaction cannot be committed to the Java
  Message Service (JMS) queue. Ensure that the JMS services on the
  application server are operational.  Refer to the the error and
  server log files for more information.
  	The statement is closed.
  psdi.util.MXApplicationException: BMXAA1470E - A transaction
  cannot be committed to the Java Message Service (JMS) queue.
  Ensure that the JMS services on the application server are
  operational.  Refer to the the error and server log files for
  more information.
  	The statement is closed.
  	at psdi.iface.load.FileLoaderProcess.commit(FileLoaderProcess.
  java:530)[businessobjects.jar:?]
  	at psdi.iface.load.FlatFileLoaderImpl.processFlatData(FlatFile
  LoaderImpl.java:185)[businessobjects.jar:?]
  	at psdi.iface.app.extsystem.MaxExtIfaceIn.importData(MaxExtIfa
  ceIn.java:321)[businessobjects.jar:?]
  	at psdi.webclient.beans.extsystem.LoadBean.loadImport(LoadBean
  .java:175)[classes/:?]
  	at psdi.webclient.beans.extsystem.LoadBean.importdata(LoadBean
  .java:108)[classes/:?]
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  ~[?:1.8.0]
  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
  essorImpl.java:90)~[?:1.8.0]
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
  ethodAccessorImpl.java:55)~[?:1.8.0]
  	at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]
  	at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess
  .java:172)[classes/:?]
  	at java.lang.Thread.run(Thread.java:825) [?:2.9 (08-17-2022)]
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
  statement is closed.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ERROR BMXAA6992E WHEN LOADING FLAT FILE WITH NO DATA         *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.7 Product
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels