Best Of

Hello,

To answer the very first question there is no limit to the number of entities you can set up in a dataview.

There is a limit on the number of rows in the server config named "Report rows upper limit".

This limit stops the execution of layouts whose potential rows exceeds the given limit.

You can remove this limit by setting it to -1, this way the only limits of your dataview rows will come from the array allocation limits of your .NET framwork.

Anyway consider that the best way to use a dataview is not to put all the entity by row, but to get a summary view and then use the drill down feature to find data that you need. For sure you will gain in performance and usability with the drill down approach.

At last, I noticed that you created a dense cube. A dense cube contains all the potential values of the various combinations. Try setting some sparsity. A good way would be to set up the entities you want to put by row as sparse.

Hope this helps,

Antonio Speca

Hello Bob,

The Board server handles the concurrency at procedure step level, not at procedure level.

So if you want to handle concurrency at procedure level you can do this as Daniel Zillmann suggested.

By default board handles concurrency at procedure step level.

There are several write actions you can do on the server via procedure:

Dataflow

Datareader

Cube clear

Cube align

Normalize

While a datareader is running other users cannot perform write actions, so they will be queued.

If we run  dataflows on the same portion of data the last one that is triggered will overwrite previous changes.

if we run  dataflows on separate portions of the same cube, dataflows can run in parallel.

Dataflows never lock other write actions, so dataentry clear cube (use current selection) will run.

fi two users are running the same procedure in parallel on different slices of data and you are not using datareader or clear cube (without use current selection) you should not have problems.

We are restyling concurrency to improve it, many news are coming on this topic!

To summarize:

Board server always runs procedures in parallel, then the single procedure step may wait for a lock to be unlocked (like a datareader running) or start in parallel

If you want a procedure to be exclusive for the db so that when that's running nobody else can modify the db, you can use the procedure steps "Db exclusive lock/unlock". If you do not want to lock the full db but have a custom queue on a procedure feel free to use Daniel Zillmann's idea.

To come back to your original question, both the capsule log and the db log will show you the sequence of actions on the server and the user, so you will see who ran the step first.

Hi Ricard,

i have experienced myself this error once, and it was related to some changes i had applied to the database not being retained or saved correctly.

This happened in our development environment and we managed to resolve it by identifying (from the database logs) that some changes (an entity had been deleted) had been applied to the database.

This specific entity was used in multiple dynamic selections in screens, so we restored a previously taken backup and all has been resolved.

I found very useful going through the Deleting Entity Elements article as well because it also helped me understand the impacts of entity deletion.

Hope this helps

Regards

Hello Ricard,

i have also once experienced this error message and i resolved it by checking all the relationships as there were some elements of hierarchies which were not related to others and hierarchies were therefore "missing relationships".

I have normalized all trees, checked for missing relationships, corrected any missing link and resolved the item.

I have also found Troubleshoot: effect of missing relationships very interesting because it helped me preventing this in the future.

Hope this helped you