Questions Tagged With systemdb

Where do the //inject.ivp tasks come from?

DanielGauch — Thu, 22 Aug 2019 11:45:18 -0400

Hi there

I recently checked our task database and I found out, that there is a huge number of tasks having a request path similar to these:

137869A7988738D3/137869A7988738D3-f0/inject.ivp
14C5C59BB225874A/14C5C59BB225874A-f7/inject.ivp
...

Does anybody have a clue where they come from?

Thanks and cheers, Daniel

Engine Performance Issue

a_v_a — Tue, 06 Aug 2019 09:54:35 -0400

Hello,

I want to ask what would be the impact of not setting up Character set & collation for the system DB as per Axon Ivy's Engine Installation guide? Could it lead to performance issues?

Thanks,

Huge MySQL/MariaDB System Database has slow response time

SupportIvyTeam — Mon, 04 Feb 2019 10:43:40 -0500

I've got so far some ivy engines running with mysql and mariadb as system database. The databases are huge, with about 10'000'000 tasks. With more and more tasks the responding time will be slower. The more tasks in the database, the worse the response times. Is there anything I can do to optimize this?

Where to get an Entity Relation Diagram (ERD) of the Axon.ivy System DB

SupportIvyTeam — Thu, 24 May 2018 06:25:53 -0400

Is there any schema documentation available that show the relations of the tables in the Axon.ivy system database?

ORACLE 12 in Ivy6

josef_koupal — Fri, 13 Apr 2018 08:17:26 -0400

Hallo!

Ich kann nicht mit Ivy 6.0.12 (Säntis) (Designer oder Server) zu Oracle 12.2.0.1.0 nicht verbinden. Fehler ist: Error: ORA-28040: No matching authentication protocol. Ideen ?

Cleanup of cases (and tasks) via an IVY Process causes to Database Deadlocks

Dieter Staudt — Thu, 08 Jun 2017 07:34:33 -0400

I refer to the question # “478 - How to cleanup old Cases / Tasks?” with my questions:

“Triggers in the XpertIvySystemDatabase” Among other triggers there is a trigger when deleting cases and when deleting tasks. Because the installing and setup of IVY was done many years ago by a former colleague so my first question is: Were all triggers delivered by AXONIVY?
“Cleanup of old Cases and Tasks” We use an timer triggered Ivy Process for the Cleanup with the sql-statement for deleting finished cases: “DELETE FROM IWA_Case WHERE DATEDIFF(dd, EndTimestamp, GETDATE()) > in.TimestampString.

The Timestampstring contains the number of days the finished cases will be stored.

For example: “DELETE FROM IWA_Case WHERE DATEDIFF(dd, EndTimestamp, GETDATE()) > 7” will delete all finished cases older than 7 days.

As mentioned in my first question, all Delete-Statements in the CASE-DELETE-Trigger and all the nested Delete-Statements in the TASK-DELETE-Trigger will be executed automatically.

This causes to Database-Deadlocks – see one Message of our Nagios tool:

5 deadlocks detected on LUXDB004

spid status loginame hostname blk open_tran dbname cmd waittype waittime last_batch SQLStatement 
66 suspended sa_ivy LUXAS004 0 2 IvyDb DELETE 0044 6 Jun 6 2017 08:58:20:460PM DELETE IWA_TaskData FROM IWA_TaskData, deleted WHERE IWA_TaskData.TaskId = deleted.TaskId \n \n
66 suspended LUXAS004 0 0 IvyDb DELETE 00bb 76873 Jun 6 2017 08:58:20:460PM DELETE IWA_TaskData FROM IWA_TaskData, deleted WHERE IWA_TaskData.TaskId = deleted.TaskId \n \n
66 suspended LUXAS004 0 0 IvyDb DELETE 00bb 71822 Jun 6 2017 08:58:20:460PM DELETE IWA_TaskData FROM IWA_TaskData, deleted WHERE IWA_TaskData.TaskId = deleted.TaskId \n \n
66 suspended LUXAS004 0 0 IvyDb DELETE 00bb 49495 Jun 6 2017 08:58:20:460PM DELETE IWA_TaskData FROM IWA_TaskData, deleted WHERE IWA_TaskData.TaskId = deleted.TaskId \n \n
66 suspended LUXAS004 0 0 IvyDb DELETE 00bb 55455 Jun 6 2017 08:58:20:460PM DELETE IWA_TaskData FROM IWA_TaskData, deleted WHERE IWA_TaskData.TaskId = deleted.TaskId \n \n

What is wrong? What must we do to avoid this deadlocks?

Thanks in advance. Dieter

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

Dieter Staudt — Wed, 07 Sep 2016 11:12:26 -0400

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

How to improve performance of MSSql system database with jTDS driver (many temporary files)

SupportIvyTeam — Wed, 07 Sep 2016 09:25:31 -0400

If I use an Microsoft SQL Server as System Database and access it with the jTDS driver. Then I have many temporary files (jdtsXYZ.tmp) stored with clob and blob data in the temp folder. How can I avoid that they are created? Because it is obvious that the performance of storing such files is not as good as if the data is only held in memory.

SQL Select all Cases that belong to a specific Process Model Version

SupportIvyTeam — Wed, 11 May 2016 10:43:21 -0400

How would a SQL select statement look like, that returns all Cases that run in a specific Process Model Version?

How to connect To SystemDB using Windows-Authentification

Alexis — Wed, 05 Aug 2015 14:35:29 -0400

How do I connect to Ivy System DB using the Windows-Authentification?

Create System-DB on DB-Server without EngineConfigurationUI

SupportIvyTeam — Tue, 17 Feb 2015 14:08:17 -0500

With the AxonIvyEngineConfigurationUI I can create a MS-SQL DB on my developer workstation. In production I do not have enough rights to create a System-DB on the SQL Server. So our operations team must create the empty System-DB without Java on the DB-Server. Is there a dump that can be used to for this task?

Access designer system db

matej_smetana — Fri, 10 Oct 2014 09:34:58 -0400

Hi, I would like to know how to add connection to the system database of the designer next to other connections. This would allow me to browse systemdb via database elements.

Thanks a lot.

Can I retry a Database conversion after a failed run?

Nathalie — Tue, 17 Jun 2014 12:41:42 -0400

Because we had to move the ivy environment from one server to another, we did a backup of the ivy db and restored it to the new environment (for test and prod).

The convertion on the first system was successful. Trying to convert the Ivy System database on the second we got the error: Failure while system database conversion: Error 'Column names in each table must be unique. Column name 'BusinessCalendarId' in table 'IWA_Application' is specified more than once.' while executing statement 'ALTER TABLE IWA_Application ADD BusinessCalenderId INTEGER NULL'

how can we solve the problem?

Thanks

Manipulate users directly in the system DB of Ivy

Steffen Janthor — Wed, 27 Jan 2010 02:48:25 -0500

In the mean time we have around 140 users with 16 roles in our application. To improve the administration we created a SQL query. The query works perfect to see the user-role assignments. But as soon as we want to change the assignments with SQL, it does not work properly. We always have to re-start the server.