201
Views
20
Comments
Solved
[Discovery] Error in Query CreateModuleDefinitionsForExtensionsOracle
Question
discovery
Web icon
Forge asset by Architecture Team

Good day!

We have a problem with this application.
Just a couple of days ago, the snapshot timer stopped working. ServiceCenter contains error
Manual capture new snapshot leads to a similar problem


????????? ?????????? ????? ?????? 5.1.0.
???????? ??? ?? ??????.

????????? ????????? ??????? ?????? BootstrapFirstSnapshot (https://www.outsystems.com/forums/discussion/60696/still-doesnt-work-with-oracle/)
???????? ????????


As it appears the query returns no records


Need assistance

For additional information:
* Platform version - 11.8.2
* This is the Web
* Oracle Database

2021-04-05 17-12-19
Davide Duarte
Solution

Until the new release is available, the work around is to remove Discovery tool, and then install version 5.0.8

After it is installed and you have successfully run it, update to the latest version.

Sorry for the inconvenience.

UserImage.jpg
Vladimir Zagoruiko

Can anyone help?


Installing the latest version 5.1.0 - didn't help. Problem still exists

Running BootstrapFirstSnapshot timer (https://www.outsystems.com/forums/discussion/60696/still-doesnt-work-with-oracle/) also didn't help

 

UserImage.jpg
adom anim

you have not created a variable called reddit yet which is why the error is thrown. I don't see the variable reddit created anywhere.

Can you tell me what you are trying to do with that line? Where did it come from?

UserImage.jpg
adom anim

adom anim wrote:

you have not created a variable called reddit yet which is why the error is thrown. 

Can you tell me what you are trying to do with that line? Where did it come from?

 I don't see the variable reddit created  192.168.100.1  192.168.1.1 jpg to pdf /anywhere.

UserImage.jpg
Vladimir Zagoruiko

adom anim wrote:

adom anim wrote:

you have not created a variable called reddit yet which is why the error is thrown. 

Can you tell me what you are trying to do with that line? Where did it come from?

 I don't see the variable reddit created  192.168.100.1  192.168.1.1 jpg to pdf /anywhere.

This functioanality is a part of DiscoveryProbe
As I understand it should be inside

 

2021-04-05 17-12-19
Davide Duarte

Hi all,

We are releasing a new version during this weekend, with fixes and corrections.

Keep tuned!

Thank you!

2021-04-05 17-12-19
Davide Duarte

Hi all,

Version 5.1.1 (OutSystems 11) and version 4.1.1 (OutSystems 10) were released today with the expected fixes.

Thank you!

UserImage.jpg
Vladimir Zagoruiko

Davide Duarte wrote:

Hi all,

Version 5.1.1 (OutSystems 11) and version 4.1.1 (OutSystems 10) were released today with the expected fixes.

Thank you!

Thank you
I will check the changes

Unfortunately, last time only a complete reinstallation helped
 

 

2020-06-22 03-41-08
Ruttanachai Auitragool

I still have this problem in version 5.1.1

2021-04-05 17-12-19
Davide Duarte

Ruttanachai Auitragool wrote:

I still have this problem in version 5.1.1

Hi Ruttanachai
What problem are you facing? Can you provide more detail?

Thank you!

Best regards,

Davide

 

2020-06-22 03-41-08
Ruttanachai Auitragool

Davide Duarte wrote:

Ruttanachai Auitragool wrote:

I still have this problem in version 5.1.1

Hi Ruttanachai
What problem are you facing? Can you provide more detail?

Thank you!

Best regards,

Davide

 

 

 I found the error in the DiscoveryProbe Module


UserImage.jpg
Vladimir Zagoruiko

Good day! 


Our problem is back 


The problem is that this request returns empty (

SELECT    E.[Name],   EV.[Description],   E.[SS_Key],   'xif' as Kind,   AD.[Id] as ApplicationDefId,   NULL as ESpaceId,   E.[Id] as ExtensionId,   @LibModuleLayerId as Layer,  1 as IsSelected,  0 as IsDeleted  FROM {Extension_Version} EV      Inner JOIN {Extension} E ON E.[VERSION_ID] = EV.[ID]      Inner JOIN {Module} M ON M.[EXTENSION_ID] = E.[ID]       Inner JOIN {App_Definition_Module} ADM ON ADM.[MODULE_ID] = M.[ID]      Inner JOIN {ApplicationDef} AD ON ADM.[APPLICATION_ID] = AD.[APPLICATIONID]      Left JOIN  {ModuleDef} MD ON MD.[EXTENSIONID] = E.[ID]  WHERE E.[IS_ACTIVE] = 1 AND AD.[ISDELETED] <> 1 AND MD.[ID] IS NULL

), so Oracle throws a constraint error: 

integrity constraint (OSADMIN.OSFRK_OSUSR_MRN_MODULED2_42096) violated - parent key not found


If you comment out this block, then all assigned layers by modules and applications disappear, so this is not an option 

UserImage.jpg
Vladimir Zagoruiko

For some unknown reason, the layer table is empty 


Because of this, the system cannot find any layer, and the snapshot is not generated due to the error.

UserImage.jpg
Vladimir Zagoruiko

Maybe the problem is related to changing the hostname in the administration tab?

2021-04-05 17-12-19
Davide Duarte

Hi,

We are now reviewing pending issues as this one, and fix them in a new version, that we hope to have it available in the next weeks.

Best regards,

Davide Duarte

UserImage.jpg
Vladimir Zagoruiko

Thank you

We will wait ))

2019-12-23 13-54-26
Niek de Jong

We are experiencing the same issue described over here. In the middle of our upgrade from OutSystems 10 to 11 upgrade, we are coming from an really old version that was working. Tried the most recent version, and the same error is logged.

We are running OutSystems platform 11 with an Oracle database version 19c.

Looking forward for a fix for this, or a workaround for the time being.

2021-04-05 17-12-19
Davide Duarte
Solution

Until the new release is available, the work around is to remove Discovery tool, and then install version 5.0.8

After it is installed and you have successfully run it, update to the latest version.

Sorry for the inconvenience.

2019-12-23 13-54-26
Niek de Jong

Thank you. My goal is to have a running version, so this is more than enough for me. :-)

2018-09-22 14-36-02
Kurt Vandevelde
 
MVP

Any idea when this will be solved? Installed version 5.1.1 and had the issue. Reverted back to 5.0.8 and it works.

2018-09-22 14-36-02
Kurt Vandevelde
 
MVP

Still no updated version? The issue has been reported months ago.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.