Are you a visual learner? Do you search for knowledge on YouTube? There is an extensive selection of Business Process Management, education, developerWorks, and general support YouTube videos that are available to help you maximize your investment in IBM Business Process Management software. Here's a short list of some of the Business Process Management YouTube channels:
- Follow the BPMSupport channel from our IBM Business Process Manager Level 2 Support Team for videos that describe some common issues. Look for more videos to come!
- Look to the BPMInAction channel for various demos and insights from Bill Hahn on how to use the IBM Business Process Manager products.
- View the developerWorks channel for a wide variety of tips and information across the IBM product portfolio. This channel includes the "This week On developerWorks (TWOdW)" podcasts.
- See the IBMElectronicSupport channel for tips about using the IBM Electronic Support options including how to use the different features in the IBM Support Portal, the Service Request Tool, Passport Advantage, and My Notifications.
- Follow the WebSphereEducation channel to find short demos on how to use various functions within a variety of IBM software products. Currently, there are several videos for WebSphere Lombardi Edition and the IBM Business Process Manager products. You can find more information about the WebSphere Educational opportunities including information on IBM Business Process Manager education at the following URL: http://www.ibm.com/software/websphere/education/
- See the WebSphereServiceZone channel if you are interested in learning about the services that are available through the IBM Software Services for WebSphere Team. You can find more information about IBM Software Services for WebSphere at the following URL: http://www.ibm.com/developerworks/websphere/services/
Here are some of the more popular YouTube videos from these channels:
It is not an uncommon occurrence to run into problems when trying to discover a WSDL using the Web Service Integration component from within the Process Designer tooling. These scenarios can happen for a variety of reasons, ranging from the wrong URL being used to actual problems in the structure of the WSDL or associated XSD files. The problem is that from Process Designer, the only error reported is a pop up box that looks like this:
This error does not help too much to point out the actual core problem. All is not lost, though. While Process Designer currently does not give a detailed message, Process Center does. It should be noted that when doing the WSDL discovery, it is actually done from the Process Center side. So even though you are using Process Designer, it is the connected Process Center that has the actual detailed log files. If you experience a problem with WSDL discovery, the best place to check is the SystemOut.log file, which is located in the Process Center's profile logs directory. In most cases, the resulting error will directly point to the problem and it can be remedied.
||Video: Installing WebSphere Process Server V7.0.0 Fix Pack 4
Need help installing WebSphere Process Server V7.0.0 Fix Pack 4? Watch this step-by-step demonstration video, created by the IBM Support team and now available on IBM Education Assistant!
This 6-minute video demonstrates the five steps required to silently install WebSphere Process Server V7.0.0 Fix Pack 4 without an internet connection:
- Install WebSphere Application Server.
- Install Update Installer (UPDI).
- Uninstall two Interim Fixes (SDKPM00452 and PK98944) that come with the WebSphere Application Server installation.
- Install Installation Manager V1.5.
- Install WebSphere Process Server V7.0.0 Fix Pack 4 using a customized response file.
A Readme file is also provided that contains the following helpful information:
- Links to the install packages that you will need to download
- The commands that are used in the video and so you can copy and paste
- Links to the response files used in the video
Want to learn more? IBM Education Assistant offers over 100 videos about Business Process Management V7.0!
Earlier this week, Fix Central was updated to prompt for an IBM ID prior to downloading fixes.
When you visit the Fix Central site
, you will see the following announcement:
As of January 31, 2012, each IBM client accessing Fix Central (whether through their employees or other authorized representatives) is required to have an individual IBM ID to download fixes (some exemptions may apply). The registration is quick and simple and will provide users with a customized experience to better serve their needs. Fix Central downloads are available only for IBM clients with hardware or software under warranty, maintenance contracts, or subscription and support. Software code, samples, updates and fixes being accessed on this website (collectively, the Code) are subject to the terms of the license agreements which govern the use of the associated Code.
If you use Fix Central and don't already have an IBM ID, you can see this News item
or the Fix Central site
for how to get one. Keep your IBM ID handy so you won't have any delay if you need a fix.
Today, we are announcing an upcoming change to the Twitter accounts for the IBM Business Process Management (BPM) product family. For your convenience, and to better align with our product family strategy, we are consolidating the IBM_Lombardi, IBM_Modeler, IBM_Monitor, and IBM_ProcessServ Twitter accounts into one Twitter account. Effective Wednesday, February 1, 2012, we will consolidate these four Twitter accounts into one Twitter account called IBM_BPM. To denote product-specific tweets, we will use the following #hashtags:
- IBM Business Process Manager Standard / IBM Business Process Manager Express / IBM Business Process Manager Advanced: #bpm
- IBM Integration Designer: #iid
- WebSphere Lombardi Edition: #lombardi
- WebSphere Business Modeler: #modeler
- WebSphere Business Monitor: #monitor
- WebSphere Enterprise Service Bus: #wesb
- WebSphere Integration Developer: #wid
- WebSphere Process Server: #wps
So, what does this change mean for you?
Current IBM_ProcessServ followers
If you are currently following the IBM_ProcessServ Twitter account, an action is not necessary. The account name will change and you will follow the new account automatically.
Current IBM_Lombardi, IBM_Modeler, and IBM_Monitor followers
If you are following the IBM_Lombardi, IBM_Modeler, or IBM_Monitor Twitter accounts, new tweets will cease on Wednesday, February 1, 2012. To avoid any interruption, follow the IBM_ProcessServ account before February 1, 2012 in advance of the change or the IBM_BPM account beginning on February 1st. If you follow the IBM_ProcessServ account before February 1st, you will automatically migrate to the IBM_BPM account. Beginning February 1st, tweets that previously were sent from the IBM_Lombardi, IBM_Modeler, and IBM_Monitor Twitter accounts will originate from the IBM_BPM account.
Note: The IBM_Adapters Twitter account will remain active.
Looking for information on IBM Business Process Management (BPM)? We recently added more than 30 videos, including 16 demonstrations, about IBM BPM V7.5.1 to IBM Education Assistant, which brings the total to over 100 videos for BPM versions 7.5 and 7.5.1! IBM Education Assistant offers many videos for earlier versions of BPM as well. Here are examples of new videos that are available for IBM Business Process Manager:
- Overview: What is new in IBM Business Process Manager V7.5.1
- Understanding the development process:
- Integration with IBM Case Manager V5.1
- Overview, configuration and usage of federated task management for business process definitions, BPEL processes and human tasks, and IBM Case Manager case instances
- Key application scenarios:
- Top down development demo and lab for V7.5.1
- Federated task management demo for V7.5
- Using the send message event to start a business process definition
- Event gateway demo, plus a demo with the error event sub-process to catch errors and parse the error message
- Overview of Process Designer
Watch and learn about BPM today!
(content by Holly_Fitzgerald)
The Accelerated Value Program is pleased to announce that Accelerated Value Central (AVC) will again be part of the upcoming IMPACT 2012 Conference to bring you exclusive events and opportunities that will enhance your IMPACT 2012 experience.
Over the coming months we will be providing additional information on our AVC events, designed exclusively for you - our AVP clients(*). This information will be provided directly to you by your Accelerated Value Leader and / or Specialist as well as published in our News item entitled Accelerated Value Central at Impact 2012 (April 29 - May 04)
. Be sure to bookmark the News item to stay on top of these exclusive AVC events.
Additional information about the conference can be found on the main IMPACT 2012 page
Please visit the IMPACT 2012 registration site
for more information including Early Bird Registration.
We look forward to seeing you in Las Vegas!
* If you're not an AVP client, see what AVP has to offer: WebSphere Software Accelerated Value Program
When installing an enterprise application with Microsoft SQL Server (Microsoft SQL), it is important to be careful with the database user, SQL Authentication, and the default schema. The SQL scripts provided in this document would apply to any scenario where you need to change the owner of tables, views, or stored procedures in any Microsoft SQL database.
Note: For this article's reference, I reference Lombardi Teamworks (v7.0, v6.x and earlier), WebSphere Lombardi Edition (v7.1, 7.2), and IBM Business Process Manager (v7.5 and later).
When you install these products with Microsoft SQL Server as the database and choose SQL authentication, the default schema needs to be the same as the user name.
Example: The database user is 'teamworks', then all tables after installation will be similar to the following name: teamworks.LSW_tableName. If your tables read dbo.LSW_tableName then you will need to correct the schema name. When installing with Microsoft SQL Authentication, there are various built-in SQL queries, which look for dbUserName.LSW_table. You might see error messages that are similar to the following text in log files:
Error Example 1 - The table LSW_SYSTEM exists, but it cannot be reached because it is owned by dbo.
2011-06-10 15:18:52,593 [SIBJMSRAThreadPool : 7] ERROR com.lombardisoftware.server.ejb.persistence.PersistenceServicesBean -
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into LSW_SYSTEM (SYSTEM_ID,NAME,DESCRIPTION,ARCHIVED,VERSION,LAST_MODIFIED,LAST_MODIFIED_BY_USER_ID) values (?,?,?,?,?,?,?)]; SQL state ; error code ; Cannot insert duplicate key row
in object 'teamworks.LSW_SYSTEM
Error Example 2 - The auto creation scripts for the performance server wants to create tables with the schema teamworks. In this case, the user teamworks is not the default schema and does not have db_owner rights.
2011-06-13 09:01:48,205 [SIBJMSRAThreadPool : 6] ERROR com.lombardisoftware.server.ejb.tracking.RepresentationManagerServicesBean -
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ CREATE TABLE teamworks.TG_SLATHRESHOLDTRAVERSALS (
Complete the following steps to correct the schema name:
- Shutdown the application (Teamworks, WebSphere Lombardi Edition, or IBM Business Process Manager)
- Log in to the database with a high level user, system administrator or equivalent
- Back up the database in the event you need to roll it back.
- Check to see if the database user has db_owner rights and that the default schema is the same as the user. By default, when creating new users in Microsoft SQL, the user's default schema is dbo. Make changes as necessary.
- Drop all Service Integration Bus (SIB) tables in the database. New SIB tables with the proper schema name are created when the servers start. There is no harm in dropping SIB tables on the process database. There is no in-flight instance or task data that is stored in SIB records.
- Run the SQL scripts to change tables, stored procedures, and views.
- Refresh the view database to confirm that all schema names are changed.
- Restart servers and confirm that the log files do not have any errors.
Change Stored Procedure
Change Table Owner
This script changes the schema owner for stored procedures.
SET @OldOwner = 'dbo'
SET @NewOwner = 'lswbpm'
DECLARE CURS CURSOR FOR
type = 'p'
uid = (SELECT uid FROM sysusers WHERE name = @OldOwner)
NOT name LIKE 'dt%' FOR READ ONLY
DECLARE @ProcName sysname
FETCH CURS INTO @ProcName
WHILE @@FETCH_STATUS = 0
IF @@VERSION >= 'Microsoft SQL Server 2005'
EXEC('alter schema ' + @NewOwner + ' transfer ' + @OldOwner + '.' + @ProcName)
exec('alter authorization on ' + @NewOwner + '.' + @ProcName + ' to schema owner')
EXEC('sp_changeobjectowner ''' + @OldOwner + '.' + @ProcName + ''', ''' + @NewOwner + '''')
FETCH CURS INTO @ProcName
This script changes the schema owner for all tables in a database.
use bpmProcessDB /*which database to perfrom operation on.*/
DECLARE tabcurs CURSOR
SELECT 'dbo.' + [name] /*dbo here is the OLD schema name*/
WHERE xtype = 'u'
DECLARE @tname NVARCHAR(517)
FETCH NEXT FROM tabcurs INTO @tname
WHILE @@fetch_status = 0
EXEC sp_changeobjectowner @tname, 'lswbpm' /*lswbpm here is the NEW schema and owner*/
FETCH NEXT FROM tabcurs INTO @tname
Example for single changes, in VIEWS, performance DB. These are the default views for the perfomance server. If other views exist from tracking tables, those will also need to be changed.
EXEC sp_changeobjectowner 'oldschema.VIEW_NAME', 'newSchema'
/*default ones for bpmPeformanceDB*/
EXEC sp_changeobjectowner 'dbo.PROCESSFLOWS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.SLASTATUS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.SLATHRESHOLDTRAVERSALS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.SNAPSHOTS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TASKS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TIMINGINTERVALS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TIMINGINTERVALVALUE', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TRACKEDFIELDS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TRACKEDFIELDUSE', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TRACKINGGROUPS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TRACKINGPOINTS', 'lswbpm'
EXEC sp_changeobjectowner 'dbo.TRACKINGPOINTVALUE', 'lswbpm'
I recently published two new technotes related to some common issues that I have encountered in Support. Both of these issues are common issues that multiple IBM WebSphere Process Server users have come across. If you are encountering delays with WebSphere Process Server start-up, or WS-AT headers in your web services, then these publications might help you solve your problem. Check them out!
By Colleen Lhota
Good business processes enable you to anticipate shifts in the marketplace and exceed your customers' expectations, while keeping costs under control. IBM Business Process Management (BPM) V7.5 can help you discover, document, automate, and continuously improve your business processes to increase efficiency and reduce costs.
Want to learn more about BPM V7.5? IBM Education Assistant provides more than 75 videos covering the following topics:
- Overview of IBM Business Process Management V7.5
- Business Process Manager - overview, architecture, installation, migration, configuration, the development process and key application scenarios
- Integration Designer - overview, installation and testing
- Business Monitor - overview, new features, installation, administration, dashboards, models, debugging and scenarios
- Industry Packs - overview, Banking Pack, Healthcare Pack and Telecom Pack
- Business Space powered by WebSphere - overview and new features
- WebSphere Adapters - overview, new features, technology adapter enhancements and application adapter enhancements
Watch and learn today using the IBM Education Assistant videos about BPM V7.5
The IBM Business Manager suite is a comprehensive BPM platform providing users the visibility and insight to manage business processes. Version 7.5 is the latest release of the suite, which ranges from development tools and production servers. With this release, application development and deployment are more scalable, agile, and on demand.
To help users master the new products, product training materials are provide in a variety of online or in-class forms. For example, the IBM Integration Designer V7.5 - Installation and Related Topics
is an online training session offered by WebSphere Support Technical Exchange. The session focuses on IBM Integration Designer installation, a development tool of the IBM Business Manager suite. The discussion contains an overview on the installation, step-by-step walk-through of two typical installation scenarios, installation with product launchpad and silent installation. The FAQ section contains answers to commonly asked questions, such as, system requirements, database requirements, process center and process server test environment installation and configuration, security, coexistence, non-admin user, and Business Space issues. The FAQ section is followed by a troubleshooting discussion about basic techniques used in troubleshooting a failed installation. The session ends with a recommendation section, which contains best practices to avoid potential installation failure.
Do you follow us on Twitter? Our presence on Twitter is extensive! We provide links to technical support-related information that exists in many different formats such as problem and solution documents, developerWorks articles, IBM Red Books, IBM Red Papers, YouTube videos, blogs, and so on. We also provide links to educational opportunities and other related information to help you get the most out of your investment in our products.
There are two Business Process Management products that do not have a Twitter account named for them. However, we are currently providing information about those products through related Twitter accounts.
- IBM Business Process Manager Version 7.5 products were released earlier this year. To obtain information on IBM Business Process Manager Standard, IBM Business Process Manager Express, and IBM Business Process Manager Advanced, you can follow either the IBM_ProcessServ or the IBM_Lombardi Twitter account. Information pertaining to those products are provided through both of those accounts at different times; you won't miss any Business Process Manager-related tweets if you are following one account and not the other.
- WebSphere Enterprise Service Bus Version 7.5 was released earlier this year. To obtain information about this release and previous releases, follow the IBM_ProcessServ account.
We provide Business Process Management-related information through the following Twitter accounts:
- Twitter Account: IBM_Adapters
Products covered: WebSphere Adapters
- Twitter Account: IBM_Lombardi
Products covered: IBM Business Process Manager Standard, IBM Business Process Manager Express, IBM Business Process Manager Advanced, WebSphere Lombardi Edition
- Twitter Account: IBM_Modeler
Products covered: WebSphere Business Modeler and WebSphere Business Compass
- Twitter Account: IBM_Monitor
Products covered: WebSphere Business Monitor
- Twitter Account: IBM_ProcessServ
Products covered: IBM Business Process Manager Standard, IBM Business
Process Manager Express, IBM Business Process Manager Advanced,
WebSphere Enterprise Service Bus, and WebSphere Process Server
If you have any suggestions for content that you would like to see through our Twitter accounts, you can leave us comments here or send us a direct message through Twitter.
In my role as a support engineer at IBM, I sometimes come across questions regarding XML maps. According to the information center
, in a heterogeneous environment, different systems may use different message object formats. To consume a message with a different object format, developers rely on features, such as XML map, to perform the message transformation. Correspondingly, WebSphere Integration Developer V7.0 and IBM Integration Designer V7.5 offer corresponding graphic user interfaces to facilitate this development.
To get started, refer to the following article on developerWorks for a practical example on how to use XML map in a real-world loan application scenario: Processing an array using an XML map in WebSphere Integration Developer V7
The above article elicits the technique - developing XML maps - to separate an array of objects into several smaller output arrays based on each object’s content. First, the author begins with a banking scenario, which requires the implementation of a web service that receives a list of customers who are applying for a loan. The service divides the applications into two piles and returns them to the caller so that they can be processed separately. This requirement - dividing the array of input into two piles - can be effectively implemented using XML maps. The author then goes on to introduce the graphic-based development interface that developers use to facilitate the XML map development. The article concludes with applying this XML map development utility to develop the required maps in the sample scenario. Check it out!
This post represents the first, in what we hope, will be a series of question and answer blogs with developmental, architectural, and project management experts for the IBM Business Process Management family of products.
As a 10-year IBMer writing technical documentation and providing technical support, I am frequently reminded of the need to look at our products with a customer-centric lens. With that focus, I strive to understand how you use our products and what kind of information truly helps you solve business issues. So, with that perspective in mind, I wanted to focus on the differences that you might encounter as you move from WebSphere Lombardi Edition Versions 7.x and 6.x to IBM Business Process Manager Standard, IBM Business Process Manager Express, or IBM Business Process Manager Advanced Version 7.5. (From this point forward, these products will be collective referred to as the IBM Business Process Manager products.) To gain an understanding of the differences, I had a discussion with Zachary Roadhouse, who is the Chief Engineer for the WebSphere Lombardi Edition and IBM Business Process Manager Standard products. The following information is based on that discussion:
Q: Can you upgrade from Lombardi Teamworks Version 6.1.x and 6.2.x?
A: With the introduction of the IBM Business Process Manager Version 7.5 products, upgrades are now available for the Lombardi Teamworks Version 6.x product. Previously, an upgrade path was not available for this product. An upgrade from Lombardi Teamworks Version 6.2.x and 6.1.x to the IBM Business Process Manager products enables you to have a repository-based environment for the first time. For more information on this repository-based environment, see Asset repository in the IBM Business Process Manager Information Center.
If you want to upgrade from Lombardi Teamworks Versions 6.1.x and 6.2.x directly to IBM Business Process Manager Version 7.5.0 Fix Pack 1, you must upgrade to IBM Business Process Manager Version 7.5 and then upgrade to Fix Pack 1. Otherwise, you might encounter the following error message:
Target database schema version: 7.5.0 is not in the supported list of versions to upgrade [7.5]
Q: What are the similarities and enhancements between Lombardi Teamworks / WebSphere Lombardi Edition Version 7.x and the IBM Business Process Manager Version 7.5 products?
A: IBM Business Process Manager Standard uses the same functional footprint and code base that you are accustomed to using with Lombardi Teamworks / WebSphere Lombardi Edition Version 7.x. However, the new products contain enhancements that aid in installation and configuration. Let us focus on just a few of the enhancements in Version 7.5:
- Uses the IBM Installation Manager, which is a common installation mechanism across some of the WebSphere-branded products and is new to you if you are familiar with the installation process for Lombardi Teamworks V6.x, Teamworks V7.x or WebSphere Lombardi Edition V7.x. IBM Installation Manager is a wizard-based user interface that enables you to install the product and update both Process Designer and IBM Integration Designer. However, before you upgrade to the latest fix pack using Installation Manager, see the following documents:
- Provides full support for creating and configuring profiles using the Profile Management Tool. For more information, see Starting the Profile Management Tool.
- Provides wizard support through the administrative console to create sophisticated configurations such as clusters. For more information, see Creating a cluster.
Q: What are some of the differences between the Standard, Express, and Advanced versions of IBM Business Process Manager V7.5?
A: Although there are many differences between these products, here are some notable differences:
- IBM Business Process Manager Express has a limited license for the Process Center and Process Server. Also, it does not offer cluster support. However, IBM Business Process Manager Standard provides clustering support.
- IBM Business Process Manager Advanced includes the functionality that was present in WebSphere Lombardi Edition Version 7.x and now, in IBM Process Designer, includes Advanced Integration Service. Advanced Integration Service allows the Process Designer author to access BPEL, complex web services, mediation flows, and SCA components that you create using the IBM Integration Designer. The Advanced Integration Service allows for more advanced integration capabilities than in the standard or express products.
- IBM Business Process Manager Standard and IBM Business Process Manager Express target a process developer with the following knowledge:
- Understands business requirements and can create the process diagram and build the user interface to enable the implementation of those requirement
- IBM Business Process Manager Advanced includes an additional role, which targets both a process developer and an integration developer. The integration developer should know Java and be a service-oriented architecture (SOA) expert in a technology such as web services. The integration developer will use IBM Integration Designer to implement the business process requirements.
- IBM Business Process Manager Advanced enables an integration designer to author assets in IBM Integration Designer and publish those assets to the process center; you do not need to manually develop the assets. The product infrastructure configures and installs the web application (WAR) or enterprise archive (EAR) file automatically; you do not need to manually deploy the asset. The tooling assembles the asset due to the existence of versioning and life cycle support.
- IBM Business Process Manager Advanced comes with WebSphere Enterprise Service Bus, Business Process Execution Language (BPEL), and Service Component Architecture (SCA) technology.
To set up a robust, efficient IBM Business Monitor system, we, the administrators need to conduct a thorough self-education session beforehand. The WebSphere Business Monitor Checklist, which outlines most of the implementation considerations, is a good starting point. We also need to have a comprehensive understanding of the information center (v6.2, v7, and v7.5). In addition, Frequently asked questions (FAQ) about IBM Business Monitor is another valuable resource to help us plan, deploy, and troubleshoot.
In essence, we go through installation, configuration, model development and deployment, performance tuning, and troubleshooting to successfully deploy a WebSphere Business Monitor environment.
During the installation phase, we should verify that our system and the ID that is used for product installation meets the hardware, software, and authorization requirements.
The monitor configuration phase includes successfully configuring event distribution, security, CEI, scheduler; and additional service configuration in a network deployment environment, such as failover, database connectivity, Monitor bus, and messaging engine.
Model development and deployment
When designing and developing monitor models, we might take into consideration model versioning, trigger, usage of Deliver to all instances, event group versus monitoring context, naming scheme, and model structure.
There are many aspects to be considered when we tune our system to achieve optimal performance. These aspects include (non-exclusively) event rates, model complexity, topology, and system resources.
To troubleshoot our monitor system, we can follow the checklist, which also emphasizes referring to the FAQ for common problem determination.