ERROR: portal “C_1” does not exist

ERROR: portal “C_1” does not exist

by Jedox 4 BeginnersNo Comments
Sometimes while loading via Relational load you might stumble upon the following error: Cannot load data into table XXX: ERROR: portal "C_1" does not exist(load New Relational load) Although I am not sure for the real reason of this error, it is worth of looking and Fetch Modes for PostgreSQL. For a PostgreSQL database, you can adjust the fetch mode as follows:Buffered (default): the query result is returned with buffering. In this case, no parallel queries to the same PostgreSQL Server are possible.Full: PostgreSQL returns the query result in one block. This is potentially slower, with higher memory consumption. It should only be set if the connection is used in several components that are processed in parallel during a load, e.g. several PostgreSQL extracts that are joined in a transform, an extract, and a load on the same PostgreSQL connection or when using parallel jobs. (Note that in those cases, if the fetch mode is not set to "full" this might lead to an error...
Read More
IOUtils.setByteArrayMaxOverride() issue

IOUtils.setByteArrayMaxOverride() issue

by Jedox 4 BeginnersNo Comments
Upgrading to the 2022.2 version brings more perks and features. One of these is also the IOUtils.setByteArrayMaxOverride() issue. Usually, it comes in this type of form and states that the maximum length for this record type is achieved. The fix is very simple. If you have access to the config file it is necessary to add this line: Afterward, you just need to restart the ETL service and you are ready to go. In case you don't have access, please write to Jedox Cloud Support....
Read More
A session token is missing from the request

A session token is missing from the request

by Jedox 4 BeginnersNo Comments
This bug appears when we are trying to upload a cube or dimension from the modeler. To learn more about that you can check here. The error usually looks something like this: One of the possible reasons why this happens could be the size of the file. If the file size is bigger than stated in the configuration file then an error could occur. Definitely, this is not the best error message but I am sure the Jedox Dev team will change this. So, to fix this you will need to change upload_max_filesize to the size you need. After that, a restart of services is required. In case you are on cloud ---> Just write to [email protected] and they will do it for you. In case you are on-premise --->, you will need to go to Jedox/Jedox Suite/httpd/php/php.ini and find the line upload_max_filesize. Then restart the services....
Read More
Unable to click save button in Jedox ETL

Unable to click save button in Jedox ETL

by Jedox 4 BeginnersNo Comments
Hi Jedox beginners, How many times has it happened that while working on your super complex ETLs, the save button becomes unclickable? It can become really annoying problem, especially if you spent a decent amount of time in front of the PC. Until now, the problem could be solved by: Clicking Test button before and then pop up with "Save button" will appear Log out, delete cache and log in again. Since both solutions bring anxiety to your hands, simple CTRL + S typing on the keyboard is enabling the SAVE button again. Click now and thank us later....
Read More