{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"This feature is not currently available. See the known issue ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://infozone.atlassian.net/wiki/spaces/MD91/pages/23278867/Known+Issues#Unable-to-change-platform-database-after-installation"}},{"text":" ","type":"text"}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"details","parameters":{"macroParams":{"hidden":{"value":"true"},"_parentId":{"value":"111850793"}},"macroMetadata":{"macroId":{"value":"21dee662738d4b7b1e07d74281cb6bbc"},"schemaVersion":{"value":"1"},"title":"Page Properties"}},"localId":"d1bd145e-7d5f-489e-bda3-45ee0b8190a5"},"content":[{"type":"paragraph","content":[{"text":"This section describes how to change the Platform database. The new database can be of the type Oracle, PostgreSQL or SAP HANA.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Note!","type":"text"}]},{"type":"paragraph","content":[{"text":"Changing the database will cause the stored data to be lost.","type":"text"}]},{"type":"paragraph","content":[{"text":"This includes:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System log messages","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Duplicate Batch processing data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Archiving data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error Correction System data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User Access data (deprecated and configurable with Platform property)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System Statistics","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Alarm data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Group Server data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"License data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Workflow transactions and workflow states","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" Migration of the data listed above is possible, however the method for this is outside the scope of this document. ","type":"text"}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"text":"Follow these steps to change the Platform database type to an Oracle, PostgreSQL or SAP HANA database.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a properties file for the new database. This file contains the database related properties that are available when you install","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"cc15eaa9-e999-4890-bd33-035c6c6f6460","collection":"contentId-111772403","height":"12"}}},{"text":".","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ mzsh mzadmin/ db-scripts create-properties \\\n--properties-file ","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update the properties that are applicable for the new database type. For further information about the properties in this file, see ","type":"text"},{"text":"Properties for Oracle","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Properties for Oracle (to be removed)"},"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD92&title=Properties%20for%20Oracle%20%28to%20be%20removed%29&linkCreation=true&fromPageId=111850793"}}]},{"text":", ","type":"text"},{"text":"Properties for PostgreSQL (to be removed)","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Properties for PostgreSQL (to be removed)"},"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD92&title=Properties%20for%20PostgreSQL%20%28to%20be%20removed%29&linkCreation=true&fromPageId=111850793"}}]},{"text":" or ","type":"text"},{"text":"Properties for SAP HANA","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Properties for SAP HANA (to be removed)"},"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD92&title=Properties%20for%20SAP%20HANA%20%28to%20be%20removed%29&linkCreation=true&fromPageId=111850793"}}]},{"text":" in the ","type":"text"},{"text":"Installa","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD92/pages/111870228"}}]},{"text":" (to be removed)","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Properties for SAP HANA (to be removed)"},"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD92&title=Properties%20for%20SAP%20HANA%20%28to%20be%20removed%29&linkCreation=true&fromPageId=111850793"}}]},{"text":" ","type":"text"},{"text":"ion Instructions","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD92/pages/111870228"}}]},{"text":". ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Extract the database scripts that are required to create the new database.","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ mzsh mzadmin/ db-scripts extract --output-directory \\\n--properties-file ","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When the database and ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"cc15eaa9-e999-4890-bd33-035c6c6f6460","collection":"contentId-111772403","height":"12"}}},{"text":" are not installed on the same machine (the database may be installed on any machine within the network), you need to transfer the database definition files.","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create the new database.","type":"text"}]},{"type":"paragraph","content":[{"text":"For an Oracle database, follow the steps in ","type":"text"},{"text":"Oracle Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD92/pages/111772579"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"For a PostgreSQL database , follow the steps in ","type":"text"},{"text":"PostgreSQL Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD92/pages/111837570"}}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"For a SAP HANA database, follow the steps in ","type":"text"},{"text":"SAP HANA Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD92/pages/111805456"}}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable all workflow groups from the Execution Manager in Desktop, or by entering an mzsh command, for example:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh mzadmin/ wfgroupdisable \\*","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Note!

If you use the wfgroupdisable command, make sure that you enable all system tasks again when you are done.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Note!","type":"text"}]},{"type":"paragraph","content":[{"text":"If you use the ","type":"text"},{"text":"wfgroupdisable ","type":"text","marks":[{"type":"code"}]},{"text":"command, make sure that you enable all system tasks again when you are done.","type":"text"}]}]}],"version":1},"reason":"A note macro in a list item can't be created or edited in the new editor."}}}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Stop all batch workflows and let them finish execution.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Shut down all connected Desktops.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you want to see which Desktops that are connected, you can use the following command:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh mzadmin/ pico -view","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set up the connection to the new database.","type":"text"}]},{"type":"paragraph","content":[{"text":"For Oracle:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ cd ./scripts/system-configure\n$ ./oracle.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"For PostgreSQL:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ cd ./scripts/system-configure\n$ ./postgresql.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"For SAP HANA:","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ cd ./scripts/system-configure\n$ ./saphana.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"When the saphana.sh script is launched without any parameters, it will return a list of expected parameters, an example command output is the following: ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]}]},{"type":"paragraph","content":[{"text":"The user needs to specify the mandatory parameters such as the SQL port where the tenant database is listening. The","type":"text"},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"field indicates the tenant name, while the ","type":"text"},{"text":"","type":"text","marks":[{"type":"em"}]},{"text":" is the name of the directory where the ngbc.jar file is stored. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the platform. ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh restart platform","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Start all ECs that were previously shut down.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh startup ","type":"text"}]},{"type":"paragraph"}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the workflow groups.","type":"text"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"scroll-pagebreak","parameters":{"macroParams":{"_parentId":{"value":"111850793"}},"macroMetadata":{"macroId":{"value":"2de953e2-389b-4d61-8fc3-d0111518066a"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://scroll-exporter-extensions.us.exporter.k15t.app/static/assets/images/macro-icons/scroll-pagebreak.svg"}}],"title":"Scroll Pagebreak"}},"localId":"2dbedd74-7100-4bde-abcc-b09573b7a0d8"}}]}],"version":1}

Changing Platform Database