Cannot view signed versions and witness in E-Notebook after change of IP addresses of webserver and database

Cannot view signed versions and witness in E-Notebook after change of IP addresses of webserver and database

PROBLEM:

After the IP addresses of webserver and database server were changed, ELN users cannot witness (nothing happens when they select an experiment to countersign), and got an error message when they select "View Signed Versions":

---------------------------
Initializing the view signed version dialog failed
---------------------------
Sorry, System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
System.Data.OracleClient.OracleException: ORA-12545: Connect failed because target host or object does not exist

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior,
Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior,
ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OracleClient.OracleCommand.ExecuteReader()
at CSDocStore.DocStoreService.RetrieveDocumentInfos(String[] receipts, String username, Byte[] password)
--- End of inner exception stack trace ---.
---------------------------
OK
---------------------------



SOLUTION:

If the CsDocStore and ENotebook are installed on the same database server, re-create the synonym LTA_USER_ACCESS
without the dblink ENLINK.

CREATE OR REPLACE SYNONYM CS_LTA_USER.LTA_USER_ACCESS for
CS_LTA_ELN_ACCESS.LTA_USER_ACCESS;


REFERENCE:

The script that creates the synonym and dblink can be found in <drive:>\Program Files\CambridgeSoft\CSDocStore\Database.