Hi,when a user clicks on public folders in SolidCP they are presented with this error
System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Data.SqlClient.SqlException: Procedure or function ‘GetExchangeAccounts’ expects parameter ‘@ActorID’, which was not supplied.
do you know what could be causing this?
Normally you would see this if the versions of SolidCP Portal / Enterprise (including db) / Server do not fully match (where it’s sending an older Soap call which does not have all current parameters).
Can you verify they are all the exact same version?
they are all running 1.4.2, the database was upgraded with upgrade script. I have noticed when i click on ‘member of’ tab, this error also appears.
I notice there is a new release out, 1.4.3, should we try upgrading?
Then yes i would try an upgrade and see if that helps anything at all.
i have upgraded everything to 1.4.3 using the installer, portal, enterprise server and server on all nodes, the error still exists unfortunately.
Is there anything else i could try?
You should try remove and recreate the GetExchangeAccounts stored procedure in MsSQL.
CREATE PROCEDURE [dbo].[GetExchangeAccounts]
ExchangeAccounts AS E
LEFT OUTER JOIN ExchangeMailboxPlans AS P ON E.MailboxPlanId = P.MailboxPlanId
E.ItemID = @ItemID AND
(E.AccountType = @AccountType OR @AccountType IS NULL)
ORDER BY DisplayName
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
- Views213 times
- Answers6 answers