I am having a recurring issue occur in BPM when I delete lookup objects and fields, I have deleted the lookup object “Exchange Rate Lookup” and removed the fields from the pages where they were inserted however the page will not save in setup wizard and gives me this error:

After removing the columns from the Exchange Rate Object, the DB will not modify in Configuration, I get the following error:

At this point there is no lookup object and no lookup fields on any of the other custom objects in the package. Any Ideas as to how to get the update and compile working would be great. 

Thanks

Like 0

Like

5 comments

Hi,

You can check logs to find more detailed error on why db cannot be updated for specified object. Also please note that we do not recommend deleting data from configuration - this can lead to unpredictable issues if they are not deleted correctly. 

Angela Reyes,

Hi, Which Logs in particular? there are several in the file system. Also the package was not deleted from base configuration, but the package and all associations were between a custom object i had created and replacing objects I had also made so none of the changes, including deleting the custom object should affect the base packages.

Vishay Kerai,

You can check Error log file for any details. Base packages are not affected - your custom object cannot be published correctly. This can happen if some data was deleted directly from configuration. 

Angela Reyes,

Yes, i cannot publish the object that is the issue, so is there a solution for this?

I have found the error file, it says the reference schema is deserialised from the metadata. the Schema UId ir refers to is not in the package(checked the UId's of all the other package elements). I have attached the error log file below, how do I go about solving this so the DB can compile sucessfully?

2019-10-23 08:44:44,646 [36] ERROR IIS APPPOOL\BPMOnline Terrasoft LogEmptyReferenceSchema - ReferenceSchema set to null;schemaName: ; referenceSchemaUId: 8d73a1af-df6c-4675-9f55-88c5d242a4fc; IsDeserializedFromMetaData: False; stackTrace: 

   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

   at System.Environment.get_StackTrace()

   at Terrasoft.Core.SchemaProperty.LogEmptyReferenceSchema()

   at Terrasoft.Core.SchemaProperty.get_ReferenceSchema()

   at Terrasoft.Core.Entities.EntitySchemaColumn..ctor(EntitySchemaColumn source)

   at Terrasoft.DB.MSSql.MSSqlMetaScript.CreateColumnIndex(ColumnAction columnAction)

   at Terrasoft.Core.DB.DBMetaScript.AddColumnIndexDeletingActions(DBMetaActionCollection actions, ColumnAction columnAction)

   at Terrasoft.Core.DB.DBMetaScript.AddColumnDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, String entitySchemaName, EntitySchemaColumn entitySchemaColumn)

   at Terrasoft.DB.MSSql.MSSqlMetaScript.AddColumnDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, String entitySchemaName, EntitySchemaColumn entitySchemaColumn)

   at Terrasoft.Core.DB.DBMetaScript.AddColumnsDeletingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)

   at Terrasoft.Core.DB.DBMetaScript.AddEntitySchemaEditingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)

   at Terrasoft.DB.MSSql.MSSqlMetaScript.AddEntitySchemaEditingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)

   at Terrasoft.DB.MSSql.MSSqlMetaScript.<>c__DisplayClass78_0.<AddEntitySchemaSavingActions>b__0()

   at Terrasoft.Core.DB.DBMetaScript.ExecuteWithDBElementCache(String schemaName, Action action)

   at Terrasoft.DB.MSSql.MSSqlMetaScript.AddEntitySchemaSavingActions(DBMetaActionCollection actions, EntitySchema entitySchema, Boolean saveAdditionalSchemas)

   at Terrasoft.Core.DB.DBMetaScript.AddEntitySchemaWithAdditionalSchemasSavingActions(DBMetaActionCollection actions, EntitySchema entitySchema, Boolean forceUpdateStructure)

   at Terrasoft.Core.Packages.PackageInstallUtilities.AddEntitySchemasSavingActions(DBMetaActionCollection actions, EntitySchema schema, String packageName, Boolean forceUpdateStructure)

   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallSchemasDBStructure(IEnumerable`1 schemaDescriptors, ActionsConfig actionsConfig, Boolean continueIfError, Boolean batchExecute, Boolean forceUpdateStructure, Boolean updateDbStructureOnceForEachSchemaName)

   at Terrasoft.Core.Packages.PackageInstallUtilities.InstallRequiredSchemasDBStructure(Boolean continueIfError)

   at Terrasoft.WebApp.WorkspaceExplorerModule.OnUpdateDBStructureForRequiredMenuItemClick(Object sender, AjaxEventArgs e)

   at Terrasoft.UI.WebControls.Controls.ComponentAjaxEvent.OnEvent(Object sender, AjaxEventArgs e)

   at Terrasoft.UI.WebControls.Controls.ScriptManager.RaisePostBackEvent(String eventArgument)

   at Terrasoft.UI.WebControls.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest()

   at System.Web.UI.Page.ProcessRequest(HttpContext context)

   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)

   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)

   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)

   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)

   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)

   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

 

Vishay Kerai,

Deleting in the configuration section is prohibited at all. Please never do that again. 

As for now, the best solution is rolling back the system from the backup that was made before deleting the column.

Alternatively, try to check the columns in the database. They should match the object columns. Disable logging, if it was enabled for the object. Try to generate source code for all items, then compile all items. Try to update the database structure for the object (in the right-click menu). Check the exception if it appears. 

Show all comments
7.14_()
sales_enterprise

Hi all!

on the activities section, Calendar view all of the users can see  24-hour clock (military view) we do not need these on the calendar. Every user has US time zone and date and time format set up but on the calendar we still see this 14..15... - 24-hour clock.

 

Where is the place in the system I can change this to 12-hour clock that is regular for US?

Thanks!

Like 0

Like

3 comments

Hello, 



Currently, changing the date/time format and language won't change the format displayed in the Activities Schedule. 

We have this idea registered for our R&D team so they will consider it for the implementing in the future updates.



Kind regards, 

Roman

Roman Brown,

Hi,

 

Is there any update related to this? Thanks!

Pedro Santos,

Hello, 

Unfortunately, so far, there is no functionality that would allow users to change the time format in the calendar view. The task is still active, though, and is being worked on. 

Our R&D team is constantly working on improving Creatio, and this feature will be implemented in future releases.

Show all comments
sales_enterprise
section wizard
mobile application
7.15_()

Hi!

We have problems using the mobile application wizard.

The section "contact" does not open - no matter which point I choose (List, Page or Details). Only delete works immediately.

Even deleting and adding the section fails because the page does not rebuild after clicking on "save".

I do not think it's because of the number of contacts, because we have just created 10 test contacts.

Other sections (Account, Activities, ...) do not cause any problems.

Does anyone have any idea how to fix this?

Like 0

Like

1 comments

Hi!

I would recommend you to contact support and request mobile emulator - you will be able to check errors from the console and see network responses. It will help you to find more details about this issue. 

Show all comments
email templates
sales_enterprise
Macros
7.15_()

Hi!

We have problems using the (native) macros in email templates.

When parameters are inserted, the system displays them in yellow and reports that they can not be used / found.

Does anyone have any idea how we can solve this?

Thank you!

Like 0

Like

1 comments

Hello,

Can you please provide us with step by step description on how do you add this parameter, do you add it in a basic template or into your custom template, which object is a macro source for this template, and please send us screenshots of the template and the resulted email.

Thank you in advance!

Best regards,

Oscar

Show all comments
Business Process
7.14_()
sales_enterprise

Hi-

I was told that you could forward links to reports in emails from BPM. I'm assuming that is through business processes. I see how to send the email- but how do I link the report? The link I'm am sending is just bringing my users to the account page instead of the folder I set up for them in the account page. 

(yes they all have access to the folder)

Like 0

Like

3 comments

Hello Heather,

Unfortunately there is no way to form a direct link that will open a folder in a section when clicking on this link. If I understood you right this should be some internal email to your colleagues. As a workaround you can ask to open some specific folder in the template directly and provide the link to a section. But direct link to open the folder cannot be formed. I will ask our R&D team to create some logic that allows doing it. Thank you for reporting this issue to us!

Best regards,

Oscar

i made folders in my gmail account to filter incoming emails and i did synchronized it with created but Is there a way to recieve the information like applied filters with email object received ?

Hello Werdien,

 

Thank you for your question! Could you please clarify your business task? 

 

Looking forward to your reply!

Olga. 

Show all comments
7.14_()
sales_enterprise

Hi,

In the release notes for 7.14.4 there is a new feature that allows you to have a single field with a multiple choice selector. Our platform has been upgraded, but I cannot find how to add such a field to one of my pages.

Is there any further information on this feature, as we have been wanting such a thing for a while now.

You can now create details with multiple values (connection of “many-to-many”) using a separate junction table. For example, multiple values are available for selection in the [Activity results] lookup.

Source - https://academy.bpmonline.com/documents/bpmonline-release-notes-7-14-4

Like 0

Like

5 comments

If it can be done in Low Code, it would be great

 

Stéphane Banon2,

Well that is what the release notes indicate, but as I cannot find it I am unsure. There is no new field type on the left list and within the Lookup field type settings there is nothing related to it being a multi select field.

I am sure they are not teasing us all, as the custom coded method is WAY to complicated to expect users to implement across their instances.

Any comment from bpm'online ?

Is anyone from BPM able to provide some guidance on this? 

A new feature has been added, but either the description is inaccurate or needs further information to allow users to know where and how to use it.

Mark Roberts,

This part of release notes is located in "DEVELOPMENT TOOLS" so this means this feature is available using development. To check how you can achieve this you may check the code from Activity results lookup - with similar code you can implement detail with "many-to-many" connection. 

Show all comments
Business Process
collection
web service
web api
call web service
Web-to-Object
Loop
7.14_()
sales_enterprise

I have been struggling very much with handling collection type response parameters in web services.

When response parameters are or normal type they are very easy to handle in the business processes. Here we are able to handle them as parameters on the Call web service process element. And use these in the process right away.

When there is a Collection which is returned, this is very different. Now the Call web service element parameter is of type Collection of Objects with attributes.

It seems to me that this parameter-type is very difficult to handle in the business process. I can't seem to find documentation in the Academy about how to extract and loop through the contents of the Collection of Objects with attributes.

What I have found in the academy is this article about setting up the Web service.

https://academy.bpmonline.com/documents/administration/7-14/adding-resp…

What I need to learn is how to handle them in bpm'online business processes.

Is there something about this in the Academy?

Is writing source code the only option? It's difficult to debug.

Like 0

Like

6 comments

Dear Julius,

Unfortunately, it is impossible to handle parameters that have the “collection of object” type without using the source code.

Therefore, in this case we recommend using “ScriptTask” element for both calling the web-service and processing the results of call.

For more detailed assistance, please contact technical support.

Best regards,

Norton

Norton Lingard, Thank you. Is there anything like this in the academy? Because there is a special bpm'online syntax to go by in the source-code.

Dear Julius,



The service call in a "Script task” business process element can be implemented via native C#. Please find a lot of examples on how to do that in Google. For example, several links below:



https://stackoverflow.com/questions/9620278/how-do-i-make-calls-to-a-rest-api-using-c



https://code-maze.com/different-ways-consume-restful-api-csharp/

Please note that it is possible to use the native C# collections instead of working with the the special bpmonline collections.

Best regards,

Norton

Hi Julius,

 

Did you manage to solve this?

 

I'm struggling with the same issue and didn't manage to get it to work.

 

Looking forward to having Your answer.

 

Raz

Norton Lingard,

Hi Norton,

 

Is there another example on how to do it in the script task?

 

I tried implementing it based on the links you posted and I'm getting many error messages when posting the code.

 

Thanks,

Raz

Dear Raz,

 

Please find another example in the article by the link below:

 

https://stackoverflow.com/questions/3900371/how-can-i-call-a-webservice-from-c-sharp-with-http-post

 

If you still can’t resolve the issue please provide us with a source code that you wrote and errors that you got.

 

Best regards,

Norton

Show all comments
7.14_()
sales_enterprise

Hi,

We have a use-case where we have to support parallel development and UAT activities on BPM'Online. Ideally, we'd like to achieve it through a branching strategy on SVN, where we have a "main" branch for development and a "UAT" branch which is forked out of "main". This "UAT" branch will run independently of "main" to cater to UAT fixes. Once UAT is done it will be merged back with "main". During the UAT phase, the "main" branch will continue to get updated with ongoing development activities. I wanted to check if this is feasible from a BPM'Online perspective. Can this branching strategy be seemlessly integrated into BPM'Online? If yes, could you point me to some documentation that has guidelines around this?

Like 0

Like

8 comments

Please feel free to find information about working with SVN on the bpm'online platform in the article by the link below:

https://community.bpmonline.com/articles/working-svn-bpmonline-platform

Thank you for your reply Alina! My question was more around branching strategy to support parallel development initiatives, for example, to support in-proc development and release hot fixes at the same time. Also the possibility of switching branches on demand based on whether it is release related work or main development activity. Below is a fair representation of what I was having in mind. Also, is there a way to merge the release branch with the main development branch? Does BPM'Online support such a branching strategy?

Unfortunately, bpm'online doesn't support a branching strategy.

Thanks Alina! Is it part of the product roadmap? Can you suggest a workaround?

The only approach for working with SVN on the platform is described in the article mentioned earlier.

Alina Kazmirchuk,

Your article is just about configuration management, not SVN specific. The question is about branching strategy, not configuration management.

Van Ly,

As it was mentioned above, unfortunately, 

bpm'online doesn't support a branching strategy.

Show all comments
7.14_()
sales_enterprise

Does BPM'Online automatically refresh the list of users from Azure AD when it is configured to use Azure AD as SSO? Or do we have to manually create/update/delete the users in BPM'Online as well in addition to maintaining them in Azure AD?

Thanks in advance for all the help...

Like 0

Like

7 comments

Hello! 

This can be done turning on JIT on the site. To do this you would need to send a letter to the support@bpmonline.com if your site is located in cloud as well as do some additional settings on your side. Please see the article below: 

https://academy.bpmonline.com/documents/administration/7-14/setting-just-time-user-provisioning

Best regards, 

Dennis

Dennis Hudson,

​​​​​​Thank you for your reply! I am working on an on-premise setup. Can JIT be configured on an on-premise installation along with Azure Active Directory as SSO provider? Thanks again for all the help...

amanthena,

Yes, it can be activated for on-site and cloud deployed applications. Please refer to this Academy article when setting SSO up 

https://academy.bpmonline.com/documents/administration/7-14/setting-single-sign-adfs#XREF_62278_ADFS

Best regards,

Oscar

Oscar Dylan,

Thank you!

Oscar Dylan,

Dennis Hudson,

Is it possible to automatically sync the roles (organizational and functional) of the user in Azure Active Directory through JIT to BPM'Online? I was referring to the documentation mentioned here - 

https://docs.microsoft.com/en-us/azure/active-directory/saas-apps/bpmonline-tutorial



At the end of this article, there is a point about user creation - 

"In this section, you create a user called Britta Simon in Bpm’online. Work with Bpm’online support team to add the users in the Bpm’online platform. Users must be created and activated before you use single sign-on."



It mentions that the users would have to be manually "created" and "activated" in BPM'Online for SSO to work. This contradicts JIT feature on BPM'Online. Could you please re-confirm if JIT is valid for Azure Active Directory(AAD) and that it is also possible to automatically synchronize the organizational and functional roles in AAD to BPM'Online through JIT?



Thanks in advance...

 

Dennis Hudson,

Oscar Dylan,

Hi! Any update on this? Your help here would be greatly appreciated. Thanks!

amanthena,

 

Hello, 

 

You can synchronize user's data from Active Directory to Creatio with a help of JIT function.

Each time a user logs on using SSO, the data on the contact page are updated with the data obtained from the identity provider. If a user has no account, it can be created when the user logs in for the first time.

If there is already a user with such username, the data will be simply updated based on the received information, if there is no user with such username, a new user will be created and provided with all the needed licenses based on it's user type (company employee/portal user). 

To specify contact fields that should be populated with data from the identity provider, configure the mapping of the SAML Assertion fields with Creatio columns. This is done in the SAML Assertion of the identity provider and in the [ SAML field name converters to contact field name ] lookup.

You can find more detailed information in the article below:

https://academy.creatio.com/docs/user/setup_and_administration/user_and…

As for the roles, Creatio should have the same roles as Active Directory (and as user as well). This way, once the user logs on, all their roles are being updated based on the received information. However, if the user has roles that are not presented in Creatio, new roles will not be created (but can be updated during the next login, if you decide to add same new roles to Creatio).

 

Hope it clarifies!

Best regards,

Anastasiia

Show all comments
7.14_()
sales_enterprise

I'm using this.reloadEntity() to refresh page, but the problem is i have to double click a button to refresh a page. Any idea for this case?

             messageHandler: function(args) {

                this.set("UsrIsLead", "1");

                this.save({ isSilent: true });

            },

            onOpenPrimaryContactClick: function() {

                this.reloadEntity();

                this.messageHandler();

            }

Like 0

Like

1 comments

Try to debug the functionality. I've just tried the JS code specified below and it worked every time.

define("ContactPageV2", [], function() {
	return {
		entitySchemaName: "Contact",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {
			getActions: function() {
				var actionMenuItems = this.callParent(arguments);
				actionMenuItems.addItem(this.getButtonMenuItem({
					"Caption": "testBtn",
					"Tag": "testMethod",
					"Visible": true
				}));
				return actionMenuItems;
			},
			testMethod: function(){
				this.reloadEntity();
			}
		},
		rules: {}
	};
});

 

Show all comments