Problem 1
Check the configured HOST NAME and PORT for the repository Server
Error Log:
ERROR : REP_12400 [Mon Mar 14 23:17:07 2011] : (2224|4204) Repository Error ([REP_51024] Failed to connect to the repository. Either the server address (<none>) or the port number (5001) is invalid.)
ERROR : REP_12400 [Mon Mar 14 23:17:07 2011] : (2224|4204) Repository Error ([REP_51337] Unable to connect to the repository server on Host <none>, Port 5001. Please check your configuration.)
ERROR : CMN_1006 [Mon Mar 14 23:17:07 2011] : (2224|4204) Failed to connect to repository [INFA_REPO].
FATAL ERROR : SF_34004 [Mon Mar 14 23:17:07 2011] : (2224|4204) Server initialization failed.
Problem 2
Code page was not same for Actual Server and the Workflow manger server that we created
Error Log:
FATAL ERROR : LM_36011 [Mon Mar 14 23:20:01 2011] : (4972|6204) Codepage mismatch. Server is running in codepage [MS Windows Latin 1 (ANSI), superset of Latin1] whereas the server is configured in the Workflow Manager to run in codepage [ISO 8859-1 Western European].
FATAL ERROR : SF_34004 [Mon Mar 14 23:20:01 2011] : (4972|6204) Server initialization failed.
How to troubleshoot the Problem
By enabling service logs
1.Goto Programs-->Informatica PowerCenter-->Informatica Server-->Informatica Server Setup
2.In the Server Tab select the radio button Output log to a file and fill the textbox with valid file path(Text file is fine)
Problem 1 solution
1.Goto Programs-->Informatica PowerCenter-->Informatica Server-->Informatica Server Setup
2.In the Repository Tab update the HOST NAME (Ex:Venki-PC)
Success Log:
INFO : LM_36033 [Mon Mar 14 23:20:01 2011] : (4972|6204) Connected to repository [INFA_REPO] running on server:port [Venki-PC]:[5001] user [Administrator]
INFO : LM_36008 [Mon Mar 14 23:20:01 2011] : (4972|6204) Server name is [INFA_SERVER].
Problem 2 solution
1.Open Workflow manager and login
2.Connect to the INFA_SERVER
3.Right on INFA_SERVER and click on Edit
4.Change the codepage to the MS Windows Latin 1 (ANSI), superset of Latin1
Now restart Repository Server first and then start Informatica Server
Success Log:
INFO : SF_34082 [Mon Mar 14 23:35:10 2011] : (9100|5684) Server starting up.
INFO : LM_36005 [Mon Mar 14 23:35:10 2011] : (9100|5684) Platform validation successful.
INFO : CMN_1053 [Mon Mar 14 23:35:10 2011] : (9100|5684) PowerCenter
INFO : CMN_1053 [Mon Mar 14 23:35:10 2011] : (9100|5684) Copyright (c) 1998-2004 Informatica Corporation
INFO : LM_36009 [Mon Mar 14 23:35:10 2011] : (9100|5684) Informatica PowerCenter Server, version [7.1.1], build [0811], 32-bit.
INFO : LM_36063 [Mon Mar 14 23:35:10 2011] : (9100|5684) (Powered by ZL Engine)
INFO : LM_36069 [Mon Mar 14 23:35:10 2011] : (9100|5684) All Rights Reserved.
INFO : LM_36068 [Mon Mar 14 23:35:10 2011] : (9100|5684) This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.
INFO : SF_34058 [Mon Mar 14 23:35:10 2011] : (9100|2332) Service started.
INFO : SF_34002 [Mon Mar 14 23:35:10 2011] : (9100|2332) Server is initializing.
INFO : LM_36033 [Mon Mar 14 23:35:13 2011] : (9100|2332) Connected to repository [INFA_REPO] running on server:port [Venki-PC]:[5001] user [Administrator]
INFO : LM_36008 [Mon Mar 14 23:35:13 2011] : (9100|2332) Server name is [INFA_SERVER].
INFO : SF_34012 [Mon Mar 14 23:35:13 2011] : (9100|2332) Opened Server Port [4002] to listen for client connections.
INFO : CMN_1570 [Mon Mar 14 23:35:13 2011] : (9100|2332) Server Codepage: [MS Windows Latin 1 (ANSI), superset of Latin1]
INFO : CMN_1569 [Mon Mar 14 23:35:13 2011] : (9100|2332) Server Mode: [ASCII]
INFO : LM_36070 [Mon Mar 14 23:35:13 2011] : (9100|2332) The server is running on a host with 2 logical processors.
INFO : LM_36039 [Mon Mar 14 23:35:13 2011] : (9100|2332) The maximum number of sessions that can run simultaneously is [10].
INFO : CMN_1010 [Mon Mar 14 23:35:13 2011] : (9100|2332) Allocated system shared memory [id = 2700923] of [2000000] bytes for [Load Manager Shared Memory].
INFO : LM_36095 [Mon Mar 14 23:35:14 2011] : (9100|2332) Persistent session cache file cleanup is scheduled to run on [Tue Mar 15 23:35:14 2011].
INFO : SF_34003 [Mon Mar 14 23:35:14 2011] : (9100|2332) Server initialization completed.
Cheers
Winkey
.Informatica Services are automatically stopped but database services are up only.I tried with different possibilities but it is not solved please help me to resolve this issue.
ReplyDelete