Raymond Vermeer
Rank: #2970
227Views
9Comments
[DBCleaner] Errors when dropping entities
Question
Forge
DBCleaner
Forge component by Ricardo Silva
56
Published on 13 Aug 2020

Hi,  when I try to cleanup database entities and click on the drop button I get two different errors.

This one I get when dropping an entity where the Espace is also marked as deleted:

Object reference not set to an instance of an object.

This next one I get when dropping an entity where the Espace is not marked as deleted:

ORA-00942: table or view does not exist


0
0
on 2019-11-22
Copy link to comment
Raymond Vermeer
Rank: #2970

I'm running on-premise Outsystems version 11.0.607.0 against an Oracle 12c database.

0
0
on 2019-11-22
Copy link to comment
Amreen
Rank: #395

Raymond Vermeer wrote:

Hi,  when I try to cleanup database entities and click on the drop button I get two different errors.

This one I get when dropping an entity where the Espace is also marked as deleted:

Object reference not set to an instance of an object.

This next one I get when dropping an entity where the Espace is not marked as deleted:

ORA-00942: table or view does not exist


Hi Raymond ,

Please refer this post for the issue:

https://www.outsystems.com/forums/discussion/18659/bug-found-object-reference-not-set-to-an-instance-of-an-object/

Hope this will help you and clear your point.

Regards,

Amreen




0
2
on 2019-11-22
Copy link to comment
Sudip Dey
Rank: #205

Hi Raymond,

Please use this updated component which is more user-friendly and able to avoid referential integrity constraint error.  Please use the component of the below link...

https://www.outsystems.com/forge/component-overview/5018/db-cleaner-on-steroids

I hope you will able to solve the issues bu using these new ones.

waiting for your feedback.

Thank you,

Sudip

2
0
on 2019-11-22
Copy link to comment
Vasco Mendes
Rank: #1914

Hello,

I am facing the same issue on both dbCleaner and DBCleaner on Steroids.


The issue seems to happen when the espace was deleted. The error is issued on the DropDeletedTable action from Outsystems DB API.

0
0
on 2020-05-29
Copy link to comment
Dorine Boudry
Rank: #128

Hi,

same here, this worked before, but since several months, it is no longer possible to drop tables with either of these tools.

Dorine

0
0
on 2020-05-29
Copy link to comment
Barry
Rank: #3151

Same here, error dropping entities from deleted eSpace, SQL Server. Anyone has workaround?

0
0
on 2020-06-08
Copy link to comment

Same here, the error is caused by DBCleaner_API module but unclear why. (I'm on MS db)

0
0
on 2020-06-26
Copy link to comment
bfcantante
Rank: #2881

Hi,


Same problem. Any update?


Regards,


0
0
on 2020-09-11
Copy link to comment
Jolanda Koopdonk
Rank: #7462

This has been fixed in Platform Server 11.9.0. See Bug fixing on Platform Server - OutSystems 

1
0
on 2020-12-17
Copy link to comment