IV33856: APPLYING SPATIAL 7.5.0.1 FIXPACK FAILS IN CLASS V7501_07.

APAR status

• Closed as program error.

Error description

• Spatial script V7501_07 generated SQL insert statement of the
  form Insert Into <table>(<table>.<column>, ....
  
  So far so good.  Statements is passed to method
  AutoUpgradeTemplate.executeSql(), which changes the insert
  statement to Insert Into zx<table>(<table>.<column>
  
  This is invalid syntax.  No such column <table>.<column> within
  table zx<table>.
  

Local fix

• None.  Modified V7501_07.class provided by Spatial development
  team.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Maximo Spatial Asset Management 7.5.0.1 users.           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Spatial 7.5.0.1 installation may fail while migrating assets *
  * and locations service address information into new Maximo    *
  * 7.5.0.3 Service Address structure, if any required address   *
  * information in Maximo is missing in Spatial.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install latest Spatial 7.5.0.1 interim fix.                  *
  ****************************************************************
  The database operations to insert Maximo service addresses from
  assets and locations addresses wasn't supported by Maximo
  installation framework, when it tried to set the default values
  into missing fields.
  

Problem conclusion

• The database insert statement was rewritten to match Maximo
  expectations, resolving the problem.
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO SPATIAL

• Fixed component ID

  5724T3900

Applicable component levels

• R750 PSY

     UP