Congratulations!

[Valid RSS] This is a valid RSS feed.

Recommendations

This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.

Source: http://portal2portal.blogspot.com/feeds/posts/default?alt=rss

  1. <?xml version='1.0' encoding='UTF-8'?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-6740338341177826314</atom:id><lastBuildDate>Thu, 27 Jul 2017 12:43:58 +0000</lastBuildDate><title>A Portal to a Portal</title><description>In the words of Dr Cathy Ryan, &quot;If you don&#39;t write it down, it never happened&quot;.&#xa;&#xa;The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.&#xa;&#xa;My blog is PERSONAL, and is a repository of the stuff that I learn, play with, enjoy and want to share.&#xa;&#xa;If you follow one of my tips, your mileage MAY well vary - Here be dragons :-)</description><link>http://portal2portal.blogspot.com/</link><managingEditor>[email protected] (Dave Hay)</managingEditor><generator>Blogger</generator><openSearch:totalResults>2418</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-3759234076511344159</guid><pubDate>Wed, 26 Jul 2017 13:45:00 +0000</pubDate><atom:updated>2017-07-26T14:52:52.891+01:00</atom:updated><title>WebSphere Application Server - Scripting Security</title><description>I&#39;m creating a set of scripts to automate a number of common tasks, including setting up Web SSO: -&lt;br /&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;/mnt/Scripts/enableSSO.jy&amp;nbsp;&lt;/u&gt;&lt;br /&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminTask.configureSingleSignon([&#39;-enable&#39;, &#39;true&#39;, &#39;-requiresSSL&#39;, &#39;true&#39;, &#39;-domainName&#39;, &#39;uk.ibm.com&#39;])&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;#&amp;nbsp;Save and Sync&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminConfig.save()&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminNodeManagement.syncActiveNodes()&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;/mnt/Scripts/exportLTPAkeys.jy&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminTask.exportLTPAKeys(&#39;[-ltpaKeyFile file:/mnt/Misc/bpm855.uk.ibm.com.ltpa -password passw0rd ]&#39;)&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;/mnt/Scripts/importLTPAkeys.jy&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminTask.configureSingleSignon([&#39;-enable&#39;, &#39;true&#39;, &#39;-requiresSSL&#39;, &#39;true&#39;, &#39;-domainName&#39;, &#39;uk.ibm.com&#39;])&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;#&amp;nbsp;Save and Sync&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal; min-height: 13px;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminConfig.save()&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div style=&quot;background-color: #fef49c; font-family: Menlo; font-size: 11px; line-height: normal;&quot;&gt;&lt;span style=&quot;font-variant-ligatures: no-common-ligatures;&quot;&gt;AdminNodeManagement.syncActiveNodes()&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;With thanks to this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a class=&quot;&quot; href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/rxml_7securityconfig.html&quot;&gt;SecurityConfigurationCommands command group for the AdminTask object&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a class=&quot;&quot; href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.0.0/com.ibm.websphere.nd.doc/info/ae/ae/rxml_8ltpacomm.html&quot;&gt;LTPACommandGroup command group for the AdminTask object&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/websphere-application-server-scripting.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-6472889351526261729</guid><pubDate>Wed, 26 Jul 2017 12:58:00 +0000</pubDate><atom:updated>2017-07-26T13:58:37.776+01:00</atom:updated><title>WebSphere Liberty Profile - Variables</title><description>As per my previous posts, I&#39;m setting up an IBM BPM Process Federation Server (PFS), which runs on WebSphere Liberty Profile (WLP).&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;m now going back through the setup from scratch, to see (a) what I learned and (b) whether I can repeat my success :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Looking at the WLP configuration file - &lt;b class=&quot;&quot;&gt;server.xml&lt;/b&gt;&amp;nbsp;- I&#39;d noticed reference to a pair of variables: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;keyStore&amp;nbsp;id=&quot;defaultKeyStore&quot;&amp;nbsp;location=&quot;${&lt;b class=&quot;&quot;&gt;server.output.dir&lt;/b&gt;}/resources/security/key.jks&quot;&amp;nbsp;password=&quot;password&quot;&amp;nbsp;/&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;keyStore&amp;nbsp;id=&quot;defaultTrustStore&quot;&amp;nbsp;location=&quot;${&lt;b class=&quot;&quot;&gt;server.config.dir&lt;/b&gt;}/resources/security/key.jks&quot;&amp;nbsp;password=&quot;password&quot;/&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and was trying to work out what, if anything, the difference is, given that they actually point to a the same darn file.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This helped: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSAW57_liberty/com.ibm.websphere.wlp.nd.multiplatform.doc/ae/twlp_admin_customvars.html&quot; class=&quot;&quot;&gt;Customizing the&amp;nbsp;Liberty&amp;nbsp;environment&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;WLP_OUTPUT_DIR&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;This environment variable can be used to specify an&amp;nbsp;alternative location for server generated output such as logs, the&amp;nbsp;workarea&amp;nbsp;directory, and generated files. Files in the logs directory can include&amp;nbsp;console.log,&amp;nbsp;messages.log, and any generated FFDC files.&amp;nbsp;Generated files can include server dumps that are created with the&amp;nbsp;server dump&amp;nbsp;or&amp;nbsp;server javadump&amp;nbsp;command. This variable must be an absolute path. If this&amp;nbsp;environment variable is specified,&amp;nbsp;${server.output.dir}&amp;nbsp;is set to the equivalent of&amp;nbsp;WLP_OUTPUT_DIR/serverName. &lt;b class=&quot;&quot;&gt;If this environment variable is not&amp;nbsp;specified,&amp;nbsp;${server.output.dir}&amp;nbsp;is the same as&amp;nbsp;${server.config.dir}.&lt;/b&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So, because I have not actively specified&amp;nbsp;&lt;b class=&quot;&quot;&gt;WLP_OUTPUT_DIR&lt;/b&gt;&amp;nbsp; the value of&amp;nbsp;&lt;b class=&quot;&quot;&gt;server.output.dir&lt;/b&gt; is the same as&amp;nbsp;&lt;b class=&quot;&quot;&gt;server.config.dir&lt;/b&gt;.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;For the record, I can also dump out the value of the overall WLP environment: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/PFS/v8.5/bin/server status&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;CWWKE0005E: The runtime environment could not be launched.&lt;br class=&quot;&quot;&gt;CWWKE0010E: The required server.xml file must exist and be readable. Path: /opt/ibm/PFS/v8.5/usr/servers/defaultServer/server.xml Reason: file not found&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Java home:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/java/java_1.8_64/jre&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;Install root:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;System libraries:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/lib/&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;User root:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/usr/&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;Config:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/usr/servers/defaultServer/&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;Output:&amp;nbsp;&amp;nbsp;/opt/ibm/PFS/v8.5/usr/servers/defaultServer/&lt;/b&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;As I did not specify a server name, it dumps out the overall WLP configuration, which is helpful&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/websphere-liberty-profile-variables.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-5504416900312104993</guid><pubDate>Wed, 26 Jul 2017 10:32:00 +0000</pubDate><atom:updated>2017-07-26T11:32:42.427+01:00</atom:updated><title>Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables</title><description>&lt;div class=&quot;&quot;&gt;I&#39;m working through this process: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSFPJS_8.5.7/com.ibm.wbpm.imuc.doc/topics/newhw_top.html&quot; class=&quot;&quot;&gt;Migrating&amp;nbsp;IBM BPM&amp;nbsp;to the&amp;nbsp;same version on new hardware&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;specifically testing the process of &quot;lifting and shifting&quot; an IBM BPM Deployment Environment from one VM to another.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This is, in part, to help a client move a running environment from Red Hat Enterprise Linux v5 to v7.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So I&#39;ve got a working environment on a VM, and I&#39;ve exported the BPM Deployment Environment thus: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -de De1 -profile Dmgr01 -outputDir /tmp/De1&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;deleted the WAS profiles: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -deleteAll&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;removed the WAS profile root: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;rm -Rf WebSphereProfiles/&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then recreated the Deployment Environment using the exported configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -create -de&amp;nbsp;&amp;nbsp;/tmp/De1/De1.properties&amp;nbsp;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I then need to do this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSFPJS_8.5.7/com.ibm.wbpm.imuc.doc/topics/newhw_db.html&quot; class=&quot;&quot;&gt;Dropping the messaging&amp;nbsp;engine tables&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Manually&amp;nbsp;drop the existing messaging engine tables in the&amp;nbsp;messaging database of your new deployment environment before you start&amp;nbsp;the deployment environment.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;The messaging&amp;nbsp;engine table names use the SIB prefix.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;...&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;even though the underlying Oracle database isn&#39;t moving anywhere.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So, I&#39;m on the Oracle box, and have started the SQLPlus client: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;sqlplus / as sysdba&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Now I need to find the tables: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;SELECT TABLE_NAME FROM ALL_tables WHERE TABLE_NAME LIKE &#39;%SIB%&#39; AND OWNER = &#39;CMNUSER&#39;;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which gives me this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;TABLE_NAME&lt;br class=&quot;&quot;&gt;--------------------------------------------------------------------------------&lt;br class=&quot;&quot;&gt;DATA_VISIBILITY_TEMPLATE_T&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;SIB000&lt;br class=&quot;&quot;&gt;SIB001&lt;br class=&quot;&quot;&gt;SIB002&lt;br class=&quot;&quot;&gt;SIBCLASSMAP&lt;br class=&quot;&quot;&gt;SIBKEYS&lt;br class=&quot;&quot;&gt;SIBLISTING&lt;br class=&quot;&quot;&gt;SIBOWNER&lt;br class=&quot;&quot;&gt;SIBOWNERO&lt;br class=&quot;&quot;&gt;SIBXACTS&lt;/b&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;10 rows selected.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;ve highlighted the ones in which I&#39;m interested: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SIB000&lt;br class=&quot;&quot;&gt;SIB001&lt;br class=&quot;&quot;&gt;SIB002&lt;br class=&quot;&quot;&gt;SIBCLASSMAP&lt;br class=&quot;&quot;&gt;SIBKEYS&lt;br class=&quot;&quot;&gt;SIBLISTING&lt;br class=&quot;&quot;&gt;SIBOWNER&lt;br class=&quot;&quot;&gt;SIBOWNERO&lt;br class=&quot;&quot;&gt;SIBXACTS&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;so I merely need to drop them: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;vi dropSIBtables.sql&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIB000;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIB001;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIB002;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBCLASSMAP;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBKEYS;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBLISTING;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBOWNER;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBOWNERO;&lt;br class=&quot;&quot;&gt;DROP&amp;nbsp;TABLE&amp;nbsp;CMNUSER.SIBXACTS;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;exit | sqlplus / as sysdba @dropSIBtables.sql&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 26 11:25:45 2017&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1982, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connected to:&lt;br class=&quot;&quot;&gt;Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table dropped.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;SQL&amp;gt; Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Finally, I need to recreate the SIB tables, using the&amp;nbsp;&lt;b class=&quot;&quot;&gt;createSchema_Messaging.sql&lt;/b&gt;&amp;nbsp;script that i used when I first built the environment: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;exit | sqlplus / as sysdba @createSchema_Messaging.sql&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 26 11:31:36 2017&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1982, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connected to:&lt;br class=&quot;&quot;&gt;Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Index created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Index created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Index created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Table created.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;SQL&amp;gt; Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then restart my Deployment Environment: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -start -profile Dmgr01 -de De1&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and on to testing ….&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/moving-ibm-bpm-857-environment-dealing.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-6541459448856121616</guid><pubDate>Wed, 26 Jul 2017 06:34:00 +0000</pubDate><atom:updated>2017-07-26T07:35:00.958+01:00</atom:updated><title>Hmm, Box Sync not playing nice - &quot;Unable to Connect to Box&quot;</title><description>&lt;div class=&quot;&quot;&gt;So I started seeing this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Unable to Connect to Box&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Box Sync is unable to connect to Box.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;Verify that you are connected to the Internet and restart Box Sync.&lt;/b&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;If you continue to see this message, contact your administrator to verify if it is a network issue.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;If it is not a network issue, visit the Box Support website to submit a ticket.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;yesterday, on my Mac.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;No matter how many times I tried stopping/starting the Box Sync app, it flatly refused to connect.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This whilst I was working away on Box via my browser, and happily using the internet for mail, browsing, Slack, Twitter, iMessage etc.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So, this morning, I took Roy&#39;s advice ( if you don&#39;t know The IT Crowd, you really should ) and &quot;turned it off and on again&quot; - by which I mean the Mac itself.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;A reboot didn&#39;t seem to sort it, so a full power-down and restart was the order of the day.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;When I then tried to start the Box Sync client I saw this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;There was a login error. Please make sure your network is connected and try logging in again. If you still experience issues, please restart Box Sync. Reason Code: (8)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;so I again restart the Box Sync client itself ….&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;And, quelle surprise, I was able to log in and get syncing … which is nice :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/hmm-box-sync-not-playing-nice-unable-to.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-5486011466841623979</guid><pubDate>Tue, 25 Jul 2017 16:07:00 +0000</pubDate><atom:updated>2017-07-25T17:07:27.533+01:00</atom:updated><title>IBM BPM and the Process Federation Server - A Voyage of Discovery #3</title><description>So, following these two posts: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://portal2portal.blogspot.co.uk/2017/07/ibm-bpm-and-process-federation-server.html&quot; class=&quot;&quot;&gt;IBM BPM and the Process Federation Server - A Voyage of Discovery #1&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://portal2portal.blogspot.co.uk/2017/07/ibm-bpm-and-process-federation-server_25.html&quot; class=&quot;&quot;&gt;IBM BPM and the Process Federation Server - A Voyage of Discovery #2&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;once I&#39;d got PFS set up and (mostly) working, I did some testing.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;However, I kept seeing errors such as this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://4.bp.blogspot.com/-8WO-MBIObjI/WXdswPiaavI/AAAAAAAACgE/RcYu2DIw8AoVVKstTe3gvlQRWIS1TwkZwCK4BGAYYCw/s1600/PastedGraphic-1-747535.png&quot;&gt;&lt;img src=&quot;http://4.bp.blogspot.com/-8WO-MBIObjI/WXdswPiaavI/AAAAAAAACgE/RcYu2DIw8AoVVKstTe3gvlQRWIS1TwkZwCK4BGAYYCw/s320/PastedGraphic-1-747535.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6446740967664544498&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;when I logged into the BPM 8.5.7 Process Portal ( if you remember, this is the new go-to Portal for everything, including the 8.5.5 instances ) via this URL: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://bpm857.uk.ibm.com:8443/ProcessPortal&quot; class=&quot;&quot;&gt;https://bpm857.uk.ibm.com:8443/ProcessPortal&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Talking to some of my genius colleagues, I realised that I could debug this better using a JavaScript console such as that provided by Google Chrome.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This is what I saw: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://3.bp.blogspot.com/-8LFT_l-FGCA/WXdswhZ3tEI/AAAAAAAACgM/ezkb1UXyhgYM_L7PiyK1Ebegm2tMU27dgCK4BGAYYCw/s1600/PastedGraphic-2-749222.png&quot;&gt;&lt;img src=&quot;http://3.bp.blogspot.com/-8LFT_l-FGCA/WXdswhZ3tEI/AAAAAAAACgM/ezkb1UXyhgYM_L7PiyK1Ebegm2tMU27dgCK4BGAYYCw/s320/PastedGraphic-2-749222.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6446740972460553282&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;A spot of Googling for&amp;nbsp;&lt;b class=&quot;&quot;&gt;net::ERR_INSECURE_RESPONSE&lt;/b&gt;&amp;nbsp;made me realise the error of my ways.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;m using self-signed certificates for the IHS instances fronting BPM 8.5.5 and 8.5.7. In addition, I&#39;m also using a self-signed certificate for PFS which, although not using IHS, still has a web UI sitting on port 9443: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://pfs.uk.ibm.com:9443&quot; class=&quot;&quot;&gt;https://pfs.uk.ibm.com:9443&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;When I first access Process Portal or PFS in Chrome, I see this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://3.bp.blogspot.com/-WCOsSVON7zI/WXdsxhQj0iI/AAAAAAAACgU/8gk1h7vqo2UUVoHRW0tIf46iYacqz1icwCK4BGAYYCw/s1600/PastedGraphic-3-750357.png&quot;&gt;&lt;img src=&quot;http://3.bp.blogspot.com/-WCOsSVON7zI/WXdsxhQj0iI/AAAAAAAACgU/8gk1h7vqo2UUVoHRW0tIf46iYacqz1icwCK4BGAYYCw/s320/PastedGraphic-3-750357.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6446740989601370658&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In other words, whilst I&#39;d told Chrome to &quot;trust&quot; BPM 8.5.7 I had not told it to similarly trust BPM 8.5.7.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I accessed PFS: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://pfs.uk.ibm.com:9443&quot; class=&quot;&quot;&gt;https://pfs.uk.ibm.com:9443&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and reloaded the original 8.5.7 Process Portal page, suddenly my instances started to appear …&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I did see one subsequent issue: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;XMLHttpRequest cannot load &lt;a href=&quot;https://bpm855.uk.ibm.com:8443/rest/bpm/wle/v1/task/56?federationMode=true&amp;amp;parts=actions&quot; class=&quot;&quot;&gt;https://bpm855.uk.ibm.com:8443/rest/bpm/wle/v1/task/56?federationMode=true&amp;amp;parts=actions&lt;/a&gt;. The &#39;Access-Control-Allow-Origin&#39; header has a value &#39;&lt;a href=&quot;https://bpm855.uk.ibm.com:9443&quot; class=&quot;&quot;&gt;https://bpm855.uk.ibm.com:9443&lt;/a&gt;&#39; that is not equal to the supplied origin. Origin&amp;nbsp;&#39;&lt;a href=&quot;https://bpm857.uk.ibm.com:8443&quot; class=&quot;&quot;&gt;https://bpm857.uk.ibm.com:8443&lt;/a&gt;&#39; is therefore not allowed access.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;It took me a while to work this out, but then I realised that it&#39;s telling me that the IHS fronting BPM 8.5.5 is being asked to allow the HTTP header to be modified to read&lt;b class=&quot;&quot;&gt; &lt;a href=&quot;https://bpm857.uk.ibm.com:8443&quot; class=&quot;&quot;&gt;https://bpm857.uk.ibm.com:8443&lt;/a&gt;&lt;/b&gt;&amp;nbsp;which doesn&#39;t match up with the &lt;b class=&quot;&quot;&gt;mod_headers&lt;/b&gt;&amp;nbsp;directive of: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Header set Access-Control-Allow-Origin &quot;&lt;a href=&quot;https://bpm855.uk.ibm.com:8443&quot; class=&quot;&quot;&gt;https://bpm855.uk.ibm.com:8443&lt;/a&gt;&quot;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which makes no sense at all, given that it&#39;s on the BPM 8.5.5 box itself :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I changed my IHS configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LoadModule headers_module modules/mod_headers.so&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;Header set Access-Control-Allow-Origin &quot;&lt;a href=&quot;https://bpm857.uk.ibm.com:8443&quot; class=&quot;&quot;&gt;https://bpm857.uk.ibm.com:8443&lt;/a&gt;&quot;&lt;/b&gt;&lt;br class=&quot;&quot;&gt;Header set Access-Control-Allow-Credentials &quot;true&quot;&lt;br class=&quot;&quot;&gt;Header set Access-Control-Allow-Headers &quot;DNT,X-CustomHeader,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type&quot;&lt;br class=&quot;&quot;&gt;Header set Access-Control-Allow-Methods &quot;GET,POST,PUT,DELETE,OPTIONS&quot;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;all was well.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;m still on the learning curve, especially with regard to the specifics of SSL certificate exchange, so expect more posts ….&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ibm-bpm-and-process-federation-server_72.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-8WO-MBIObjI/WXdswPiaavI/AAAAAAAACgE/RcYu2DIw8AoVVKstTe3gvlQRWIS1TwkZwCK4BGAYYCw/s72-c/PastedGraphic-1-747535.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-8835472543814708422</guid><pubDate>Tue, 25 Jul 2017 15:55:00 +0000</pubDate><atom:updated>2017-07-25T16:55:46.361+01:00</atom:updated><title>IBM BPM and the Process Federation Server - A Voyage of Discovery #2</title><description>So, following on from my earlier post: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://portal2portal.blogspot.co.uk/2017/07/ibm-bpm-and-process-federation-server.html&quot; class=&quot;&quot;&gt;IBM BPM and the Process Federation Server - A Voyage of Discovery #1&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;it took me a while to realise that PFS is NOT a UI in its own right; it merely aggregates processes from other BPMs into one single Process Portal.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;However, YOU need to provide that Process Portal :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So, in my limited test rig here, I have four VMs: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;BPM 8.5.5&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;This is my source environment, from which I am migrating, which has running instances which I need to drain down over time&lt;/div&gt;&lt;div class=&quot;&quot;&gt;BPM 8.5.7&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;This is my target environment, to which I am NOW going to send my users, upon which they will run new instances AND access their old instances&lt;/div&gt;&lt;div class=&quot;&quot;&gt;PFS&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;This is running the ElasticSearch engine etc.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;DB2&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;With three instances; db2inst1 (BPM 8.5.5), db2inst2 (BPM 8.5.7) and db2inst3 (PFS)&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Interestingly, PFS is a WebSphere Liberty-based runtime, which is nice.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Each of the BPM servers also has a local instance of IBM HTTP Server, which helps me simplify things.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Five key things I&#39;ve learned: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;ul class=&quot;MailOutline&quot;&gt;&lt;li class=&quot;&quot;&gt;BPM 8.5.7 becomes the target UI; effectively PFS is &quot;feeding&quot; tasks from the BPM 8.5.5 box AND the BPM 8.5.7 box into the same Process Portal&lt;/li&gt;&lt;li class=&quot;&quot;&gt;The two BPMs *and* PFS need to either share a common user-registry e.g. LDAP, or the users need to exist ( with identical IDs and passwords ) in all three systems&lt;/li&gt;&lt;li class=&quot;&quot;&gt;SSL between the three components is important; this requires the exchange of self-signed certificates unless we&#39;re using CA-signed ( which I&#39;m not in this particular PoC )&lt;/li&gt;&lt;li class=&quot;&quot;&gt;LTPA keys need to be exchanged between all three components; I generated a LTPA key on the BPM 8.5.5 box, and then shared it with the other two&lt;/li&gt;&lt;li class=&quot;&quot;&gt;Cross-Origin Resource Sharing&amp;nbsp;(CORS) and XML HTTP Request (XHR) are now things I never knew I need to know - this is all related to the fact that the BPM 8.5.7 Process Portal is providing me with a list of tasks from BOTH BPMs, and has to generate URLs that relate to both&lt;/li&gt;&lt;li class=&quot;&quot;&gt;Similarly, Apache&amp;nbsp;&lt;b class=&quot;&quot;&gt;mod_headers&lt;/b&gt;&amp;nbsp;and the&amp;nbsp;&lt;b class=&quot;&quot;&gt;Access-Control-Allow-Origin&lt;/b&gt;&amp;nbsp;header are also my new BFFs&lt;/li&gt;&lt;/ul&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This is fun ….&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ibm-bpm-and-process-federation-server_25.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-2509928176757840153</guid><pubDate>Tue, 25 Jul 2017 15:40:00 +0000</pubDate><atom:updated>2017-07-26T17:19:50.745+01:00</atom:updated><title>IBM BPM and the Process Federation Server - A Voyage of Discovery #1</title><description>So I&#39;ve spent the past week getting to grips with Process Federation Server (PFS), and I think I&#39;m pretty close now.&lt;br /&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In essence, PFS is a capability that&#39;s been around for a few years, and allows a business to provide an aggregation layer across multiple different Process Server environments.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Whilst this is often pertinent in the context of a migration or upgrade, perhaps where an older version of BPM is being maintained, to allow existing process instances to drain down, whilst new work is being initiated on a new environment, there&#39;s another use case for PFS.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;For example, where a business wants to segregate workloads onto different environments, perhaps with a Bronze/Silver/Gold SLA-driven approach, then PFS can provide the &quot;glue&quot; between the three environments, allowing a user to &quot;find their process&quot;.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;PFS includes an ElasticSearch engine which maintains an index of inflight instances of BPMN ( BPD ) and SCA/BPEL processes.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Here&#39;s a picture: -&lt;br /&gt;&lt;br /&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.7/com.ibm.wbpm.main.doc/images/pfs_overview.gif&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;266&quot; data-original-width=&quot;522&quot; height=&quot;163&quot; src=&quot;https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.7/com.ibm.wbpm.main.doc/images/pfs_overview.gif&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Source:&amp;nbsp;&lt;a class=&quot;&quot; href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSFPJS_8.5.7/com.ibm.wbpm.main.doc/topics/cbpm_fps.html&quot;&gt;Getting started with&amp;nbsp;Process Federation Server&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Install&amp;nbsp;this component to create a federated process environment that provides business users with a single&amp;nbsp;point of access to their task list and launch list, regardless of the type of process that they are&amp;nbsp;working on and the&amp;nbsp;IBM BPM&amp;nbsp;back-end system on&amp;nbsp;which the&amp;nbsp;process artifacts are stored.&lt;br class=&quot;&quot; /&gt;&lt;br class=&quot;&quot; /&gt;Consider installing&amp;nbsp;Process Federation Server&amp;nbsp;in&amp;nbsp;the following situations:&lt;/i&gt;&lt;br /&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;• Your process applications are deployed on different&amp;nbsp;IBM BPM&amp;nbsp;deployment&amp;nbsp;environments. Your users must log on to several different instances&amp;nbsp;of&amp;nbsp;Process Portal&amp;nbsp;to&amp;nbsp;get their work done.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;• Your users work with both BPD-related and BPEL-related processes&amp;nbsp;and tasks.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;• Your&amp;nbsp;IBM BPM&amp;nbsp;environment&amp;nbsp;contains multiple versions of&amp;nbsp;IBM BPM&amp;nbsp;that&amp;nbsp;each runs a different version of the same process application. Your&amp;nbsp;users need to work with the older versions of the process applications&amp;nbsp;while process instances are still running,&amp;nbsp;which means that they need&amp;nbsp;to log on to the&amp;nbsp;Process Portal&amp;nbsp;or&amp;nbsp;Heritage Process Portal&amp;nbsp;application&amp;nbsp;that runs on the associated version of&amp;nbsp;IBM BPM.&lt;/i&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Process Federation Server&amp;nbsp;aggregates both BPD and&amp;nbsp;BPEL-related tasks from all the&amp;nbsp;IBM BPM&amp;nbsp;back-end systems, including systems that run previous versions of&amp;nbsp;IBM BPM&amp;nbsp;that are supported by&amp;nbsp;Process Federation Server. You can take advantage of this&amp;nbsp;support to gradually phase out process applications that are still running on previous versions,&amp;nbsp;while new versions of the process applications run on the latest release of&amp;nbsp;IBM BPM&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot; /&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So this is the first of many posts about PFS …..&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ibm-bpm-and-process-federation-server.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-2658449441047805884</guid><pubDate>Tue, 25 Jul 2017 14:39:00 +0000</pubDate><atom:updated>2017-07-25T15:39:45.925+01:00</atom:updated><title>8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12</title><description>I missed this on Friday: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www-01.ibm.com/support/docview.wss?uid=swg24043844&quot; class=&quot;&quot;&gt;8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www-01.ibm.com/support/docview.wss?uid=swg27036319&quot; class=&quot;&quot;&gt;Fix list for IBM WebSphere Application Server V8.5&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Time to get downloading ….&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/85512-websphere-application-server-v855.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-6353154344025698982</guid><pubDate>Mon, 24 Jul 2017 14:56:00 +0000</pubDate><atom:updated>2017-07-24T15:57:14.938+01:00</atom:updated><title>java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002</title><description>I saw this: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://2.bp.blogspot.com/-REm6QvnDHiY/WXYKzBVlLlI/AAAAAAAACfo/p5D23FDtLD0FiWdqtGNSRTcFjvEzwhpNwCK4BGAYYCw/s1600/PastedGraphic-1-734939.png&quot;&gt;&lt;img src=&quot;http://2.bp.blogspot.com/-REm6QvnDHiY/WXYKzBVlLlI/AAAAAAAACfo/p5D23FDtLD0FiWdqtGNSRTcFjvEzwhpNwCK4BGAYYCw/s320/PastedGraphic-1-734939.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6446351788276002386&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;The test connection operation failed for data source BPM Business Process Choreographer data source on server nodeagent at node Node1 with the following exception: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code =&amp;nbsp;17,002.&amp;nbsp;View JVM logs&amp;nbsp;for further details.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;whilst testing JDBC data sources configured to connect to a newly-minted Oracle 12c database.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I checked the Oracle box to ensure that the listener was running: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;netstat -aon | grep LISTEN&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;tcp&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 0.0.0.0:111&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0.0.0.0:*&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;tcp&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 127.0.0.1:1521&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0.0.0.0:*&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;/b&gt;&lt;br class=&quot;&quot;&gt;tcp&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 0.0.0.0:22&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0.0.0.0:*&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;br class=&quot;&quot;&gt;tcp&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 127.0.0.1:25&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0.0.0.0:*&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;br class=&quot;&quot;&gt;tcp&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 127.0.0.1:6010&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0.0.0.0:*&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;br class=&quot;&quot;&gt;tcp6&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 :::36620&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;:::*&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;but I wasn&#39;t able to connect using &lt;b class=&quot;&quot;&gt;telnet&lt;/b&gt;&amp;nbsp;from either the BPM 8.5.7 VM or, more interestingly, the Oracle box itself: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;telnet oracle 1521&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Trying 192.168.153.131...&lt;br class=&quot;&quot;&gt;telnet: connect to address 192.168.153.131: Connection refused&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;so it felt more like networking or, to be more accurate, &lt;b class=&quot;&quot;&gt;nOtworking&lt;/b&gt; :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I again checked the listener: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;lsnrctl status&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 24-JUL-2017 15:21:04&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1991, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))&lt;br class=&quot;&quot;&gt;STATUS of the LISTENER&lt;br class=&quot;&quot;&gt;------------------------&lt;br class=&quot;&quot;&gt;Alias&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTENER&lt;br class=&quot;&quot;&gt;Version&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;TNSLSNR for Linux: Version 12.2.0.1.0 - Production&lt;br class=&quot;&quot;&gt;Start Date&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;24-JUL-2017 13:26:23&lt;br class=&quot;&quot;&gt;Uptime&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 days 1 hr. 54 min. 41 sec&lt;br class=&quot;&quot;&gt;Trace Level&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off&lt;br class=&quot;&quot;&gt;Security&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;ON: Local OS Authentication&lt;br class=&quot;&quot;&gt;SNMP&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;OFF&lt;br class=&quot;&quot;&gt;Listener Parameter File&amp;nbsp;&amp;nbsp;&amp;nbsp;/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;br class=&quot;&quot;&gt;Listener Log File&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;/home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml&lt;br class=&quot;&quot;&gt;Listening Endpoints Summary...&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))&lt;br class=&quot;&quot;&gt;Services Summary...&lt;br class=&quot;&quot;&gt;Service &quot;&lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt;&quot; has 1 instance(s).&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;Instance &quot;orcl&quot;, status READY, has 1 handler(s) for this service...&lt;br class=&quot;&quot;&gt;Service &quot;&lt;a href=&quot;http://orclXDB.uk.ibm.com&quot; class=&quot;&quot;&gt;orclXDB.uk.ibm.com&lt;/a&gt;&quot; has 1 instance(s).&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;Instance &quot;orcl&quot;, status READY, has 1 handler(s) for this service...&lt;br class=&quot;&quot;&gt;The command completed successfully&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I then started to dig into the OS more: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sestatus&amp;nbsp;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SELinux status:&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;enabled&lt;br class=&quot;&quot;&gt;SELinuxfs mount:&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;/sys/fs/selinux&lt;br class=&quot;&quot;&gt;SELinux root directory:&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;/etc/selinux&lt;br class=&quot;&quot;&gt;Loaded policy name:&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;targeted&lt;br class=&quot;&quot;&gt;Current mode:&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;enforcing&lt;br class=&quot;&quot;&gt;Mode from config file:&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;disabled&lt;br class=&quot;&quot;&gt;Policy MLS status:&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;enabled&lt;br class=&quot;&quot;&gt;Policy deny_unknown status:&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;allowed&lt;br class=&quot;&quot;&gt;Max kernel policy version:&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;28&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;service firewalld status&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Redirecting to /bin/systemctl status&amp;nbsp;&amp;nbsp;firewalld.service&lt;br class=&quot;&quot;&gt;● firewalld.service - firewalld - dynamic firewall daemon&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;Active: inactive (dead)&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Docs: man:firewalld(1)&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Jul 24 12:31:09 &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt; systemd[1]: Starting firewalld - dynamic firewall daemon...&lt;br class=&quot;&quot;&gt;Jul 24 12:31:10 &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt; systemd[1]: Started firewalld - dynamic firewall daemon.&lt;br class=&quot;&quot;&gt;Jul 24 11:33:20 &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt; systemd[1]: Stopping firewalld - dynamic firewall daemon...&lt;br class=&quot;&quot;&gt;Jul 24 11:33:20 &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt; systemd[1]: Stopped firewalld - dynamic firewall daemon.&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Wondering whether &lt;b class=&quot;&quot;&gt;selinux&lt;/b&gt;&amp;nbsp;was the problem, I changed the configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;vi /etc/selinux/config&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;changing from: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SELINUX=enforcing&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;to: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SELINUX=disabled&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and rebooted, but to no avail.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I then tried this:&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;telnet localhost 1521&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;from the Oracle box itself.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Which worked ….&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So I revisited the &lt;b class=&quot;&quot;&gt;lsnrctl&amp;nbsp;status&lt;/b&gt; again&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;Listening Endpoints Summary...&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=&lt;b class=&quot;&quot;&gt;127.0.0.1&lt;/b&gt;)(PORT=1521)))&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;…&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I started wondering whether the listener was &quot;bound&quot; to the &lt;b class=&quot;&quot;&gt;127.0.0.1&lt;/b&gt; address ….&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So I reconfigured it …&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;vi&amp;nbsp;/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;changing from: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;br class=&quot;&quot;&gt;# Generated by Oracle configuration tools.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;LISTENER =&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION_LIST&amp;nbsp;=&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;(DESCRIPTION&amp;nbsp;=&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;(ADDRESS&amp;nbsp;= (PROTOCOL&amp;nbsp;=&amp;nbsp;TCP)(HOST&amp;nbsp;= localhost)(PORT&amp;nbsp;= 1521))&lt;/b&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;(ADDRESS&amp;nbsp;= (PROTOCOL&amp;nbsp;=&amp;nbsp;IPC)(KEY&amp;nbsp;= EXTPROC1521))&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;)&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;to: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;# Generated by Oracle configuration tools.&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;LISTENER =&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;DESCRIPTION_LIST&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;=&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;DESCRIPTION&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;=&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;b style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;(ADDRESS&amp;nbsp;= (PROTOCOL&amp;nbsp;=&amp;nbsp;TCP)(HOST&amp;nbsp;= &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;)(PORT&amp;nbsp;= 1521))&lt;/b&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;ADDRESS&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;= (&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;PROTOCOL&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;=&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;IPC&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;)(&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;KEY&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;= EXTPROC1521))&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;)&lt;/span&gt;&lt;br style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;;&quot; class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;)&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and restarted it: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;lsnrctl stop&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 24-JUL-2017 15:41:45&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1991, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=&lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;)(PORT=1521)))&lt;br class=&quot;&quot;&gt;TNS-12541: TNS:no listener&lt;br class=&quot;&quot;&gt;&amp;nbsp;TNS-12560: TNS:protocol adapter error&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;TNS-00511: No listener&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;Linux Error: 111: Connection refused&lt;br class=&quot;&quot;&gt;Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))&lt;br class=&quot;&quot;&gt;The command completed successfully&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;lsnrctl start&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 24-JUL-2017 15:41:56&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1991, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Starting /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;TNSLSNR for Linux: Version 12.2.0.1.0 - Production&lt;br class=&quot;&quot;&gt;System parameter file is /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;br class=&quot;&quot;&gt;Log messages written to /home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml&lt;br class=&quot;&quot;&gt;Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=&lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;)(PORT=1521)))&lt;br class=&quot;&quot;&gt;Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=&lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;)(PORT=1521)))&lt;br class=&quot;&quot;&gt;STATUS of the LISTENER&lt;br class=&quot;&quot;&gt;------------------------&lt;br class=&quot;&quot;&gt;Alias&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTENER&lt;br class=&quot;&quot;&gt;Version&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;TNSLSNR for Linux: Version 12.2.0.1.0 - Production&lt;br class=&quot;&quot;&gt;Start Date&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;24-JUL-2017 15:41:56&lt;br class=&quot;&quot;&gt;Uptime&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 days 0 hr. 0 min. 0 sec&lt;br class=&quot;&quot;&gt;Trace Level&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off&lt;br class=&quot;&quot;&gt;Security&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;ON: Local OS Authentication&lt;br class=&quot;&quot;&gt;SNMP&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;OFF&lt;br class=&quot;&quot;&gt;Listener Parameter File&amp;nbsp;&amp;nbsp;&amp;nbsp;/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora&lt;br class=&quot;&quot;&gt;Listener Log File&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;/home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml&lt;br class=&quot;&quot;&gt;Listening Endpoints Summary...&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=&lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;)(PORT=1521)))&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))&lt;br class=&quot;&quot;&gt;The listener supports no services&lt;br class=&quot;&quot;&gt;The command completed successfully&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and now telnet works: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;telnet `hostname` 1521&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Trying 192.168.153.131...&lt;br class=&quot;&quot;&gt;Connected to &lt;a href=&quot;http://oracle.uk.ibm.com&quot; class=&quot;&quot;&gt;oracle.uk.ibm.com&lt;/a&gt;.&lt;br class=&quot;&quot;&gt;Escape character is &#39;^]&#39;.&lt;br class=&quot;&quot;&gt;^]quit&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;telnet&amp;gt; &lt;/font&gt;&lt;i class=&quot;&quot;&gt;quit&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Connection closed.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;More importantly …&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://4.bp.blogspot.com/-qyFdvE2kgHo/WXYKzZNKysI/AAAAAAAACfw/zqPoG2OCHvMERpW_WRRLeJUv1o8WETCoQCK4BGAYYCw/s1600/PastedGraphic-2-736723.png&quot;&gt;&lt;img src=&quot;http://4.bp.blogspot.com/-qyFdvE2kgHo/WXYKzZNKysI/AAAAAAAACfw/zqPoG2OCHvMERpW_WRRLeJUv1o8WETCoQCK4BGAYYCw/s320/PastedGraphic-2-736723.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6446351794683169474&quot; /&gt;&lt;/a&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/javasqlsqlexception-io-error-network.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/-REm6QvnDHiY/WXYKzBVlLlI/AAAAAAAACfo/p5D23FDtLD0FiWdqtGNSRTcFjvEzwhpNwCK4BGAYYCw/s72-c/PastedGraphic-1-734939.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-8201672959298978800</guid><pubDate>Mon, 24 Jul 2017 13:58:00 +0000</pubDate><atom:updated>2017-07-24T14:58:56.734+01:00</atom:updated><title>Further adventures with Oracle database - ORA-01078 and LRM-00109</title><description>&lt;div class=&quot;&quot;&gt;Having installed Oracle 12c (&amp;nbsp;12.2.0.1.0 ) today, I was somewhat concerned when I tried to start my database: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sqlplus / as sysdba&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:04:56 2017&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1982, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connected to an idle instance.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;SQL&amp;gt; &lt;/font&gt;&lt;i class=&quot;&quot;&gt;startup&lt;/i&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;font-family: &#39;Courier New&#39;; white-space: pre;&quot;&gt; &lt;/span&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;ORA-01078: failure in processing system parameters&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LRM-00109: could not open parameter file &#39;/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/initorcl.ora&#39;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL&amp;gt; &lt;/font&gt;&lt;i class=&quot;&quot;&gt;quit&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Disconnected&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I checked the offending directory: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ls $ORACLE_HOME/dbs&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;init.ora&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which made me think …..&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So I re-ran the &lt;b class=&quot;&quot;&gt;dbca&lt;/b&gt;&amp;nbsp;command to see what was going on.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Guess what ?&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I didn&#39;t have a database; I&#39;d obviously installed the product BUT not created a database.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I created one, all is well: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ls $ORACLE_HOME/dbs&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;hc_orcl.dat&amp;nbsp;&amp;nbsp;init.ora&amp;nbsp;&amp;nbsp;lkORCL&amp;nbsp;&amp;nbsp;orapworcl&amp;nbsp;&amp;nbsp;spfileorcl.ora&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sqlplus / as sysdba&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:53:27 2017&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Copyright (c) 1982, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Connected to:&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL&amp;gt; &lt;/font&gt;&lt;i class=&quot;&quot;&gt;exit&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/further-adventures-with-oracle-database.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-8741551407949686591</guid><pubDate>Sun, 16 Jul 2017 16:04:00 +0000</pubDate><atom:updated>2017-07-16T17:04:38.517+01:00</atom:updated><title>ilog.rules.teamserver.model.IlrConnectException Caused by: java.lang.NullPointerException</title><description>As one of my many spinning threads, I&#39;ve been tinkering with the migration of an IBM Operational Decision Manager (ODM) environment from version 8.0 ( circa 2012 ) to version 8.9 ( circa 2017 ).&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In part, this involves running some SQL scripts to migrate the old data to the new environment.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This is especially relevant for the Decision Center, which is the Rules authoring environment, aka the Source Code Management (SCM) system-of-record.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;The Decision Center, also known as the Team Server ( reflecting the product&#39;s heritage as iLog JRules ) or Rule Team Server or RTS, is based upon a database.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Therefore, the first step is to BACKUP the existing database ( RTSDB, in my case ) from the old/source system.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;One benefit of the &lt;u style=&quot;font-weight: bold;&quot; class=&quot;&quot;&gt;migration&lt;/u&gt;&amp;nbsp;is that it&#39;s effectively side-by-side, meaning that you leave the old source system alone, and build a new, parallel environment into which the data ( Rules etc. ) is restored.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In my case, I&#39;m using IBM DB2, but other databases are available.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;The process is documented here: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSQP76_8.9.0/com.ibm.odm.distrib.migrating/dcbc_topics/tsk_odm_distrib_migrate_db.html&quot; class=&quot;&quot;&gt;Migrating the Decision Center database&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and here: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSQP76_8.9.0/com.ibm.odm.distrib.migrating/dcbc_topics/tpc_mig_dcbc_ant_tasks.html&quot; class=&quot;&quot;&gt;Ant tasks for database migration&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and involves running a pair of Ant scripts against the existing database schema ( in my case, that&#39;s &lt;b class=&quot;&quot;&gt;db2user1&lt;/b&gt;&amp;nbsp;) resulting in a pair of SQL scripts that can then be executed against a new database schema ( in my case, that&#39;s &lt;b class=&quot;&quot;&gt;db2user2&lt;/b&gt;&amp;nbsp;) to migrate the roles AND data from one to t&#39;other.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I was quite obviously doing something wrong, as I kept seeing exceptions such as: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;ilog.rules.teamserver.model.IlrConnectException&lt;br class=&quot;&quot;&gt;Caused by: java.lang.NullPointerException&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;in the Decision Center logs post migration.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;It was, however, a PEBKAC - I was obviously doing it wrong.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I changed my approach: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Restore backup of RTSDB - as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 restore database RTSDB from /tmp&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Connect as the instance owner&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 connect to RTSDB user db2inst1 using passw0rd&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Grant the new schema - db2user2 - rights to the database&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 grant dbadm on database to user db2user2&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Terminate the DB2 session&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 terminate&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Connect as the new schema&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 connect to RTSDB user db2user2 using passw0rd&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Run the provided script to create the necessary ODM tables, indices etc.&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 -tvf ~/rule-team-server.sql&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;-&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;For the record, this SQL script is generated when one first logs into the Decision Center, so I just kept a copy :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Terminate the DB2 session&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 terminate&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Start the Decision&amp;nbsp;Centre cluster - as wasadmin&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;AdminControl.invoke(&#39;WebSphere:name=DecisionCenterCluster,process=dmgr,platform=common,node=Dmgr,version=8.5.5.11,type=Cluster,mbeanIdentifier=DecisionCenterCluster,cell=odmCell01,spec=1.0&#39;, &#39;start&#39;)&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Log into the Decision&amp;nbsp;Centre&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as wasadmin&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://odm.uk.ibm.com:9443/teamserver/faces/login.jsp&quot; class=&quot;&quot;&gt;https://odm.uk.ibm.com:9443/teamserver/faces/login.jsp&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Follow the prompts to&amp;nbsp;complete basic setup - extensions, locale ( I&#39;m using &lt;b class=&quot;&quot;&gt;en_GB&lt;/b&gt; as I&#39;m a Brit ) etc. *BUT* avoid executing the generated SQL ( this has already been done ), as per this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://2.bp.blogspot.com/-wBXrOjCPMm8/WWuOl8cBfAI/AAAAAAAACfM/htCkhdTrJL46hR0xMKKKg4zl3CNb8hCMACK4BGAYYCw/s1600/PastedGraphic-1-778519.png&quot;&gt;&lt;img src=&quot;http://2.bp.blogspot.com/-wBXrOjCPMm8/WWuOl8cBfAI/AAAAAAAACfM/htCkhdTrJL46hR0xMKKKg4zl3CNb8hCMACK4BGAYYCw/s320/PastedGraphic-1-778519.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6443400474413595650&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;At this stage, we&#39;ve got a clean Decision Center database, ready to receive BUT with no roles or data migrated from the old environment: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://2.bp.blogspot.com/-lxQeO4rE-Cg/WWuOmWY3ofI/AAAAAAAACfU/dBW_Sv3NdJ4Uoh4-8X025jhJkYRV_LDhACK4BGAYYCw/s1600/PastedGraphic-2-779947.png&quot;&gt;&lt;img src=&quot;http://2.bp.blogspot.com/-lxQeO4rE-Cg/WWuOmWY3ofI/AAAAAAAACfU/dBW_Sv3NdJ4Uoh4-8X025jhJkYRV_LDhACK4BGAYYCw/s320/PastedGraphic-2-779947.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6443400481379688946&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Set variables&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as wasadmin&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;export ANT_HOME=/opt/ibm/ODM89/shared/tools/ant&lt;br class=&quot;&quot;&gt;export PATH=$PATH:/opt/ibm/ODM89/shared/tools/ant/bin&lt;br class=&quot;&quot;&gt;export JAVA_HOME=/opt/ibm/ODM89/jdk/jre&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Run the Ant scripts to extract the roles and data for the old&amp;nbsp;db2user1&amp;nbsp;schema&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as wasadmin&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;cd /opt/ibm/ODM89/teamserver/bin&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ant -DoldDatabaseSchemaName=db2user1 -Dserver.url=&lt;a href=&quot;https://odm.uk.ibm.com:9443/teamserver&quot; class=&quot;&quot;&gt;https://odm.uk.ibm.com:9443/teamserver&lt;/a&gt; -DrtsAdmin.login=wasadmin -DrtsAdmin.password=passw0rd -DoutputFile=/tmp/migrate_roles.sql gen-migration80-role&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ant -DoldDatabaseSchemaName=db2user1 -Dserver.url=&lt;a href=&quot;https://odm.uk.ibm.com:9443/teamserver&quot; class=&quot;&quot;&gt;https://odm.uk.ibm.com:9443/teamserver&lt;/a&gt; -DdatasourceName=jdbc/ilogDataSource -DrtsAdmin.login=wasadmin -DrtsAdmin.password=passw0rd -DoutputFile=&lt;/i&gt;/tmp&lt;i class=&quot;&quot;&gt;/migrate_data.sql gen-migration80-script&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This results in a pair of SQL scripts: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;-rw-r--r-- 1 wasadmin wasadmins 79746 Jul 16 16:25 /tmp/migrate_data.sql&lt;br class=&quot;&quot;&gt;-rw-r--r-- 1 wasadmin wasadmins&amp;nbsp;&amp;nbsp;9552 Jul 16 16:24 /tmp/migrate_roles.sql&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Connect as the new schema - as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 connect to RTSDB user db2user2 using passw0rd&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Execute migration scripts&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 -tvf /tmp/migrate_roles.sql&lt;br class=&quot;&quot;&gt;db2 -tvf /tmp/migrate_data.sql&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Terminate the DB2 session&lt;/u&gt;&lt;u class=&quot;&quot;&gt;&amp;nbsp;- as db2inst1&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;db2 terminate&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Log into the Decision&amp;nbsp;Centre - as wasadmin&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://odm.uk.ibm.com:9443/teamserver/faces/login.jsp&quot; class=&quot;&quot;&gt;https://odm.uk.ibm.com:9443/teamserver/faces/login.jsp&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;C&#39;est voila, we have a NEW ODM 8.9 Decision Centre with the project that was previously created on the OLD ODM 8.0 Decision Centre: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://1.bp.blogspot.com/-N7QN_WMeTfQ/WWuOmuQdL6I/AAAAAAAACfc/-tYzdUvIVwQsplQovnShI17RB49DohjwACK4BGAYYCw/s1600/PastedGraphic-3-781518.png&quot;&gt;&lt;img src=&quot;http://1.bp.blogspot.com/-N7QN_WMeTfQ/WWuOmuQdL6I/AAAAAAAACfc/-tYzdUvIVwQsplQovnShI17RB49DohjwACK4BGAYYCw/s320/PastedGraphic-3-781518.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6443400487786852258&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ilogrulesteamservermodelilrconnectexcep.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/-wBXrOjCPMm8/WWuOl8cBfAI/AAAAAAAACfM/htCkhdTrJL46hR0xMKKKg4zl3CNb8hCMACK4BGAYYCw/s72-c/PastedGraphic-1-778519.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-2171589853525721537</guid><pubDate>Sun, 16 Jul 2017 13:02:00 +0000</pubDate><atom:updated>2017-07-16T14:03:00.507+01:00</atom:updated><title>WebSphere Application Server - Transaction Logs - getting it wrong</title><description>&lt;div class=&quot;&quot;&gt;I do need to write a long-form article about this, but I&#39;ve been on a voyage of discovery configuring AND testing WAS transaction recovery, by placing the transaction/compensation/partner logs in an Oracle 12c database.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This is in the context of an IBM Business Process Manager Advanced environment.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;During the process, I saw this in the SupCluster logs ( specifically the second cluster member ) : -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SupClusterMember2/SystemOut.log:[16/07/17 11:53:47:332 BST] 00000001 WASSessionCor I SessionProperties shouldSetAndDoLogging SESN0169I: Session Manager found the custom property&amp;nbsp;InvalidateOnUnauthorizedSessionRequestException&amp;nbsp;with value true.&lt;br class=&quot;&quot;&gt;SupClusterMember2/SystemOut.log:[16/07/17 11:59:40:316 BST] 0000004d SQLMultiScope I&amp;nbsp;&amp;nbsp;&amp;nbsp;CWRLS0009E: Details of recovery log failure: Another server has locked the HA lock row,&amp;nbsp;com.ibm.ws.recoverylog.spi.InternalLogException: Another server has locked the HA lock row&lt;br class=&quot;&quot;&gt;SupClusterMember2/SystemOut.log:[16/07/17 11:59:40:319 BST] 0000004d SQLMultiScope E&amp;nbsp;&amp;nbsp;&amp;nbsp;CWRLS0024E:&amp;nbsp;Exception&amp;nbsp;caught during recovery! Another server has locked the HA lock row,&amp;nbsp;com.ibm.ws.recoverylog.spi.InternalLogException: Another server has locked the HA lock row&lt;br class=&quot;&quot;&gt;SupClusterMember2/SystemOut.log:[16/07/17 11:59:40:324 BST] 0000004d SQLMultiScope A&amp;nbsp;&amp;nbsp;&amp;nbsp;WTRN0107W: Caught non-SQLException&amp;nbsp;Throwable when forcing SQL RecoveryLog tranlog for server&amp;nbsp;PSCell1\Node2\SupClusterMember2 Throwable: Another server has locked the HA lock row, com.ibm.ws.recoverylog.spi.InternalLogException: Another server has locked the HA lock row&lt;br class=&quot;&quot;&gt;SupClusterMember2/SystemOut.log:[16/07/17 11:59:40:333 BST] 0000004d SQLMultiScope A&amp;nbsp;&amp;nbsp;&amp;nbsp;WTRN0100E: Cannot recover from SQLException&amp;nbsp;when forcing SQL RecoveryLog tranlog for server PSCell1\Node2\SupClusterMember2&amp;nbsp;Exception: Another server has locked the HA lock row, com.ibm.ws.recoverylog.spi.InternalLogException: Another server has locked the HA lock row&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;The problem was a PEBCAK, in that I&#39;d obviously misconfigured things.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I validated my WAS configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;cat /opt/ibm/WebSphereProfiles/Dmgr01/config/cells/PSCell1/nodes/Node1/serverindex.xml | grep -i recoveryLog&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;recoveryLog&amp;nbsp;xmi:id=&quot;RecoveryLog_1500062274540&quot; transactionLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;AppCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;App1&lt;/b&gt;&quot;&amp;nbsp;compensationLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;AppCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;App1&lt;/b&gt;&quot; compensationLogFileSize=&quot;5&quot;/&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;recoveryLog&amp;nbsp;xmi:id=&quot;RecoveryLog_1500062279192&quot; transactionLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;SupCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;Sup1&lt;/b&gt;&quot;/&amp;gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;cat /opt/ibm/WebSphereProfiles/Dmgr01/config/cells/PSCell1/nodes/Node2/serverindex.xml | grep -i recoveryLog&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;recoveryLog&amp;nbsp;xmi:id=&quot;RecoveryLog_1500062274432&quot; transactionLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;AppCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;App2&lt;/b&gt;&quot;&amp;nbsp;compensationLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;AppCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;App2&lt;/b&gt;&quot; compensationLogFileSize=&quot;5&quot;/&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;recoveryLog&amp;nbsp;xmi:id=&quot;RecoveryLog_1500062279152&quot; transactionLogDirectory=&quot;&lt;a href=&quot;custom://com.ibm.rls.jdbc.SQL&quot; class=&quot;&quot;&gt;custom://com.ibm.rls.jdbc.SQL&lt;/a&gt;RecoveryLog?datasource=jdbc/&lt;b class=&quot;&quot;&gt;SupCluster_Tranlogs&lt;/b&gt;,tablesuffix=&lt;b class=&quot;&quot;&gt;Sup2&lt;/b&gt;&quot;/&amp;gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;to ensure that I : -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;(a) was using the right datasources for the right clusters ( AppCluster has both Transaction and Compensation logs, whereas SupCluster only has Transaction logs )&lt;/div&gt;&lt;div class=&quot;&quot;&gt;(b) had suitably incremented the suffix - &lt;b class=&quot;&quot;&gt;App1&lt;/b&gt; or &lt;b class=&quot;&quot;&gt;Sup1&lt;/b&gt; for member &lt;b class=&quot;&quot;&gt;1&lt;/b&gt;, &lt;b class=&quot;&quot;&gt;App2&lt;/b&gt; or &lt;b class=&quot;&quot;&gt;Sup2&lt;/b&gt; for member &lt;b class=&quot;&quot;&gt;2&lt;/b&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Finally, as this was a &lt;u class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;TEST&lt;/b&gt;&lt;/u&gt;&amp;nbsp;environment, I dropped the tables: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_TRAN_LOGAPP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_PARTNER_LOGAPP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_COMP_LOGAPP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_TRAN_LOGAPP2;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_PARTNER_LOGAPP2;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_COMP_LOGAPP2;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_TRAN_LOGSUP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_PARTNER_LOGSUP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_COMP_LOGSUP1;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_TRAN_LOGSUP2;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_PARTNER_LOGSUP2;&lt;br class=&quot;&quot;&gt;DROP TABLE CMNUSER.WAS_COMP_LOGSUP2;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and recreated them: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;CREATE TABLE CMNUSER.WAS_TRAN_LOGAPP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;CREATE TABLE CMNUSER.WAS_PARTNER_LOGAPP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;CREATE TABLE CMNUSER.WAS_COMP_LOGAPP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;CREATE TABLE CMNUSER.WAS_TRAN_LOGAPP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;CREATE TABLE CMNUSER.WAS_PARTNER_LOGAPP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;CREATE TABLE CMNUSER.WAS_COMP_LOGAPP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;CREATE TABLE CMNUSER.WAS_TRAN_LOGSUP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;CREATE TABLE CMNUSER.WAS_PARTNER_LOGSUP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;CREATE TABLE CMNUSER.WAS_COMP_LOGSUP1(&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;CREATE TABLE CMNUSER.WAS_TRAN_LOGSUP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;CREATE TABLE CMNUSER.WAS_PARTNER_LOGSUP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;CREATE TABLE CMNUSER.WAS_COMP_LOGSUP2(&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVER_NAME VARCHAR(128),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;SERVICE_ID SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RU_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_ID NUMBER(19),&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;RUSECTION_DATA_INDEX SMALLINT,&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;DATA BLOB);&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;And all is well.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;From a testing perspective, I&#39;ve created a SCA module which uses a JDBC Resource Adapter to create/update/read data from an Oracle database table.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Again, that&#39;s for a future long-form article ….&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/websphere-application-server.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-2454028581989539518</guid><pubDate>Sun, 16 Jul 2017 12:43:00 +0000</pubDate><atom:updated>2017-07-16T13:43:39.776+01:00</atom:updated><title>XAException occurred.  Error code is: XAER_RMERR (-3).  Exception is: </title><description>&lt;div class=&quot;&quot;&gt;I&#39;m tinkering with WebSphere Application Server, underlying IBM BPM Advanced, in the context of transaction/compensation/partner log recovery.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In this scenario, I&#39;m placing these logs into a database, Oracle 12c.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;It&#39;s been a useful - and interesting - learning curve, and I&#39;ve pretty much proved/tested the concept.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I did, however, see one issue today; specifically, these messages: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;[16/07/17 13:34:06:748 BST] 00000074 XARecoveryDat A&amp;nbsp;&amp;nbsp;&amp;nbsp;WTRN0151I: Preparing to call xa recover on XAResource: dave&lt;br class=&quot;&quot;&gt;[16/07/17 13:34:06:866 BST] 00000074 WSRdbXaResour E&amp;nbsp;&amp;nbsp;&amp;nbsp;DSRA0304E:&amp;nbsp;&amp;nbsp;XAException occurred. XAException contents and details are: &quot;&quot;.&lt;br class=&quot;&quot;&gt;[16/07/17 13:34:06:866 BST] 00000074 WSRdbXaResour E&amp;nbsp;&amp;nbsp;&amp;nbsp;DSRA0302E:&amp;nbsp;&amp;nbsp;XAException occurred.&amp;nbsp;&amp;nbsp;Error code is: XAER_RMERR (-3).&amp;nbsp;&amp;nbsp;Exception is: &amp;lt;null&amp;gt;&lt;br class=&quot;&quot;&gt;[16/07/17 13:34:06:866 BST] 00000074 XARminst&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;E&amp;nbsp;&amp;nbsp;&amp;nbsp;WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was [email protected]&amp;nbsp;The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:727)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1111)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:723)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:432)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1544)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2286)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:119)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2239)&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at java.lang.Thread.run(Thread.java:809)&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;appearing in the &lt;b class=&quot;&quot;&gt;SystemOut.log&lt;/b&gt;&amp;nbsp;for one of my cluster members - AppCluster.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This IBM Knowledge Center article: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/SSEQTP_8.5.5/com.ibm.websphere.base.doc/ae/rtrb_dsaccess2.html&quot; class=&quot;&quot;&gt;Data access problems for Oracle data sources&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&amp;lt;snip&amp;gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Problem&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;When WebSphere Application Server attempts to&amp;nbsp;recover Oracle database transactions, the transaction service issues&amp;nbsp;the following exception:&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;WTRN0037W: The transaction service encountered an error on an xa_recover operation.&amp;nbsp;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;The resource was [email protected]&amp;nbsp;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;The error code was XAER_RMERR. The exception stack trace follows:&amp;nbsp;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;javax.transaction.xa.XAException&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:726)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:954)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:609)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:511)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1784)&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2241)&lt;/font&gt;&lt;/div&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Cause&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Oracle&amp;nbsp;requires services such as the WebSphere Application&amp;nbsp;Server transaction service to have special permissions for performing&amp;nbsp;transaction recoveries.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Solution&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;As user SYS, run the&amp;nbsp;following commands on your Oracle server:&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;grant select on pending_trans$ to public;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;grant select on dba_2pc_pending to public;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;grant select on dba_pending_transactions to public;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;grant execute on dbms_system to &amp;lt;user&amp;gt;;&lt;/font&gt;&lt;/div&gt;&lt;i class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;User&amp;nbsp;is&amp;nbsp;a user ID in the application server that is authorized to perform&amp;nbsp;transaction recovery for the XA data source. If you have not authorized&amp;nbsp;any user IDs to perform transaction recovery, the application server&amp;nbsp;uses the login alias for the data source as the user&amp;nbsp;ID.&lt;br class=&quot;&quot;&gt;This&amp;nbsp;problem is mentioned under Oracle bug: 3979190. Running the preceding&amp;nbsp;commands solves the problem.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&amp;lt;/snip&amp;gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Following the KC article, I updated the Oracle DB permissions: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sqlplus / as sysdba&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 16 13:20:39 2017&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1982, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connected to:&lt;br class=&quot;&quot;&gt;Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;grant select on pending_trans$ to public;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Grant succeeded.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;grant select on dba_2pc_pending to public;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Grant succeeded.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;grant select on dba_pending_transactions to public;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Grant succeeded.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;grant execute on dbms_system to cmnuser;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Grant succeeded.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then restarted the AppCluster.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Let&#39;s see how it goes, but it&#39;s looking good so far.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/xaexception-occurred-error-code-is.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-67474625022932778</guid><pubDate>Fri, 14 Jul 2017 20:02:00 +0000</pubDate><atom:updated>2017-07-14T21:02:16.997+01:00</atom:updated><title>TypeError: __add__ nor __radd__ defined for these operands</title><description>Whilst scripting the configuration of the WebSphere Application Server transaction/compensation/partner logs into an Oracle database: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphereProfiles/Dmgr01/bin/wsadmin.sh -lang jython -user wasadmin -password passw0rd -f tranlogs.jy&amp;nbsp;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I saw this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;WASX7209I: Connected to process &quot;dmgr&quot; on node Dmgr using SOAP connector;&amp;nbsp;&amp;nbsp;The type of process is: DeploymentManager&lt;br class=&quot;&quot;&gt;WASX7017E: Exception received while running file &quot;tranlogs.jy&quot;; exception information: com.ibm.bsf.BSFException: exception from Jython:&lt;br class=&quot;&quot;&gt;Traceback (innermost last):&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;File &quot;&amp;lt;string&amp;gt;&quot;, line 18, in ?&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;TypeError: __add__ nor __radd__ defined for these operands&lt;/b&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Last time I saw this error ( 2012 ), it was user error.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I checked my script ( specifically line 18 as per the exception ) : -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;datasource=AdminTask.createDatasource(provider,&amp;nbsp;&#39;[-name &#39;+clusterName+&#39;_Tranlogs -jndiName jdbc/&#39;+clusterName+&#39;_Tranlogs -dataStoreHelperClassName com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper -containerManagedPersistence true -componentManagedAuthenticationAlias &#39;+j2cAlias+&#39; -configureResourceProperties [[URL java.lang.String jdbc:oracle:thin:@//&#39;+dbHost+&#39;:&#39;+dbPort+&#39;/&#39;+dbName+&#39;]]]&#39;)&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Looking at the concatenation of three strings ( dbHost, dbPort and dbName ) gave me a clue, and I checked the variables, and found: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;dbPort=1521&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;In other words, I&#39;d defined it as an integer whereas Jython was expected a string.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I changed it: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;dbPort=&#39;1521&#39;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;the script ran without errors.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/typeerror-add-nor-radd-defined-for.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-3572090831159421061</guid><pubDate>Fri, 14 Jul 2017 19:42:00 +0000</pubDate><atom:updated>2017-07-14T20:42:59.198+01:00</atom:updated><title>CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/TeamWorksDB</title><description>&lt;div class=&quot;&quot;&gt;This follows on from an earlier post: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://portal2portal.blogspot.co.uk/2017/07/ora-12514-tnslistener-does-not.html&quot; class=&quot;&quot;&gt;ORA-12514, TNS:listener does not currently know of service requested in connect descriptor&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Having updated my JDBC data sources to reflect the correct Oracle service name: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;jdbc:oracle:thin:@//&lt;a href=&quot;http://bpm857.uk.ibm.com:1521/orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com:1521/orcl.uk.ibm.com&lt;/a&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;m now seeing the following warning: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;[14/07/17 20:07:17:855 BST] 000000f5 ConfigReader&amp;nbsp;&amp;nbsp;W com.ibm.bpm.config.util.ws.ConfigReader getDatabaseInfo&amp;nbsp;CWMCB0012W: An inconsistent configuration has been detected for data&amp;nbsp;source jdbc/TeamWorksDB. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;in the SystemOut.log for the AppCluster members.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;The IBM BPM Knowledge Center has a solution: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;CWMCB0012W&amp;nbsp; &amp;nbsp;An inconsistent configuration has been detected for data source&amp;nbsp;0. It is assumed that the correct Oracle&amp;nbsp;service name or SID is&amp;nbsp;1&amp;nbsp;rather than&amp;nbsp;2.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Explanation&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;An&amp;nbsp;IBM BPM data source has been manually modified rather than updated&amp;nbsp;using the &quot;BPMConfig -update -dataSource&quot; command. The resulting&amp;nbsp;configuration is inconsistent.&lt;br class=&quot;&quot;&gt;User response&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Export&amp;nbsp;the IBM BPM deployment environment configuration and fix the data&amp;nbsp;source configuration by running the &quot;BPMConfig -update -dataSource&quot;&amp;nbsp;command.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Following the advice therein, I exported the BPM configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -profile Dmgr01 -de De1 -outputDir /tmp/De1&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Logging to file /opt/ibm/WebSphere/AppServer/logs/config/BPMConfig_20170714-203920.log.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/WPSDB. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/ECMDBXA. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/CommonDB. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/BPEDB. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/ECMDB. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;CWMCB0012W: An inconsistent configuration has been detected for data source jdbc/SharedDb. It is assumed that the correct Oracle service name or SID is &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt; rather than orcl.&lt;br class=&quot;&quot;&gt;The &#39;BPMConfig.sh -export -profile Dmgr01 -de De1 -outputDir /tmp/De1&#39; command completed successfully.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then updated the Data Source configuration: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -update -dataSource /tmp/De1/De1.properties&amp;nbsp;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Logging to file /opt/ibm/WebSphere/AppServer/logs/config/BPMConfig_20170714-204136.log.&lt;br class=&quot;&quot;&gt;Saving configuration changes...&lt;br class=&quot;&quot;&gt;The &#39;BPMConfig.sh -update -dataSource /tmp/De1/De1.properties&#39; command completed successfully.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then re-exported the configuration to check that all was good: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -profile Dmgr01 -de De1 -outputDir /tmp/Foobar&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Logging to file /opt/ibm/WebSphere/AppServer/logs/config/BPMConfig_20170714-204220.log.&lt;br class=&quot;&quot;&gt;The &#39;BPMConfig.sh -export -profile Dmgr01 -de De1 -outputDir /tmp/Foobar&#39; command completed successfully.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So that&#39;s all good then :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/cwmcb0012w-inconsistent-configuration.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-4902904412514673466</guid><pubDate>Fri, 14 Jul 2017 19:32:00 +0000</pubDate><atom:updated>2017-07-14T20:32:06.476+01:00</atom:updated><title>IBM BPM - &quot;CWSCA8095W: Unable to find class...&quot; seen during serviceDeploy process</title><description>&lt;div class=&quot;&quot;&gt;I&#39;m tinkering with IBM BPM Advanced again, specifically taking an export of an SCA module, built using IBM Integration Designer and exported as a Project Interchange (PI) file, and attempting to &quot;compile&quot; it ready for deploying to an external IBM BPM 8.57 environment.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Having exported the PI file, and made it available to the BPM box, I then ran &lt;b class=&quot;&quot;&gt;serviceDeploy.sh&lt;/b&gt;&amp;nbsp;against it: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/serviceDeploy.sh OracleTest.zip&amp;nbsp;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which returned: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;The workbench is starting in /home/wasadmin/15d428ea0a1.&lt;br class=&quot;&quot;&gt;The workspace is initializing.&lt;br class=&quot;&quot;&gt;OracleTest.zip was successfully imported into the workspace.&lt;br class=&quot;&quot;&gt;The OracleTestApp project is being created.&lt;br class=&quot;&quot;&gt;The OracleTestWeb project is being created.&lt;br class=&quot;&quot;&gt;The OracleTest project is building.&lt;br class=&quot;&quot;&gt;OracleTest is being validated.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;The following 36 warning messages were reported during deployment:&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.jdbc.JDBCInteractionSpec, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.jdbc.JDBCInteractionSpec, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.jdbc.JDBCInteractionSpec, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultSelectorImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8085W: The fault selector of com.ibm.j2ca.extension.emd.runtime.WBIFaultSelectorImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.MatchingFaultDataBinding, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.MatchingFaultDataBinding type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.MatchingFaultDataBinding, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.MatchingFaultDataBinding type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA9537W: The fault binding of com.ibm.j2ca.extension.emd.runtime.WBIFaultDataBindingImpl type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.jdbc.JDBCManagedConnectionFactory, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8043W: com.ibm.j2ca.jdbc.JDBCManagedConnectionFactory cannot be validated.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8095W: Unable to find class com.ibm.j2ca.jdbc.JDBCResourceAdapter, please make sure the class path is properly set up.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;CWSCA8082E: The resource adapter of the com.ibm.j2ca.jdbc.JDBCResourceAdapter type is missing in the class path or in the dependencies.&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;toAndFromOracle.import&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Severity:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;[warning]&lt;br class=&quot;&quot;&gt;Description:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;XSD: The location &#39;JDBCASI.xsd&#39; has not been resolved&lt;br class=&quot;&quot;&gt;Resource:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;DaveConsultant.xsd&lt;br class=&quot;&quot;&gt;Location:&amp;nbsp;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;1&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;The OracleTestApp.ear application is being exported.&lt;br class=&quot;&quot;&gt;Deployment has completed.&lt;br class=&quot;&quot;&gt;The workspace is being deleted.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Now I&#39;ve definitely done this before ….&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;… but, this time around, I&#39;m also using a JDBC Resource Adapter (RA) as evidenced by the messages e.g.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;CWSCA8082E: The resource adapter of the com.ibm.j2ca.jdbc.JDBCResourceAdapter type is missing in the class path or in the dependencies.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;This provided a clue.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Next time around, I exported BOTH the SCA module AND the dependent project that contains the JDBC Resource Adapter code ( this was created for me when I dragged a JDBC Adapter component into my Assembly Diagram : -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://1.bp.blogspot.com/-woVmtOjblLA/WWkcN_OetQI/AAAAAAAACfA/T3bkzlZnPlMb7ExLQX_-tUc5gMCXBWBxgCK4BGAYYCw/s1600/PastedGraphic-2-726478.png&quot;&gt;&lt;img src=&quot;http://1.bp.blogspot.com/-woVmtOjblLA/WWkcN_OetQI/AAAAAAAACfA/T3bkzlZnPlMb7ExLQX_-tUc5gMCXBWBxgCK4BGAYYCw/s320/PastedGraphic-2-726478.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6442711768566248706&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;For the record, this was the PI file first time around: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;-rwxr-xr-x&amp;nbsp;&amp;nbsp;&amp;nbsp;1 wasadmin wasadmins&amp;nbsp;&amp;nbsp;&amp;nbsp;31538 Jul 14 20:23&amp;nbsp;OracleTest.zip&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;and this was the version the second time around: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;-rwxr-xr-x&amp;nbsp;&amp;nbsp;&amp;nbsp;1 wasadmin wasadmins 5747285 Jul 14 20:30&amp;nbsp;OracleTest.zip&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;It looks slightly more podgy because it contains the RA code.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;More importantly, the &quot;compilation&quot; process worked a treat: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;The workbench is starting in /home/wasadmin/15d42955f45.&lt;br class=&quot;&quot;&gt;The workspace is initializing.&lt;br class=&quot;&quot;&gt;OracleTest.zip was successfully imported into the workspace.&lt;br class=&quot;&quot;&gt;The OracleTestApp project is being created.&lt;br class=&quot;&quot;&gt;The OracleTestWeb project is being created.&lt;br class=&quot;&quot;&gt;The OracleTest project is building.&lt;br class=&quot;&quot;&gt;OracleTest is being validated.&lt;br class=&quot;&quot;&gt;The OracleTestApp.ear application is being exported.&lt;br class=&quot;&quot;&gt;Deployment has completed.&lt;br class=&quot;&quot;&gt;The workspace is being deleted.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ibm-bpm-cwsca8095w-unable-to-find-class.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://1.bp.blogspot.com/-woVmtOjblLA/WWkcN_OetQI/AAAAAAAACfA/T3bkzlZnPlMb7ExLQX_-tUc5gMCXBWBxgCK4BGAYYCw/s72-c/PastedGraphic-2-726478.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-6924424419565240369</guid><pubDate>Fri, 14 Jul 2017 19:16:00 +0000</pubDate><atom:updated>2017-07-14T20:16:30.122+01:00</atom:updated><title>java.sql.SQLException: Could not commit with auto-commit set on</title><description>&lt;div class=&quot;&quot;&gt;I saw this earlier: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;[14/07/17 20:00:02:593 BST]&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;FFDC Exception:java.sql.SQLException SourceId:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit ProbeId:587 Reporter:[email protected]&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;java.sql.SQLException: Could not commit with auto-commit set on&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;in the FFDC logs for an IBM BPM 8.57 JVM: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;view /opt/ibm/WebSphereProfiles/AppSrv01/logs/ffdc/AppClusterMember1_72d880eb_17.07.14_20.00.02.5935101433318572951378.txt&amp;nbsp;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I am using Oracle 12c ( specifically &lt;b class=&quot;&quot;&gt;12.2.0.1.0&lt;/b&gt;&amp;nbsp; )&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and am using the version of the Oracle JDBC drivers that ship with WAS 8.5.5.11: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ls -altrc /opt/ibm/WebSphere/AppServer/jdbcdrivers/Oracle/&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;total 6632&lt;br class=&quot;&quot;&gt;&lt;b class=&quot;&quot;&gt;-rw-r--r-- 1 wasadmin wasadmins 3389454 Jul 10 19:59&amp;nbsp;ojdbc6.jar&lt;/b&gt;&lt;br class=&quot;&quot;&gt;drwxr-xr-x 5 wasadmin wasadmins&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;45 Jul 10 19:59&amp;nbsp;..&lt;br class=&quot;&quot;&gt;drwxr-xr-x 2 wasadmin wasadmins&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;40 Jul 10 19:59&amp;nbsp;.&lt;br class=&quot;&quot;&gt;-rw-r--r-- 1 wasadmin wasadmins 3397734 Jul 10 19:59&amp;nbsp;ojdbc7.jar&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;specifically: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/java_1.7.1_64/jre/bin/java -jar /opt/ibm/WebSphere/AppServer/jdbcdrivers/Oracle/ojdbc6.jar -getversion&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Oracle 12.1.0.1.0 JDBC 4.0 compiled with JDK6 on Thu_Apr_04_15:06:58_PDT_2013&lt;br class=&quot;&quot;&gt;#Default Connection Properties Resource&lt;br class=&quot;&quot;&gt;#Fri Jul 14 20:11:21 BST 2017&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Source:&amp;nbsp;&lt;a href=&quot;https://blogs.oracle.com/csoto/checking-the-oracle-jdbc-driver-version-on-a-weblogic-server&quot; class=&quot;&quot;&gt;Checking the Oracle JDBC Driver Version on a Weblogic Server&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Thankfully, this IBM developerWorks Answers ( dwAnswers ) page: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://developer.ibm.com/answers/questions/240645/how-to-resolve-wtrn0107w-could-not-commit-with-aut.html&quot; class=&quot;&quot;&gt;How to resolve &quot;WTRN0107W: Could not commit with auto-commit set on&quot; exceptions in WebSphere Application Server?&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;provides an answer: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;This kind of exceptions occur when the Oracle JDBC Driver&amp;nbsp;(ojdbc6.jar) version 12 or above will be used. Version 12 and above of&amp;nbsp;the driver is more strictly than earlier driver versions.&amp;nbsp;You can solve the problem, by setting the jvm-argument:&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;• &amp;nbsp;-Doracle.jdbc.autoCommitSpecCompliant=false&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;/div&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;on all affected servers.&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;as does this IBM Technote: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www-01.ibm.com/support/docview.wss?uid=swg21989586&quot; class=&quot;&quot;&gt;java.sql.SQLException: Could not commit with auto-commit set on&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I added the JVM property, and restarted the AppCluster, all was well.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;For the record, this is what I now have in &lt;b class=&quot;&quot;&gt;server.xml&lt;/b&gt;&amp;nbsp;in the context of JVM arguments: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;lt;jvmEntries xmi:id=&quot;JavaVirtualMachine_1499716654178&quot; verboseModeClass=&quot;false&quot; verboseModeGarbageCollection=&quot;true&quot; verboseModeJNI=&quot;false&quot; initialHeapSize=&quot;1536&quot; maximumHeapSize=&quot;2560&quot; runHProf=&quot;false&quot;&amp;nbsp;hprofArguments=&quot;&quot; debugMode=&quot;false&quot; debugArgs=&quot;-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=7777&quot; genericJvmArguments=&quot;${IBMSCMX} ${IBMGCPOLICY_GENCON} ${IBMJITPMC} -Xmns256m -Xmnx768m -Xgc:preferredHeapBase=0x100000000 -Xdisableexplicitgc -Xss2048k -&lt;a href=&quot;http://Dsun.net&quot; class=&quot;&quot;&gt;Dsun.net&lt;/a&gt;.http.allowRestrictedHeaders=true -Declipse.bundle.setTCCL=false&amp;nbsp;&amp;nbsp;&lt;b class=&quot;&quot;&gt;-Doracle.jdbc.autoCommitSpecCompliant=false&quot;&lt;/b&gt; executableJarFileName=&quot;&quot;&amp;nbsp;disableJIT=&quot;false&quot;&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;and, via the GUI: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://3.bp.blogspot.com/-HVrAeEP6UVs/WWkYj9AMbFI/AAAAAAAACe4/jWR3CyF8BFIXeuKWOpztOsJ6JTeucKO_wCK4BGAYYCw/s1600/PastedGraphic-1-790123.png&quot;&gt;&lt;img src=&quot;http://3.bp.blogspot.com/-HVrAeEP6UVs/WWkYj9AMbFI/AAAAAAAACe4/jWR3CyF8BFIXeuKWOpztOsJ6JTeucKO_wCK4BGAYYCw/s320/PastedGraphic-1-790123.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6442707747880070226&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/javasqlsqlexception-could-not-commit.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://3.bp.blogspot.com/-HVrAeEP6UVs/WWkYj9AMbFI/AAAAAAAACe4/jWR3CyF8BFIXeuKWOpztOsJ6JTeucKO_wCK4BGAYYCw/s72-c/PastedGraphic-1-790123.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-3831546332000912699</guid><pubDate>Tue, 11 Jul 2017 06:19:00 +0000</pubDate><atom:updated>2017-07-11T07:19:58.825+01:00</atom:updated><title>Bootstrap cannot be run against WebSphere:cell=PSCell1,node=Node2,server=dmgr because it is not a BPM deployment target.</title><description>Another thing that makes me go &quot;Hmmmm&quot; …&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;m running the process to bootstrap an IBM BPM 8.5.7 Process Server: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphereProfiles/Dmgr01/bin/bootstrapProcessServerData.sh - clusterName AppCluster&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;and I see this: -&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Bootstraping data for server at /opt/ibm/WebSphereProfiles/Dmgr01 and logging into /opt/ibm/WebSphereProfiles/Dmgr01/logs/bootstrapProcesServerData.log&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;WASX7357I: By request, this scripting client is not connected to any server process. Certain configuration and application operations will be available in local mode.&lt;br class=&quot;&quot;&gt;Bootstrap cannot be run against WebSphere:cell=PSCell1,node=Node2,server=dmgr because it is not a BPM deployment target.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Now I&#39;m not just offended that we can&#39;t get the spelling of &quot;bootstrapping&quot; right - even though I pointed the error out to someone in 2012 :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;But what else can you see ?&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Yeah, it took me a minute ….&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I&#39;d copied and pasted the command from a PDF and, thanks to the vagaries of PDFs, a space has crept into the command: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphereProfiles/Dmgr01/bin/bootstrapProcessServerData.sh - clusterName AppCluster&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;between the hyphen ( - ) and &lt;b class=&quot;&quot;&gt;clusterName&lt;/b&gt;.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I fixed the command: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphereProfiles/Dmgr01/bin/bootstrapProcessServerData.sh -clusterName AppCluster&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;#LifeIsGood again&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Bootstraping data into cluster AppCluster and logging into /opt/ibm/WebSphereProfiles/Dmgr01/logs/bootstrapProcesServerData.AppCluster.log&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;WASX7357I: By request, this scripting client is not connected to any server process. Certain configuration and application operations will be available in local mode.&lt;br class=&quot;&quot;&gt;Activating snapshot 8.5.7.0 in process app TWP&lt;br class=&quot;&quot;&gt;Activating snapshot done: 8.5.7.0 in process app TWP&lt;br class=&quot;&quot;&gt;Activating snapshot 8.5.7.0 in process app SYSRP&lt;br class=&quot;&quot;&gt;Activating snapshot done: 8.5.7.0 in process app SYSRP&lt;br class=&quot;&quot;&gt;&#39;BootstrapProcessServerData admin command completed successfully.....&#39;&lt;br class=&quot;&quot;&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/bootstrap-cannot-be-run-against.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-1626142732558886832</guid><pubDate>Tue, 11 Jul 2017 06:11:00 +0000</pubDate><atom:updated>2017-07-11T07:11:41.487+01:00</atom:updated><title>ORA-12514, TNS:listener does not currently know of service requested in connect descriptor</title><description>&lt;div class=&quot;&quot;&gt;I&#39;m tinkering with a new Oracle 12C build, using it as a database for an IBM BPM Advanced 8.5.7 environment.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;However, something seems to have gone awry with my WAS -&amp;gt; Oracle configuration, as I see this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;[11/07/17 06:58:16:482 BST] 000000f1 DataSourceCon E&amp;nbsp;&amp;nbsp;&amp;nbsp;DSRA8040I: Failed to connect to the DataSource &quot;&quot;.&amp;nbsp;&amp;nbsp;Encountered java.sql.SQLException: Listener refused the connection with the following error:&lt;br class=&quot;&quot;&gt;ORA-12514, TNS:listener does not currently know of service requested in connect descriptor&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;DSRA0010E: SQL State = 08006, Error Code = 12,514&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;in my Node Agent SystemOut.log, when I test a data source connection, and this in the ISC: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://4.bp.blogspot.com/-yrYyx_UvcIE/WWRsHpIjzQI/AAAAAAAACeg/PMIITDht8XEoe8rzlfT0LjV7ct7XoqGtgCK4BGAYYCw/s1600/PastedGraphic-1-701489.png&quot;&gt;&lt;img src=&quot;http://4.bp.blogspot.com/-yrYyx_UvcIE/WWRsHpIjzQI/AAAAAAAACeg/PMIITDht8XEoe8rzlfT0LjV7ct7XoqGtgCK4BGAYYCw/s320/PastedGraphic-1-701489.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6441392245603290370&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I checked the Oracle listener: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;lsnrctl services&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-JUL-2017 07:02:01&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1991, 2016, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=&lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;)(PORT=1521)))&lt;br class=&quot;&quot;&gt;Services Summary...&lt;br class=&quot;&quot;&gt;Service &quot;&lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt;&quot; has 1 instance(s).&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;Instance &quot;orcl&quot;, status READY, has 1 handler(s) for this service...&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;Handler(s):&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&quot;DEDICATED&quot; established:2 refused:0 state:ready&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;LOCAL SERVER&lt;br class=&quot;&quot;&gt;Service &quot;&lt;a href=&quot;http://orclXDB.uk.ibm.com&quot; class=&quot;&quot;&gt;orclXDB.uk.ibm.com&lt;/a&gt;&quot; has 1 instance(s).&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;Instance &quot;orcl&quot;, status READY, has 1 handler(s) for this service...&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;Handler(s):&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&quot;D000&quot; established:0 refused:0 current:0 max:1022 state:ready&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DISPATCHER &amp;lt;machine: &lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;, pid: 8429&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;(ADDRESS=(PROTOCOL=tcp)(HOST=&lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;)(PORT=12518))&lt;br class=&quot;&quot;&gt;The command completed successfully&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;netstat -aon | grep LISTEN | grep 1521&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;tcp6&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;0 :::1521&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;:::*&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;LISTEN&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;off (0.00/0/0)&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;telnet `hostname` 1521&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Trying 192.168.153.132...&lt;br class=&quot;&quot;&gt;Connected to &lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;.&lt;br class=&quot;&quot;&gt;Escape character is &#39;^]&#39;.&lt;br class=&quot;&quot;&gt;telnet&amp;gt; &lt;/font&gt;&lt;i class=&quot;&quot;&gt;quit&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;Connection closed.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then checked the database itself: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sqlplus / as sysdba&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL&amp;gt;&lt;/font&gt; &lt;i class=&quot;&quot;&gt;select value from v$parameter where name=&#39;service_names&#39;;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;VALUE&lt;br class=&quot;&quot;&gt;————————————————————————————————————————&lt;br class=&quot;&quot;&gt;&lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt;&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;cat /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora&lt;br class=&quot;&quot;&gt;# Generated by Oracle configuration tools.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;LISTENER_ORCL =&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(ADDRESS = (PROTOCOL = TCP)(HOST = &lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;)(PORT = 1521))&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;ORCL =&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;(DESCRIPTION =&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;(ADDRESS = (PROTOCOL = TCP)(HOST = &lt;a href=&quot;http://bpm857.uk.ibm.com&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com&lt;/a&gt;)(PORT = 1521))&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;(CONNECT_DATA =&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;(SERVER = DEDICATED)&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;(SERVICE_NAME = &lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt;)&lt;br class=&quot;&quot;&gt;&amp;nbsp; &amp;nbsp;&amp;nbsp;)&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;)&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which explains a lot.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;My JDBC data sources have the Oracle URL like this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;jdbc:oracle:thin:@//&lt;a href=&quot;http://bpm857.uk.ibm.com:1521/&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com:1521/&lt;/a&gt;&lt;b class=&quot;&quot;&gt;orcl&lt;/b&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;whereas they should be like this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;jdbc:oracle:thin:@//&lt;a href=&quot;http://bpm857.uk.ibm.com:1521/&quot; class=&quot;&quot;&gt;bpm857.uk.ibm.com:1521/&lt;/a&gt;&lt;b class=&quot;&quot;&gt;&lt;a href=&quot;http://orcl.uk.ibm.com&quot; class=&quot;&quot;&gt;orcl.uk.ibm.com&lt;/a&gt;&lt;/b&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Once I changed and saved the configuration, the Test Connection works SO much better: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://4.bp.blogspot.com/-By6e6Gr8DDc/WWRsH2PyC6I/AAAAAAAACeo/Aqd3uhbEkG8mQl4PTgu8Xfd0tnYU5yN7ACK4BGAYYCw/s1600/PastedGraphic-2-702961.png&quot;&gt;&lt;img src=&quot;http://4.bp.blogspot.com/-By6e6Gr8DDc/WWRsH2PyC6I/AAAAAAAACeo/Aqd3uhbEkG8mQl4PTgu8Xfd0tnYU5yN7ACK4BGAYYCw/s320/PastedGraphic-2-702961.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6441392249123244962&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/ora-12514-tnslistener-does-not.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-yrYyx_UvcIE/WWRsHpIjzQI/AAAAAAAACeg/PMIITDht8XEoe8rzlfT0LjV7ct7XoqGtgCK4BGAYYCw/s72-c/PastedGraphic-1-701489.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-1771533003750430177</guid><pubDate>Sat, 08 Jul 2017 07:53:00 +0000</pubDate><atom:updated>2017-07-08T08:53:22.628+01:00</atom:updated><title>Tinkering with Oracle 12c on Linux - will the fun ever stop ?</title><description>&lt;div class=&quot;&quot;&gt;I&#39;m going back through the process of learning how to install Oracle 12c on Red Hat Enterprise Linux 7.3.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;One niggle that I saw post-install was this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;sqlplus / as sysdba;&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 8 05:23:05 2017&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;Copyright (c) 1982, 2014, Oracle.&amp;nbsp;&amp;nbsp;All rights reserved.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;ERROR:&lt;br class=&quot;&quot;&gt;ORA-12547: TNS:lost contact&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;During the installation, I&#39;d seen reference to a missing dependency: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;/usr/bin/ld: cannot find -ljavavm12&lt;br class=&quot;&quot;&gt;collect2: error: ld returned 1 exit status&lt;br class=&quot;&quot;&gt;make: *** [/home/oracle/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle] Error 1&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I dug about and found the missing artefact: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;/home/oracle/app/oracle/product/12.1.0/dbhome_1/javavm/jdk/jdk7/lib/libjavavm12.a&lt;/font&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which I placed here: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;/home/oracle/app/oracle/product/12.1.0/dbhome_1/lib&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;via: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;ln -s&amp;nbsp;/home/oracle/app/oracle/product/12.1.0/dbhome_1/javavm/jdk/jdk7/lib/libjavavm12.a&amp;nbsp;/home/oracle/app/oracle/product/12.1.0/dbhome_1/lib&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Having linked the binary, I then re-ran &lt;b class=&quot;&quot;&gt;dbca&lt;/b&gt;&amp;nbsp;to delete the original borked database ( there was, of course, no data therein ) and create a new working database :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/tinkering-with-oracle-12c-on-linux-will.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-4270375527718517305</guid><pubDate>Thu, 06 Jul 2017 15:50:00 +0000</pubDate><atom:updated>2017-07-06T16:51:14.726+01:00</atom:updated><title>Someone Else&#39;s Blog - How to automatically remove meeting invitations from your IBM Lotus Notes Inbox after you have responded to them</title><description>It&#39;s always semi-annoyed me that Notes 9 doesn&#39;t automatically remove calendar invitations from my Inbox when I&#39;ve processed them: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://2.bp.blogspot.com/-KJvEI5-YmXU/WV5cdKrppHI/AAAAAAAACeE/mxxHy8MaN7IQn-vSgV5I_qch6rEIiqq0QCK4BGAYYCw/s1600/PastedGraphic-1-774728.png&quot;&gt;&lt;img src=&quot;http://2.bp.blogspot.com/-KJvEI5-YmXU/WV5cdKrppHI/AAAAAAAACeE/mxxHy8MaN7IQn-vSgV5I_qch6rEIiqq0QCK4BGAYYCw/s320/PastedGraphic-1-774728.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6439686173339788402&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I have to go and click the &lt;b class=&quot;&quot;&gt;Remove From Folder&lt;/b&gt;&amp;nbsp;button each and every time, which is a PITA.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Thankfully the legend&amp;nbsp;&lt;a href=&quot;https://www.twitter.com/matnewman&quot; class=&quot;&quot;&gt;Mr Mat Newman&lt;/a&gt;&amp;nbsp;has a solution: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://www.matnewman.com/webs/personal/matblog.nsf/dx/how-to-automatically-remove-metting-invitations-from-your-ibm-lotus-notes-inbox-after-you-have-responded-to-them&quot; class=&quot;&quot;&gt;How to automatically remove meeting invitations from your IBM Lotus Notes Inbox after you have responded to them&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://1.bp.blogspot.com/-j-2UVXAdCCo/WV5cd8bB_0I/AAAAAAAACeM/fHjPcJppotYJUmGbVtorZqEOsxVLD8hZwCK4BGAYYCw/s1600/PastedGraphic-2-777640.png&quot;&gt;&lt;img src=&quot;http://1.bp.blogspot.com/-j-2UVXAdCCo/WV5cd8bB_0I/AAAAAAAACeM/fHjPcJppotYJUmGbVtorZqEOsxVLD8hZwCK4BGAYYCw/s320/PastedGraphic-2-777640.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6439686186691854146&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;He&#39;s amazing :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/someone-elses-blog-how-to-automatically.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/-KJvEI5-YmXU/WV5cdKrppHI/AAAAAAAACeE/mxxHy8MaN7IQn-vSgV5I_qch6rEIiqq0QCK4BGAYYCw/s72-c/PastedGraphic-1-774728.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-8870581974546989501</guid><pubDate>Wed, 05 Jul 2017 09:32:00 +0000</pubDate><atom:updated>2017-07-05T10:32:11.622+01:00</atom:updated><title>For the record, enabling Application Security in WebSphere Application Server</title><description>&lt;div class=&quot;&quot;&gt;For context, I&#39;m building an IBM Operational Decision Manager 8.9 environment, as part of a migration from an older version of ODM ( 8.0 ).&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I needed to enable Application Security; Administrative Security was enabled when I created the profile: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -create -templatePath /opt/ibm/WebSphere/AppServer/profileTemplates/management -profileName Dmgr01 -profilePath /opt/ibm/WebSphereProfiles/Dmgr01 -nodeName Dmgr -isDefault &lt;b class=&quot;&quot;&gt;-enableAdminSecurity true&lt;/b&gt; -adminUserName wasadmin -adminPassword passw0rd&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and the IBM Knowledge Centre didn&#39;t seem to give me a clue: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/txml_enabledisable.html&quot; class=&quot;&quot;&gt;Enabling and disabling security using scripting&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Happily this blog post: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://www.techpaste.com/2013/07/enablingdisabling-administrative-application-security-jython-websphere/&quot; class=&quot;&quot;&gt;Websphere Application Security Using Wsadmin&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;gave me what I needed: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Start WSAdmin Client&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphereProfiles/Dmgr01/bin/wsadmin.sh -lang jython -user wasadmin -password passw0rd&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Validate whether Application Security is enabled&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;print AdminTask.isAppSecurityEnabled()&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;false&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Enable Application Security&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;securityConfigID = AdminConfig.getid(&quot;/Security:/&quot;)&lt;br class=&quot;&quot;&gt;AdminConfig.modify(securityConfigID,[[&#39;appEnabled&#39;,&#39;true&#39;]])&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Validate whether Application Security is enabled&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;print AdminTask.isAppSecurityEnabled()&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;true&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Save and Sync&lt;/u&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;AdminConfig.save()&lt;br class=&quot;&quot;&gt;AdminNodeManagement.syncActiveNodes()&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;u class=&quot;&quot;&gt;Quit&lt;/u&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;quit&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Job done&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/for-record-enabling-application.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-7264126175881691724</guid><pubDate>Mon, 03 Jul 2017 09:58:00 +0000</pubDate><atom:updated>2017-07-03T10:58:50.968+01:00</atom:updated><title>More about the killall command, in the context of WebSphere Application Server</title><description>Whilst creating a pair of WebSphere Application Server (WAS) profiles: -&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -create -templatePath /opt/ibm/WebSphere/AppServer/profileTemplates/management -profileName Dmgr01 -profilePath /opt/ibm/WebSphereProfiles/Dmgr01 -nodeName Dmgr -isDefault -enableAdminSecurity true -adminUserName wasadmin -adminPassword passw0rd&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -create -templatePath /opt/ibm/WebSphere/AppServer/profileTemplates/managed -profileName AppSrv01 -profilePath /opt/ibm/WebSphereProfiles/AppSrv01 -nodeName Node1&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I saw this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;INSTCONFPARTIALSUCCESS: The profile now exists, but errors occurred. For more information, consult /opt/ibm/WebSphere/AppServer/logs/manageprofiles/Dmgr01_create.log.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;INSTCONFPARTIALSUCCESS: The profile now exists, but errors occurred. For more information, consult /opt/ibm/WebSphere/AppServer/logs/manageprofiles/AppSrv01_create.log.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;When I checked the logs: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;cat /opt/ibm/WebSphere/AppServer/logs/manageprofiles/Dmgr01_create.log |grep Exception&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I saw this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;method&amp;gt;logException&amp;lt;/method&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;message&amp;gt;Exception&amp;nbsp;was thrown, type of exception is: class org.apache.tools.ant.BuildException&amp;lt;/message&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;method&amp;gt;logException&amp;lt;/method&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;message&amp;gt;The exception message is: Execute failed: &lt;b class=&quot;&quot;&gt;java.io.IOException: Cannot run program &quot;killall&quot; (in directory &quot;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions&quot;): error=2, No such file or&amp;nbsp;directory&amp;lt;/message&amp;gt;&lt;/b&gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;method&amp;gt;logException&amp;lt;/method&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;message&amp;gt;The translated exception message is: Execute failed: java.io.IOException: Cannot run program &quot;killall&quot; (in directory &quot;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions&quot;): error=2, No&amp;nbsp;such file or directory&amp;lt;/message&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;method&amp;gt;logException&amp;lt;/method&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;method&amp;gt;logException&amp;lt;/method&amp;gt;&lt;br class=&quot;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;lt;message&amp;gt;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions/createProfileShortCut2StartMenuMgmt.ant:792: Execute failed: java.io.IOException: Cannot run program &quot;killall&quot; (in directory&amp;nbsp;&quot;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions&quot;): error=2, No such file or directory&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at org.eclipse.equinox.internal.app.EclipseAppContainer.callMethodWithException(EclipseAppContainer.java:587)&lt;br class=&quot;&quot;&gt;Caused by: java.io.IOException: Cannot run program &quot;killall&quot; (in directory &quot;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions&quot;): error=2, No such file or directory&lt;br class=&quot;&quot;&gt;Caused by: java.io.IOException: error=2, No such file or directory&lt;br class=&quot;&quot;&gt;--- Nested&amp;nbsp;Exception&amp;nbsp;---&lt;br class=&quot;&quot;&gt;java.io.IOException: Cannot run program &quot;killall&quot; (in directory &quot;/opt/ibm/WebSphere/AppServer/profileTemplates/management/actions&quot;): error=2, No such file or directory&lt;br class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;at org.eclipse.equinox.internal.app.EclipseAppContainer.callMethodWithException(EclipseAppContainer.java:587)&lt;br class=&quot;&quot;&gt;Caused by: java.io.IOException: error=2, No such file or directory&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which ties up nicely with an earlier blog post : -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://portal2portal.blogspot.co.uk/2017/06/oh-red-hat-enterprise-linux-wheres-my.html&quot; class=&quot;&quot;&gt;Oh, Red Hat Enterprise Linux, where&#39;s my trusty killall command&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So it looks like RHEL 7.3 has dropped the &lt;b class=&quot;&quot;&gt;killall&lt;/b&gt;&amp;nbsp;command from the default installation - or, to be more accurate, my RHEL Gold Master VM doesn&#39;t have &lt;b class=&quot;&quot;&gt;killall&lt;/b&gt; therein.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;So I installed &lt;b class=&quot;&quot;&gt;killall&lt;/b&gt;&amp;nbsp;: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;yum install -y psmisc&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;cleaned up the old profiles: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -deleteAll&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;INSTCONFPARTIALSUCCESS: The profiles no longer exist, but errors occurred. For more information, consult /opt/ibm/WebSphere/AppServer/logs/manageprofiles/deleteAll.log.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;rm -Rf /opt/ibm/WebSphereProfiles/&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;and then recreated the profiles: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -create -templatePath /opt/ibm/WebSphere/AppServer/profileTemplates/management -profileName Dmgr01 -profilePath /opt/ibm/WebSphereProfiles/Dmgr01 -nodeName Dmgr -isDefault -enableAdminSecurity true -adminUserName wasadmin -adminPassword passw0rd&lt;/i&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;INSTCONFSUCCESS: Success: Profile Dmgr01 now exists. Please consult /opt/ibm/WebSphereProfiles/Dmgr01/logs/AboutThisProfile.txt for more information about this profile.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;/opt/ibm/WebSphere/AppServer/bin/manageprofiles.sh -create -templatePath /opt/ibm/WebSphere/AppServer/profileTemplates/managed -profileName AppSrv01 -profilePath /opt/ibm/WebSphereProfiles/AppSrv01 -nodeName Node1&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;font face=&quot;Courier New&quot; class=&quot;&quot;&gt;INSTCONFSUCCESS: Success: Profile AppSrv01 now exists. Please consult /opt/ibm/WebSphereProfiles/AppSrv01/logs/AboutThisProfile.txt for more information about this profile.&lt;/font&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;which is nice :-)&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/more-about-killall-command-in-context.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-3001292039622975872</guid><pubDate>Sat, 01 Jul 2017 20:25:00 +0000</pubDate><atom:updated>2017-07-01T21:25:36.059+01:00</atom:updated><title>There was an error connecting to the Apple ID server</title><description>I&#39;ve been seeing this repeatedly this evening: -&lt;br class=&quot;&quot;&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;http://3.bp.blogspot.com/-ZXmNaYkIK0w/WVgFQfgH4nI/AAAAAAAACd0/FGZ5dY0JYvQg9hpyXz3jxmOsO28zaUqogCK4BGAYYCw/s1600/PastedGraphic-1-736061.png&quot;&gt;&lt;img src=&quot;http://3.bp.blogspot.com/-ZXmNaYkIK0w/WVgFQfgH4nI/AAAAAAAACd0/FGZ5dY0JYvQg9hpyXz3jxmOsO28zaUqogCK4BGAYYCw/s320/PastedGraphic-1-736061.png&quot;  border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_6437901448218403442&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;on both macOS and iOS devices.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;What was strange was that I &lt;b class=&quot;&quot;&gt;was&lt;/b&gt;&amp;nbsp;able to log into&amp;nbsp;&lt;a href=&quot;https://appleid.apple.com/#!&amp;amp;page=signin&quot; class=&quot;&quot;&gt;https://appleid.apple.com/#!&amp;amp;page=signin&lt;/a&gt;&amp;nbsp;without problems.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;After some trial and error, I realised that, for some reason, my home broadband router was somehow blocking the connection.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;I proved this, on an iPhone, by turning off WiFi and using 3G instead. I proved the same on an iPad and on a Mac, by connecting to a different broadband connection.&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;Weird or what ?&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/07/there-was-error-connecting-to-apple-id.html</link><author>[email protected] (Dave Hay)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://3.bp.blogspot.com/-ZXmNaYkIK0w/WVgFQfgH4nI/AAAAAAAACd0/FGZ5dY0JYvQg9hpyXz3jxmOsO28zaUqogCK4BGAYYCw/s72-c/PastedGraphic-1-736061.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-6740338341177826314.post-5275248334105026553</guid><pubDate>Fri, 30 Jun 2017 15:22:00 +0000</pubDate><atom:updated>2017-06-30T16:22:25.697+01:00</atom:updated><title>WebSphere continuous delivery offerings provide functional and usability enhancements for 2Q 2017</title><description>&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;As organizations increase their pace of digital transformation and the transition to a hybrid cloud world, WebSphere offerings can help facilitate this pace of change with our quarterly cadence of&amp;nbsp;continuous delivery enhancements.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;This recurring blog will summarize these deliverables each quarter, the new and updated functionality that they provide, and offer references for more detailed information.&lt;br class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Before we look at Liberty and WAS enhancements, here are two new updates we&#39;re excited share:&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;• IBM launched Microservice Builder, a new tool that provides your organization with a complete user experience for creating, testing and deploying applications.. Learn more about Microservice&amp;nbsp;Builder&amp;nbsp;here.&lt;br class=&quot;&quot;&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;• We have strengthened&amp;nbsp;IBM Cloud Product Insights&amp;nbsp;with a range of enhancements. Check out&amp;nbsp;this blog post&amp;nbsp;for all of the latest updates.&lt;/i&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/blogs/cloud-announcements/2017/06/websphere-continuous-delivery-offerings-provide-functional-usability-enhancements-2q-2017/&quot; class=&quot;&quot;&gt;WebSphere continuous delivery offerings provide functional and usability enhancements for 2Q 2017&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;plus this: -&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;i class=&quot;&quot;&gt;Today, enterprises need a way to securely develop and deploy containerized applications with the flexibility to run in both a public cloud and on-premises system. We built&amp;nbsp;Microservice Builder&amp;nbsp;to&amp;nbsp;help you solve this challenge. The new tool provides your organization with a complete user experience for creating, testing and deploying applications.&lt;br class=&quot;&quot;&gt;Microservice Builder includes everything a business needs to focus on application development rather than the framework. It provides beta binaries to support building and testing environments,&amp;nbsp;and low-touch development-to-deployment experience with simplification of DevOps tasks.&lt;/i&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;a href=&quot;https://www.ibm.com/blogs/cloud-computing/2017/06/continuous-delivery-microservices-builder/&quot; class=&quot;&quot;&gt;Microservice Builder: Software delivery goes from days to&amp;nbsp;minutes&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;&quot;&gt;&lt;br class=&quot;&quot;&gt;&lt;/div&gt;</description><link>http://portal2portal.blogspot.com/2017/06/websphere-continuous-delivery-offerings.html</link><author>[email protected] (Dave Hay)</author><thr:total>0</thr:total></item></channel></rss>

If you would like to create a banner that links to this page (i.e. this validation result), do the following:

  1. Download the "valid RSS" banner.

  2. Upload the image to your own server. (This step is important. Please do not link directly to the image on this server.)

  3. Add this HTML to your page (change the image src attribute if necessary):

If you would like to create a text link instead, here is the URL you can use:

http://www.feedvalidator.org/check.cgi?url=http%3A//portal2portal.blogspot.com/feeds/posts/default%3Falt%3Drss

Copyright © 2002-9 Sam Ruby, Mark Pilgrim, Joseph Walton, and Phil Ringnalda