Solved

Not possible to add new shop floor employee

  • 27 June 2023
  • 1 reply
  • 78 views
M
Rank
Userlevel 2
Badge +7

Hi!

I´m getting following error when trying to add new shop floor employee. Person is created and added without any problem under Company/Employee already as normally but when trying to add Shop floor employee following error comes:

 

icon

Best answer by mingram 3 July 2023, 09:37

View original

1 reply

M
Rank
Userlevel 2
Badge +7

Problem sorted, this problem was part of the wider oracle problem that gave in some views Message 20 000 errors (Inventory part in stock, Shop order). 

 

Oracle Database cannot properly display the error message.

SQL> select * from duul;

select * from duul

*

ERROR at line 1:

ORA-00942: Message 942 not found; No message file for product=RDBMS, facility=ORA

 

CAUSE

The Oracle Database gets the error messages from the following files:

 

$ORACLE_HOME/rdbms/mesg/oraus.msg

$ORACLE_HOME/rdbms/mesg/oraus.msb

  

If any of them is corrupted, the proper error message cannot be retrieved.

 

SOLUTION

Such files can be copied from another working DB installation (provided the same exact version and patching level) and pasted in the concerning Oracle Home while the DB was up and running. There is no need for relinking or downtime.

After such a fix, the error message is properly raised as follows:

 

SQL> select * from duul;

select * from duul

*

ERROR at line 1:

ORA-00942: table or view does not exist

 

Reply


Terms & ConditionsCookie settings