Category Archives: Infrastructure

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

      No Comments on 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 »

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 »