IJ48712: MISSING GENINSERTDBC.SH FILE

APAR status

• Closed as program error.

Error description

• PROBLEM:
  
  geninsertdbc.sh script is missing in MAS Manage and Maximo 76x
  
  STEPS TO REPRODUCE:
  N/A
  
  CURRENT ERRONEOUS RESULT:
  
  Missing script
  
  EXPECTED RESULT:
  Expect to see geninsertdbc.sh script
  
  
  From Dev Team:
  ---
  I was able to test my sh script port in a docker container.  Go
  ahead and take an APAR for this.
  
  
  
  # pwd
  
  /opt/workspace/maximo/tools/maximo/internal
  
  # ./geninsertdbc.sh
  
  Usage : -t<table name> -w<where clause> -f<script file name>
  -c<input directory name> -h<help>
  
  
  # ./geninsertdbc.sh -tPO -fPeteTest -cscript
  
  param 0 is -tPO
  
  param 1 is -fPeteTest
  
  param 2 is -cscript
  
  Log file: GenInsertDbc_PeteTest.log
  
  outputDir: script
  
  outputFile: PeteTest
  
  tableName: PO
  
  createBulk: false
  
  fetching information about the table
  
  root: /opt/workspace/maximo/tools/maximo
  
  output file:
  /opt/workspace/maximo/tools/maximo/en/script/PeteTest.dbc
  
  Full path for output file:
  /opt/workspace/maximo/tools/maximo/en/script/PeteTest.dbc
  
  # cat /opt/workspace/maximo/tools/maximo/en/script/PeteTest.dbc
  
  <?xml version="1.0" encoding="UTF-8"?>
  
  <!DOCTYPE script SYSTEM "script.dtd">
  
  
  <script author="GenInsertDbc app" scriptname="Inserts into PO">
  
  *snip*
  

Local fix

• --- if the customer wants to do this now copy and paste the
  statements below into a file titled geninsertdbc.sh under
  tools/maximo/internal and run chmod +x on the file..
  
  ---------------------------------------------------------------
  ----------cut below this line ----------------------------------
  
  #!/bin/sh
  
  
  
  # -t (table) Name of the table used to query data to create the
  insert statement dbc.
  
  #           This table is also used as a target one for the
  insert statement.
  
  # -w (where clause) Where clause used to query data to create
  the insert statement dbc.
  
  #                         Contents of the where clause must be
  inside double quotes. This is not a
  
  #           required argument.
  
  # -f (script filename)  Name of the insert statement dbc file
  without the extension.
  
  # -c (infile dir)         Subdirectory for input file, with
  assumed root being the location of
  
  #                         this bat file (tools/maximo).  For
  example, if the input file is in
  
  #                         tools/maximo/en/script, this parameter
  would equal script(lower case).
  
  #                         for itsme project this parameter is
  itsme.So script file will be in
  
  #                         tools/maximo/en/itsme.
  
  #                         If not specified, then the input
  directory is tools/maximo/en/script.
  
  
  
  # Reset arguments just in case you ran the script earlier.
  
  arg1=""
  
  arg2=""
  
  arg3=""
  
  arg4=""
  
  
  
  # Test up to 20 arguments and store them in $arg1 to $argk
  
  if [ "$*" != "" ]
  
  then  arg1=$1
   shift
  
  fi
  
  
  
  if [ "$*" != "" ]
  
  then  arg2=$1
   shift
  
  fi
  
  
  
  if [ "$*" != "" ]
  
  then  arg3=$1
   shift
  
  fi
  
  
  
  if [ "$*" != "" ]
  
  then  arg4=$1
   shift
  
  fi
  
  
  
  cd ..
  
  
  
  pathToScript=`dirname %0`
  
  . $pathToScript/commonenv.sh
  
  
  
  ../java/jre/bin/java -Xmx5G -classpath
  .:./classes:$MAXIMO_CLASSPATH psdi.tools.GenInsertDbc $arg1
  $arg2 $arg3 $arg4
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users desiring to generate stub insert DBC scripts on *
  * a Unix/Linux system.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The shell script geninsertdbc.sh does not exist.             *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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