Showing posts with label defined. Show all posts
Showing posts with label defined. Show all posts

Wednesday, March 7, 2012

Error using neural network mining model viewer

I've successfully created and processed a very simple neural network mining model (defined against a cube). However, when I go to the model viewer in BI studio, it displays the following error:

"Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Input string was not in a correct format.."

Any ideas about what's going wrong? This is with SQL Server 2005 SP1.

Hello,

Some issues with the neural network viewer were fixed for Service Pack 2. You can download the latest technology preview (CTP2) for SP2 from here http://www.microsoft.com/downloads/details.aspx?FamilyID=7A9AD90F-7F95-4369-A206-E84053D63FD3&displaylang=en

If this is not an option, or it does not solve the problem with your model, could you provide a few details about the mining models? (columns, their content type , data type).

thanks

|||Going to the SP2 beta a bit problematic for us right now. Any idea when it's suppose to RTM?

I've been playing around with different variations of the mining structure - mostly super-simple structures (I'm just dipping my toes in the DM waters here). The results seem to vary. For example, a two attribute structure - a text key column and a double continuous Predict column results in the error

"Internal error: An unexpected exception occured.
Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Object reference not set to an instance of an object.."

I then added a nested table as an input (a text key column), and after that get a different error:

"Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Input string was not in a correct format.."

Processing the model and doing prediction queries seems to work OK, but the Mining Model Viewer is just completely broken.|||SP2 is scheduled for release in Q1 '07. If this becomes a blocking issue for you, please contact support (start at support.microsoft.com)

Sunday, February 26, 2012

Error Type 'System.Xml.XmlTextWriter' is not defined

I use this Code in SSIS Destination Script Transforamtion:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.Xml

Public Class ScriptMain
Inherits UserComponent
Dim xWriter As XmlTextWriter
' get this Error: Type 'System.Xml.XmlTextWriter' is not defined

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
End Sub
End Class

Whats wrong Tongue Tied?

I use CTP Sept 2005 on Windows XP German.

Willfried

You need to add a reference to System.Xml in your script component

Go to Project|Add Reference... and select System.xml from the assembly list|||Thanks, i'm a fool Idea|||Don't worry I just spent 30 minutes doing exactly the same thing