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 GitHub<https://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 unsubscribe<https://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 <#590 (comment)>, 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.