Answered

Virtualization: Database View insted of table

Hello,

Currently I am in the final stages of a comprehensive evaluation test of BizAgi Enterprise 10.1.0.2020 .Net edition, and by the way, results are more than impressive this far. It's an incredible and amazing technology / solution what you have achieved.

After defining several, not so simple, processes, with corresponding workflows, messages, data models, forms and rules, I have a doubt about virtualization.

Currently I have several of replicated entities and one virtualized 'products' entity in the data model. 'products' entity is virtualized and not replicated because despite BizAgi doesn't need to write anything on it, data needs to be refreshed almost instantly, and has a fairly large ammount of rows.

The matter is that I'm getting an erratic forms behaviour when clicking the next button to advance cases, ending throwing the following error:

"Unable to process the case:Cannot update view of function 'vwM_Products' because it contains aggregates, or a DISTINCT or GROUP BY clause, or PIVOT or UNPIVOT operator"

vwM_Products is an SQL Server database view (not a proper database table). Does virtualization currently support virtualization over database views instead of tables? Could it be the source of the error?

Thank you very much in advance.

Sincerely,

Jose F

Best Answer
photo

Dear Jose,

About your question, Bizagi support views and tables from Oracle and SQL Server. Maybe

something is wrong in your configuration. I will recommend this links in order

to check any mistake out. Remember that you can virtualized an entity using

wizard or advance configuration.

Virtualization:

http://help.bizagi.com/bpmsuite/en/index.html?virtualization.htm

Using the

Virtualization Wizard: http://help.bizagi.com/bpmsuite/en/index.html?using_the_virtualization_wizar.htm

Using advanced Virtualization configuration: http://help.bizagi.com/bpmsuite/en/index.html?using_advanced_virtualization_.htm

Best Regards,

Juan Zuluaga

photo
0

Dear Jose F

A member of our support team will contact you

Best regards

Luis Emilio

photo
0

Dear Jose,

About your question, Bizagi support views and tables from Oracle and SQL Server. Maybe

something is wrong in your configuration. I will recommend this links in order

to check any mistake out. Remember that you can virtualized an entity using

wizard or advance configuration.

Virtualization:

http://help.bizagi.com/bpmsuite/en/index.html?virtualization.htm

Using the

Virtualization Wizard: http://help.bizagi.com/bpmsuite/en/index.html?using_the_virtualization_wizar.htm

Using advanced Virtualization configuration: http://help.bizagi.com/bpmsuite/en/index.html?using_advanced_virtualization_.htm

Best Regards,

Juan Zuluaga

photo
0

Dear Jose,

About your

question, Bizagi support views and tables from Oracle and SQL Server. Maybe

something is wrong in your configuration. I will recommend this links in order

to check any mistake out. Remember that you can virtualized an entity using

wizard or advance configuration.

Virtualization:

http://help.bizagi.com/bpmsuite/en/index.html?virtualization.htm

Using the

Virtualization Wizard: http://help.bizagi.com/bpmsuite/en/index.html?using_the_virtualization_wizar.htm

Using advanced Virtualization configuration: http://help.bizagi.com/bpmsuite/en/index.html?using_advanced_virtualization_.htm

Best Regards,

Juan Zuluaga

photo
0

Dear Juan Zuluaga,

After writing my post on the support forum, I found I had made a mistake at one of the user forms, allowing to edit a field of the Products entity, which is virtualized. So the test user was changing it's value, and it was fine until the "Next" button was pressed.

I understand that is in this precise moment when BizAgi commits activity data to entities, so I suppose the app tried to update the changed field, and failed with that error (the database view is read-only).

Since I detected the cause and configured the field as non editable, everything is working fine.

In my humble opinion, it would be an improvement if BizAgi checks for write-permissions on the virtualized entity and throws a more-descriptive error message.

Thank you very much for your response. We are on the final stage of evaluation process, so I think will become formal customers in a few weeks.

Sincerely,

Jose F.

photo
0

Dear Jose,

I am glad to see that everything is working fine. I will report it as a suggestion.

Thank you

Regards,

Juan Zuluaga