Tuesday, January 25, 2022

MAIL NOT WORKING

MAIL NOT WORKING

OUTLOOK 

OPENROWSET RETURN 7307 FOR SQL Server authentication

SQL SERVER 2008

using window Authentication ,it excute ok,but for SQL Server authentication ,sometimes it returns message like this,sometimes ok,can anybody help 

The OLE DB provider "SQLNCLI10" of the linked server "(null)" returned the message "The login process could not be completed due to a delay in opening the server connection."
Message 7303, Level 16, State 1, Line 1
Unable to initialize Linked Server "(null)" for the OLE DB provider "SQLNCLI10" for the data source object.

SQL:

SELECT top 10 * FROM OPENROWSET('SQLOLEDB','server ip';'username';'passwrod',dbname.dbo.tablename) 


Reply:

Hi,

This is expected sometime when your target server is busy and could process the request in time. You will get this error when Remote Query timeout has reached. You need to verify what is issue with Remote server at specific time when you get this error. You should check N/w around that time. Try to increase remote query time period. 

Thanks,

Kindly mark the reply as answer if they help


------------------------------------

Merry X-Mas for SCSM 2012 R2 Users

Merry Chillmas everyone!


Reply:

Hi 

That is a nice Reviewer Portal upload to the Gallery and must have been a bit of work. 

And who says we can't have Christmas early. Just got to convince the rest of the family that I can open my other presents as well.

Cheers

Glen

Web: www.xapity.com  |   Twitter: @xapityapps  |   Facebook: xapityapps


  • Edited by Glen.Xapity Thursday, December 15, 2016 11:54 PM

------------------------------------
Reply:

Good work

Congrats.!

Fırat


------------------------------------

Error when using default MDS WSDL in Java

Hi,

We are trying to implement Java client for MDS default service. We tried to create proxy for the WSDL (http:/localhost/Service/Service.svc?wsdl).

1) We use Eclipse with Apache CXF Maven Plug in to generate the proxy class. We get the following error:

[ERROR] Error while generating code.Location [ http://winx-v0223.jbhunt.com:81/Service/Service.svc?xsd=xsd0{1,196971}].
org.xml.sax.SAXParseException; systemId: http://winx-v0223.jbhunt.com:81/Service/Service.svc?xsd=xsd0; lineNumber: 1; columnNumber: 196971; A class/interface with the same name "com.roytuts.soap.client.Version" is already in use. Use a class customization to resolve this conflict.

[ERROR] Error while generating code.Location [ http://winx-v0223.jbhunt.com:81/Service/Service.svc?xsd=xsd4{1,280}].
org.xml.sax.SAXParseException; systemId: http://winx-v0223.jbhunt.com:81/Service/Service.svc?xsd=xsd4; lineNumber: 1; columnNumber: 280; (Relevant to above error) another "Version" is generated from here.

2) We also tried to create the proxy in Eclipse with Axis 2. We get the following error:

IWAB0399E Error in generating Java from WSDL:  java.io.IOException: ERROR: Missing <soap:fault> element inFault "SkuNotSupportedMessageFault" in operation "SkuNotSupportedMessageFault", in binding BusinessRulesPaletteGet

    java.io.IOException: ERROR: Missing <soap:fault> element inFault   

However, when we replace the wsdl:fault with wsdl:Soap in the WSDL file, we could able to generate the proxy.

3) We tried to create java proxy with the above tools for another WCF service (WSDL), there is no hurdle in getting the proxy class now. It creates without error. But, we get all the above 2 issues only with Default MDS Service


Please Let us know what is the right way to get the proxy out of Default MDS service WSDL.

- ANAND


Reply:
Anand, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Model Package Editor

I am on SQL Server 2012 and have just discovered the Model Package Editor which looked like a good alternative to our full package deployment.

When reading online, they talk about a wizard for editing the package however, when I run ModelPackageEditor, I don't get a wizard nor do I find any option to initiate the wizard. If I open a package file, I just get the XML and no option for easily managing what's in or out. 

Does anyone know what I'm missing or what I need to do to get it as per guides? Or even to bring up this mystical GUI for element selection?


Thanks


Reply:
Ryan, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

ERR210052 - while deactivating a member even when there are no references

I am trying to deactivate some members and getting ERR210052  this error all the time. When i try from UI,  I am able to delete the member. Please suggest. 

SQL Server 2008 R2 MDS Version:  10.53.6000.34

We are having a major issue because of this problem. Please help.

Reply:
Swapna, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

MDS2012 - Adding Owner and Model to the Entity Metadata Definition entity

Hi - Ive looked through the forum but cant really find what Im looking for here.

In order to be able to support our instance of MDS there are a couple of basic questions we need to be able to answer quickly and in a reportable format:

1) what models and entities do we have in MDS

2) what roles have been assigned to the models ie who is the owner, who has Explorer, who has Read Only etc

The Metadata Model is in essence what we are looking for but with some extra information.

 so how do I:

  1. Model Definition: add attributes that show which users and groups access the model (and even better in what capacity)
  2. Entity Definition: Plug in an extra attribute that shows the model name
  3. have these attributes auto populate.

has anyone already done this or similar? If so could you please share how to (in simple speak please)


Reply:
Felice, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

application backup on network HDD

Dear Sir/Madam

Thanks for tech help given on clarification on Mycloud HDD which can configure to desired network series 

Attach snap shot on schedule application time based backup in sql 2008. I have mapped a drive of another PC. On select browse option in backup facility in sql 2008 it shows only server HDD path. If I have time based backup on server HDD than server HDD space gets exhausted .

Right Now I am overwriting the same earlier backup on server & thru batch file on other pc I overwrite the backup on Mybook live

steps done the above process

If i connect USB HDD to SERVER than path is assigned & I than can take time based backup In sql 2008.On USB HDD. If any issue with USB driver on server than concept goes for toss & it has happened earlier With wd 250 HDD

My query is with Network HDD

On having Mycloud HDD (configured to require series 192.168.0.N) how can I have application time based backup back directly on the mycloud network HDD .

I shall checkout with Microsoft also . I hope email is clear

Looking forward for reply

Anand b kasturi

9167026568


Reply:
Anand, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Many to Many structure for product kits in SQL Server MDS 2016

I'm building a product model in that includes the bill of material data. Customer account was pretty straightforward with parent accounts and child locations.

We have components at the lowest level. Those can be assembled to make finished goods or kits with multiple finished goods plus packaging components. The relationship between kits and components is many to many. The finished goods each have a "type".

Moreover, kits can be part of other kits with the addition of a few components.

An example would be a company that sells hard drives, cases and CPUs as well as complete computers. In this case, the finished good types would be "hard drive", "case" or "CPU". Complete computers would be kits and a computer bundled with an external hard drive would be a kit containing another kit.

The ultimate objective is to be able to report on sales by finished good type - with and without the kit level. Kits would mostly be "cross-type", but some, like CPU multi-packs, would be "CPU". We'll be excluding the other components for now, but they have their own identifying attributes.

My question is: Do I need to do anything special to handle the kits within kits case?

Thanks in advance.


Reply:
William, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Staging Stored Procedure

Hi All,

Just wondering what is happening behind the scene when you execute those MDS created staging stored procedure. Is it simply loading the data into appropriate table within the mdm schema? or is there something else?

Cheers,


Reply:
Gil, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

EntityMemberMerge MDS API

I have a custom developed application that uses MDS API to enter data into database. I want to enter only those records that are new. If a record already exists with one or two attributes different then I want to update the existing record in database with these new values. I found out that EntityMembersMerge does a similar thing what I want to do but couldn't understand how it does. Can you xplain how to do it with the use of EntityMembersMerge function?

Reply:
Jahanzeb, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Service activation exception when loading explorer view

Hi all,

I'm running MDS on SQL Server 2014 (patched to the latest CU 6) and, due to domain-imposed restrictions and other oddities with regards to how my employer's domain is setup, I had to manually configure the MDS application pool to run under LocalSystem on my dev computer.  All administrative functionality within MDS is working with the exception of the explorer.  When I select a model and go to the explorer view, I'm greeted with the following error:



I'm then seeing the following in the event log:

WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/50934102
 Exception: System.ServiceModel.ServiceActivationException: The service '/Service/Service.svc' cannot be activated due to an exception during compilation.  The exception message is: The authentication schemes configured on the host ('IntegratedWindowsAuthentication') do not allow those configured on the binding 'WSHttpBinding' ('Anonymous').  Please ensure that the SecurityMode is set to Transport or TransportCredentialOnly.  Additionally, this may be resolved by changing the authentication schemes for this application through the IIS management tool, through the ServiceHost.Authentication.AuthenticationSchemes property, in the application configuration file at the <serviceAuthenticationManager> element, by updating the ClientCredentialType property on the binding, or by adjusting the AuthenticationScheme property on the HttpTransportBindingElement.. ---> System.NotSupportedException: The authentication schemes configured on the host ('IntegratedWindowsAuthentication') do not allow those configured on the binding 'WSHttpBinding' ('Anonymous').



Reply:
Jonathan, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

MDS Web application and Excel Addin Connection issues

Hi Guys, I am sure there is a simple solution to this but I have searched for weeks and haven't really found a solution.

I have an MDS Server setup on VM. On that VM I am able to access the web app and connect to the MDS Server via the Excel Addin just fine.

However, If I try accessing either the web app or connect via excel addin from my local machine I just can't connect:

TITLE: Master Data Services Add-in for Excel
------------------------------

The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.

------------------------------
ADDITIONAL INFORMATION:

There was no endpoint listening at (site) that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. (mscorlib)

------------------------------

The remote name could not be resolved: 'VM Name/ Remote Desk Top Name' (System)

------------------------------
BUTTONS:

OK
------------------------------

I am using the correct connection string and have a feeling perhaps it is an issue with IIS permissions. Should you be able to access the MDS Web app or Connect via Master Data service Excel Addin outside of the machine it was installed and set up on? If so, is someone able to suggest what permission settings are required. I have administrative rights and currentlyy windows firewall on the remote desktop/ vm is turned off.

 Any information/suggestions would be appreciated.

Thanks,

MrD1l


Reply:
MrD, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Help for pivot use

Hi

its been a day since I'm searching for the right way to pivot my table.

here are the details:

view name: [dbo].[PIVOTSAMPLE]

Table view

Account Name  ------Charge_To------Expense

ABC----------------------CDS----------------1,000

ABC ---------------------BMG----------------2,000

DEF----------------------CDS----------------1,500

GHI----------------------CDS-----------------4,000

GHI----------------------NSM-----------------3,500

KLM----------------------CDS-----------------2,500

KLM----------------------BMG-----------------1,800

I want my table to look like this

ACCOUNT NAME------CDS---------BMG------------NSM

ABC----------------------1,000--------2,000------------0

DEF----------------------1,500---------0-----------------0

GHI----------------------4,000----------0----------------3,500

KLM----------------------0---------------1,800-----------0

Can anyone help me with the proper pivot query?

Hoping for a favorable response from the group!

best regards,

chard





Reply:
Chad/Chard, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

How to handle 'System.ServiceModel.Security.SecurityNegotiationException'

To test Masterdata service API I follow this article "Getting Started with the Web Services API in SQL Server 2008 R2 Master Data Services"

(Sorry i cannot post a link,

sqlblog.com/blogs/mds_team/archive/2010/01/12/getting-started-with-the-web-services-api-in-sql-server-2008-r2-master-data-services.aspx)

I got the error message

"An unhandled exception of type 'System.ServiceModel.Security.SecurityNegotiationException' occurred in mscorlib.dll

Additional information: Secure channel cannot be opened because security negotiation with the remote endpoint has failed. This may be due to absent or incorrectly specified EndpointIdentity in the EndpointAddress used to create the channel. Please verify the EndpointIdentity specified or implied by the EndpointAddress correctly identifies the remote endpoint."

Does it mean I didn't authenticate to use API? or else?

Please give me a suggestion. Thanks.


Reply:
Pure, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Can someone provide an example of a key registry?

I'm working an MDM project right now. I've read a lot of literature but I've found little in the way of actual physical architecture. Specifically, I'm looking to see what a proper key registry looks like. I can't find an example online. Does anybody have one that they would be willing to share?

Reply:
Falcon, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

User group membership not updating in MDS

When modifying a user's group membership in Active Directory, this change is not reflected in MDS.

The initial group memberships were taking in in the MDS security setup, but changes made in AD afterwards are not coming through.

I verified that the user was logged out and in again. This was reflected in the "last login time" in the MDS security screen.
Also the change in group membership was replicated to all domain controllers, so that can be eliminated as a potential cause.
The Identity for the Application Pool has the rights to query the Active Directory (and is the same user which was used initially to populate the security membership in MDS).
IIS was restarted a couple of times as well to potentially trigger a refresh.

Is this a known problem, or what could help me troubleshoot this problem further?


Reply:
Mattias, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Managing a DQS knowledge base by MDS - MDS 2012

Hi,

about MDS-DQS integration, is it possible to create/manage in an automatic manner a DQS knowledge by MDS, without using the DQS client?

Many thanks


Reply:
Pscorca, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Lengthen default maximum length of nvarchar

Hi,

Is there a possibility to allow string in MDS table to be say 3000 characters long when the default max is 1000?

I've managed to change length to 3000 in both main and staging tables using "ALTER COLUMN". Even the procedure works like a charm and I get those long strings inserted.

The problem lies in end user updating. When end user changes for example Name of record in Web UI, the record won't update because check says that description is longer than 1000 chars.

Can I change WebApplication setting to support longer strings? Or is there other workaround?

Br,

PA


Reply:

Which SQL Server version are you using?

In the SQL Server 2012 and 2014, the maximum length is 4000.

In the SQL Server 2016, we added Max length option. In the underlying table, it is NVARCHAR(MAX).


------------------------------------
Reply:
I'm using SQL Server 2014. I see that it is possible to set maximum length as 4000 when creating the attribute, but as in my problem I'd need to change length of an old attribute and in that case value goes no higher than 1000. When setting it to 4000 it is accepted but really it stays in 1000.

------------------------------------
Reply:
Profound, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

what is the best design when we have daily updates in a model

Hi All 

we have created Customer Model , in which we will get new and updated customers on daily basis , in this case how can we handle version and version flag for consideration of sub systems.

Surendra Thota


Reply:
Surrendra, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...