ORA-20105: Assert.IS_LOGICAL_UNIT: " " is non existing logical unit.
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
Page 1 / 1
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.
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.
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.
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.
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