Create a diffusion database not work

cbrianso

I tried to create a diffusion ontology, as you mentioned in other threads, which would be the best way to customize it
I created a whole new structure, following the instructions in the documentation https://dedalo.dev/docs/diffusion/diffusion_data_flow/#how-publication-ontology-works, I have been creating table_alias, so as not to have to duplicate the fields, but it does not work
What I have created is

When trying to publish any of the tables I have created, this message appears

In the error log, it does not indicate anything, there is only an error in the chrome inspector

Any idea what could be happening? or how to solve it?

another problem with the ontology, perhaps related, is that an element has been left hanging

When I try to enter, it gives me an error related to masle0, which I can't find where it can be or how to return to a correct state. The error is:
hook.js:608 Page running with server errors. dedalo_last_error: dd_core_api::start Invalid tipo is received. The model cannot be resolved
tipo: masle0

Thanks

Alex

cbrianso Any idea what could be happening? or how to solve it?

Previous and important notes: In your configuration, you are using a common tld dd that IS NOT able to be used in local definitions. Nodes: dd1751 and dd1753 will be changed by the common definitions when you update the common ontology. If you do it, you has to NOT update the ontology anymore with the common definitions.

Steps:

Check your Ontology main record for your TLD masle, seems that your has not defined it correctly.
The main ontology defines the root section as masle0, that has not well defined. So, you. must go to:

Ontology -> Ontologies main

Locate and edit the masle definition, and recreate it:

It will recreate the masle0 section.

Parse your ontology.

And as you are mixing TLD (ddand masle), you will need to build both before running the diffusion tool.

check your diffusion configuration, it needs to match with your diffusion_domain.

And if all is ok, it will work.

Best.

cbrianso

thanks for the instructions

I have done all the steps you mentioned, and it looks like this

The table_alias, have as relation, the table in the default diffusion_domain

and I changed the settings
define('DEDALO_DIFFUSION_DOMAIN', 'masle');

with all this, the button has disappeared, and it won't let me publish to diffusion

He provat de crear taules, amb camps amb el mateix resultat, and no error appears anywhere

No crec que estigui relacionat, però al fer "Ontology parser", la que he creat jo "masle" es regenera bé, però en els altres, que no s'han tocat, hi ha errors

I don't think it's related, but when doing "Ontology parser", the one I created "masle" regenerates well, but in the others, which haven't been touched, there are errors

Thanks

Alex

Hi!

Can you provide the result obtained with this SQL command running it in your PostgreSQL?

SELECT *
FROM "jer_dd"
WHERE "tld" = 'masle';

And with that:

SELECT *
FROM "matrix_ontology"
WHERE "section_tipo" = 'masle0';

You should see your diffusion nodes in both cases.

Best

cbrianso

Alex SELECT *
FROM "jer_dd"
WHERE "tld" = 'masle';

The result is empty

Alex SELECT *
FROM "matrix_ontology"
WHERE "section_tipo" = 'masle0';

The result is
id | terminoID | parent | modelo | esmodelo | esdescriptor | visible | norden | tld | traducible | relaciones | propiedades | properties | term | model
-------+-----------+----------------+--------+----------+--------------+---------+--------+-------+------------+------------------------------------------+-------------+-------------------------------------------+---------------------+---------
37984 | masle0 | ontologytype15 | dd6 | no | si | si | | masle | no | [{"tipo":"ontology1"},{"tipo":"dd1201"}] | | {"color": "#2d8894", "main_tld": "masle"} | {"lg-spa": "masle"} | section

Thanks

Alex

Seems that you are not creating masle nodes. The results show that only the section node exists in the active ontology (the result that you provide of jer_dd).

Can you provide the section_tipo of one of your masle nodes as masle1753?

To know it, you can observe the tipo variable in the URI or in the inspector when editing the node (while any component is not selected). For instance:

Modify the node clicking in the page icon (in my case, the default diffusion_domain node, with the section_tipo dd45).

In the edit window, you can observe the section_tipo in the URI. Additionally, you can access it within the inspector.

Best