Skip to main content

Hi Community,

 

I have found below installation error below when deploying UPD12.

!!!Error occurred while executing Plsql Block

BEGIN

 Object_Connection_SYS.Refresh_Active_List__(5);

END;

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

 

But I can't find a logical unit called "CounselingPlan".

So do I need to follow any manual steps to fix this?

 

Thanks,

Kalana

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


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

 

 


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. :slight_smile:

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 @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 Shardha, 

Thank you very much for your answer. :slight_smile:  

Best Regards,
Kalana


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

Hi Thilini,

Thanks for the answer. :slight_smile:

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


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

 

 

Hi @durette , 

Thanks for the answer. :relaxed:

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


The issue is, it is existing in all the customer environments as well. So, the same error will be appeared in customer 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.

I’m sending you a PM.


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