FAILED TO CHANGE DATA MODEL

Hi @Raman Silotia,

Which application from the marketplace did you install? It might be that the application relies on specific tables and columns. Are none of them missing?

Kind regards,

Sverre Klein

Hi,

Ok the issue is now fixed, as it required assigning of the data model at package settings.

But now it asks for specific table names, I guess I am required to create these tables in the data integration ?

The app name is -: Monitoring (used for Data pipeline and consumption monitoring)

Hi @Raman Silotia,

Exactly. Either that or change the PQL behind these components so that it matches your tables names

Kind regards,

Sverre Klein

Hi Raman,

have you enabled Custom Monitoring like described here:

https://docs.celonis.com/en/set-up-custom-monitoring.html#UUID-9a5d440d-0e09-5f2f-4c72-4b3a9bf72ce3_section-idm4674092075072033927283802794

After that a new Data Pool (Monitoring Pool) will be created as well as the necessary tables.

BR

Dennis

Hi Dennis,

Thanks for your response.

yes I have gone through the documentation and mentioned the data models from Monitoring data pool.

But it looks like I am still getting an error of the unavailability of some particular fields.

For example -: clean_status field is missing here for Data monitoring data model.

Hi Raman,

I shortly checked our tables and haven't found any clean_status field directly.

Can you please show where this field is used and where you are getting the error message?

Are other components of the Data Pipeline and Consumtion Monitor now working?

BR

Dennis

Hi Dennis

Thanks for your response,

I did check for clean_status field but even in the component YAML I was not able to find.

Ok it looks like we are using this field in PQL of the KPIs

Hi Raman,

have you used the Monitoring Data Pool already before the Monitoring Views with the "old" Data Pipeline and Consumption analyses?

I just identified that I get the same error message when using the Monitoring packages (views) and non of my tables from Monitoring DM have this data / field as well.

I am not sure if there is any better way of "upgrading" the Monitoring Data Model but what I did now is deactivating the Custom Monitoring within Data Integration settings, manually deleted the Monitoring DM and afterwards enabled custom Monitoring again.

But this results in a complete restart of Data Monitoring. But now I got all the "new" tables containing the new fields like clean_status.

BR

Dennis

Hi Dennis,

Thanks for your response.

Just few questions I have regarding this -:

• Is the monitoring required to be disabled from job schedules ?
• I have deleted the monitoring data pool, is it going to be created again or do I need to install the monitoring app again from marketplace ?

• Is the monitoring required to be disabled from job schedules ?

No but in order to delete the Monitoring Data Pool you have to disable Custom Monitoring at all within Data Integration -> upper right corner Monitoring

• I have deleted the monitoring data pool, is it going to be created again or do I need to install the monitoring app again from marketplace ?

No. After deletion of Monitoring Data Pool you have to activate Custom Monitoring again. So please go again to Data Integration -> upper right corner "Monitoring" and active it.

After that the Monitoring Data Pool is getting added automatically. Then it takes some minutes / hours till all relevant tables (e.g data_consumption_updated_events, data_connections etc.) are getting created automatically.

When this has been done you need to go into your Monitoring Data Pool and execute the three Data Jobs (Data Consumption, Data Pipeline, Replication Cockpit). Then all relevant tables, views etc. are being created and after successful Data Model load you can select those Data Models within your Monitoring Studio Package.

BR

Dennis