Msmdsrv.ini (Split Post): Error Registering Plugin
Jan 23, 2008
hello,everyone,I also met a problem.
I stoped the SQL Server Analysis Services first, and registered the GAC successfully,
then modified the msmdsrv.ini manually.In fact,I found the format of my msmdsrv.ini is diffirent from the one mentioned in the tutorial,it just like below:
<DataMining>
...
<Algorithms>
.
.
.
<MyCompany_Managed_Plugin_Algorithm>
<Enabled>1</Enabled>
</MyCompany_Managed_Plugin_Algorithm>
.
</Algorithms>
<Services>
...
<MyCompany_Managed_Plugin_Algorithm>
<ProgID>44503EAB-570E-4b25-A9F4-043949A7D78E</ProgID>
</MyCompany_Managed_Plugin_Algorithm>
...
</Services>
when i restarted the the AS,
some error information displayed in event viewer,
" can't load MyCompany_Mamaged_Plugin_Algorithm data mining Algorithm provider(ProgID,
can't create Algorithm Provider program for MyCompany_Managed_Plugin_Algorithm,
ProgID does not exist in the server configuration file"
I am confused by it and have not any idea to solve it.
some one can give tips?
thanks.
View 3 Replies
ADVERTISEMENT
Nov 13, 2007
Good evening everyone,
I'm following the steps of the tutorial on how to construct a managed data mining plugin in C#.
Once created the Metadata, Algorithm and Navigator classes I tried to register it on Analisys Service by running the XMLA template written on the tutorial but I got the following error:
Unable to retrieve a list of supported data mining algorithms. Make
sure you are connected to the correct Analysis Services server
instance and the Analysis Services server named localhost is running
and configured properly. You can continue with a default list of data
mining algorithms
The GUID in the XMLA is correct as so the service name. The SQL Server engine runs fine.
I noticed that when I run this XMLA, the file msmdsrv.ini is modified, so in DataMining/Algorithms session a new entry is correctly created, enabled and the GUID is also set correct.
I also tried to ignore the XMLA setting up msmdsrv.ini manually but it also didn't work.
The build process is fine, both DMPluginWrapper and the Shell are registered by gacutil and I restarted (also try to stop and start) the server.
Any ideas will be very appreciated.
Thanks,
-Renan
View 17 Replies
View Related
Jan 11, 2007
Good afternoon,
I'm doing a custom clustering plugin for text to pre-process ("clean" the texts), calculate weights, estimate the number of clusters (using the PBM index) and finally, do the actual clustering.
So... I've made each of these modules on C++ and I'm putting them all togheter on the plugin.
My database (MDB file) has only one table, with only two fields within: a key (auto-incremental) and a small text. What I intend to do is to get the text in each test case, store them togheter somewhere and call my classes to cluster these texts.
I'm trying to log the texts in a file (just a test) on the ProcessCase method, in the CaseProcessor class. I've did it with no problems with numerical data.
But when I load the MDB file on the Mining Structures Wizard, it says the content type of the field holding the texts is "Continous" and the data type is "Text". Actually, when I saw it I didn't really mind.
But when I run the mining model it gives me the following error: "Error 1 Error (Data mining): The data type of the Table1.Texto mining structure column must be numeric since it has a continuous content type (Content is set to Continuous or Key Time or Key Sequence). 0 0 "
So... How do I change this content type ? (the content type combobox on the Mining Structures Wizard couldn't the changed)
Can anyone help me on this, please ?
Thanks a lot.
View 6 Replies
View Related
Jan 17, 2007
Good morning,
Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one.
First of all, thanks a lot again.
Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging.
My clustering method returns a vector containing information of what cluster each register belongs. For instance:
vector[0] = 1 -> The register of index 0 belongs to cluster 1.
vector[1] = 9 -> The register of index 1 belongs to cluster 9.
vector[2] = 2 -> The register of index 2 belongs to cluster 2.
...
And so on.
But... I know that none of the Navigation methods receives a structure like this one discribed above. I only use it to log the results to debug the algorithm.
But how to pass this information (what register (or test case) belongs to what cluster) to the Navigation ?
Thanks a lot again, and any help will be very appreciated.
View 1 Replies
View Related
Mar 22, 2006
TITLE: New Server Registration
------------------------------
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
When I try to regiter a sql server, I take this error message. I am using Sql Server 2005. What is the problem,can you help me?
View 4 Replies
View Related
May 16, 2006
Help.
When I try to CREATE/Register a third party assembly (dtsearchNetApi2) within SQL server I am getting an error (see below). I have the source code for dtsearchNetApi2 but it is in C++ and I would like to avoid having to extend/modify it if that is avoidable. I have written a 'wrapper' class in C# but sine it references dtsearchNetApi2.dll I can't register that dll either.
CREATE ASSEMBLY DBSEARCHNETAPI
FROM 'C:TempdtsearchNetApi2.dll'
WITH PERMISSION_SET = UNSAFE
Msg 6218, Level 16, State 3, Line 2
CREATE ASSEMBLY for assembly 'dtSearchNetApi2' failed because assembly 'dtSearchNetApi2' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
dtsearchNetApi2 has references to unmanaged code. The dtSearchNetApi2.dll is a .NET 2.0 wrapper around C++ objects exported in dten600.dll. It is implemented in MSVC++ with Managed Extensions is implemented in C++/CLI 2.0.
View 3 Replies
View Related
Aug 1, 2007
hi, Derek Comingore
My self Jitendra Nayi....
I am trying to generate a SQL CLR stored procedure and i have done it too. Now the next step is to convert that *.dll file in to assembly. I am getting erro that. My server Database is on the LAN, not on my PC.
Here is the code which i have tried to register an assembly...
/*
CREATE ASSEMBLY MyAssembly FROM 'C:Documents and SettingsAdministrator.ORC80My DocumentsVisual Studio 2005ProjectsMyDB1MyDB1inDebugMyDB1.dll'
WITH PERMISSION_SET=SAFE
GO
*/
and here is the error that i am getting...
/*
Msg 6585, Level 16, State 1, Line 1
Could not impersonate the client during assembly file operation.
*/
Please help me .I am stuck at here.
View 2 Replies
View Related
Oct 22, 2007
---------------------------------------------------------------
My Original Post
I have to query n table(NLRImports) using the Distinct keyword, to retrieve a set of ID numbers. ( "Select DISTINCT id_nbr from NLRImport" ).
Now i want to use those values i retrieved, to process the records in the table(NLRImports) 1 by 1. How do i use those ID no's i retrieved as Variables or parameters for my next query?? If this makes sense?
----------------------------------------------------------------
First, thanks for the response.... now here is what im trying to do.
I created a simple application in delphi to import information to a table in MSSql2005. This is some of the resulting columns...
date | id_nbr | account_nbr | sub_account_nbr | ... etc
-------------------------------------------------------------
Now there will be several entries with the same id no but on different dates, so i take it dates would rather be my pkey.
Then i need to take one person's entries(i work on id_nbr) and go thru all the entries taking the earliest date and comparing all the other entries for that person to the first date and select all the dates more than 19 days after the first date and less than 91 days from first date and place it in a new table.
I used cursor s and while loops to kind of get it going but i know that cursors are not really recommended use but the performance implications dont bother with this particular job.
What other ways should i be using to accomplish this?
thanks, i hope this is clear...
View 1 Replies
View Related
Nov 13, 2006
I am getting the following (MOM) error on 3 of my databases anytime I initiate a backup of the mdf. The database seems to backup as expected. The one thing that has recently changed is I implemented MS Hotfix 2187 on my SQl cluster over the weekend.
Severity: Critical Error
Status: New
Source: MSSQLSERVER
Name: Commit record has already been distributed. Check DBTABLE
Description: Unable to expand message 17055 [-1073724769] 18264 Database backed up: Database: XX03PLUS, creation date(time): 2005/12/06(18:38:50), pages dumped: 23026, first LSN: 18761:44:1, last LSN: 18761:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'G: empar03PLUS_fromVCforK1.bak'}).
thanks in advance,
Jerry
View 1 Replies
View Related
Sep 19, 2001
Hi,
The following error has started appearing consistently this week (50-100) times a day. No code has been changed in the database and I ran a trace to identify the procs executed in the time before this error.There is not any errors with the procs and the procs are running correctly. Does anyone know what is causing this and the remedy for this?
Thank You
Michael
DESCRIPTION: Error: 16955, Severity: 16, State: 2 Could not create an acceptable cursor.
View 1 Replies
View Related
Oct 9, 2001
Dear All - The following message pops up when I try to execute SQL Agent Jobs - has anyone else seen this before, or know what it is ??
Box Heading is : Microsoft SQL-DMO (ODBC SQLState : 42000)
Message is : Error 22022: Unable to post notification to SQLServerAgent (reason Unknown)
Thanks,
Jazz.
View 3 Replies
View Related
Mar 13, 2007
Good morning everybody,
I'm here once again asking for help. Here's my problem:
I have a table that I use in my text mining clustering third-party algorithm. The table is as follows:
ID: primary key (int)
ID_DOC: an ID I use to know from what document a term came from (int)
ID_TERMO: the term ID (int)
TERMO: the term itself (varchar(max))
FREQ: the term frequency, usually TFxIDF (real)
Alright... I need the term itself to do some visualization. What I want to do is to get each case's term and store'em on a vector<char*>. So I did some changes on the ProcessCase method. In this method the data (each variable of the case) can be accessed rolling over the case using a DM_STATE_VALUE* as follows:
DM_STATE_VALUE* xpto = (DM_STATE_VALUE*) rgValue;
for(unsigned int i=0;i<_cAttribute;i++) { // _cAttribute is the number of variables
double aux = xpto.r8;
//Do some calculation using aux
}
Alright... It works quite well when I only have real and int data types on the database. But how the get the term collumn (varchar(max)) ?
How to modify the DM_STATE_VALUE union to accept strings as well ?
Any clues are wellcome.
Thanks a lot once more,
-Renan
View 4 Replies
View Related
Jan 1, 2008
Hi,
I want to create a Data Mining Plugin-Algorithmn that uses existing mining models in the current DB. Is there a way to get a AdomdConnection from within an (Managed) Plugin-Algorithmn? This Connection should point to the current SSAS-Database.
Regards,
Manfred
View 1 Replies
View Related
Oct 18, 2006
I have a code for Nearest neighbour algorithm, I want to build a datamining algorithm using that code..
I have the following link that includes the source code for a sample plug-in algorithm written in C#.
(managed plug-in framework that's available for download here: )http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en#DMAPI.
But i am confused on where to insert my algorithm logic?
View 3 Replies
View Related
Dec 30, 2007
Hi,
I spent the last days programming a managed datamining plugin-algorithmn for SSAS 2005 and have troubles with the Prediction-Method.
Die Prediction-Methode of the "Shell-Algorithm" leads to an error-message on execution of the prediction-query (Internal Error: Unexprected Error ... dmxpredict.cpp Row 205 ...).
Can anyone provide me with a very simple implementation of this Method which just says that for every output-attribute the first (discrete) state should be predicted with a probability of, let's say, 90 % ?
Best Whishes
Manfred
View 5 Replies
View Related
Sep 19, 2006
hi,
as we know we get clustering algorithm with managed plugin algorithm API
does anyone have developed any other plugin algorithm as i want to check what are the things that needs to be modified. i am not data mining algorithm developer but i just want to check where we have to make changes. i would be better if i get source code for algorithm other than clustering
ANOTHER PLUGIN ALGORITHM REQURIED??
thanks in advanced
View 4 Replies
View Related
Jul 10, 2007
Good afternoon,
I've developed a clustering plugin for SQL Server 2005 but now I want to port the .dll so my algorithm can run on another machine. Both machines have SQL Server 2005 installed, but different versions of Windows.
What are the steps I need to follow to port the plugin ?
Any help will be very appreciated.
Thanks a lot once more,
-Renan
View 3 Replies
View Related
Mar 20, 2007
Hi!
I am working on an AS Algorithm Plugin . I want to debug it in the AS Server, but I cant figure out how it works. Now I every time install and deploy the plugin, but if I catch an exception, it just shows me the message, not the stack trace. Anyone, something friendlier method?
Sorry for my poor English!
Bye,
Laci
View 6 Replies
View Related
May 1, 2008
We have written a test CRL stored procedure to test replacing one of our complex stored procedures but can€™t get it deployed to our SQL server that hosts a mirrored configuration of our production database (very locked down). It works fine on our development instances (not very locked down). It only references the default assemblies that were added when we created the project. All it does is use Context Connection=true to get data, loops though some records and returns the data using SQLContext. CLR is enabled on SQL server, the assembly is strongly signed, and we tried deploy using the binary string with the SAFE setting.
CREATE ASSEMBLY for assembly 'SQLCLRTest2' failed because assembly 'SQLCLRTest2' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : SQLCLRTest2.StoredProcedures::GetLift][mdToken=0x600001e] Type load failed.
[token 0x02000008] Type load failed.
View 8 Replies
View Related
Jan 1, 2008
Hi,
I tried to create a lift chart with my custom plugin-algorithmn. The chart seems to be correct, but before it is drawn, an error occours:
Function ... Row 1 ... Column 43 ... cannot be used in this context.
(I've translated the key facts of this error message from german)
What did I do wrong?
Best wishes,
Manfred
View 12 Replies
View Related
Jun 21, 2007
Getting the below error msg on my conditional split. I changed the error output to ignore errors and that keeps the error msg from appearing (and everything seems to work normally), but why would it evaluate to NULL?
Thanks
[Conditional Split - Find rows with balances [3412]] Error: The expression "FINDSTRING(Column0,"OPENING",1) > 0 || FINDSTRING(Column0,"CLOSING",1) > 0" on "output "Balance Rows" (3415)" evaluated to NULL, but the "component "Conditional Split - Find rows with balances" (3412)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error.
View 10 Replies
View Related
Feb 8, 2008
Hello All,
I am using SQL 2005 SP2. I have a table partitioned on date range. I am trying to SWITCH, MERGE and SPLIT partitions.
My SWITCH and MERGE work great. When the SPLIT query is executed, an error 9002 is thrown....
"The transaction log for database is full. To find out why space in log cannot be resued, see log_reuse_wait_desc column in sys.databases."
Below are more details...
- All SWITCH, MERGE and SPLIT are executed in one TRANSACTION.
- After SWITCH and MERGE, I execute a query set the partition scheme "NEXT USED [PRIMARY]".
- Finally i execute SPLIT statement.
Could you please tell me where am I going wrong?
Any help would be appreciated.
Thanks..................
View 2 Replies
View Related
Dec 31, 2007
Hi,
After I've written my first Plugin-Algorithmn, I have some general questions about the Managed Plugin-Algorithmn wrapper.
What does the Property "support" express in view of predictions? Is it the overall number of cases the found rule works for?
What's the difference between AdjustedProbability and Probability ?
There is a probability for a specific StateStatistic and one for the whole AttributeStatistic.
What does the latter one express? Perhaps the overall probability that the discovered rules will lead to correct results for this attribute ? Let's say I have two rules for an attribute. Rule A has a probability of 0.5 and Rule B has a probability of 0.66. What would be AdjustedProbability.Probability in the case? The mean of 0.5 and 0.66 ?
Best whishes,
Manfred
View 5 Replies
View Related
Oct 14, 2006
A little puzzle with this Error - Status and PropertyType fields do not allow nulls while other columns do ( there are about 20 columns in original expression but left out for simplicity - these are created the same way ). Any ideas how to solve it?
[Conditional Split Filter Changes [813]] Error: The expression
"LOOK_Status != Status || LOOK_PropertyType != PropertyType
|| (LOOK_OfficeName != OfficeName || ISNULL(LOOK_OfficeName) != ISNULL(OfficeName))
|| (LOOK_OfficeID != OfficeID || ISNULL(LOOK_OfficeID) != ISNULL(OfficeID)) "
on "output "Listing Changed" (885)" evaluated to NULL, but the "component "Conditional Split Filter Changes" (813)" requires a Boolean results.
(My wish for next version is to have better expression editor and be able to see the output for those in dataflow transforms with lets say sample 200 rows)
View 8 Replies
View Related
May 30, 2006
We have a large number of SPs in our databases and decided it was time to get some source control. I have VSTS team explorer installed and working in visual studio, but I cannot get the plugin for SSMS to work - it just says none in the current source control plug-in dialogue box - nothing when I drop it down either.
Any ideas what I am doing wrong?
View 1 Replies
View Related
Oct 7, 2015
I have a report that is using the following expression for one of the fields:
=Split(Fields!FromAccount.Value, " ")(1)
The format of the number is xxxxx-xxx xxxxxxxxxxxx
So the function is to grab the second section of numbers after the space. The query for this report can bring back 1 to many results which equals one to many pages.
I have an issue where the query returns three results. The first page will display the correct number, the second page displays #Error and the third displays the number.
When I run the query from Management Studio I see the numbers are as follows:
xxxxx-xxx xxxxxxxxxxxx
xxxxx-xxx xxxxxxxxxxxx
xxxxx-xxx xxxxxxxxxxxx
Note the first and and last lines have extra spaces which I thought would be the cause of the problem though I would've expected the #Error to appear on the first and third page rather than the second one.
When I remove the extra space for the first and third number all three pages display their values correctly.
However, there are many, many numbers in the table that have one to two spaces. These numbers are from a spreadsheet that is imported biweekly. So it was either I fix the spreadsheet before every import or I come up with a new expression to check for one or two spaces. This is what I came up with:
=IIF (Fields!FromAccount.Value.Contains("Â "), Split(Fields!FromAccount.Value, "Â ")(1),Split(Fields!FromAccount.Value, " ")(1))
Now, the first page displays the number correctly while the second and third page displays with the #Error. Basically I want to say if the value contains two spaces then split at the two spaces otherwise split at the one space.
View 3 Replies
View Related
May 8, 2001
Does anyone know what SQL Server uses to identify other servers which contain SQL Server, when you attempt to register a new server through enterprise mgr? For instance when you go through the new sql server registration wizard, the second screen allows you to choose what server you would like to register, and it shows you the available servers on the lan that contain sql server 6.5 or 7.0. What is enterprise mgr using to locate the other servers containing SQL Server? Thanks in advance.
View 2 Replies
View Related
Mar 2, 2000
Can anyone give me advice on how to register 6.5 servers using SQL 7.0. Every time I try and register a 6.5 servers it fails. I get an error stating that "I must upgraded the 6.5 server or later to be administered by this version of SQL-DMO". I can't upgrade the server to 7.0 because the COTS product that we are using as the front end relies on 6.5. Is there any way to do this? Or do I have to install 6.5 on my workstation as a separate application than 7.0? Someone please help?
View 2 Replies
View Related
Dec 15, 2000
I just created a new db on a programmer's machine. Now I cannot register his sql server on my sql server. It doesn't like 'sa'. I can connect as 'administrator' but then I cannot do anything. Seems like the logins are messed up. I am not able to execute any stored procedures as administrator.
Any ideas besides reloading sql?
Thanks.
View 1 Replies
View Related
Oct 14, 1999
When using MSDE or SQL7 as the back-end to Access2000 projects (adp),
the examples often have an .mdf file to match such as say NorthwindCS.mdf
The instructions are:
1. set this file aside,
2. create a database with this name then
3. stop SQLServer,
4. copy own file to msql7data...
5 use it....
although this soemtimes works, i mostly get a "suspect" database
I was hoping to fix this with DBCC REPAIR, but support for this command seems
to have disappeared
Help
View 1 Replies
View Related
Aug 28, 2000
Hi,
I mistakenly registered a SQL 6.5 server in SQL 7.0. I would like to remove the registration entry, since I often will click it by acident, and it will fire up the SQL 6.5 EM session. However, when I right click on the server and try to select the "Delete SQLServer Registration" from the menu, that option is greyed out. Is there any way I can remove this SQLServer somehow?
Thanks,
Joe
View 1 Replies
View Related
Jul 24, 1998
Hi! Just started playing, but when I try to register an active (on the network) 6.5 server in the 7.0 EM I get the message that I must upgrade the 6.5 server...I know in 6.5 I could access 6.0 servers after runnning a script on the 6.0 server, but so far I don`t see anything like this for 7.0. Will I end up having to run 2 versions of EM on a machine (if possible) to access my 6.5/7.0 servers? (I know I won`t be able to do anything fancy, but it is nice (under my 6.5 EM) to be able to manage server activity/db`s from one machine, regardless of them being 6.0 or 6.5!
John
View 1 Replies
View Related
Mar 8, 2001
Hi,
I have recently installed SQL Server 2000, And trying to register a remote SQL 7 server, through enterprise manager which fails with the following error message: Timeout expired
I am able to connect to the same server using Query Analyzer.
I was able to register this server from the same machine, prior to the installation of SQL 2000. Also, I am still able to connect to other SQL 7 servers, with SQL 2000 enterprise manager.
Any Ideas?
View 2 Replies
View Related
