IV95707: TYPO IN CLASS FILE PSDI.APP.LABOR.FLDSERVRECTRANSITEMNUM

APAR status

• Closed as program error.

Error description

• Client is getting an error in an import, the error was.
  
  where ((itemnum =: itemnum ) - the space is between the : and
  itemnum
  
  [4/27/17 8:45:39:802 CDT] 000000e2 SystemOut     O 27 Apr 2017
  08:45:39:802 [ERROR] [ctgJVMMIF01] [] BMXAA6714E - The data for
  the next record in the mboset could not be retrieved for the
  SQL query select * from item  where ((itemnum =: itemnum )  and
  ( itemsetid= 'ITEM1'  )) and (rownum<=1000). See the log file
  for more details about the error.
  
  java.sql.SQLException: ORA-01008: not all variables bound
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of inventory                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * extra space in the where clause bind variable                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  	  Release 7.6.0.9 of Base Services
  

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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R760 PSY

     UP