Posts Tagged ‘BizTalk’

I just update and release the last version of “BizTalk Mapper Extensions UtilityPack” project (available on CodePlex and Code Gallery) this time optimized for BizTalk Server 2013.

Although the version of BizTalk Server 2010 is compatible with 2013, this project as mentioned earlier is optimized (some minor changes were made), compiled in framework 4.5 and properly tested for BizTalk Server 2013.

biztalk-mapper-extensions-utilitypack-2010-v1-6Project Description

BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities. And is divide in libraries:

  • Conversion Functoids: This library includes a suit of functoids that make data conversions that you can use inside BizTalk mapper.
  • Dynamic Generators Functoids: This library includes a suit of functoids that generate dynamic data; you can use this inside BizTalk mapper.
  • Encoder Functoids: This library includes a suit of functoids that make data encoder that you can use inside BizTalk mapper.
  • Configuration Functoids: This library includes a suit of functoids that make read configuration parameter values from different locations and that you can use inside BizTalk mapper.
  • CRM Functoids: This library includes a suit of functoids that help you to wok easly in CRM integration solution; you can use this inside BizTalk mapper.
  • String Functoids: This library includes a suit of functoids that provides many methods for safely creating, manipulating, and comparing strings that you can use this inside BizTalk mapper.
  • Custom Advanced Functoids: This library includes a suit of functoids that provides methods for Conditional mapping that you can use this inside BizTalk mapper.

You can found and download Source Code, Application Binaries and Documentation in CodePlex BizTalk Mapper Extensions UtilityPack home page:

BizTalk Mapper Extensions UtilityPack
CodePlex

 

or from MSDN Code Gallery:

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013 (533.1 KB)
Microsoft | MSDN Code Gallery

I just release a new version of “BizTalk Mapper Extensions UtilityPack” project (available on CodePlex and Code Gallery) this time with only 1 new but cool functoid for BizTalk Server 2010 that was inspired by a problem that occurred to me last week.

biztalk-mapper-extensions-utilitypack-2010-v1-6

Project Description

BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities. This is the list of previous functoids available:

  • Conversion Functoids
    • Convert from human readable to epoch date Functoid: This functoid allows you to convert a traditional date (Human Readable Date) into a unix date (Epoch Date).
    • Convert from epoch to human readable date Functoid: This functoid allows you to convert a unix date (Epoch Date) into a traditional date (Human Readable Date).
    • Convert datetime format Functoid: This functoid allows you to convert datetime format.
  • Dynamic Generators Functoids
    • Password Generator Functoid: Use this functoid to build a random password.
    • Guid Generator Functoid: This functoid allows you to generate a new Guid.
    • Tiny Id Generator Functoid: This functoid allows you to generate a new Tiny Id.
  • Encoder Functoids
    • Base64 Decoder Functoid: This functoid allows you to decode Base64-encoded text strings.
    • Base64 Encoder Functoid: This functoid allows you to convert string object into base64 encoded string.
  • Configuration Functoids
    • BTSNTSvc Config Get Functoid: This functoid allows you to get configuration parameters from BTSNTsvc.exe.config. If there is no section specified, the functoid reads from the AppSettings.
    • System Environment Variable Get Functoid: This functoid allows you to get configuration parameters from machine System Environment Variable.
    • Custom Config Get Functoid: This functoid allows you to get configuration parameters from a custom configuration file.
    • Windows Registry Config Get Functoid: This functoid allows you to get configuration parameters from Windows Registry.
    • SSO Config Get Functoid: This functoid allows you to get configuration parameters from SSO Database.
  • CRM Functoids
    • CRM Lookup Functoid: This functoid allows you to retreive a value from CRM lookup field.
  • String Functoids
    • String Constant functoid: This functoid allows you to set constant values (strings) inside de maps.
    • String ToTitleCase functoid: This functoid allows you to Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms)
    • String Advance Compare Functoid: This functoid allows you to compare two specified String objects, ignoring or honoring their case, and returns an boolean that indicates if they are equal or not.
    • String Replace Functoid: This functoid returns a new string in which all occurrences of a specified string (second parameter) found in the first string are replaced with another specified string (third parameter).
    • String Normalize Functoid: This functoid allows you to normalize the text. It will remove two or more consecutive spaces and replace them with a single space, remove two or more consecutive newlines and replace them with a single newline and “condense” multiple tabs into one.
    • String PadLeft Functoid: This functoid allows you to set a new string that right-aligns the characters in this instance by padding them on the left with a specified Unicode character, for a specified total length.
    • String PadRight Functoid: This functoid allows you to set a new string that left-aligns the characters in this string by padding them on the right with a specified Unicode character, for a specified total length.
What’s new in this version?

Although BizTalk Server provides many functoids to support a range of diverse operations when working with conditional mapping, we are limited to the number of existing operations or otherwise have to use custom XSLT. This new version will provide a new library that enables to perform 1 new method for you to be able to perform conditional mapping inside BizTalk mapper.

Default Value Mapping functoid

The Value Mapping and Value Mapping (Flattening) functoids are used to provide conditional mapping from an input instance message to an output instance message. When their first input parameter is true, the second input parameter is put into the specified element or attribute in the output instance message; otherwise, that element or attribute is not created in the output instance message.

The Default Value Mapping have a similar but different behavior. You can use the Default Value Mapping functoid to return a value from one of two input parameters. If the value of the first input parameter is Null or Empty, then the value of the second input parameter is returned, otherwise the first input is returned.

Parameters

The functoid takes one mandatory input parameters:

  1. String value to tested as Null or Empty.
  2. String value that will act as Default Value in case of the first input will be Null or empty.

If the value of the first input parameter is Null or Empty, then the value of the second input parameter is returned, otherwise the first input is returned, Example: “P0011”

default-value-mapping-functoid

I will explain better the use of is functoid in my next post.

You can found and download Source Code, Application Binaries and Documentation in CodePlex BizTalk Mapper Extensions UtilityPack home page:

BizTalk Mapper Extensions UtilityPack
CodePlex

 

or from MSDN Code Gallery:

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2010 (522.1 KB)
Microsoft | MSDN Code Gallery

Today I encountered the following issue when I was trying to install an application into a new BizTalk Server environment:

An error occurred while attempting to install the BizTalk application: World Wide Web service (W3SVC) on host “localhost” not available.

The following Windows component may not be installed: Application Server -> Internet Information Services (IIS) -> Common Files.
Unknown error (0x80005000)
Unknown error (0x80005000)”

World-Wide-Web-service-not-available

Note: This error occurred either if I try to install the application by or the MSI or by the BTSTask tool and this error is also followed by other two errors with no particular or interest information.

CAUSE

On a particular note, when I’m installing or configuring a new BizTalk environment I really prefer to install all features that BizTalk provides like BAM, BRE, … even though I don’t need them , at least for now, since we do not know the challenges of tomorrow and I try to follow all the guidelines provided by Microsoft or community members.

However we sometimes find clients that don’t install all components simply because they don’t need them for now, or even worse, they don’t install all the features necessary like IIS 6 Management Compatibility role services because for them it makes no sense

The problem this time was that IIS 6 Management Compatibility role services was not installed.

The Deployment Framework for BizTalk includes support for deploying application pools and virtual directories in IIS.  Virtual directory and application pool deployment is fully active for server deployments.

Due to IIS 7.0/7.5 includes significant change on the configuration system, on Windows Server 2008 and above, we need to enable IIS 6 Management Compatibility role services: IIS Metabase and IIS 6 configuration compatibility, IIS 6 WMI Compatibility and IIS 6 Scripting Tools to allow System.DirectoryServices code work on modifying IIS configurations on IIS7.x.

This topic is clearly documented in BizTalk 2010 installation guides.

SOLUTION 1

To solve this problem you must enable IIS 6 Management Compatibility role services by following the steps below:

  • Go to Administrative Tools à Server Manager
  • Select “Roles” and under “Web Server (IIS)” select “Add Role Services”
  • On the “Select Role Services” window, check the box next to “IIS 6 Management Compatibility”. Make sure you checked all four options below it.

IIS-Select-Roles-Services

Note: After this steps you need to restart the ISS.

SOLUTION 2

In alternative you can install these features by using PowerShell:

Import-Module ServerManager
@("Web-Server",
"Web-Http-Errors",
"Web-App-Dev",
"Web-Asp-Net",
"Web-Net-Ext",
"Web-ASP",
"Web-CGI",
"Web-ISAPI-Ext",
"Web-ISAPI-Filter",
"Web-Includes",
"Web-Basic-Auth",
"Web-Windows-Auth",
"Web-Mgmt-Compat",
"Web-Metabase",
"Web-WMI",
"Web-Lgcy-Scripting",
"Web-Lgcy-Mgmt-Console"
)| Add-WindowsFeature

You can download this PowerShell script from:

Enable all the requires IIS features for BizTalk Server with PowerShell
Microsoft | TechNet Gallery

In the last months many of you asked or somehow became concerned by the absence of the BizTalk Server 2013 Developer Edition because you may not knew what to use to create your or your clients development environments. And maybe worse, often you didn’t know how to answer the questions of your clients about this topic.

I am not able to find the download for BizTalk 2013 Developer Edition, this version has been discontinued?

No. Developer Edition was not discontinued and will be available in the BizTalk Server 2013 version.

So when will be available?

As probably you already know, the BizTalk Server 2013 Developer Edition is coming and is scheduled to arrive on November 1, 2013 (check BizTalk Server 2013: Developer Edition – It’s Coming!). However there’s one “small” difference comparing to the previous Developer edition (2010), BizTalk Server 2013 Developer Edition will not be free.

How match BizTalk Server 2013 Developer Edition will costs?

For people not covered by MSDN they will probably can buy the Developer edition for a nominal fee of around $30 per seat (again this apply to people not covered by MSDN).

For now there’s no BizTalk Server 2013 Developer Edition, so what can I use to create my developer environments right now?

In the meantime, these are your options:

  • People covered by MSDN (Premium or Ultimate) don’t need to wait for a developer edition, you can use the Enterprise version for Developer/Test today.
  • If you don´t have MSDN, you can use the Evaluation Edition that have a 120-day time-bombed Enterprise Edition.

Alternatively, you can also use the BizTalk Server 2013 on Windows Azure IaaS (Windows Azure VM) were you can find the following BizTalk images available:

  • BizTalk Server 2013 Enterprise
  • BizTalk Server 2013 Standard
  • BizTalk Server 2013 Evaluation

With MSDN discounts, a medium BizTalk Enterprise instance is less than $50 a month (For more information check: Configuring BizTalk Server 2013 on a Windows Azure VM or Announcing BizTalk Server 2013 in Windows Azure Infrastructure Services)

We installed BizTalk Server 2013 Evaluation for a developer environment but the copy is now expiring. Can I upgrade this version?

There is no easy option to change/upgrade the edition.

One of the best option is to just setup a new environment and do a fresh install of your applications. However this mean that you have to setup a new environment.

The other option is explained here: http://charlesemes.blogspot.pt/2011/01/biztalk-server-evaluation-version.html.

I’ve been working on a BizTalk Server 2004 project that had (not any more) between 6 or 8 visual studio solutions each one with a BizTalk Project inside. After a few minutes swapping from a solution to another I decided to add all the project in a single solution.

I notice that all the solution are configure to build the assemblies to a common reference folder shared by all projects:

Visual-studio-2003-build-options

And the other project are referring the assemblies from that folder.

However when trying to compile the project I was getting the following error:

The file ‘MyDLLProject.dll’ cannot be copied to the run directory. The process cannot access the file because it is being used by another process.

But when I open that project isolated from the others projects I could successfully compile.

CAUSE

The cause is easy… the Visual Studio has a lock on the file.

Note: That this lock could be from the Visual Studio instance that you are working on or another Visual Studio instance in another session.

SOLUTION 1

The easy solution to avoid further problems is to change the “Output path” to another location for example the default “bin\Development\”

And then instead of referring the assembly from a folder, chose Add reference from Projects

Visual-studio-2003-add-reference-from-project

Work like a charm!

SOLUTION 2

Close all the Visual Studio solution that reference this assembly or assemblies and build the project.

Great news for the BizTalk community, BizTalk Innovation Day will be back to Italy on October 17 and event more great news: the event is free but be aware that the places are limited! So book your seat now!

The speaker are the usual suspect, the "BizTalk Crew": me, Steef-Jan Wiggers, Tord Glad Nordahl, Saravana Kumar and of course the host of the event Nino Crudele! But as has been normal in recent events and the ones we are preparing, we will also have special guests, and in this particular case, a well known special guest: Paolo Salvatori and Salvatore Pelliteri.

BID-Italt-2013-bar

bid-italy-2013

BizTalk Innovation Day is a one-day community driven event focused purely on Microsoft BizTalk Server related topics that has been conducted in several major European cities since Feb 2011: Amsterdam (Netherland), Milan (Italy), Stavanger (Norway), London (UK) and Porto (Portugal) and we definitely hope to be a day with high technical sessions, in the company of prominent speakers and international experts in the field of integration, is definitely an event not to be missed for all professionals and companies that use BizTalk Server and interested in the field of integration and private public Cloud.

So we invite you all to join us next October 17, 2013 in Milan, Italy in the Microsoft Italia headquarters (Via Lombardia 2/a-1 – Peschiera Borromeo), where you can count with the following agenda:

09:00: Agenda Briefing, Health & Safety;

09:15: BizTalk Server 2013 and the Windows Azure Service Bus: Hybrid Solutions
by Steef-Jan Wiggers [Microsoft Integration MVP];

The IT landscape has changed over the years. Applications and services are spread within enterprises and in the cloud. The demand for integration will increase in the future. Microsoft’s will provide us the technology to build hybrid solutions, bridging on-premise systems with the cloud.

10:15: Use Windows Azure Service Bus, BizTalk Services, Mobile Services, and BizTalk Server to create hybrid solutions
by Paolo Salvatori [Microsoft Windows Azure Customer Advisory];

The Service Bus is part of Windows Azure and is designed to provide connectivity, queuing, and routing capabilities not only for the cloud applications but also for on-premises applications. Microsoft BizTalk Server enables organizations to connect and extend heterogeneous systems across the enterprise and with trading partners. Using both together enables a significant number of scenarios in which you can build secure, reliable and scalable hybrid solutions that span the cloud and on premises environments. Windows Azure BizTalk Services is a simple, powerful, and extensible cloud-based integration service that provides Business-to-Business (B2B) and Enterprise Application Integration (EAI) capabilities for delivering cloud and hybrid integration solutions. Windows Azure Mobile Services accelerates connected client application development by streamlining common backend tasks like structuring storage, authenticating users, and sending push notifications. In this session you will see how to integrate these technologies to build secure, reliable and scalable hybrid solutions that span the cloud and on premises environments.

11:15: Break;

11:30: Management and Monitoring of BizTalk Server using BizTalk360
by Saravana Kumar [Microsoft Integration MVP]

Some of you might have attended the BizTalk innovation day in Milan last year and watched my session on BizTalk360. You may be thinking, you don’t want to hear the same story again. But, it’s pretty much 12 months since you heard the story and BizTalk360 is drastically advancing product with one simple objective "Increase the efficiency of day-to-day BizTalk Server operations". There were 2 major releases (5.0 and 6.0) since my last presentation and possibly a big announcement by the time I present the session in Milan again this year. So I can assure you, you’ll not be disappointed by this session.

12:30: Lunch;

14:00: BizTalk Mapping Patterns and Best Practices
by Sandro Pereira [Microsoft Integration MVP]

This presentation will explain how maps are processed internally by the engine of the product as we explore the map editor and will provide you with common mapper problems and solutions, i.e., some BizTalk Mapper Patterns specifying best practices and some of the best ways to address some of your needs within the context of message transformation and also to enhance your skills when using the BizTalk Server Mapper.

15:00: Break;

15:15: Proactivity in BizTalk
by Tord Glad Nordahl [Microsoft Integration MVP]

BizTalk is used by the majority of all large companies worldwide and is considered the heart of many companies, when it comes to supporting and transferring parcel information, updating gas prices or combining important information at an ER. It’s important to understand the different bottlenecks and the resources available for your environment. You have to keep it stable, available and fully supported. This presentation will give you the overview of the important aspects that needs to be taken into consideration when running a BizTalk environment where availability, scalability and stability is important.

16:15: BizTalk 2013: All about in real environment
by Nino Crudele [Microsoft Integration MVP] and Salvatore Pellitteri [Community Member]

Our clients target many requests at gaining a complete understanding, and a subsequent optimal application, of the innovations introduced with BizTalk 2013. The facets that should be addressed are equally numerous, from new licensing and productivity, to an analysis of the expected advantages, and all these aspects should be investigated strategically in order to reap the best results from this new platform.

17:00: Q &A
with all Speakers and Guests

You can find all detail about this event here.

Reserve your ticket now and we are looking forward to see you in October!

And don’t forget that we are also held in Stavanger (Norway) the Bouvet BizTalk Innovation Day 2013 on September 25 and 26, 2013.

After I deploy a BAM activity to a new BizTalk Server 2010 environment I create a job called “BAM Generic Import data” to import all BAM data information to OLAP Cubes that will be presented on Aggregations tab in the BAM Portal.

However when I try to manual execute the job I got an error messages saying:

“The cube “MyView” was not processed. Please run the cube DTS to process the cube”

When I went to the event viewer I saw several Bam Event Provider warning messages with the following details:

Bam-Event-Provider-warning-messages

Log                Job History (BAM Generic Import data)
Step ID                0

Server                MyServer\BIZTALK
Job Name                BAM Generic Import data
Step Name                (Job outcome)
Duration                00:00:00
Sql Severity                0
Sql Message ID                0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted                0

Message

The job failed. Unable to determine if the owner (Domain\User) of job BAM Generic Import data has server access (reason: Could not obtain information about Windows NT group/user ‘Domain\User’, error code 0x2. [SQLSTATE 42000] (Error 15404)).

CAUSE

This error most likely when the machine account that runs the job (BAM Generic Import data) doesn’t have permission to query the AD.

Job-BAM-Generic-Import-Data-ower

SOLUTION 1

I would recommend requesting to the AD administrator access to this user or change owner that runs this job to a low-privileged domain account that has proper permissions on the AD – Members of the Domain should be enough.

SOLUTION 2

However in my case the AD administrator was in vacation and the other unavailable and my user account indeed didn’t have permission to query the AD (don’t ask me why) so the only solution that I found to try to solve the problem was to change the owner to the SQL Login System administrator (sa) that, lucky, wasn’t locked.

Job-BAM-Generic-Import-Data-ower-fixed

And problem solved … at least momentarily until we can apply the solution 1

After installing some upgrades in the BizTalk Server machine, in this particular case after installing Internet Explorer 10 I started to receive the following error message when I try to access BAM Portal:

“Failed to get data. If available, errors returned from the provider are listed below”

BAM-Portal-Failed-to-get-data

However without no error was listing… so what’s the problem and how can I solve it?

Additional I also get this error messages and bad behaviors:

BAM-Portal-Pivot-Table-Provider-MSOLAP-error

BAM-Portal-Pivot-Table-Provider-MSOLAP-error-2

CAUSE

Sometimes a website you’re visiting, in this case BAM Portal, doesn’t look like you expect it to. Images might not show up, menus might be out of place, and text boxes could be jumbled together. This can be caused by a compatibility problem between Internet Explorer and the site you’re on. When a site is incompatible with Internet Explorer, you’ll see the Compatibility View button in the Address bar.

Note: Not all website display problems are caused by browser incompatibility. Interrupted Internet connections, heavy traffic or network connections can also affect how a page is displayed.

SOLUTION

To solve this problem you must turn on Compatibility View for BAM Portal in the IE10. You can do this by:

  • Clicking in the “Compatibility View” button that appears in the Address bar to display the site in Compatibility View.

BAM-Portal-tap-Compatibility-View

Note: If you don’t see the button, there’s no need to turn on Compatibility View.

Once you turn on Compatibility View, Internet Explorer will automatically show that site in Compatibility View each time you visit. You can turn it off by tapping or clicking the button again. Or, you can clear the entire list of sites using Compatibility View by deleting your browsing history.

After one year and together again with the usual suspects: Steef-Jan Wiggers, Nino Crudele, Saravana Kumar and of course the host of the event Tord Glad Nordahl, BizTalk Innovation Day is back to Norway! This year also with 2 extra special guest speakers: MVP Kent Weare is coming all the way from Canada and we are hoping to have Microsoft BizTalk Product Group member to hold the key notes about BizTalk 2013 and Azure BizTalk Services.

BizTalk Innovation Day is a one-day (sometimes two) community driven event focused purely on Microsoft BizTalk Server related topics that has been conducted in several major European cities since Feb 2011: Amsterdam (Netherland), Milan (Italy), Stavanger (Norway), London (UK) and Porto (Portugal).

Bouvet-BID-2013-logo

As happened last year this will be a two day event dedicated to BizTalk Server and all-around of Integration world and will occur on 25 and 26 September at the Clarion Hotel in Stavanger, one of the most exclusive hotels in Stavanger.

And we invite you all to join us where you can count with the following agenda:

DAY 1

08:30: Registration;

09:00: Welcome and Introduction;

10:45: Exposing Line of Business (LOB) services to mobile devices
by Kent Weare [Microsoft Integration MVP];

In this session Kent will demonstrate some of the different ways to expose SAP Line of Business data to mobile devices using BizTalk 2013 and the Azure Service Bus. The core principle that will be demonstrated will take a real world On-Premise BizTalk integration scenario and expose its functionality to external consumers using the aforementioned technologies.

10:00: Break;

10:15: BizTalk Server 2013 and the Windows Azure Service Bus: Hybrid Solutions
by Steef-Jan Wiggers [Microsoft Integration MVP];

BizTalk Server 2013 will bring on-premise systems closer to the cloud. This latest version of BizTalk Server will bring more capabilities and features to build hybrid solutions. In this session you will learn how to leverage BizTalk Server 2013 and Windows Azure Service Bus to create hybrid solutions. Real-world scenario’s will be featured with demo’s and code samples.

11:00: Key Notes of BizTalk 2013
by Microsoft

11:45: Lunch;

12:45: Management and Monitoring of BizTalk Server using BizTalk360
by Saravana Kumar [Microsoft Integration MVP]

Some of you might have attended the BizTalk innovation day in Stavanger last year and watched my session on BizTalk360. You may be thinking, you don’t want to hear the same story again. But, it’s pretty much 12 months since you heard the story and BizTalk360 is drastically advancing product with one simple objective "Increase the efficiency of day-to-day BizTalk Server operations". There were 2 major releases (5.0 and 6.0) since my last presentation and possibly a big announcement by the time I present the session in Stavanger again this year. So I can assure you, you’ll not be disappointed by this session.

13:30: BizTalk Mapping Patterns and Best Practices
by Sandro Pereira [Microsoft Integration MVP]

This presentation will explain how maps are processed internally by the engine of the product as we explore the map editor and will provide you with common mapper problems and solutions, i.e., some BizTalk Mapper Patterns specifying best practices and some of the best ways to address some of your needs within the context of message transformation and also to enhance your skills when using the BizTalk Server Mapper.

14:15: Break;

14:30: Proactivity in BizTalk
by Tord Glad Nordahl [Microsoft Integration MVP]

As BizTalk evolves and matures over time the importance of the applications and its dependencies is getting more attention. We all know that business critical application only ends up as business critical when they run in production. As a BizTalk Expert it’s important to be aware of the different areas to monitor and follow to create a proactive solution. When it comes to performance counters, logs, databases, disks, hardware e.g. it’s important to be aware when and if they are approaching a possible failure.

15:15: BizTalk Hostage Situation
by Nino Crudele [Microsoft Integration MVP]

There are many bad implementations of BizTalk around the world created by consultants that do not understand BizTalk. The deployed solution takes the IT budget hostage. The speaker will tell the story of a SWAT team taking control of the situation and solving the problem of a bad implementation. He will provide best practices and approaches for a solid BizTalk implementation that is future proof, resilient and sustainable.

16:00: Q and A
with 6 MVPs and Microsoft Product Group

20:00: Dinner;

DAY 2

(All labs run simultaneously for 1 hours and you can go to the one you want you will have the option to attend all labs based on the presentations)

09:00: Startup

09:30: Labs

11:30: Lunch

12:30: Labs

16:30: Event ends

You can find all detail about this event here.

Reserve your ticket now and we are looking forward to see you in September!

registerbbid2013

When we try to access BAM Portal, sometimes Office Web Components Display Cross-Domain warning messages such as:

“This Web site uses a data provider that may be unsafe. If you trust the Web site, click OK, otherwise click Cancel.”

This-website-uses-data-provider-that-may-be-unsafe

Or this other common warning messages

“This page accesses data on another domain. Do you want to allow this?”

Or even:

“Failed to get data. If available, errors returned from the provider are listed below… Safety settings on this machine prohibit accessing a data source on another domain.”

CAUSE

This are some of the normal warning message that the Microsoft Office 2003 Web Components displays when a user try to accesses to BAM Portal, some because a scripted Web page tries to run ADO code from an untrusted provider (accessing data from a domain other than the one from which the Web page originates)

For ADO 2.7 and earlier you may receive: “This page accesses data on another domain. Do you want to allow this?”

However, for ADO 2.8 and later, the preceding message no longer appears. Instead, the following message appears in this context: “This Web site uses a data provider that may be unsafe. If you trust the Web site, click OK, otherwise click Cancel.”

The purpose for the alert is to prevent a Web page author from directing users to a potentially malicious page that uses the security context of the user to access data for which the author does not have access.

SOLUTION

To avoid this messages in Microsoft Internet Explorer, you can add a secure Web site to your Trusted Sites zone on the Security tab of the Internet Options dialog box:

  • In the Internet Explorer window, click “Tools”, then click “Internet Options”.
  • Click the “Security” tab, and then select the “Trusted sites” zone.

Add-BAM-Portal-Trusted-Sites-Zone-Security-tab

  • Click “Sites” button, and then “Add” the BAM Portal to the Trusted sites zone

Add-BAM-Portal-Trusted-Sites-Zone