Yes, once the changes are done, please truncate all the tables in the schema and restore the repository from the beginning.
Hi Smitha, When you say truncate all the tables, does this mean run a SQL query to truncate or is there an Informatica command that should be ran? Should I truncate the Views too?
Also, I assume I will have to run the RetoreDomain command, restore Content from AdminConsole, and run UpdateGatewayNode command. Is this correct?
Yes, you need to delete all the tables/views in the Repository DB schema and restore the contents. Contact your DBA to clear the schema content.
As the issue is related to the Repository schema you need to restore the content from Admincosnole. NO need to perform Restore domain and updategatewaynode.
Hi Smitha, I'm new to this process so excuse all the obvious questions. I thought the RestoreDomain command created the tables/views and the restore content loaded the tables. Does the restore content from AdminConsole create the tables/views? If the DBA deletes the tables/views, will restoring the content suffice?
Yes, Restore content will create the tables and restore the data.
You mention "RestoreDomain", but I understand this is a typo because you are asking about the restoration of a PowerCenter metadata repository.
Getting back to your main query and Smitha's suggestion about truncating the tables, I'd say you can also delete the repository content from Admin Console, without involving the DBA (i.e. Properties => Actions => Content).
Even though the process of restoring the content of a PCRS also fires "DROP TABLE" commands against the DB schema, the documentation indicates that the target database must be empty before running a restore from either GUI/CLI.
I've done the following:
- Stopped the domain
- Requested the DBA to clear the schema content
- The DBA truncated the tables
- I've attempted to start the Informatica service but get error: Cannot start node because the database does not have domain metadata"
I assume I should not have stopped the domain because now it will not startup. the content within those tables are gone. To fix, should I ask the DBA to drop the DB tables (basically, create an empty schema) and then I will run the RestoreDomain command to recreate the tables in the schema? If so, after the tables are recreated, I can restore the content from the AdminConsole?
EDIT: The following was done:
- The DBA has dropped the DB tables.
- I've ran the RestoreDomain command to recreate the tables/views.
- In AdminConsole, I've changed the DatabaseConnectionTimeout value to 600
- In AdminConsole, I've changed the HeartBeatInterval value to 1000
- In AdminConsole, I've changed the Resilience Timeout value to 1000
- In AdminConsole, I've changed the Resilience Timeouts value to 1000
- In AdminConsole, I've refreshed the repository
- I've restored the content. In the AdminConsole, the action to restore the content ran successfully. However, while checking the logs, I still get the error: Not all repository tables have been found when updating statistics.
The Repository database is in SQL Server. It seems the Statistics tables are only found in a SQL Server database and used for database performance and not necessary functionality. Is the statistic tables important or can the error be ignored? If it cannot be ignored, is there a different solution?
First of all, you have to cleanly distinguish between the domain repository and all application repositories (such as the PowerCenter repositories).
The domain repository is vital to the Informatica domain. Without it no application services can run.
The application repositories are necessary for particular application services but not for the domain as a whole.
The command "infacmd.sh RestoreDomain" is used (as its name suggests) to restore the contents of a domain repository database from the respective backup file.
The error message you received has nothing to do with the domain, "only" with a single PowerCenter repository. So you should NEVER temper with the domain repository when dealing with anything related to PowerCenter.
That's the introduction. Now of to your actual questions in the first post.
The timeout values are just "handling" values for the repository service process. Simply restart the PowerCenter repository service after changing any of the timeout values, that's enough (no need to restart the domain).
Also the runtime statistics table may or may not be saved to a PowerCenter repository backup file. You can choose them at will when performing the backup process (which creates the backup file).
When you restore a backup file without the runtime information, then you get this message. You can simply ignore it.
Hi Nico, Thank you for the information.