Error: 17805, Severity: 20, State: 3

We are getting the following messages sporadically in the Event Viewer:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
We are running SQL Server 2000 SP4 on Windows Server 2003 SP1 with 4Gb RAM
without AWE enabled; however, we do have the -g256 startup parameter.
Any help would be greatly appreciated,
JamesHave a look here:
http://support.microsoft.com/kb/891719
Andrew J. Kelly SQL MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:75855665-46E4-4429-9B11-0B5C92773451@.microsoft.com...
> We are getting the following messages sporadically in the Event Viewer:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Error: 17803, Severity: 20, State: 12
> Insufficient memory available.
> We are running SQL Server 2000 SP4 on Windows Server 2003 SP1 with 4Gb RAM
> without AWE enabled; however, we do have the -g256 startup parameter.
> Any help would be greatly appreciated,
> James|||Refer
http://support.microsoft.com/default.aspx?scid=kb;en-us;896373
http://support.microsoft.com/kb/891719
--
Thanks & Rate the Postings.
-Ravi-
"James" wrote:
> We are getting the following messages sporadically in the Event Viewer:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Error: 17803, Severity: 20, State: 12
> Insufficient memory available.
> We are running SQL Server 2000 SP4 on Windows Server 2003 SP1 with 4Gb RAM
> without AWE enabled; however, we do have the -g256 startup parameter.
> Any help would be greatly appreciated,
> James

Error with Neural Network Viewer

I have read the threads regarding the Neural Network Viewer and I think I have a similar problem. I do have Service Pack 2 installed and I'm running the x64 version of SQL 2005.

I'm building a model from a single relational CASE table. Granted the table has many columns summarized at the customer level but there are it is well formed and has no NULL values (plenty of zero or blank values though). The only time I can get the NN Viewer to work is when I accept the attribute recommendations. It seems once I stray from these recommendation, even if there is still correlation with an attribute, I cannot view the model using the NN Viewer. My latest error message says:

"The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value."

I get this message even when all input attributes are Continuous so I'm not sure what String column it is referring to.

Any help is greatly appreciated. I'm in a time crunch and I have sold the client on SQL Server 2005 capabilities. It's a bit embarrasing if I can't get this resolved.

-- Steve

P.S.: I don't recall having any issues with the NN Viewer prior to Service Pack 2 (although others have). Have you done regression testing to test this issue?

Hello,

Is it possible for you to export your model and send it to us? You can send to tatyanam "at" microsoft "dot" com.

Thanks,

Tatyana

|||

Hi Tatyana

Per our joint discovery, it appears that dates that are too far out into the future (e.g., 12/31/9999) are causing this problem. The solution is to either use earlier default dates (e.g., 12/31/2999) or discretize the date fields. This eliminates the specific NN Viewer problem I was experiencing.

Thanks.

Error while trying to load the mining model in the mining model viewer

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

These are Analysis Services stored procedures that are suppposed to be installed with your server. Would you please start Management Studio and coonect to the Analysis Services instance you are using? After you connected, click the Assemblies in the object Explorer, you should be able to find System listed there. Right click system, and select properties. You will have a list of properties of this the system assembly.

At first, please verify your assemly exisits. The location of the assembly is list under general->Source. And it looks something like this:

C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdspdm.dll

Please verify this file is not deleted by accident

Second, please check Security Settings. Usually, it should work fine for the following settings:

Impersonation Info ImpersonateServiceAccount

Permission Set Unrestricted.

Good luck,

|||

I installed SQL Server and SSAS in D drive. For some reason, the System assembly source property still points to the C drive. I can't change it either from the property screen or rerun the XMLA script. I also copied the folder from D: to C:. It does not work either.

Do you know how to resolve it?

Thanks a lot.

|||

On possible solution (if you don't have any sensitive data in Analysis Services): stop the service, rename your Data folder to something like Data.bak (%ProgramFiles%\Microsoft SQL Server\MSSQL.2\OLAP\Data), then restart the service. This might fix the incorrect path issue.

Error while trying to load the mining model in the mining model viewer

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

These are Analysis Services stored procedures that are suppposed to be installed with your server. Would you please start Management Studio and coonect to the Analysis Services instance you are using? After you connected, click the Assemblies in the object Explorer, you should be able to find System listed there. Right click system, and select properties. You will have a list of properties of this the system assembly.

At first, please verify your assemly exisits. The location of the assembly is list under general->Source. And it looks something like this:

C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdspdm.dll

Please verify this file is not deleted by accident

Second, please check Security Settings. Usually, it should work fine for the following settings:

Impersonation Info ImpersonateServiceAccount

Permission Set Unrestricted.

Good luck,

|||

I installed SQL Server and SSAS in D drive. For some reason, the System assembly source property still points to the C drive. I can't change it either from the property screen or rerun the XMLA script. I also copied the folder from D: to C:. It does not work either.

Do you know how to resolve it?

Thanks a lot.

|||

On possible solution (if you don't have any sensitive data in Analysis Services): stop the service, rename your Data folder to something like Data.bak (%ProgramFiles%\Microsoft SQL Server\MSSQL.2\OLAP\Data), then restart the service. This might fix the incorrect path issue.