OutSystems – Java extension: write log messages

I was looking for a way to debug an (Java) extension and found some posts about this on the OutSystems community. Of course most of these posts are on .NET, but Java or .NET, debugging an extension is not that easy. The easiest way to enable some sort of debugging for an extension, is to write (debug) messages to the OutSystems… Read more »

OutSystems – Java / WebLogic related bugs

      No Comments on OutSystems – Java / WebLogic related bugs

Installing, configuring and working with the OutSystems platform on an Oracle stack (Orcle linux, Oracle WebLogic and Oracle database) made me run into some bugs. This posts lists some of the problems/bugs I ran into. #1 – Using non-suggested installation paths and users To install the OutSystems platform server, OutSystems created an installation checklist for the .NET and Java stacks…. Read more »

OutSystems – How the Count output parameter counts rows

In OutSystems you can use the “Count” output parameter, supplied with both aggregates and advanced queries, to count the number of rows that would be returned by the aggregate or advanced query. Aggregates When using “Count” for an aggregate, the OutSystems platform will count the number of records by using SELECT COUNT(1) FROM <tables, join conditions and filters> Advanced Queries When… Read more »

OutSystems – Use of comments in Advanced Queries

I was creating an advanced query (see post OutSystems – Getting Database Information) for the DBCleaner application to display table space usage. When I executed the query in OutSystems Service Studio using the “Test” button, it gave a (the expected) result, so publish the application an go! Publishing the application went fine, but when I went to the page with… Read more »

OutSystems – Getting Database Information

      No Comments on OutSystems – Getting Database Information

In this post I will provide some queries that you can use to get information on the OutSystems schemas in an Oracle database.   List inactive (unused) entity tables It is pretty simple to get a list of all inactive entity (unused – the entity got removed from OutSystems) database tables. SELECT esp.name ESPACE, ent.name ENTITY, ent.physical_table_name TABLE_NAME FROM osadmin.ossys_espace… Read more »

OutSystems – Adding/Changing/Deleting Entities and Entity Attributes – Database Implications

Running into an “Database Upgrade Error” on publishing and application after I changed the length of an existing entity attribute, gave me some insight into how the OutSystems platform handles changes on entities and entity attributes. In this post I want to give an overview of the implications on the database used by OutSystems, whenever you work (add, change, delete) with… Read more »

OutSystems platform using Oracle Database – VARCHAR2 to CLOB

When I was developing an application in OutSystems, I changed the size of one of the “Text” entity attributes of one of my entities from 500 to 5000. Service Studio just let me do this and there were no errors or warnings in TrueChange. Then I clicked the publish button: Database Upgrade Error Different Oracle data types used for OutSystems “Text”… Read more »

OutSystems NextStep Benelux 2016, 12 October 2016

Come and join Quobell at the OutSystems NextStep event on the 12th of October in the NBC Congrescentrum in Nieuwegein. NextStep Benelux is an annually returning event for people who want to know more about OutSystems or want to share experiences with other people. During this event new features will be unveiled and OutSystems customers like RET and Frankort & Koning… Read more »

Apache Traffic Server (ATS) as reverse proxy for OutSystems – URL remapping

I’ve been working on getting internal (on-premise) OutSystems platform servers (version 9) installed, running completely on a red stack (Oracle Linux, Oracle database and Oracle WebLogic). One of the things I wanted to try, was getting the platform server available from the outside world, the internet. Port forwarding on the firewall When you enable port forwarding on the firewall, using a… Read more »

Oracle Database Appliance – Problem Replacing Shared Disk (2.4)

As with all systems, a disk failure can happen and so we had a failing disk on one of our ODA’s. As mentioned in the ODA documentation, replacing a disk is easy and OAK does everything for you. Actually it is doing everything for you, from all OS related actions (like multipath configuration and partitioning) to dropping and adding the… Read more »