Question

Dataset not loading in PSO in UAT environment post 6.9 upgrade (Unable to connect to SIM - no remoting string found)

  • 15 March 2022
  • 2 replies
  • 366 views
T
Rank
Userlevel 2
Badge +3

Hi all, 

FSM/PSO customer receiving following error in PSO application Unable to connect to SIM - no remoting string found error in UAT application. 

 

We noticed Following behaviors in application PSO 

Gateway error

The description for Event ID 1254 from source IFSGWY cannot be found. Either the component that raises this event is not installed on your local c

The description for Event ID 0 from source IFSSIM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

UMBU01MW01*****B

Default

 

Connection request timed out   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)

   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()

   at ThreeSixty.DAL.DbInternalBase.OpenConnection(IDbConnection conn)

 

The handle is invalid

omputer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

SIM

UMBU01MW0***B

Default

BE TELCOMSERV

----------------------------------------------------------------------------------------------------------------------------------------------------------------------


Customer tried to rerun the installer and notice strange behavior, Connection string format is different in UAT than other all environment and when we try to make it similar to DEV it is not accepting.

Example Format 

data source=SERVERNAME:PORT/DATABASE;user id=USERNAME;password=PASSWORD

Configured in UAT

data source=WFMUAT;user id=PSO;password=PSO1;connection timeout=20;command timeout=300;connection lifetime=40;max pool size=20

Configured in Dev

data source=dmbu01db06159b.dev.sdt.ericsson.se:1537/NGWFMTRN;user id=PSO;password=PSO;connection timeout=20;command timeout=300;connection lifetime=40;max pool size=20
Changed URL to Following format , Try to configure, which is not working invalid URL

data source=umbu01db01249b.uat.sdt.ericsson.se:1537/WFMUAT;user id=PSO;password=PSO1;connection timeout=20;command timeout=300;connection lifetime=40;max pool size=20

 

Can someone please let me know if you experienced same issue or got any clue how to proceed forward.


Thank you,

Best Regards,

Teshan

 

This topic has been closed for comments

2 replies

roklde
Rank
Userlevel 6
Badge +23

Hi Teshan,

I suggest to check the following with the customer:

  1. Did they had DB connection issues prior changing the connection string? (as far as I remember the connection string was always like that in UAT)
  2. Did you check the Installer Logs of PSO? Any errors? If the Upgrade was performed by Ericsson - did they perform it correctly?

Possible troubleshooting steps:

  1. Try to stop all PSO Services and shutdown the DB. Reboot Application Servers, start DB and PSO Services.
  2.  Try to check, if you can login to the database from one of the Application Servers by using sqlplus. If that fails as well, then probably it's a DB connection issue and DBA needs to check. (again, check tnsnames.ora for any misconfiguration when using DB connection string with Alias instead of actual hostname)

Best regards

Roman

Ruchira Jayasinghe
Rank
Userlevel 5
Badge +7

Dear Teshan,

 

The databases are not loading as the PSO windows Servers fail to connect to the database and pull the required data.

As I suspect, the issue is with the PSO Installation / infrastructure itself. As corrective actions I would like to suggest;

  1. Use the PSO Installer (uninstall option) and remove all the Windows Services.
  2. Make sure there is nothing left in the location “C:\Program Files (x86)\IFS\Scheduling\”
  3. Then, restart the Database to make sure all the connections are released.
  4. Reinstall the PSO Windows Services.

During this operation, make sure to use the “Database String” option in the database section of the installation wizard and verify the full string.

 

Apart from that, this could happen if the Application Servers do not have connectivity with the database server. If the firewall rules of the servers blocks inbound/outbound operations, this could happen. Further, as Roman also mentioned, there can be a misconfiguration in the tnsnames.

 

Thanks and Regards

Ruchira

Terms & ConditionsCookie settings