Hello together,

in my Designer environment all cases, tasks etc. will only be available through the actual session; after close/reopen the Designer all this informations are lost und for example the TaskQuery will not work.

In the meantime I defined the SystemDb as a Hypersonic SQL DB in the Memory (like Q&A#996) but all the informations are also lost after restart the Designer.

Is there a way to assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb or to save the Hypersonic MemoryDb to MS-SQL to store all the contents permanently for further developing and testing?

Thanks in advance.


asked 07.09.2016 at 11:12

Dieter%20Staudt's gravatar image

Dieter Staudt
accept rate: 50%

Create a Database Configuration:

  • database = Hypersonic SQL Db
  • driver = HSQL Db Memory
  • DatabaseName = AxonIvySystemDatabase

Open the SQL query window and execute:

  1. SCRIPT 'c:/temp/myHsqlDbExport.sql' to export the full system db schema plus its content
  2. DROP SCHEMA PUBLIC CASCADE removes the default system db after a restart
  3. Paste the content of the previously exported SQL file to re-create the old version

Normally you will run into escaping and encoding problems in the last step. A practical solution could be that you only re-import the INSERT statements instead of the whole SCHEMA+DATA to avoid these problems.


answered 08.09.2016 at 14:57

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
accept rate: 70%

edited 08.09.2016 at 14:57

Dear Sir,

thank you for your answer. Sorry, where can I found the Export-SQL-Script? There was no attachment to the e-mail or our virus detection has deleted it.

Best regards Dieter Staudt

(08.09.2016 at 15:12) Dieter Staudt Dieter%20Staudt's gravatar image

Reguel is ok :)

the export script will be written to the path you specify as parameter. In the example above the file c:/temp/myHsqlDbExport.sql will be written when the command is executed...

(08.09.2016 at 15:14) Reguel Werme... ♦♦ Reguel%20Wermelinger's gravatar image

Dear Reguel, thank you. the first step works fine - I have all "my" case- and task-data etc. No I must try to restore this sql-file.

(08.09.2016 at 15:44) Dieter Staudt Dieter%20Staudt's gravatar image

Dear Reguel,sorry. It's me again. All tries restoring the saved database don't work.

  1. DROP... and COPY the complete saved file into the db window the error message "invalid schema name in statement (CRATE SCHEMA PUBLIC AUTHORIZATION DBA ) apperas.
  2. Only COPY of all INSERT statements: following error message "violation of unique constraint SYS_PK_48: duplicate value(s) for column(s) ... of the first table form the instert statements" appears.
  3. and DELETE and INSERT do not work because there are problems with missing forreign keys and so on. Do you have any idea? Best regards Dieter
(09.09.2016 at 13:06) Dieter Staudt Dieter%20Staudt's gravatar image

I'd try to work with a delta insert.

  1. Start a Designer with an empty workspace
  2. Export the SystemDb at the current state
  3. Import your project and start the engine
  4. Create your tasks that you wan't to re-use
  5. Export the SystemDB again
  6. Work with a diff tool like WinMerge or similar to find the differences between the first and the second DB export. Try to only apply these insert statements which we're added by your engine start + task creations after a re-boot of the engine
(12.09.2016 at 08:44) Reguel Werme... ♦♦ Reguel%20Wermelinger's gravatar image

You can setup a standalone DB (like MsSql) with an Axon.ivy Engine Configuration UI. To run this DB in a Designer simply copy the /configuration/serverconfig.xml of the engine into your designer. With this approach you will need a license as well for the designer.


answered 07.09.2016 at 12:47

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
accept rate: 70%

Dear Reguel (is it ok?)

Is there no possibility to store the content of the Hypersonic MEMORY Database for developing and testing functions like ITask, TaskQuery etc.? Now I must create every day new cases and tasks in the Designer.

Best regards Dieter

(07.09.2016 at 14:00) Dieter Staudt Dieter%20Staudt's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 07.09.2016 at 11:12

Seen: 1,685 times

Last updated: 12.09.2016 at 08:45