Master Data Management & Reference Data Management 🛰️

Discuss, learn, ask, suggest, share all things MDM and RDM 🔍

  • 175 Topics
  • 314 Replies

175 Topics

S
sujmazumData Voyager
asked in Master Data Management & Reference Data Management 🛰️

Encountering NoRouteToHostException Error on OnPublish

The response message was:null and response error was 'errorMsg:java.net.NoRouteToHostException: No route to host    at java.base/sun.nio.ch.Net.connect0(Native Method)    at java.base/sun.nio.ch.Net.connect(Net.java:579)    at java.base/sun.nio.ch.Net.connect(Net.java:568)    at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:593)    at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)    at java.base/java.net.Socket.connect(Socket.java:633)    at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:121)    at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)    at org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:326)    at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:605)    at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:440)  

0
S
1 day ago
M
Mr.DQData Voyager
asked in Master Data Management & Reference Data Management 🛰️

Accessing parent node attributes in XML with repeated tags

I have an xml file with a structure like this:<model xmlns="http://www.ataccama.com">    <entities>        <entity name="table1" />     <columns>             <column datatype="varchar(100)" name="abc" required="false" />             <column datatype="int" name="xyz" required="false" />             <column datatype="datetime" name="123" required="false" />     </columns>...I want to produce a data stream that combines the column name and data_type with the name from the parent entity node.  If I define the columns using xpath nm:model/nm:entitles/nm:entity/nm:columns/nm:column then I cannot access the entity name using ../../@name (or any xpath expression for that matter).  If I define the columns using entity level xpath epxression nm:model/nm:entitles/nm:entity and the columns with xpath nm:columns/nm:column/@name then I only get 1 record per entity with the first column only.   How can I get the entity name, column name, and column data

2
M
2 days ago
S
sriniData Voyager
asked in Master Data Management & Reference Data Management 🛰️

Implement checkpoints in mdm data consolidation process

Hi Team, could someone please assist in getting idea of implementing checkpoints in master data consolidation process.?  as currently we observed MDM follows a one lengthy workflow of MDM data consolidation process from Data acquisition to publish data to the downstream systems [ data acquisition→ change detection → cleansing → match→ and then merge.]  during this entire flow execution if any one of the components failed after few hours due technical some issues, then it is required to restart this entire flow. just to avoid this we wanted to restart the jobs from the point where failure happens, is there any way to breakdown or separate the jobs or implement the check points to restart.? please suggest with the recommendations.Thanks, 

1
P
Ataccamer
13 days ago
C
C_RUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️

Export lookup file

Hi all,Can I export lookup file and import to another environment?  Thanks in advance.

2
Cansu
Community Manager
16 days ago
Fergus
FergusData Voyager
asked in Master Data Management & Reference Data Management 🛰️

Getting logged out far too frequently from RDM

We have recently upgraded to RDM V14.5.0 and are finding that if you leave the screen idle for 5-10 mins the system will log you out and back in immediately. When it logs you back in it has closed all the tables that you had open previously.  Also, when you want to close RDM and press the “Log out” button it more often than not logs you out and then back in again. It takes a 2nd press of the “Log out” button to finally log out. Is there a setting somewhere that will increase the idle time so we don’t keep losing the open tables and is the need for a double log out a bug or some setting that we need to change. Any help would be appreciated.

3
Cansu
Community Manager
20 days ago
S
sriniData Voyager
asked in Master Data Management & Reference Data Management 🛰️

MDM Rest API Services + new columns to the existing model

Hello Team, require help, we are on MDM 13.9.3 → newly added columns to the Instance and Master entities are not visible in REST API calls, do we required to enable any configuration to visible those new attributes in get calls.?  thanks in advance for your inputs.

2
Cansu
Community Manager
21 days ago
O
OjaswiniData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️

Not enough memory to run the plan file.

I want to load around 832,032 records from Excel file to DB table using Plan. Plan is not executing.It giving below error message :-1)Not enough memory to run the plan file. java.lang.OutOfMemoryError: Java heap space     at org.apache.commons.io.IOUtils.byteArray(IOUtils.java:338)     at org.apache.commons.io.output.AbstractByteArrayOutputStream.needNewBuffer(AbstractByteArrayOutputStream.java:104)     at org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:51)     at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:181)     at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:153)     at org.apache.poi.openxml4j.util.ZipArchiveFakeEntry.<init>(ZipArchiveFakeEntry.java:67)     at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:98)     at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:132)     at org.apache.poi.openxml4j.opc.OPCP

9
greglvaughan
1 month ago
maykwok_hamilton
maykwok_hamiltonData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️

RDM REST API (v14.3 or later)

Hello hive mind,Has anyone out there who have RDM v14.3 or later, and successfully used the new RDM REST API feature?We’ve upgraded our dev environment to v14.5.1 this week, I tried the REST API, and it keeps returning with “java.lang.Exception: org.springframework.security.access.AccessDeniedException: Cannot access entity: address_type” error. (Was trying to query my entity called address_type)I ensured my service account client has full access to the table. That service account client calls other API endpoints that I have built before on rdm-server and that authenticates fine.I wonder what I’m missing. Anybody successful before and we can compare notes?Thanks!

4
Cansu
Community Manager
2 months ago
S
sandip IlagData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️

getRowsWithDraftsFailed to determine origin for record party, id = 37104

Hi Team, require help- when clicking on any entity in web URL, popup error box and not able to edit for seach any records.error- "getRowsWithDraftsFailed to determine origin for record party, id = 37104” MDM log capture as per below:2024-02-09 19:24:33,338 ←[39mDEBUG←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:31←[0;39m - actionId=findRecords() status=START2024-02-09 19:24:33,355 ←[31mWARN ←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:51←[0;39m - actionId=findRecords() status=FAILURE message=findRecords() method failed. Error: Failed to determine origin for record party, id = 371042024-02-09 19:24:33,356 ←[31mWARN ←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:51←[0;39m - actionId=findRecords() status=FAILURE message=findRecords() method failed. Description: java.lang.NullPointerException: Failed to determine origin for record party, id = 37104        at com.ataccama.dqc.commons.util.AssertUtil.as

2
Cansu
Community Manager
2 months ago
S
sandip IlagData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️

This user does not have sufficient rights to access the application

Hi All,require help on below error "This user does not have sufficient rights to access the application”.

1
OGordon100
Ataccamer
2 months ago
A
Anonymous
published in Master Data Management & Reference Data Management 🛰️

Keycloak: Login Failures SettingF.A.Q.

Would you like to cover the case what will happen when a user enters her/his credentials incorrectly many times? The setting of Max Login Failure can be set in Keycloak Admin Console, follow these steps:Log into Keycloak Admin Console Go to Realm Settings (Ataccamaone) on the left-hand menu Go to Security Defenses tab Select Brute Force Detection and enable the feature Set the Max Login Failure to the desired amountBrute Force Detection before enablementWhen enabled, all setting can be changed accordingly to your needs Any question or comment? Let us know!

11844
P
Ataccamer
2 months ago
O
OjaswiniData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️

Behavior of Invalid records in RDM Approval workflow

Dear Community,I have query regarding RDM approval workflow. In our project we have stages Initiator → Review → Publish .It has been noticed that when a record is invalid, its status is displayed as 'INVALID,' yet it progresses in the workflow for review. The reviewer has the option to accept this invalid record, and it moves to the Publish section. However, when the approver attempts to publish the record, an error occurs, stating that the record is invalid and cannot be published.The client is now requesting clarification on why an INVALID record is allowed to progress through these stages in the first place. They propose that it should not be permitted to move to the review state initially.Anyone faced this scenario before? Can we do something in approval workflow configuration that record should not move to review state if it is Invalid.Any help regarding this will be really helpful.Best regards,Ojaswini

4
O
2 months ago
J
Ataccamer
joyceAtaccamer
published in Master Data Management & Reference Data Management 🛰️

Running RDM v14.5.0 Locally on MacOS

Download links: https://support.ataccama.com/home/downloads/14.5.0Steps overview:Download all components Install ONE Desktop Launch ONE Desktop and create the RDM Banking example project Place the files in the right structure Modify a bunch of files so they are working on MacOS Configure the Mac permissions to run things Launch ONE Desktop and create the RDM Banking example project Launch it all (keycloak, postrgres), one by oneDownload: Builds (Latest versions here, version picker at the top): RDM: https://ataccama.s3.amazonaws.com/products/releases/rdm-assembly-14.5.0.230901-50963-541c0569-linux.zip ONE Desktop: Ataccama-one-desktop-14.5.0-macos.dmg ONE Runtime: Server-assembly-14.5.0.tar Postgres keycloak: https://ataccama.s3.amazonaws.com/products/releases/keycloak/keycloak-21.1.2-3-demo.zip Plugins (Latest versions here, the official Postgres version for Linux missing for now) Your license (.plf file) Install ONE Desktop:Install One Desktop (Ataccama-one-desktop-14.5.0-m

720
J
Ataccamer
2 months ago
J
Ataccamer
joyceAtaccamer
published in Master Data Management & Reference Data Management 🛰️

Running MDM v14.5 Locally on MacOS

Steps overview:Download all components Install ONE Desktop Launch ONE Desktop and create the MDM CDI example project Place the files in the right structure Modify a bunch of files so they are working on MacOS Configure the Mac permissions to run things Launch ONE Desktop and create the MDM Banking example project Launch it all (keycloak, postrgres, mdm-server, server), one by oneDownload:Builds (Latest versions here): MDM: Mdm-assembly-14.5.0-linux.zip ONE Desktop: Ataccama-one-desktop-14.5.0-macos.dmg  ONE MDM Server: Mdm-server-assembly-14.5.0-linux.zip   Plugins (Latest versions here, the official Postgres version for Linux missing for now): Postgres:  https://drive.google.com/file/d/1Lho_9BQh78xRWR2QHAAGoQuERof-Rn-e/view?usp=sharing  Keycloak: https://ataccama.s3.amazonaws.com/products/releases/keycloak/keycloak-21.1.2-3-demo.zip Your license (.plf file)Install ONE Desktop:Install ONE Desktop (Ataccama-one-desktop-14.5.0-macos.dmg) Rename the application so that there

600
J
Ataccamer
2 months ago
S
sgillaData Pioneer
asked in Master Data Management & Reference Data Management 🛰️

How to delete orphan but active records on source and instance table

How to delete orphan but active records on source and instance table in Omnihealthdata. The records were deleted at source but the load to onramp was missed for delete batch. Is there other way I could delete these records from _s(source) and instance tables? Is a manual SQL delete a right way to go with or would it cause any future issues?

4
S
3 months ago
maykwok_hamilton
maykwok_hamiltonData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️

RDM import data by API call online service - how to get the id back out in the response?

I’m using RDM 14.2 (soon to be upgraded to 14.5) and I need to build an API endpoint to accept incoming data.I have an integration input and will use an RDM Importer step to import the data into my table.My table has a generated id as a primary key and I need to provide the generated id as a response back to the incoming API call.But the RDM Importer step stops there. It doesn’t tell me the id. How do I then get the id back? I could make an RDM Extended Reader step in the plan, but I cannot guarantee the Reader step is executed after the Importer step, because the Importer step doesn’t have an out endpoint, it only has an err endpoint. And if I query the data before the insert is committed then I will end up with nothing to provide. Any ideas? (I believe the new RDM REST API functionality is read only so that won’t be relevant here?)

2
maykwok_hamilton
3 months ago
A
AkashUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️

How can we ingest data from RDM tables in ataccama to either to Snowflake or Amazon S3.

My requirement is to get all the RDM tables in Ataccama to Snowflake or to amazon S3.Could anyone please let me know how to do that.

5
A
Ataccamer
3 months ago
A
Ajay ShuklaData Voyager
asked in Master Data Management & Reference Data Management 🛰️

MDM Licensing model

Hi Team, Can anyone please help me with below Information on MDM licensing?Is Ataccama MDM licensing model based on number of records that we load form various sources (unconsolidated) or based based on unique profiles in MDM (Consolidated) Apart from number of records, are there other aspects that affects licensing price like the domain that I want to master (Customer/Product/Location etc.), the number of API calls, the number of batch jobs that execute per day, total volume required to host source records + history + merge history etc. ? Any other factor that is required to calculate MDM licensing cost? 

1
Cansu
Community Manager
3 months ago
K
KundanData Pioneer
asked in Master Data Management & Reference Data Management 🛰️

Ataccama MDM setup

Hi Team ,Can anyone please help me setup my MDM environment locally .Please help me with the plugins and folder structure .Regards,Kundan 

4
Cansu
Community Manager
4 months ago
S
sandipilagData Voyager
asked in Master Data Management & Reference Data Management 🛰️

Upgrade Ataccama from 13.8 version to higer one (Latest one)

Hi Team,I need to upgrade my ataccama 13.8 to new latest one…. request you to please provide upgrade version download path or URL's. As I am facing some issue on current repository-  ";Cannot instantiate class: com.ataccama.dqc.jms.sqs.SQSInitialContextFactory”

2
S
4 months ago
M
MayureshData Voyager
asked in Master Data Management & Reference Data Management 🛰️

pgsql not working in MDM template project.

I am working on template project for MDM and i am not able to run the pgsql script in it and i did followed the steps mentioned in this  MDM Example Project - Ataccama ONE Gen2 Platform Latest Kindly let me know if you have any solution for this.   

3
DannyRyan
Ataccamer
4 months ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️

RDM Record ValidityBlog

When working with Reference Data table there may be a business requirement to control what kind of values can be input into a given attribute which are checked whenever a user creates or edits records within the RDM application. There are two kinds of validations:  The first kind are called Instantaneous validations. These conditions, e.g., regular expressions or string size are checked automatically when you enter an attribute value. When the input value fails to meet these condition, an INVALID message appears next to the attribute field. The second kind are called Online validations. These are more complex conditions, which are triggered by clicking Validate in the Create detail/Edit detail dialogue or upon closing them. Such validations are performed by DQC plans (using, e.g., phone number or address lookups) or SQL queries in RDM. When the input value fails to meet these condition, a Warning message appears next to the attribute field.Records which do not satisfy online conditions

1073
Joeri
4 months ago
A
AkashUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️

Integrated Login for database

Hi Team,In Ataccama IDE, while connecting to database we need to provide connection string. Also, username and password. In other tools like SQL server, we can use windows authentication to login so no need to enter username and password.Could you please help me how we can achieve the same integrated login for database connection. 

4
Cansu
Community Manager
4 months ago
N
NatarajanData Voyager
asked in Master Data Management & Reference Data Management 🛰️

RDM web admin console connection issue

HTTP ERROR 404 Not FoundURI: /rdm STATUS: 404 MESSAGE: Not Found SERVLET: com.ataccama.server.http.ServletContextDispatcher-5eefa415

2
Cansu
Community Manager
5 months ago
M
MayKwokData Pioneer L2
published in Master Data Management & Reference Data Management 🛰️

Ataccama Admin Centre: ServerConfig and RuntimeConfig for beginners (Self-managed installations) 1/2Tutorial

Introduction What is the Ataccama Admin Centre? Where is Ataccama Admin Centre? What are the serverConfig and runtimeConfig files? Where do I start? Where are these configuration files? Sample project structure What is inside the configuration files? ServerConfig RuntimeConfig IntroductionThis is an introduction to the Ataccama Admin Centre serverConfig and runtimeConfig files:What the files are and where to find them How to setup security on the Admin Centre UI itself How to setup an online service endpoint on Admin Centre How to setup Admin Centre to enable the run of schedulers, workflows and plans / componentsThe intended audience for this article are Power Users for Ataccama ONE. Power Users may have built some plans / components / workflows / schedulers / online services, and are now looking to host them on a server environment. What is the Ataccama Admin Centre?The Atacccama Admin Centre can also be referred to as the “ONE Runtime Server”. For the purposes of this document, we

6422
Cansu
Community Manager
5 months ago

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Terms & ConditionsCookie settings