What are the main scenarios validated with ORS disabled in the Hub Console?

Can users use passwords to connect to ORS in SSMS tools? - Customers should contact their DBA team

Log in to the JBoss console and test if the data source connection was successful. Customers should contact the JBoss team for this.

Test tnsping from application server to database server - see if this is successful

Connect to the database from the MDM server using sqlcmd using both cmxsystem and its username.

Enter the below mentioned query placeholders.

sqlcmd -S -U -P -q "select * from C_REPOS_DB_RELEASE"

Clients must follow the above steps in the command prompt of the MDM server to connect to the database server.

If you run the above command successfully, you should see the result of C_REPOS_DB_RELEASE.

Verify that a specific ORS user can login successfully through SQL Server Management Studio

Run data source connection test in Jboss.

After successful testing, you should restart the app server Jboss.

After completing both, download the Hub Console again and validate the ORS.

File permissions like read, write and execute permissions is possible or not on cmxserver file using log4j.xml in informatica MDM?

No, Master Data Management (MDM) cannot use log4j.xml to provide file permissions such as read, write, and execute permissions for cmxserver files.

Through log4j.xml you can configure MaxFileSize, MaxBackupIndex, thresholds, and set parameters such as com.informatica and com.siperian.

How to overcome Custom validation error messages defined in lookup fields are not displayed in E360?

If a validation clean-up function is defined for the lookup field and that function returns a custom validation message, the custom message will not be displayed. Instead, only the generic validation message "SIP-50022: Validation failed" is displayed. Fields that caused validation errors are not highlighted.

Error message be like

SIP-50022: Validation failed.'

As a workaround, you can add a dummy input to your clean map that does not need to be linked to other elements in your map. This can be mapped to a lookup field in your deployment.

This will highlight the appropriate field and display a custom his message in a tooltip box if validation fails.