Feb 03, 2023 12:16:19 AM groovy.sql.Sql setParameters
WARNING: Found 13 parameter placeholders but supplied with 12 parameters
Feb 03, 2023 12:16:38 AM groovy.sql.Sql executeInsert
WARNING: Failed to execute:
                                                INSERT INTO newss.address (record_id,
                                                record_type_id,
                                                eb_id,
                                                address_id,
                                                address_type,
                                                street_1,
                                                street_2,
                                                town,
                                                locality_id,
                                                postcode_id,
                                                district_id,
                                                state_id,
                                                country_id,
                                                attention_name,
                                                tel_no,
                                                fax_no,
                                                email,
                                                url,
                                                remarks,
                                                survey_cost,
                                                creator_id,
                                                created_timestamp,
                                                attention_name2,
                                                tel_no2,
                                                fax_no2,
                                                email2,
                                                from_address_type,
                                                other_postcode)
                                                VALUES (?,
                                                ?,
                                                ?,
                                                ?,
                                                ?,
                                                ?,
                                                ?,
                                                ?,
                                                null,
                                                ?,
                                                null,
                                                ?,
                                                ?,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                ?,
                                                sysdate,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null)
                                                 because: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Feb 03, 2023 12:16:38 AM groovy.sql.Sql eachRow
WARNING: Failed to execute: SELECT * FROM public.lq_data WHERE state_code = ? AND data ->> 'ngdbbp' = ? AND form_id = '0def42d5-8101-44e1-bd00-f2282a940895' ORDER BY lq_id because: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Caught: java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:993)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
    at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
    at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at Main.insertAddress(Main.groovy:782)
    at Main$_run_closure1$_closure2.doCall(Main.groovy:453)
    at Main$_run_closure1.doCall(Main.groovy:406)
    at Main.run(Main.groovy:76)
Caused by: java.io.IOException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
    at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:182)
    at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:572)
    at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:263)
    at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:195)
    at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:137)
    at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:110)
    at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
    at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:791)
    at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
    ... 13 more

Process finished with exit code 1