cancel
Showing results for 
Search instead for 
Did you mean: 

Table MLICHECK creation auto

former_member325638
Participant
0 Kudos


Hi Experts,

We ahve noticed an issue in one production system that DB13 jobs started getting failed with "SQL error -131 at location Brlicheck, ora 1031  Insufficient privileges". This got resolved with grant select access to SAPERP.MLICHECK as per sap notes found.

But the probelm is RCA on why the issue occured. This is production system; last upgraded 1 year ago and last sapdba_role.sql was last run at that time. In the logs of that run; we can see that the table was not existing at that time. As shown below

"GRANT ALL to SAP.MLICHECK to sapdba

            *

Error at line 1

Ora 00942:table or view does not exist"

Later it was found by database team that table was created on 6th July but they have not created; neither got any request to create. We (basis team) has also not done the same. So; we are not sure how this table got created automatically.

Its production ECC system and the table does not exist in QA as well because it gets refreshed from prod. SAP version is 701(11) and kernel is 721 (400). So this table is not required in our SAP version and license is not longer stored in this.

Could you please help ion understandsing if any other possibilities that the table MLICHECK got created automatically due to some other activity.

As per database team; there has not been any reorg activity using brspace; neither brtools were executed for first time.

Thanks

Varun

Accepted Solutions (0)

Answers (1)

Answers (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

Please have a look at below notes

1604531 - Error messages with missing table MLICHECK

1523316 - Table MLICHECK is reported as missing in database


Meanwhile, let me read the whole story and will come back to you.


Regards,

former_member325638
Participant
0 Kudos

HI Divyanshu

Thanks for sharing the notes. Yes; checked the notes beforer posting the message but as we are on kernel 721 (400) so we have suggested version. Also; we do not notice behaviour mentioned in notes. Also checked few other notes for MLICHECK. But none could confirm if it can get created automatically.

As per one SDN post; it gets created after running brtools for the first time or any reorg using brspace. Not sure if any sucg activities can create table MLICHECK . Or any more possibilities of getting this table crated indirectly and unintentionally

Thanks

Varun

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Varun,

This table is automatically created by transaction SLICENCE or saplicense program, when you install any temp license against by selecting old ones.

To test call saplicense -temp

Regards,