Thanks a lot!!! 

Yes, this is the process but i cannot find the "Health" button, in menu button there is not Installer Wizard option

When im trying restarting the web server gives this error 

[Wed Sep 29 13:40:42.954686 2021] [:crit] [pid 7933] (38)Function not implemented: AH00141: Could not initialize random number generator

Do you know if the upgrade change the versions of apache?

I just download the guide you talk about, and talk about this.

I didnt follow the migration path.

Thanks a lot!!

The upgrade I did was from cache 2016 to 2021, no middle versions between.

Maybe this could be the reason that is genereating the error? 

Thanks Vic Sun

Another question, do you know if I can see the size of a global from portal manager?

Thanks

My journal cleanup looks like this 

How can I look on the system management portal the data you talk about? 

right now im running a GZISE on a specific namespace (the one that is getting bigger) but takes a lot of time.

Thanks

Yes thats what I was asking! I didnt know the procedure was running cinstall as if I were installing fresh instance.

Thanks!!!

Thanks!

Do yo have a tutorial/documentation on how to perform this upgrade? The links take me to download the installers

Yes, I was thinking the same but happens too when I add the parenthesis.

Now when I execute this insert give me this error: 

I read the doc you gave about inserts but I'm not getting a SQL Error that are described there, any idea of what the problem can be?

Again, thanks a lot for the help Robert!!

Now I see the table, but now I need to copy/migrate the data from HSPI_Data.patient (in cache) to PostgreSQL. 

How can I do that?

This is my recently created linked table. (i got to move the data there)

Thanks for the answer, I did what you told me but this create me a new class/table on Cache. I need to link an existant Cache class/table to a postgres table. 

Is this possible? 

Thanks Robert!!!

@Robert Cemper Hello! Now I got the SQLGateway aimed to the PostgreSQL.

The issue I have now is that I need to migrate/copy the HSPI_Data.Patient table to PostgreSQ. What i have to do to see this table on PostgreSQL?

Thanks to much!! 

Thanks Robert, but I cant get from PostgreSQL server to the Cache Server thats why I need to export the data, but this information help me with another problem.

Thanks a lot.

Hi Evgeny, I dont know if this exist on cache, but on PostgreSQL you can export the data as SQL format (on a dump file). 

And I was thinking there is maybe a way to export data from cache as this format (SQL format).

This exists on Cache? 

Thanks and sorry for the delay to answer.

Thanks a lot for the informations, its works for me.

How do you get all the informations about this classes? there is any link to get this info ?

I solved this changing the permission to cacheusr group on the journal.log file

Thanks for the help!

Hello Vic,

I dont have any other message in cconsole.log 

but looking at journal.log permission I have the user that we use to run the scripts with ownership and RW over the file.

What could have happend for this to change?