web stats
Mirth database tables - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2013, 09:45 AM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 905
StickyBandit is on a distinguished road
Cool Mirth database tables

I can't tell if mirth created the database tables in the oracle db that I put into the Mirth Connect Server Manager settings.

What are the table names so I can look for them?

I got the following error....

ERROR 2013-12-20 10:47:42,543 [Thread-1] com.mirth.connect.server.Mirth: Failed to migrate database schema
com.mirth.connect.model.util.MigrationException: Failed to execute script: oracle-9-3.0.0-1.sql
at com.mirth.connect.server.migration.Migrator.execut eScript(Migrator.java:87)
at com.mirth.connect.server.migration.Migrate3_0_0.mi grate(Migrate3_0_0.java:40)
at com.mirth.connect.server.migration.ServerMigrator. migrate(ServerMigrator.java:63)
at com.mirth.connect.server.controllers.DefaultMigrat ionController.migrate(DefaultMigrationController.j ava:85)
at com.mirth.connect.server.Mirth.startup(Mirth.java: 232)
at com.mirth.connect.server.Mirth.run(Mirth.java:151)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Reply With Quote
  #2  
Old 12-20-2013, 09:50 AM
GregD GregD is offline
Mirth Guru
 
Join Date: May 2010
Posts: 234
GregD is on a distinguished road
Default

In SQL Server Mirth creates these tables.

Greg

ALERT
ALERT_EMAIL
ATTACHMENT
CHANNEL
CHANNEL_ALERT
CHANNEL_SNAPSHOT
CHANNEL_STATISTICS
CODE_TEMPLATE
CONFIGURATION
ENCRYPTION_KEY
EVENT
MESSAGE
PERSON
SCRIPT
TEMPLATE
Reply With Quote
  #3  
Old 12-20-2013, 10:53 AM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 905
StickyBandit is on a distinguished road
Red face still failed

Thanks, I deleted these tables and tried again, but it failed, nothing in the log?
Reply With Quote
  #4  
Old 08-19-2015, 05:16 AM
anno anno is offline
Mirth Newb
 
Join Date: Jan 2013
Posts: 8
anno is on a distinguished road
Default

Hello,
I've a similar problem:
I tried to setup a new installation with mirth connect version 3.2.2.
I want to use an oracle database.
Therefore I switched the database connection information within the server manager, but nothing happens. I do not get any table within oracle.
Is there any script for this version to create the relevant tables?
Until version 2.0.x, I've got an oracle_database.sql script out of the conf folder.
Is there something like this for the current version?

Last edited by anno; 08-19-2015 at 05:32 AM. Reason: additional information
Reply With Quote
  #5  
Old 08-19-2015, 07:53 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,098
narupley is on a distinguished road
Default

Quote:
Originally Posted by anno View Post
Hello,
I've a similar problem:
I tried to setup a new installation with mirth connect version 3.2.2.
I want to use an oracle database.
Therefore I switched the database connection information within the server manager, but nothing happens. I do not get any table within oracle.
Is there any script for this version to create the relevant tables?
Until version 2.0.x, I've got an oracle_database.sql script out of the conf folder.
Is there something like this for the current version?
You just need to create the schema/user in Oracle (e.g. "mirthdb"). Then once MC starts up it will automatically create all the necessary tables within that schema.
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #6  
Old 09-14-2015, 12:05 AM
anno anno is offline
Mirth Newb
 
Join Date: Jan 2013
Posts: 8
anno is on a distinguished road
Default

Hello,
thanks for that hint.
I've done it so far:
drop and create the user
and start mirth in version 3.2.2.7694.
Now I've got
ERROR 2015-09-14 09:34:34,396 [Thread-1] com.mirth.connect.server.Mirth: Failed to migrate database schema
com.mirth.connect.model.util.MigrationException: Failed to execute script: oracle-0-1.sql
at com.mirth.connect.server.migration.Migrator.execut eScript(Migrator.java:91)
at com.mirth.connect.server.migration.Migrator.execut eScript(Migrator.java:74)
at com.mirth.connect.server.migration.LegacyMigrator. migrate(LegacyMigrator.java:24)
at com.mirth.connect.server.migration.ServerMigrator. migrate(ServerMigrator.java:67)
at com.mirth.connect.server.controllers.DefaultMigrat ionController.migrate(DefaultMigrationController.j ava:90)
at com.mirth.connect.server.Mirth.startup(Mirth.java: 246)
at com.mirth.connect.server.Mirth.run(Mirth.java:173)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden

and therefore, I've got
CouldNotLoadArgumentException[ Angegebene Datei/URL konnte nicht geladen werden: http://localhost:8081/webstart.jnlp?time=1442216697564]
Reply With Quote
  #7  
Old 09-14-2015, 12:51 AM
anno anno is offline
Mirth Newb
 
Join Date: Jan 2013
Posts: 8
anno is on a distinguished road
Default

I've found the mistake.
The script worked well.
The created user had to small rights.
after:
GRANT "DBA" TO "MIRTH"
GRANT SELECT ANY TABLE TO "MIRTH" ;
GRANT EXECUTE ANY PROCEDURE TO "MIRTH" ;
GRANT CREATE VIEW TO "MIRTH" ;
GRANT QUERY REWRITE TO "MIRTH" ;
GRANT CREATE MATERIALIZED VIEW TO "MIRTH" ;

it works well!
Reply With Quote
  #8  
Old 09-14-2015, 11:58 PM
Shakurr Shakurr is offline
What's HL7?
 
Join Date: Sep 2015
Posts: 5
Shakurr is on a distinguished road
Thumbs up

Quote:
Originally Posted by anno View Post
I've found the mistake.
The script worked well.
The created user had to small rights.
after:
GRANT "DBA" TO "MIRTH"
GRANT SELECT ANY TABLE TO "MIRTH" ;
GRANT EXECUTE ANY PROCEDURE TO "MIRTH" ;
GRANT CREATE VIEW TO "MIRTH" ;
GRANT QUERY REWRITE TO "MIRTH" ;
GRANT CREATE MATERIALIZED VIEW TO "MIRTH" ;

it works well!
Thank you for sharing





samsung s6 edge schutzhülle

Last edited by Shakurr; 09-15-2015 at 06:11 PM.
Reply With Quote
  #9  
Old 12-15-2015, 08:33 AM
rwilliams rwilliams is offline
OBX.1 Kenobi
 
Join Date: Aug 2010
Posts: 26
rwilliams is on a distinguished road
Send a message via Skype™ to rwilliams
Default

Is there any documentation that shows what the created tables are used for?

Last edited by rwilliams; 12-15-2015 at 08:34 AM. Reason: Added subscription
Reply With Quote
  #10  
Old 12-15-2015, 09:46 AM
obsessio obsessio is offline
OBX.3 Kenobi
 
Join Date: Mar 2015
Location: Turkey
Posts: 164
obsessio is on a distinguished road
Default

Quote:
Originally Posted by rwilliams View Post
Is there any documentation that shows what the created tables are used for?
There is no documentation for backend DB.
I think DB tables are understandable, for example;

MC = Content
MQ = Queue
M = Metadata
MCM = Custom Metadata

Last edited by obsessio; 12-15-2015 at 10:08 AM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 10:47 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation