Informatica Domain Has Become Corrupted and Gives ‘Internal error. Exception Class [class java.lang.AssertionError] Exception Message [null]’ (#Informatica_Domain_Corruption)

Issue:

There could be scenarios, where the Informatica Domain may go corrupt and causes issues while starting services or Services go down abruptly. Below error is what we generally see in such scenarios.

Error: ‘Internal error. Exception Class [class java.lang.AssertionError] Exception Message [null]’

Fix:

Rebuild the Domain using the below steps (Assuming that we have the previous Domain Backup*),

  1. Shutdown the Informatica Services
  2. Take a backup of Domain Schema in Database (using expdp/exp – if using Oracle)
  3. Take the DDL for the schema creation (Privileges and syntax of Schema creation)
  4. Drop the Informatica Domain Schema from Database
  5. Create the schema with same name and privileges, assign the roles
  6. Restore Domain using the Backup,

a) Navigate to $INFORMATICA_HOME/server,

b) ./infasetup.sh RestoreDomain -da <DB_NAME>:<DB_PORT> -du <DOMAIN_SCHEMANAME> -dp <DOMAIN_USER_PASSWORD> -dt <DBTYPE> -ds <DB_NAME> -bf <LOCATION_AND_NAME_OF_DOMAIN_BACKUP>

7. Connect to the schema and make sure, the Domain Schema is restored and is healthy

8. Start the services and validate the environment

 

* – Refer my blog to see how to perform Informatica backups (Domain, Repository)

https://pradeepvattem.wordpress.com/2017/06/23/informatica-pc-domain-and-repository-backups-from-command-line-informatica_backups/

 

Advertisements
This entry was posted in Informatica. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s