Log in to AnswerLog in to Follow
Vladimir Zagoruiko
139Views
20Comments
Solved
[Discovery] Error in Query CreateModuleDefinitionsForExtensionsOracle
Question
Forge
Discovery
Forge component by Francisco Menezes

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

0
0
13 Aug 2020

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.

See solution in context
0
0
03 Feb

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

 

0
0
15 Aug 2020

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?

0
0
22 Aug 2020

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.

0
0
22 Aug 2020

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

 

0
0
25 Aug 2020

Hi all,

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

Keep tuned!

Thank you!

0
0
22 Aug 2020

Hi all,

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

Thank you!

0
0
23 Aug 2020

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 

 

0
0
25 Aug 2020

I still have this problem in version 5.1.1

0
0
03 Sep 2020

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

 

0
0
03 Sep 2020

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


0
0
03 Sep 2020

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 

0
0
01 Dec 2020

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.

0
0
01 Dec 2020

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

0
0
02 Dec 2020

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

0
0
02 Dec 2020

Thank you

We will wait ))

0
0
02 Dec 2020

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.

0
0
03 Feb

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.

0
0
03 Feb

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

0
0
03 Feb
Kurt Vandevelde
mvp_badge
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.

0
0
07 Apr
Kurt Vandevelde
mvp_badge
MVP

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

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