HD92215: BY CHECKING EXPRESS-ENGINEERING (SNE), ERROR NO 00005 GENERAL DATABASE ERROR OCCURS

APAR status

• Closed as program error.

Error description

• Dear L1,
  From the attached file, I saw that the problem is Oracle
  error ORA-00942, and more than that sql statement is missing
  the ')'.
  In order to confirm this assumption,
  I will appreciate if customer will provide the following:
  1. Click on SmarTeam Error No: 00005 screen, on the Detail
  button, and send results.
  2. Activate SmarTeam SqlMonitor:
      -       Open system configuration editor
      -       Find key SqlMonitor.Visible
      -       Change its value to be YES
      -       Open and Run SmarTeam DMD
      -       See SqlMonitor running
      Please send me the file with SQL statement: "select
  count(*) from (select 'A' from TN_CAD_FILES where RowNum <=
  1"
  Thanks,
  Miki M
  

Local fix

• empty
  

Problem summary

• Dear L1,
  From the attached file, I saw that the problem is Oracle
  error ORA-00942, and more than that sql statement is missing
  the ')'.
  In order to confirm this assumption,
  I will appreciate if customer will provide the following:
  1. Click on SmarTeam Error No: 00005 screen, on the Detail
  button, and send results.
  2. Activate SmarTeam SqlMonitor:
      -       Open system configuration editor
      -       Find key SqlMonitor.Visible
      -       Change its value to be YES
      -       Open and Run SmarTeam DMD
      -       See SqlMonitor running
      Please send me the file with SQL statement: "select
  count(*) from (select 'A' from TN_CAD_FILES where RowNum <=
  1"
  Thanks,
  Miki M
  

Problem conclusion

• NOTE THAT THIS PROBLEM WILL ALSO BE FIXED ON V5R20 SP1.
  Additional Closure Information:
  N/A
  

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

  SMARTEAM NT>XP

• Fixed component ID

  569199970

Applicable component levels

• R519 PSN

     UP