Hi, 

Please help to fix the below error while instaling package to oracle based BPMonline instance. Installation fails and install log has below error and error screenshots. Please assist to fix the issue.

Oracle.DataAccess.Client.OracleException: ORA-02291: integrity constraint (DLD_CRM.FKiEw0PrrAuIapzcrL01PohOXeFM) violated - parent key not found

at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

ORA-02291: integrity constraint (DLD_CRM.FKiEw0PrrAuIapzcrL01PohOXeFM) violated - parent key not found

 ---> Oracle.DataAccess.Client.OracleException: ORA-02291: integrity constraint (DLD_CRM.FKiEw0PrrAuIapzcrL01PohOXeFM) violated - parent key not found

   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

Like 0

Like

1 comments

Dear Ganesh,

"parent key not found" message indicates that you are trying to insert a child without a matching parent, as defined by a foreign key constraint. I recommend checking data bindings for the objects that are installed with the package. 

Best regards,

Angela

Show all comments

Hi all,

We have a custom section called 'Dossiers'.

A dossier can have multiple invoices. Therefore we created a custom detail 'Invoice history' where each record is linked to a dossier (name UsrDossierInvoiceHistory).

Now I want to make the data from this detail available like a section so I can add it to a workplace and all records (linked to all dossiers) are displayed and can be filtered on.

Would it be enough to add a file 'UsrDossierInvoiceHistorySection' and 'UsrDossierInvoiceHistoryPage'?

Or can I achieve this using the section wizard, referring to an existing detail object?

Kind regards,

Vincent 

Like 0

Like

1 comments

Dear Vincent,

Please refer to this community question regarding registering custom section for existing object https://community.bpmonline.com/articles/register-custom-section-existi…. In your case your detail is an object and you need to create a section from it.

Best regards,

Oscar

Show all comments

Hi Community,

 

Is it possible to trigger a business process after new user was created?

 

I tried it, but it seems the process is not triggered. I also check the process log but this process is not there.

 

Like 0

Like

1 comments

Hi all,

Does someone knows how to import product image in the xlsx file ?

I tried the image URL, the image encode in base64...

thank you

Like 0

Like

5 comments

Hello,

if we take a look at the table in DB where information on products is stored, you can see that the column which stores information on images is called "PictureId". This column takes information directly from "SysImage" table where all images are stored. The image itself is stored in "Data" column and it is stored as binary code there. Unfortunately there is no way to import data to SysImage table directly using data import tool. I will create a problem to our R&D team so to develop this functionality in future and I hope it will be implemented soon enough. As for now you need to update images manually via product page. Thank you for helping us to make our application better.

Best regards,

Oscar

thank you Oscar

Do you know how to encode Line feed in the excel import file for BPM multi-line fields ?

LÉZORAY Nicolas,

 I ve got it, i replace line feed by <br/> in my SQL results, next in the xlsx file, i replace <br/> with ALT+010

LÉZORAY Nicolas,

Are you saving this into a standard field or the Notes field? When I did importing of data into the Notes field, it has never worked.

Mark Roberts, into the Notes Field it works

Show all comments

Hi community,

We will integrate SAP in BPM online, In standarad .net applications to start the development we need to install SAP .Net Connector. In BPM online how we can possibly do this?

 

Like 0

Like

2 comments

Dear Fulgen

Unfortunately as for now there is no marketplace or out-of-the-box solution for your task and I will create a problem regarding this issue. As for now you can try integrating using API and here is an Academy article that may be helpful https://academy.bpmonline.com/documents/technic-sdk/7-13/javascript-api….

Best regards,

Oscar

FREREJEAN,

 

Hello,

 

Our R&D team has this problem I've created for them in "Accepted" status, but the logic of SAP entities integration is currently not implemented in the Creatio app. The only way to integrate with 3rd party entities like SAP now is to develop a custom service that will transfer data between your SAP entity and the Creatio app. Here is the link to the Creatio Academy article that describes using OData for 3rd party integrations.

 

I will also inform our R&D team about your question and ask them to increase the priority of the problem registered on their end.

 

Best regards,

Oscar

Show all comments

Hi Community,

 

Is there any existing Excel reports builder for bpm’online Development Guide?

Like 0

Like

1 comments

Dear Fulgen Ninofranco,

Here is the link to a marketplace excel report builder.

https://marketplace.bpmonline.com/app/excel-reports-builder-bpmonline

Unfortunately, we do not have any available documentation for its development. However, if you have any specific development questions concerning application functionality you are welcome to contact the application developer via email bpmonlinelabs@bpmonline.com

Best regards,

Dean

Show all comments

Hi Community,

Do you have any example on how create schema that will calculate response time just like in the cases.

 

Like 0

Like

1 comments

Hi Community,

How to configure the BPM CRM that the third party application can consume it and get data from it.

 

Like 0

Like

1 comments

Hello.

Bpmonline already has endless integration possibilities. You can find more information about that in the academy article and its child articles below:

https://academy.bpmonline.com/documents/technic-sdk/7-13/integration-bp…

Best regards,

Matt

Show all comments

Hi Community,

 

Is there an existing functionality in BPM that will identity all the modified fields.

Like 0

Like

1 comments

Hello.

The best and the simplest way to check that would be a change log. You can read more about it below:

https://academy.bpmonline.com/documents/administration/7-13/change-log-…

https://academy.bpmonline.com/documents/administration/7-13/view-all-ch…

Please note, that the change log has to be enabled for a certain object first.

Best regards,

Matt

Show all comments

Hi Community,

I'am getting this error message when adding new object to "List of Objects Available for portal Users" Lookup in our development system

 

Like 0

Like

1 comments

Dear Fulgen, 

This error occurs because there is a built-in limitation on the amount of objects that can be available for the portal users. You can avoid this limitation only with development. You can examine script 'InsertPortalUserCanReadRightsOracle' in the configuration to understand how to add more objects with the help of development tools. As a workaround you may remove extra objects and replace them with the needed ones in the  'List of objects available for portal users'. 

Also the portal set up will be reworked in 7.13.2 and you would be able to set this up in the section wizard.

https://academy.bpmonline.com/documents/bpmonline-release-notes-7-13-2

Best regards, 

Dennis

Show all comments