Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After installing the new version, we cannot perform an impact analysis #24

Closed
carlosbayerl opened this issue Dec 10, 2021 · 33 comments · Fixed by #25
Closed

After installing the new version, we cannot perform an impact analysis #24

carlosbayerl opened this issue Dec 10, 2021 · 33 comments · Fixed by #25
Assignees
Labels
bug Something isn't working

Comments

@carlosbayerl
Copy link

carlosbayerl commented Dec 10, 2021

Após a instalação da nova versão, não conseguimos efetuar a análise de impactos. Abaixo, segue imagem que demonstra como era o serviço antes:
***** English******
After installing the new version, we cannot perform an impact analysis. Below is an image that demonstrates how the service was before:
impact
Como faço para voltar a visualizar estas análises e relacionamentos?
English**
How do I go back to viewing these analyzes and correcting them?

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Please write in English! And post screenshots in English too!
Thank you
Regards,
Tomolimo

@tomolimo
Copy link
Owner

tomolimo commented Dec 16, 2021

Hello @carlosbayerl
Could you post enough information so that I can try to reproduce the issue?
Thank you
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

carlosbayerl commented Dec 28, 2021

Hello @tomolimo
As I said before, after installing the new version, we were unable to perform the impact analysis.
In the image below, in table 1, we have the assets>Development Services>Datamart.
In table 2, we have the applications that directly impact this asset.
And in table 3, the applications that are directly impacted by this asset.
PIC_01
My question is: How do I create this, or do I, this relationship to generate the impact analysis graph? As shown in the image below.
PIC_02
The figures are shown from version 1.3.7, in GLPI 9.5.1. We are in the process of migrating to version 9.5.6 and your plugin (version 2.0.5) does not show the item "Impact" in the menu.
The most important thing for me is to be able to make this relationship.

@tomolimo
Copy link
Owner

tomolimo commented Dec 28, 2021

Hello @carlosbayerl

Version 1.3.7 is not compatible with GLPI 9.5, but only with 9.4

And with the latest impact plugin version (> 2.0.0, which is compatible with GLPI 9.5), there is an automatic migration of the data from the plugin to the core, in order to move the plugin data them into the core impact analysis (impact analysis has been implemented into the GLPI core since GLPI 9.5).
Of course the former "Impact" tab is no longuer available as it is now in the core... under the "Impact analysis" tab, see:
image

If after the migration you can't find the former data on the new tab, then contact me, I'll help you for the migration.

Thank you
Regards,

Tomolimo

@tomolimo tomolimo changed the title Não é possivel criar análise de impacto After installing the new version, we cannot perform an impact analysis Dec 28, 2021
@carlosbayerl
Copy link
Author

carlosbayerl commented Dec 28, 2021

Hello, @tomolimo.
I performed the migration. However, the item "Impact Analysis" does not appear in the menu yet. Can you help me?
PIC_03

@tomolimo
Copy link
Owner

Hello @carlosbayerl
You have to specify the item types for which you want having the impact analysis, see:
image

@carlosbayerl
Copy link
Author

Hello @tomolimo
I had already specified the items. Still, I can't effect relationships.
PIC_04
PIC_05

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Also check this post #22 , I think this is a similar issue.
Thank you
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

Hello @tomolimo.
Indeed, #22 is similar to my case. I just don't know which file of the "Generic Objects" plugin I make the change?
But I'm researching. Thank´s for help me.
Have a new year magnificous!
Regards,
Carlos Bayerl

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Do you mean that the object "Datamart" has been created with the "Generic Object" plugin?
Thank you
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

@tomolimo
Exactly. The Datamart object was created with the "Generic Object" plugin.

@tomolimo
Copy link
Owner

Then you should have a php file that represents the class for this object?

@carlosbayerl
Copy link
Author

Yep! I´m analysing the files.
Thank you.

@tomolimo
Copy link
Owner

On my side, I'm also searching for a solution

@carlosbayerl
Copy link
Author

Thank´s for this.

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Here is the fix:
setup.zip

  1. Replace the impacts/setup.php by the new one (from the attached zipped file)
  2. Upgrade the impacts plugin
  3. Enable it
  4. Go to http://glpiurl/plugins/impacts/front/itemtype.php
  5. Add the PluginGenericobjectDatamart impact item type if not already present
  6. Go to GLPI General Setup on the Impact analysis tab,
  7. Add to the enabled types the Datamart type
  8. Then you should be able to see the impact tab on the Datamart form
  9. Keep me informed :)

Thank you
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

Hello @tomolimo
The fix worked. I can already see "Impact Analysis" in the Menu.
image
However, the relationships were not loaded as they were presented in the previous version.
image
I followed his directions, but I didn't get the relationships to show up.
In fact, I need the "Impact" item to appear in the menu.
image

@tomolimo
Copy link
Owner

Hello @carlosbayerl
As already mentionned the impact analysis has been added to GLPI core... So as a consequence, it will no longuer being managed by the plugin, BUT the plugin should have done the migration of the data from the plugin tables to the core tables. It seems, here, that something went wrong...

So to help you, I need the content of the plugin table which is now renamed into backup_glpi_plugin_impacts_impacts. Could you post the content of this table?
Could you also post the content of the glpi_impactrelations table?

Thank you
Regards,
Tomolimo

@tomolimo tomolimo self-assigned this Dec 31, 2021
@tomolimo tomolimo added the bug Something isn't working label Dec 31, 2021
@carlosbayerl
Copy link
Author

Hello @tomolimo
An additional piece of information, which I have identified and I think I haven't mentioned yet, is that the impact plugin makes the relationships with the GLPI's native objects. However, the objects we create through the Generic Object plugin, do not perform this relationship with the Impact plugin. Is this information valid for you to help me?

@tomolimo
Copy link
Owner

tomolimo commented Jan 3, 2022

Hello @carlosbayerl

Hello @tomolimo An additional piece of information, which I have identified and I think I haven't mentioned yet, is that the impact plugin makes the relationships with the GLPI's native objects. However, the objects we create through the Generic Object plugin, do not perform this relationship with the Impact plugin. Is this information valid for you to help me?

I saw this issue too, and it should be fixed by this #24 (comment)

Hello @carlosbayerl As already mentionned the impact analysis has been added to GLPI core... So as a consequence, it will no longuer being managed by the plugin, BUT the plugin should have done the migration of the data from the plugin tables to the core tables. It seems, here, that something went wrong...

So to help you, I need the content of the plugin table which is now renamed into backup_glpi_plugin_impacts_impacts. Could you post the content of this table? Could you also post the content of the glpi_impactrelations table?

Thank you Regards, Tomolimo

I can help if you answer to these :)

Thank you,
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

Hello @tomolimo
backup_glpi_plugin_impacts_impacts.idb or backup_glpi_plugin_impacts_impacts.frm?

@tomolimo
Copy link
Owner

tomolimo commented Jan 4, 2022

Hello @carlosbayerl
Not the idb or frm files, but the content of the tables :)
To dump tables, you may use several ways:

  1. use of heidisql (Windows only) https://dbeaver.io/
  2. use of dbeaver (Linux, etc...) https://dbeaver.io/
  3. use of phpmyadmin: https://www.phpmyadmin.net/
  4. use of mysqldump : https://stackoverflow.com/questions/2987366/how-to-dump-only-specific-tables-from-mysql

Thank you,
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

Hello @tomolimo
First, I apologize for the delay in returning the message. We have urgent last-minute demands that require greater attention at the moment. However, I want to thank you for your help and ask if we can continue next week?
Thank you again!
Regards,
Carlos Bayerl

@tomolimo
Copy link
Owner

tomolimo commented Jan 7, 2022

no problem :)

@carlosbayerl
Copy link
Author

Hello @tomolimo
The glpi_impactrelations table is empty. But, follow the other table below (backup_glpi_plugin_impacts_impacts):

backup_glpi_plugin_impacts_impacts.zip

@tomolimo
Copy link
Owner

tomolimo commented Jan 7, 2022

Hello @carlosbayerl
Could you send it with a dump (export) of the table so that I'll be able to upload the content of the table in my own DB, and I'll be able to test the migration.
Sorry but RTF format is not usable for me.

Thank you,
Regards,
Tomolimo

@carlosbayerl
Copy link
Author

carlosbayerl commented Jan 12, 2022

Hello @tomolimo
Sorry for the delay. The table exported from backup_glpi_plugin_impacts_impacts follows as name export.sql. I await news.
Thanks.
Regards,
Carlos Felipe
export.zip

@carlosbayerl
Copy link
Author

Hello @tomolimo
Did you manage to parse the table? News about this case?
Regards,
@carlosbayerl

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Not yet, but I will do it quickly
Thank you,
Regards,
Tomolimo

@tomolimo
Copy link
Owner

Hello @carlosbayerl
Here is a fix for this issue: https://github.com/tomolimo/impacts/releases/tag/2.0.7

But before upgrading to the new release, please follow the steps below:

  1. rename the backup_glpi_plugins_impacts_impacts to glpi_plugins_impacts_impacts
  2. upgrade the impact plugin (copie new source files, upgrade plugin, and enable it)
  3. check that your generic object types appear in the list of added types here:
    image
  4. check that your generic object types appear here (if not, then add them):
    image

Then you should be able to view the impact analysis tab, and the existing relations.

Thank you,
Regards,
Tomolimo

@tomolimo
Copy link
Owner

tomolimo commented Feb 7, 2022

Hello @carlosbayerl
Without feedback from you, I close this issue.
Feel free to reopen it if you have news to give.
Thank you
Regards,
Tomolimo

@tomolimo tomolimo closed this as completed Feb 7, 2022
@carlosbayerl
Copy link
Author

Hi @tomolimo
First of all, thanks for the effort in finding the solution for the above case. I make this comment to let you know that relationships are shown as before. Thank you one more time.
Regards,
Carlos Bayerl

@tomolimo
Copy link
Owner

Hello @carlosbayerl
You're welcome
regards,
Tomolimo

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
2 participants