Skip to main content

Hello Community,

I changed the ifsconnect user password. I made the password change from the "change system user passwords" in the installer. I changed both the "oracle user password" and "instance configuration" from the installer. 
But, connectserver is not working. I tried many ways; I delete instance, I create new instance. none of them was a solution. services were started using stop_all_server.cmd - start_all_server.cmd. once all services were uninstalled with uninstall_services.cmd and reinstalled.

I am sharing the connectserver logs with you. I need your urgent help. Thank you in advance for your support.

connectserver1_PROD_service.log

Log file 'C:\ifs\instance\PROD\logs\connectserver1_PROD_service.log' open at 220621 21:51:24
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: INSTANCE = 'PROD'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.NAME = 'IFSConnectServer1PROD(C_ifs)'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: INSTANCE = 'PROD'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.DISPLAY_NAME = 'IFS ConnectServer1 PROD (C:\ifs)'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: JAVA_HOME = 'C:\ifs\java\jre'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: CLASSPATH = 'C:\ifs\javaruntime\connectserver.jar;C:\ifs\javaruntime\entities.jar;C:\ifs\javaruntime\documents.jar;C:\ifs\javaruntime\enumerations.jar;C:\ifs\mw_home\as\wlserver\server\lib\wljmsclient.jar;'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: INSTANCE = 'PROD'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: IFS_HOME = 'C:\ifs'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: LOGGINGCONFIG = 'connectserver1-logging.properties'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: NAME = 'CONNECT_SERVER1'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.CMD_LINE = 'C:\ifs\java\jre\bin\java -server -Xrs -Xmx768m -cp C:\ifs\javaruntime\connectserver.jar;C:\ifs\javaruntime\entities.jar;C:\ifs\javaruntime\documents.jar;C:\ifs\javaruntime\enumerations.jar;C:\ifs\mw_home\as\wlserver\server\lib\wljmsclient.jar; -Dfndext.instance=PROD -Dfndext.home=C:\ifs -Dfndext.loggingConfig=connectserver1-logging.properties -Dfndext.daemon.mode=true ifs.fnd.connectserver.ConnectorServer INS=CONNECT_SERVER1'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.SHOW_GUI = 'N'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.AUTO_START = 'Y'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.PRIORITY_CLASS = 'NORMAL'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.CHECK_INTERVAL = '300000000'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.RESTART_THRESHOLD = '300000000'
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: SERVICE.RESTART_DELAY = '5'
220621 21:51:24: ServiceStart()
C:\ifs\instance\PROD\bin\start_connectserver1.ifm: NLS_LANG = 'AMERICAN_AMERICA.UTF8'
Set env var : NLS_LANG=AMERICAN_AMERICA.UTF8
Shutdown port number generated.
Shutdown command generated.
Shutdown environment variables set.
Starting new process: C:\ifs\java\jre\bin\java -server -Xrs -Xmx768m -cp C:\ifs\javaruntime\connectserver.jar;C:\ifs\javaruntime\entities.jar;C:\ifs\javaruntime\documents.jar;C:\ifs\javaruntime\enumerations.jar;C:\ifs\mw_home\as\wlserver\server\lib\wljmsclient.jar; -Dfndext.instance=PROD -Dfndext.home=C:\ifs -Dfndext.loggingConfig=connectserver1-logging.properties -Dfndext.daemon.mode=true ifs.fnd.connectserver.ConnectorServer INS=CONNECT_SERVER1
Process successfully started
220621 21:51:24: Waiting...
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called
service_ctrl(4) called

 

ifsconnect.0.log

2022-06-21 21:51:34,215   1 ERROR RIntegration] StaServer.checkServerUrl(): checkServerURL/Exception : java.net.ConnectException: Connection refused: connect eError GUID:0f5416e9-ee04-4ec7-9e3e-248ee79eeff0]
2022-06-21 21:51:34,215   1 INFO IIntegration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:51:59,425   1 ERROR EIntegration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException pError GUID:3e4ce943-aa72-471d-a7c0-f56b0cf583f6]
2022-06-21 21:51:59,425   1 INFO 1Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:52:21,975   1 ERROR 1Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException cError GUID:91fa5ea3-e214-49ba-afdf-2f9018650db1]
2022-06-21 21:52:21,975   1 INFO Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:52:46,305   1 ERROR Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException EError GUID:3f3494f3-3c14-481c-85fd-4d5df5cb20c6]
2022-06-21 21:52:46,305   1 INFO Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:53:12,496   1 ERROR Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException eError GUID:4bffe48f-9a14-44bf-bd90-f623ed5cf28c]
2022-06-21 21:53:12,496   1 INFO 9Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:53:40,572   1 ERROR 7Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException nError GUID:f09692cd-92f8-4650-8695-74e94f3279d4]
2022-06-21 21:53:40,572   1 INFO ,Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:54:10,761   1 ERROR ,Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException oError GUID:42d0f795-fc7d-4911-9b60-8406ed5cca6c]
2022-06-21 21:54:10,761   1 INFO 1Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:54:27,139   1 ERROR 2Integration] StaServer.checkServerUrl(): checkServerURL/Exception : ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access aError GUID:8d2aff09-a9c6-416d-b483-52e620b86520]
2022-06-21 21:54:27,311   1 ERROR :Integration] ParameterList.<init>(): Error while fetching system configuration; #1 try. iError GUID:1d1e899b-c38e-49c2-9e8d-5dece2590505]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR jIntegration] ConnectorLoader.<init>():  OError GUID:2bb90784-d8d5-4b21-8b6d-dd1b6855b27d]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR cIntegration] StaServer.init(): Fatal error! /Error GUID:c14f66f3-8ba9-41d3-b6ec-0de1659b3e31]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR Integration] StaServer.init(): Shutting down server... SError GUID:4fdb4d48-5fb9-4345-93bb-d621e74612ee]
2022-06-21 21:54:27,327  13 INFO Integration] StaServer$ShutdownHook.run(): Server stopped.

 

ifsalert.0.log

2022-06-21 21:51:34,215   1 ERROR Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.net.ConnectException: Connection refused: connect wError GUID:0f5416e9-ee04-4ec7-9e3e-248ee79eeff0]
2022-06-21 21:51:59,425   1 ERROR oIntegration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException Error GUID:3e4ce943-aa72-471d-a7c0-f56b0cf583f6]
2022-06-21 21:52:21,975   1 ERROR aIntegration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException RError GUID:91fa5ea3-e214-49ba-afdf-2f9018650db1]
2022-06-21 21:52:46,305   1 ERROR vIntegration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException OError GUID:3f3494f3-3c14-481c-85fd-4d5df5cb20c6]
2022-06-21 21:53:12,496   1 ERROR aIntegration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException RError GUID:4bffe48f-9a14-44bf-bd90-f623ed5cf28c]
2022-06-21 21:53:40,572   1 ERROR jIntegration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException RError GUID:f09692cd-92f8-4650-8695-74e94f3279d4]
2022-06-21 21:54:10,761   1 ERROR Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException EError GUID:42d0f795-fc7d-4911-9b60-8406ed5cca6c]
2022-06-21 21:54:27,139   1 ERROR :Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access kError GUID:8d2aff09-a9c6-416d-b483-52e620b86520]
2022-06-21 21:54:27,311   1 ERROR TIntegration] ifs.fnd.connectserver.setup.ParameterList.<init>(): Error while fetching system configuration; #1 try. Error GUID:1d1e899b-c38e-49c2-9e8d-5dece2590505]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR eIntegration] ifs.fnd.connectserver.setup.ConnectorLoader.<init>():  oError GUID:2bb90784-d8d5-4b21-8b6d-dd1b6855b27d]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR /Integration] ifs.fnd.ifw.sta.StaServer.init(): Fatal error! )Error GUID:c14f66f3-8ba9-41d3-b6ec-0de1659b3e31]
ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access
    at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java:605)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:338)
    at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java:389)
    at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:188)
    at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:104)
    at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:121)
    at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:73)
    at ifs.fnd.ifw.sta.StaServer.init(StaServer.java:109)
    at ifs.fnd.ifw.sta.StaServer.main(StaServer.java:285)
    at ifs.fnd.connectserver.ConnectorServer.main(ConnectorServer.java:118)
2022-06-21 21:54:27,327   1 ERROR eIntegration] ifs.fnd.ifw.sta.StaServer.init(): Shutting down server... nError GUID:4fdb4d48-5fb9-4345-93bb-d621e74612ee]
 

 

Are You able to login to the database instance with new password? Is 0racle account  unlocked?


Hello @knepiosko,

Yes, I tried to login with users. I can login. And all IFS user status are OPEN.


Hi @baris.halici ,

Do you have any other IFS MWS instances installed on the same server which might be having a port conflict with PROD instance? 

It’s bit strange that IFSCONNECT user account is not getting locked after certain amount of wrong password login attempts to the database if you’re using same default oracle profile for IFS users

 

Alternatively what will happen if you shutdown the windows service (connect) and start the connect server from CMD?

 

<ifs_home>\instance\<instance_name>\bin\start_connectserver1.cmd


Hi @Ruchira ,

There is no other instance of IFS MWS. We only have one Example.

I tried running Connectserver again. I didn't get user password lock error. This also worries me. Yes, i think it's strange too.

I keep getting the same 401 error even though I uninstalled and reinstalled all services.

 

Regards,

Baris


Hi @baris.halici,

Since you mentioned you used “change system user passwords” option in the installer, could you try using the reconfiguration option instead and then changing the password? Make sure to select the option to change the database password as well when you do.

Hope this helps!


Hi @Charith Epitawatta ,

I tried all the methods mentioned. but the source of the problem is very different.

 

Thank you all for your interest and help.

The solution is very easy, it can be very hard to spot :)

We get connectserver1 401 error because ifsconnect user has inactive status in the application. The problem is solved by making the IFSCONNECT user status active. :)

 

Cheers,

Barış


Reply