0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'

[vijayalp]

I get below error for datasources 0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'

Environment: RHEL 8.4, weblogic 14110, biemond orawls 2.0.12, puppet 4.10.1

This error is not observed when weblogic 12214 and rhel 7.8 with same stated above puppet and biemond orawls.

can you help what need to check.

[vijayalp]

datasource looks like below: wls_datasources: "%{hiera('domain_name')}/TestDemoDataSource": ensure: present drivername: oracle.jdbc.driver.OracleDriver globaltransactionsprotocol: TwoPhaseCommit initialcapacity: '1' maxcapacity: '15' mincapacity: '1' statementcachesize: '10' jndinames:

• amdocs.xpidemo.DataSource target: "%{hiera('targets')}" targettype: "%{hiera('targettypes')}" testconnectionsonreserve: '0' secondstotrustidlepoolconnection: '10' testfrequency: '400' connectioncreationretryfrequency: '0' usexa: '0' testtablename: SQL SELECT 1 FROM DUAL initsql: SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,' url: jdbc:oracle:thin:@testdbhost:1521:NONDB user: "test13" password: "test3"

[biemond]

Hey , I would expect this is a new datasource option of wls 14

[vijayalp]

Hi Edwin,

I see that /opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb is causing the problem for the newly required attribute removeinfectedconnections: '1' when I commented line in the code removeinfectedconnections.rb, second time run went well. Do you have time so that I can show you what is our scenario and commenting this line worked fine for WLS 14c?

newproperty(:removeinfectedconnections, :boolean => true) do include EasyType

desc 'Specifies whether a connection will be removed from the connection pool after the application uses the underlying vendor connection object.'

newvalues(:true, :false, '0', '1')

munge do |value| case value when true, "true", :true, '1' :true when false, "false", :false, '0' :false else fail("#{value} must be a boolean") end end

to_translate_to_resource do |raw_resource| return :true if raw_resource['removeinfectedconnections'] == '1' return :false if raw_resource['removeinfectedconnections'] == '0'

fail('BUG! removeinfectedconnections should have been \'0\' or \'1\'')

end

end

Best Regards, Vijaya

[amdocs-2017-brand-mark-rgb]

From: Vijaya lakshmi Pallapothu Sent: Thursday, April 7, 2022 2:24 PM To: biemond/biemond-orawls @.***> Subject: RE: [biemond/biemond-orawls] 0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' (Issue #590)

HI Edwin,

I have added new datasource property removeinfectedconnections: '1' to the wls_datasource. However, 1st time those are created without any problem. Second time (for idempodent scenario) when we rerun , we get to see the 0400 error. Is there anything I can debug? Below is the result: 1st run: 2022-04-07 04:20:23 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}} 2022-04-07 04:20:23 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.24 seconds 2022-04-07 04:20:37 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/XPIDemoDataSource]/ensure (notice): created 2022-04-07 04:20:39 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/XPIDemoTrxDataSource]/ensure (notice): created 2022-04-07 04:20:41 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/TestDemoDataSource]/ensure (notice): created 2022-04-07 04:20:43 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/TestDemoTrxDataSource]/ensure (notice): created

2nd run:

2022-04-07 04:25:06 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}} 2022-04-07 04:25:06 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.26 seconds 2022-04-07 04:25:18 -0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'

Best Regards, Vijaya

[amdocs-2017-brand-mark-rgb]

From: Edwin Biemond @.**@.>> Sent: Wednesday, April 6, 2022 11:43 PM To: biemond/biemond-orawls @.**@.>> Cc: Vijaya lakshmi Pallapothu @.**@.>>; Author @.**@.>> Subject: Re: [biemond/biemond-orawls] 0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' (Issue #590)

CAUTION: This message was sent from outside of Amdocs. Please do not click links or open attachments unless you recognize the source of this email and know the content is safe.

Hey , I would expect this is a new datasource option of wls 14

- Reply to this email directly, view it on GitHubhttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fbiemond%2Fbiemond-orawls%2Fissues%2F590%23issuecomment-1090579971&data=04%7C01%7CVIJAYALP%40amdocs.com%7C4aa04f56b49649e5eb0b08da17f92156%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637848656054984722%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=4BXsUcp1vRUJHqf7%2Bny4xVCrWcamrGIUeCqn0wvim4M%3D&reserved=0, or unsubscribehttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALPYUAW4PGED6MDMAGQ5ZGLVDXHZHANCNFSM5SV24V3Q&data=04%7C01%7CVIJAYALP%40amdocs.com%7C4aa04f56b49649e5eb0b08da17f92156%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637848656054984722%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=rD5wSECMdC%2BjIz3dl1o7fyA2gLbnjhRXt5WV54Mwrgw%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>> This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service https://www.amdocs.com/about/email-terms-of-service

[vijayalp]

Hi Edwin, As per you comment, if removeinfectedconnections is necessary parameter, we get to see same error message during datasource creation objects. therefore, after commenting the BUG line in the file orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb, such error is not seen and datasource creation is successfull. Could you help how this work around in removeinfectedconnection.rb can be fixed? is there any higher version this issue been fixed. Regards, Vijaya.

[vijayalp]

Hi Can you help here? Regards, Vijaya.

[biemond]

ok, few things you can try .

put puppet in debug mode and look at the datasource output or follow this yourself https://github.com/biemond/biemond-orawls/tree/puppet4/files/providers/wls_datasource see if the mbean property is there and what goes wrong with the wlst scripts

maybe this true param makes it required or not type

or add a default value https://github.com/biemond/biemond-orawls/blob/puppet4/lib/puppet/type/wls_datasource/fanenabled.rb#L8

[vijayalp]

Hi, i have enabled puppet debug for wls_datasource creation, all the datasources are created successfully and have property "RemoveInfectedConnections" and still get to see the error BUG! removeinfectedconnections should have been '0' or '1'

2022-04-19 09:26:47 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0], extraproperties => [SendStreamAsBlob=true, oracle.net.CONNECT_TIMEOUT=1000, oracle.net.ssl_server_dn_match=false]}} 2022-04-19 09:26:47 -0400 Puppet (debug): wls_setting_file is overridden to /users/acdwrk1/wls_setting.yaml 2022-04-19 09:26:47 -0400 Puppet (debug): Adding relationship from Class[Amd_common_config] to Class[Amd_wls_datasources::Create_wls_datasources] with 'before' 2022-04-19 09:26:47 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.33 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Creating default schedules 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded transaction store file in 0.00 seconds 2022-04-19 09:26:47 -0400 Puppet (info): Applying configuration version '1650374807' 2022-04-19 09:26:47 -0400 /Stage[main]/Amd_common_config/before (debug): subscribes to Class[Amd_wls_datasources::Create_wls_datasources] 2022-04-19 09:26:48 -0400 Puppet (debug): Prefetching simple resources for wls_datasource 2022-04-19 09:26:48 -0400 Puppet (debug): index wls_datasource 2022-04-19 09:26:48 -0400 Puppet (debug): Evicting cache entry for environment 'production' 2022-04-19 09:26:48 -0400 Puppet (debug): Caching environment 'production' (ttl = 0 sec) 2022-04-19 09:26:48 -0400 Puppet (debug): Executing: wlstScript with action index 2022-04-19 09:26:48 -0400 Puppet (debug): domain found XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): no custom trust 2022-04-19 09:26:48 -0400 Puppet (info): Starting the wls daemon for domain XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): Defining common methods... 2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstCommonScript.py20220419-527594-1sjd1dx 2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstScript20220419-527594-4kfx7p.py with timeout = 120 2022-04-19 09:26:48 -0400 Puppet (debug): Passing domain XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): Passing tmp script location 2022-04-19 09:26:48 -0400 Puppet (debug): Passing use_default_value_when_empty True 2022-04-19 09:26:48 -0400 Puppet (debug): Passing credentials to WLST 2022-04-19 09:26:48 -0400 Puppet (info): Connecting to wls on url t3://eaasrt:27000 2022-04-19 09:26:48 -0400 Puppet (debug): CLASSPATH=/usr/java/jdk1.8.0_291-amd64/lib/tools.jar:/opt/wls1411/wlserver/modules/features/wlst.wls.classpath.jar: 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): PATH=/opt/wls1411/wlserver/server/bin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.10.5.0.0/apache-ant-1.10.5/bin:/usr/java/jdk1.8.0_291-amd64/jre/bin:/usr/java/jdk1.8.0_291-amd64/bin:/usr/java/jdk1.8.0_291-amd64/bin:/opt/puppetlabs/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/apache-maven_bundle/3.6.1.0.0/apache-maven-3.6.1/bin 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): Your environment has been set. 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): Initializing WebLogic Scripting Tool (WLST) ... 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): Welcome to WebLogic Server Administration Scripting Shell 2022-04-19 09:26:57 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): Type help() for help on available commands 2022-04-19 09:26:57 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): wls:/offline> execfile('/tmp/wlstCommonScript.py20220419-527594-1sjd1dx') 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> domain = 'XPIDemoDomain' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> tmp_script = '/tmp/wlstScriptXPIDemoDomain.out' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> use_default_value_when_empty = True 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicUser = 'acdadmin' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicPassword = 'acdadmin1' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> connect('acdadmin','acdadmin1','t3://eaasrt:27000') 2022-04-19 09:26:59 -0400 Puppet (debug): Connecting to t3://eaasrt:27000 with userid acdadmin ... 2022-04-19 09:27:00 -0400 Puppet (debug): Successfully connected to Admin Server "XPIDemoServer" that belongs to domain "XPIDemoDomain". 2022-04-19 09:27:00 -0400 Puppet (debug): 2022-04-19 09:27:00 -0400 Puppet (debug): Warning: An insecure protocol was used to connect to the server. 2022-04-19 09:27:00 -0400 Puppet (debug): To ensure on-the-wire security, the SSL port or Admin port should be used instead. 2022-04-19 09:27:00 -0400 Puppet (debug): 2022-04-19 09:27:00 -0400 Puppet (debug): wls:/XPIDemoDomain/serverConfig/> execfile('/tmp/wlstScript20220419-527594-4kfx7p.py') 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoTrxDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoTrxDataSource 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): TestDemoDataSource 2022-04-19 09:27:01 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:01 -0400 Puppet (debug): get att Url 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:01 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:01 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:01 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:01 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:01 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:01 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:01 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:01 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:01 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:02 -0400 Puppet (debug): TestDemoTrxDataSource 2022-04-19 09:27:02 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:02 -0400 Puppet (debug): get att Url 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:02 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:02 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:02 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:02 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:02 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:02 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:02 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:02 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:02 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- SendStreamAsBlob 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.CONNECT_TIMEOUT 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.ssl_server_dn_match 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:02 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoDataSource 2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): get att Url 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoTrxDataSource 2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): get att Url 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): ~~COMMAND SUCCESFULL~~ 2022-04-19 09:27:04 -0400 Puppet (debug): Storing state 2022-04-19 09:27:04 -0400 Puppet (debug): Stored state in 0.01 seconds 2022-04-19 09:27:04 -0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' 2022-04-19 09:27:04 -0400 Puppet (debug): Applying settings catalog for sections main, reporting, metrics 2022-04-19 09:27:04 -0400 Puppet (debug): Using settings: adding file resource 'confdir': 'File[/users/acdwrk1/.puppetlabs/etc/puppet]{:path=>"/users

[biemond]

can you add it to create also on retrieving it requires a boolean or 1 . probably it had a default value .

can you also check the mbeans in wlst to see this property and its type

On Tue, 19 Apr 2022 at 21:16, vijayalp @.***> wrote:

Hi, i have enabled puppet debug for wls_datasource creation, all the datasources are created successfully and have property "RemoveInfectedConnections" and still get to see the error BUG! removeinfectedconnections should have been '0' or '1'

2022-04-19 09:26:47 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0], extraproperties => [SendStreamAsBlob=true, oracle.net.CONNECT_TIMEOUT=1000, oracle.net.ssl_server_dn_match=false]}} 2022-04-19 09:26:47 -0400 Puppet (debug): wls_setting_file is overridden to /users/acdwrk1/wls_setting.yaml 2022-04-19 09:26:47 -0400 Puppet (debug): Adding relationship from Class[Amd_common_config] to Class[Amd_wls_datasources::Create_wls_datasources] with 'before' 2022-04-19 09:26:47 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.33 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Creating default schedules 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds 2022-04-19 09:26:47 -0400 Puppet (debug): Loaded transaction store file in 0.00 seconds 2022-04-19 09:26:47 -0400 Puppet (info): Applying configuration version '1650374807' 2022-04-19 09:26:47 -0400 /Stage[main]/Amd_common_config/before (debug): subscribes to Class[Amd_wls_datasources::Create_wls_datasources] 2022-04-19 09:26:48 -0400 Puppet (debug): Prefetching simple resources for wls_datasource 2022-04-19 09:26:48 -0400 Puppet (debug): index wls_datasource 2022-04-19 09:26:48 -0400 Puppet (debug): Evicting cache entry for environment 'production' 2022-04-19 09:26:48 -0400 Puppet (debug): Caching environment 'production' (ttl = 0 sec) 2022-04-19 09:26:48 -0400 Puppet (debug): Executing: wlstScript with action index 2022-04-19 09:26:48 -0400 Puppet (debug): domain found XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): no custom trust 2022-04-19 09:26:48 -0400 Puppet (info): Starting the wls daemon for domain XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): Defining common methods... 2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstCommonScript.py20220419-527594-1sjd1dx 2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstScript20220419-527594-4kfx7p.py with timeout = 120 2022-04-19 09:26:48 -0400 Puppet (debug): Passing domain XPIDemoDomain 2022-04-19 09:26:48 -0400 Puppet (debug): Passing tmp script location 2022-04-19 09:26:48 -0400 Puppet (debug): Passing use_default_value_when_empty True 2022-04-19 09:26:48 -0400 Puppet (debug): Passing credentials to WLST 2022-04-19 09:26:48 -0400 Puppet (info): Connecting to wls on url t3://eaasrt:27000 2022-04-19 09:26:48 -0400 Puppet (debug): CLASSPATH=/usr/java/jdk1.8.0_291-amd64/lib/tools.jar:/opt/wls1411/wlserver/modules/features/wlst.wls.classpath.jar: 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): PATH=/opt/wls1411/wlserver/server/bin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.10.5.0.0/apache-ant-1.10.5/bin:/usr/java/jdk1.8.0_291-amd64/jre/bin:/usr/java/jdk1.8.0_291-amd64/bin:/usr/java/jdk1.8.0_291-amd64/bin:/opt/puppetlabs/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/apache-maven_bundle/3.6.1.0.0/apache-maven-3.6.1/bin 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): Your environment has been set. 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:48 -0400 Puppet (debug): Initializing WebLogic Scripting Tool (WLST) ... 2022-04-19 09:26:48 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): Welcome to WebLogic Server Administration Scripting Shell 2022-04-19 09:26:57 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): Type help() for help on available commands 2022-04-19 09:26:57 -0400 Puppet (debug): 2022-04-19 09:26:57 -0400 Puppet (debug): wls:/offline> execfile('/tmp/wlstCommonScript.py20220419-527594-1sjd1dx') 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> domain = 'XPIDemoDomain' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> tmp_script = '/tmp/wlstScriptXPIDemoDomain.out' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> use_default_value_when_empty = True 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicUser = 'acdadmin' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicPassword = 'acdadmin1' 2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> connect('acdadmin','acdadmin1','t3://eaasrt:27000') 2022-04-19 09:26:59 -0400 Puppet (debug): Connecting to t3://eaasrt:27000 with userid acdadmin ... 2022-04-19 09:27:00 -0400 Puppet (debug): Successfully connected to Admin Server "XPIDemoServer" that belongs to domain "XPIDemoDomain". 2022-04-19 09:27:00 -0400 Puppet (debug): 2022-04-19 09:27:00 -0400 Puppet (debug): Warning: An insecure protocol was used to connect to the server. 2022-04-19 09:27:00 -0400 Puppet (debug): To ensure on-the-wire security, the SSL port or Admin port should be used instead. 2022-04-19 09:27:00 -0400 Puppet (debug): 2022-04-19 09:27:00 -0400 Puppet (debug): wls:/XPIDemoDomain/serverConfig/> execfile('/tmp/wlstScript20220419-527594-4kfx7p.py') 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoTrxDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoDataSource 2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoTrxDataSource 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): TestDemoDataSource 2022-04-19 09:27:01 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:01 -0400 Puppet (debug): get att Url 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:01 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:01 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:01 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:01 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:01 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:01 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:01 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:01 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:01 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:01 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:01 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:01 -0400 Puppet (debug): 2022-04-19 09:27:02 -0400 Puppet (debug): TestDemoTrxDataSource 2022-04-19 09:27:02 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:02 -0400 Puppet (debug): get att Url 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:02 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:02 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:02 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:02 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:02 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:02 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:02 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:02 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:02 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:02 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:02 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- SendStreamAsBlob 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.CONNECT_TIMEOUT 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.ssl_server_dn_match 2022-04-19 09:27:02 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:02 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoDataSource 2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): get att Url 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:03 -0400 Puppet (debug): 2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoTrxDataSource 2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType 2022-04-19 09:27:03 -0400 Puppet (debug): get att Url 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url 2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName 2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface 2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve 2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql 2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout 2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds 2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes 2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch 2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize 2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName 2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol 2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled 2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList 2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoCluster 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoServer 2022-04-19 09:27:04 -0400 Puppet (debug): 2022-04-19 09:27:04 -0400 Puppet (debug): ~~COMMAND SUCCESFULL~~ 2022-04-19 09:27:04 -0400 Puppet (debug): Storing state 2022-04-19 09:27:04 -0400 Puppet (debug): Stored state in 0.01 seconds 2022-04-19 09:27:04 -0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' 2022-04-19 09:27:04 -0400 Puppet (debug): Applying settings catalog for sections main, reporting, metrics 2022-04-19 09:27:04 -0400 Puppet (debug): Using settings: adding file resource 'confdir': 'File[/users/acdwrk1/.puppetlabs/etc/puppet]{:path=>"/users

— Reply to this email directly, view it on GitHub https://github.com/biemond/biemond-orawls/issues/590#issuecomment-1102810855, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAII4TFJBPOKNUUTGEMNFT3VF3IMTANCNFSM5SV24V3Q . You are receiving this because you commented.Message ID: @.***>

-- Thanks Edwin

Email: @.*** LinkedIn: http://www.linkedin.com/in/biemond Twitter: http://twitter.com/biemond Git: https://github.com/biemond

[vijayalp]

Hi, debug from puppet output for RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections 2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None]) 2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections

Results for your questions::

can you add it to create also on retrieving it requires a boolean or 1 . probably it had a default value .

I have added removeinfectedconnections to the datasource but still same error. and it seems default value is true https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/wlmbr/core/index.html RemoveInfectedConnections Privileges: Read/Write Type: boolean Default Value: true

Reference link: https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/jdbcp/phys_conr.html#GUID-EFD6823F-D6AA-450F-B216-84B4DF45A3B2

can you also check the mbeans in wlst to see this property and its type

please find wlst outputs for 'RemoveInfectedConnections','TestConnectionsOnReserve' and property when weblogic 14c and weblogic 12c

wlst: In WLS 14110c,: return type of the property wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('RemoveInfectedConnections') True

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('TestConnectionsOnReserve') False

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> ls()

-r-- CapacityIncrement 1 -r-- ConnectionCreationRetryFrequencySeconds 0 -r-- ConnectionHarvestMaxCount 1 -r-- ConnectionHarvestTriggerCount -1 -r-- ConnectionLabelingCallback null -r-- ConnectionReserveTimeoutSeconds 10 -r-- CountOfRefreshFailuresTillDisable 2 -r-- CountOfTestFailuresTillFlush 2 -r-- CredentialMappingEnabled false -r-- DriverInterceptor null -r-- FatalErrorCodes null -r-- HighestNumWaiters 2147483647 -r-- IdentityBasedConnectionPoolingEnabled false -r-- IgnoreInUseConnectionsEnabled true -r-- InactiveConnectionTimeoutSeconds 0 -r-- InitSql SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,' -r-- InitialCapacity 1 -r-- InvokeBeginEndRequest true -r-- JDBCXADebugLevel 10 -r-- LoginDelaySeconds 0 -r-- MaxCapacity 15 -r-- MinCapacity 1 -r-- PinnedToThread false -r-- ProfileConnectionLeakTimeoutSeconds 0 -r-- ProfileHarvestFrequencySeconds 300 -r-- ProfileType 0 -r-- RemoveInfectedConnections true -r-- SecondsToTrustAnIdlePoolConnection 10 -r-- ShrinkFrequencySeconds 900 -r-- StatementCacheSize 10 -r-- StatementCacheType LRU -r-- StatementTimeout -1 -r-- TestConnectionsOnReserve false -r-- TestFrequencySeconds 400 -r-- TestTableName SQL SELECT 1 FROM DUAL -r-- WrapJdbc true -r-- WrapTypes true

-r-x isSet Boolean : String(propertyName) -r-x unSet Void : String(propertyName)

In WLS 12214: return type for the property. wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('RemoveInfectedConnections') 1

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('TestConnectionsOnReserve') 0

Also though RemoveInfectedConnections, TestConnectionsOnReserve are of boolean type, the implementation for them in orawls 2.0.12 files under are different. /opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/testconnectionsonreserve.rb /opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb

[vijayalp]

Hi, Any updates?

[vijayalp]

For Weblogic 14c, in the file /opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb the return value for raw_resource['removeinfectedconnections'] is True instead of '1' or '0' Therefore , always for 2nd time rerun (that is idempotent case), even though the datasource created, always fail is executed.

to_translate_to_resource do |raw_resource| return :true if raw_resource['removeinfectedconnections'] == '1' return :false if raw_resource['removeinfectedconnections'] == '0' fail('BUG! removeinfectedconnections should have been \'0\' or \'1\'') end

Please help us update here.

[vijayalp]

Hi Edwin, Can you help us here in priority? We are stuck here?

REgards, Vijaya.

[biemond]

will check how we can remove it , then you can do this and try it out plus a make PR

[biemond]

this line has to be removed https://github.com/biemond/biemond-orawls/blob/puppet4/lib/puppet/type/wls_datasource.rb#L74

this https://github.com/biemond/biemond-orawls/blob/puppet4/files/providers/wls_datasource/create.py.erb#L99-L101

https://github.com/biemond/biemond-orawls/blob/puppet4/files/providers/wls_datasource/index.py.erb#L4

https://github.com/biemond/biemond-orawls/blob/puppet4/files/providers/wls_datasource/index.py.erb#L131-L135

https://github.com/biemond/biemond-orawls/blob/puppet4/files/providers/wls_datasource/modify.py.erb#L96-L98

this file https://github.com/biemond/biemond-orawls/blob/puppet4/lib/puppet/type/wls_datasource/removeinfectedconnections.rb

then it should be gone.

[vijayalp]

Hi Edwin, after removing all the lines you mentioned above in the files, the error is gone. But i have query, if someone needs this functionality to set removeinfectedconnection, then above removal of lines will not work. is this ok to remove lines in the files mentioned above would be compatible for WLS 12 and WLS 14?

Regards, Vijaya.

[vijayalp]

Hi Edwin, instead of removing the lines in files, i have updated removeinfectedconnections.rb file which worked for me. please tell me where should i request for PR for this file. I am attaching this file here. wls_datasource_removeinfectedconnections.zip

[vijayalp]

Opened, PR ==> https://github.com/biemond/biemond-orawls/pull/591 Please verify , approve and merge.

[vijayalp]

HI Edwin,

I have added new datasource property removeinfectedconnections: '1' to the wls_datasource. However, 1st time those are created without any problem. Second time (for idempodent scenario) when we rerun , we get to see the 0400 error. Is there anything I can debug? Below is the result: 1st run: 2022-04-07 04:20:23 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}} 2022-04-07 04:20:23 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.24 seconds 2022-04-07 04:20:37 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/XPIDemoDataSource]/ensure (notice): created 2022-04-07 04:20:39 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/XPIDemoTrxDataSource]/ensure (notice): created 2022-04-07 04:20:41 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/TestDemoDataSource]/ensure (notice): created 2022-04-07 04:20:43 -0400 /Stage[main]/Amd_wls_datasources::Create_wls_datasources/Wls_datasource[XPIDemoDomain/TestDemoTrxDataSource]/ensure (notice): created

2nd run:

2022-04-07 04:25:06 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => @.*:1521:NONTLSDB, user => test13, password => **}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoServer, targettype => Server, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, removeinfectedconnections => 1, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => *@.:1521:NONTLSDB, user => test13, password => **, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}} 2022-04-07 04:25:06 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.26 seconds 2022-04-07 04:25:18 -0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'

Best Regards, Vijaya

[amdocs-2017-brand-mark-rgb]

From: Edwin Biemond @.> Sent: Wednesday, April 6, 2022 11:43 PM To: biemond/biemond-orawls @.> Cc: Vijaya lakshmi Pallapothu @.>; Author @.> Subject: Re: [biemond/biemond-orawls] 0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' (Issue #590)

CAUTION: This message was sent from outside of Amdocs. Please do not click links or open attachments unless you recognize the source of this email and know the content is safe.

Hey , I would expect this is a new datasource option of wls 14

- Reply to this email directly, view it on GitHubhttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fbiemond%2Fbiemond-orawls%2Fissues%2F590%23issuecomment-1090579971&data=04%7C01%7CVIJAYALP%40amdocs.com%7C4aa04f56b49649e5eb0b08da17f92156%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637848656054984722%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=4BXsUcp1vRUJHqf7%2Bny4xVCrWcamrGIUeCqn0wvim4M%3D&reserved=0, or unsubscribehttps://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALPYUAW4PGED6MDMAGQ5ZGLVDXHZHANCNFSM5SV24V3Q&data=04%7C01%7CVIJAYALP%40amdocs.com%7C4aa04f56b49649e5eb0b08da17f92156%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637848656054984722%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=rD5wSECMdC%2BjIz3dl1o7fyA2gLbnjhRXt5WV54Mwrgw%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***> This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service https://www.amdocs.com/about/email-terms-of-service

[biemond]

we need to remove this field . will check what files we need to adjust , then you can do this , try it and send me a PR.

On Wed, May 11, 2022 at 11:00 AM vijayalp @.***> wrote:

Hi Edwin, Can you help us here in priority? We are stuck here?

REgards, Vijaya.

— Reply to this email directly, view it on GitHub https://github.com/biemond/biemond-orawls/issues/590#issuecomment-1123393798, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAII4TA2K3AQF3UUUOQIQ53VJNZMLANCNFSM5SV24V3Q . You are receiving this because you commented.Message ID: @.***>

-- Thanks Edwin

Email: @.*** LinkedIn: http://www.linkedin.com/in/biemond Twitter: http://twitter.com/biemond Git: https://github.com/biemond