How can I assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb

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.

Dieter

designer systemdb mssql

asked 07.09.2016 at 11:12

Dieter Staudt
(suspended)
accept rate: 50%

2 Answers:

active answers oldest newest most voted

Create a Database Configuration:

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

Open the SQL query window and execute:

SCRIPT 'c:/temp/myHsqlDbExport.sql' to export the full system db schema plus its content
DROP SCHEMA PUBLIC CASCADE removes the default system db after a restart
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.

link

answered 08.09.2016 at 14:57

Reguel Werme... ♦♦
9.4k●3●19●58
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

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... ♦♦

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

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

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.
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.
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

I'd try to work with a delta insert.

Start a Designer with an empty workspace
Export the SystemDb at the current state
Import your project and start the engine
Create your tasks that you wan't to re-use
Export the SystemDB again
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... ♦♦

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.

link

answered 07.09.2016 at 12:47

Reguel Werme... ♦♦
9.4k●3●19●58
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

Follow this question

By Email:

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

By RSS:

Answers

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

learn more about Markdown

Tags:

designer ×78
systemdb ×14
mssql ×5

Asked: 07.09.2016 at 11:12

Seen: 3,045 times

Last updated: 12.09.2016 at 08:45

How can I assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb

Follow this question

Related questions