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)

No comments:

Post a Comment