Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

After updating Spider LCM to 6.1 Columbus/iSpiderColumbus cannot connect anymore to LCM

After updating Spider LCM to 6.1 Columbus/iSpiderColumbus cannot connect anymore to LCM

Summary

After an update of Spider LCM to version 6.1 you get an error when trying to do an export from Columbus to Spider Asset.

Symptoms

After an update of Spider LCM to version 6.1 you will get the following error when trying to do an export from Columbus to Spider Asset:

 

Initialize connection process to : http://<SpiderServer>/ISpiderColumbus/ISpiderColumbus.asmx
Attach to SOAP interface...
Get remote system info...
Remote interface (ISpiderColumbus) version is: 6.1.1.0

Databasename: Spider_Core, Servername: <SpiderSQLInstance>, Active True
Databasename: Spider_Asset, Servername: <SpiderSQLInstance>, Active True
Retrieving Session ID...
Server was unable to process request. ---> The authentication of user failed.
Retrieving Session ID...
Server was unable to process request. ---> The authentication of user failed.
Finished

 

Furthermore you will notice that the user iSpiderColumbus in Spider LCM does not exist anymore

 

Cause

Since Spider LCM 6.1 the iSpiderColumbus user is not needed as a user anymore, therefore it gets deleted by the setup.

Resolution

Configure the user and password that should be used in the following settings file of the iSpiderColumbus interface:
<SpiderInstallDirectory>\CoreServer_00\iSpiderColumbus\_Settings\appSettings.config

<?xml version="1.0" encoding="utf-8" ?>
<appSettings>
    <add key="User" value="iSpiderColumbus" />
    <add key="Password" value="bra!nware" />
    <add key="SnapshotIsolationLevelEnabled" value="true" />
    <add key="SpiderAssetApplicationGuid" value="38F96E97-C314-44B8-B137-C966D35A3BA0" />
</appSettings>

 

Additional Information

For security reasons please DO change the default password

Products

C7, LCM6, ISC6

 

Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Aug 27, 2019 05:18 AM
Updated by:
Contributors