ORA-20105: Assert.IS_LOGICAL_UNIT: " " is non existing logical unit.

Hi Kalana,

I just had a quick look in CORE database and there’s a LU named ‘CounselingPlan’  in module ‘TRNDEV’.

Any scripts which gave that error ?
 

Best Regards,

Prabhavi.

Hi @Kalana Rathnayake,

Please check whether the same error occurred with other UPD12 installations as well. Many be with Evergreen team SE’s who handle UPD12 installations?

/Shardha

Hi Kalana,

There should be some script which is referring this non existing LU.

Check the error log and identify the script which is causing this error.

Cheers,

Thilini

Prabhavi Wijayaweera wrote:

Hi Kalana,

 

I just had a quick look in CORE database and there’s a LU named ‘CounselingPlan’  in module ‘TRNDEV’.

 

 

Any scripts which gave that error ?
 

Best Regards,

Prabhavi.

Hi Prabhavi,

Thanks for the answer. 

but in this case TRNDEV module version is set to Null. That means, all modules that are not upgrade will have their version set to Null. Then there are no impact from this module. 
 

Best Regards,
Kalana​​​​​​​

Hi Shardha, 

Thank you very much for your answer.   

Best Regards,
Kalana

Hi Thilini,

Thanks for the answer. 

I couldn’t find any script in _ERROR_install.log related to this. 
But there is a file ‘CompanyPersAssign’ in Person module which is referring this 'CounselingPlan'.This was in previous UPD11 as well.but there was no issue.

Best Regards,
Kalana

durette wrote:

Do you need this object connection? If not, does this error go away if you remove it?

 

 

Hi @durette , 

Thanks for the answer. 

We try this in our internal DEV and BNT environments. 
In Both environments installation was successfully completed after delete this CounselingPlan Object_Connection.

Best Regards,
Kalana 

Hi Kalana,

During a recent UPD12 installation, I received same type of an error. !!!Error deploying file install.tem at 24-SEP-21 12:39:14
!!!Error occurred while executing Plsql Block
BEGIN
 Object_Connection_SYS.Refresh_Active_List__(5);
END;
ORA-20105: Assert.IS_LOGICAL_UNIT: "DocumentContainer" is non existing logical unit.
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 341
ORA-06512: at "IFSAPP.ASSERT_SYS", line 844
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 146
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1947
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1947
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1621
ORA-06512: at line 2

When checked it in object connections window, this is how it looked,

 

The issue is, it is existing in all the customer internal environments as well. So, the same error will be appeared in customer internal environments as well. Also, I didn’t notice a script or anything that had added this. Also this doesn’t exist in R&D environments as well.

What I’m going to do is, check the requirement of this LU, and if it doesn’t require, hope we can delete it. So the issue will be not appeared as suggested here

I’m sending you a PM.

Hiroshi Perera wrote:

Hi Kalana,

During a recent UPD12 installation, I received same type of an error. !!!Error deploying file install.tem at 24-SEP-21 12:39:14
!!!Error occurred while executing Plsql Block
BEGIN
 Object_Connection_SYS.Refresh_Active_List__(5);
END;
ORA-20105: Assert.IS_LOGICAL_UNIT: "DocumentContainer" is non existing logical unit.
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 341
ORA-06512: at "IFSAPP.ASSERT_SYS", line 844
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 146
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1947
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1947
ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 1621
ORA-06512: at line 2

 

When checked it in object connections window, this is how it looked,

 

 

The issue is, it is existing in all the customer internal environments as well. So, the same error will be appeared in customer internal environments as well. Also, I didn’t notice a script or anything that had added this. Also this doesn’t exist in R&D environments as well.

What I’m going to do is, check the requirement of this LU, and if it doesn’t require, hope we can delete it. So the issue will be not appeared as suggested here

Hi Hiroshi,

It happened after upgraded to apps10, previous apps (IFS Apps9 etc.) Object Connections records still exist there.

Therefore, we have to remove them manually or run a pre-script before running the installation.

Best Regards,
Kalana

Hi .. Yes Kalana… What I did was sending them a prescript… to remove the unwanted record