Solved

Connect Server UnauthorizedAccessException

  • 21 June 2022
  • 6 replies
  • 337 views

Userlevel 5
Badge +11

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 [Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.net.ConnectException: Connection refused: connect [Error GUID:0f5416e9-ee04-4ec7-9e3e-248ee79eeff0]
2022-06-21 21:51:34,215   1 INFO [Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:51:59,425   1 ERROR [Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error GUID:3e4ce943-aa72-471d-a7c0-f56b0cf583f6]
2022-06-21 21:51:59,425   1 INFO [Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:52:21,975   1 ERROR [Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error 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 [Error 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 [Error GUID:4bffe48f-9a14-44bf-bd90-f623ed5cf28c]
2022-06-21 21:53:12,496   1 INFO [Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:53:40,572   1 ERROR [Integration] StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error 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 [Error GUID:42d0f795-fc7d-4911-9b60-8406ed5cca6c]
2022-06-21 21:54:10,761   1 INFO [Integration] StaServer.checkServerUrl(): Connection to application server failed and trying again....
2022-06-21 21:54:27,139   1 ERROR [Integration] StaServer.checkServerUrl(): checkServerURL/Exception : ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized access [Error 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. [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 [Integration] ConnectorLoader.<init>():  [Error 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] 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... [Error 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 [Error GUID:0f5416e9-ee04-4ec7-9e3e-248ee79eeff0]
2022-06-21 21:51:59,425   1 ERROR [Integration] 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 [Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error GUID:91fa5ea3-e214-49ba-afdf-2f9018650db1]
2022-06-21 21:52:46,305   1 ERROR [Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error GUID:3f3494f3-3c14-481c-85fd-4d5df5cb20c6]
2022-06-21 21:53:12,496   1 ERROR [Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error GUID:4bffe48f-9a14-44bf-bd90-f623ed5cf28c]
2022-06-21 21:53:40,572   1 ERROR [Integration] ifs.fnd.ifw.sta.StaServer.checkServerUrl(): checkServerURL/Exception : java.lang.NullPointerException [Error 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 [Error 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 [Error GUID:8d2aff09-a9c6-416d-b483-52e620b86520]
2022-06-21 21:54:27,311   1 ERROR [Integration] 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 [Integration] ifs.fnd.connectserver.setup.ConnectorLoader.<init>():  [Error 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 [Integration] ifs.fnd.ifw.sta.StaServer.init(): Shutting down server... [Error GUID:4fdb4d48-5fb9-4345-93bb-d621e74612ee]
 

 

icon

Best answer by baris.halici 22 June 2022, 15:58

View original

6 replies

Userlevel 5
Badge +15

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

Userlevel 5
Badge +11

Hello @knepiosko,

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

Userlevel 5
Badge +12

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

Userlevel 5
Badge +11

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

Userlevel 7
Badge +31

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!

Userlevel 5
Badge +11

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