Unable to login, Error: SOAP error

Rich Talbot

Created
October 08, 2021 23:11

Date Posted: 2009-12-16
Product: E-Notebook Enterprise

Problem:

Solution:

New Page 1

Problem:

One of our users is receiving an error message:

"Sorry, an error ocurred while opening a client connection: while setting up connection to business tier: while initializing the MSSOAP. SoapClient30 object on the client tier: WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is: The system cannot locate the resource specified.

HRESULT=0x1: Incorrect function.

- WSDLReader: Loading of the WSDL file failed HRESULT=0x80070057: The parameter is incorrect.

- Client:One of the parameters supplied is invalid. HRESULT=0x80070057: The parameter is incorrect."

Other users can log in successfully.

This user has a significant amount of experiments in Open status and Waiting documents and in Documents submitted.

However, the user can not log in to attend to the witnessing aspect of their responsibilities.

Solution:

Create an index on submission ID

create index idx_LTA_EVENT_subm_id on LTA_EVENT (SUBMISSION_ID) tablespace T_CS_LTA_IDX;

While testing the migration of the customer's development environment from ELN 9 to 11.0.4 we ran into a performance issue for a user with a large number of waiting documents. Their DBA created an index on submission_id and was able to obtain a sigficant performance improvement.

Related articles