web stats
Mirth database tables - Page 2 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #11  
Old 12-15-2015, 09:52 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
Default

I made this array for it, a while back.


var MIRTH_TABLES = new Array("ALERT", "ALERT_EMAIL", "ATTACHMENT", "CHANNEL", "CHANNEL_ALERT", "CHANNEL_SNAPSHOT", "CHANNEL_STATISTICS",
"CODE_TEMPLATE", "CONFIGURATION", "ENCRYPTION_KEY", "EVENT", "MESSAGE", "PERSON", "SCRIPT", "TEMPLATE",
"D_M# (message metadata)", "D_MA# (message attachments)", "D_MC# (message content)", "D_MCM# (message custom metadata)",
"D_MM# (message connector-specific metadata)", "D_MS# (message statistics)");
Reply With Quote
  #12  
Old 12-15-2015, 09:55 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

Quote:
Originally Posted by StickyBandit View Post
I made this array for it, a while back.


var MIRTH_TABLES = new Array("ALERT", "ALERT_EMAIL", "ATTACHMENT", "CHANNEL", "CHANNEL_ALERT", "CHANNEL_SNAPSHOT", "CHANNEL_STATISTICS",
"CODE_TEMPLATE", "CONFIGURATION", "ENCRYPTION_KEY", "EVENT", "MESSAGE", "PERSON", "SCRIPT", "TEMPLATE",
"D_M# (message metadata)", "D_MA# (message attachments)", "D_MC# (message content)", "D_MCM# (message custom metadata)",
"D_MM# (message connector-specific metadata)", "D_MS# (message statistics)");


Great! Thank yo for the reply.

-Robert
Reply With Quote
  #13  
Old 12-15-2015, 10:18 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 StickyBandit View Post
I made this array for it, a while back.


var MIRTH_TABLES = new Array("ALERT", "ALERT_EMAIL", "ATTACHMENT", "CHANNEL", "CHANNEL_ALERT", "CHANNEL_SNAPSHOT", "CHANNEL_STATISTICS",
"CODE_TEMPLATE", "CONFIGURATION", "ENCRYPTION_KEY", "EVENT", "MESSAGE", "PERSON", "SCRIPT", "TEMPLATE",
"D_M# (message metadata)", "D_MA# (message attachments)", "D_MC# (message content)", "D_MCM# (message custom metadata)",
"D_MM# (message connector-specific metadata)", "D_MS# (message statistics)");
Thanks for sharing!
Reply With Quote
  #14  
Old 10-16-2016, 12:33 AM
melhefnawy melhefnawy is offline
What's HL7?
 
Join Date: Sep 2016
Posts: 2
melhefnawy is on a distinguished road
Default

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!

I'm using the latest version of Mirth Connect 3.4.2.8129 and I have got same error. I have tried modifying the DB user privilege as explained but nothing happened. Any help?
Reply With Quote
  #15  
Old 10-18-2016, 06:16 AM
melhefnawy melhefnawy is offline
What's HL7?
 
Join Date: Sep 2016
Posts: 2
melhefnawy is on a distinguished road
Default

I solved it by modifying the DB user roles and privileges to be:

user roles: connect & resource ONLY
user privileges: unlimited tablespace ONLY
Reply With Quote
  #16  
Old 06-12-2019, 04:07 AM
Mirthvu14 Mirthvu14 is offline
Mirth Newb
 
Join Date: Jan 2019
Posts: 22
Mirthvu14 is on a distinguished road
Default

Quote:
Originally Posted by GregD View Post
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
Hello,
what data is saved in the 'SCRIPT' table?

For example, In a try\catch i use: e.stack

I see, for example:
at f740ee9a-e740-4cc5-a627-3eaeb8e6db1a:298 (doTransform)
at f740ee9a-e740-4cc5-a627-3eaeb8e6db1a:351 (doScript)
at f740ee9a-e740-4cc5-a627-3eaeb8e6db1a:353

Can I find the ID 'f740ee9a-e740-4cc5-a627-3eaeb8e6db1a' in this table?

Thanks a lot
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:48 AM.


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