cesarockstar1985

WITH RECURSIVE split(testing_no_performed_according_protocol_reason, rest) AS
    (SELECT '',
          testing_no_performed_according_protocol_reason||';'
        FROM impl_recurrent_visit WHERE route_detail_id = 'monsanto|1734177726753|1251712363|172' AND cast_draft_status = 10
        UNION ALL SELECT substr(rest, 0, instr(rest, ';')),
        substr(rest, instr(rest, ';')+1)
        FROM SPLIT
        WHERE rest!='' )    
    SELECT
    a.description,

cesarockstar1985

//package cast.sn.superindustrial;

import grails.converters.JSON;
import grails.plugin.mail.MailService;

import java.io.*;
import java.net.HttpURLConnection;
import java.net.Socket;
import java.net.URL;
import java.security.KeyManagementException;

cesarockstar1985

COPY (
SELECT DISTINCT
   r.id,
   c.name AS company,
   rw.week,
   u.code,
   u.full_name AS USER,
   array_agg(DISTINCT lz.description) AS user_location_zone_list,
   array_agg(DISTINCT lsz.description) AS user_location_sub_zone_list,
   r.status,

cesarockstar1985

2024-05-31 05:00:43.827 ERROR 821 --- [pool-50-thread-1] py.com.cast.srv.ExceptionsRecordService  : ERROR in saveExceptionRecord method: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[DataSourceUtils.class:5.1.6.RELEASE]
        at py.com.cast.srv.ExceptionsRecordService.saveExceptionRecord(ExceptionsRecordService.java:103) [ExceptionsRecordService.class:na]
        at py.com.cast.srv.ExceptionsRecordService.generateExceptionRecordForMessageGenerator(ExceptionsRecordService.java:37) [ExceptionsRecordService.class:na]
        at py.com.cast.threa

cesarockstar1985

SELECT
    ilor.portal_id,
    ilor.load_result,
    ilor.type_load,
    ilor.gross_weight,
    ilor.document_number,
    ilor.producer_name,
    ilor.producer_fiscal_number,
    point_of_delivery_plant_name,
    ilor.point_of_delivery_fiscal_number,

cesarockstar1985

2024-01-07 11:11:24.518 19222-19918 NetworkConnection       cast.com.py.castmobile3              I  login in request: 0
2024-01-07 11:11:24.518 19222-19918 NetworkConnection       cast.com.py.castmobile3              I  login in request: monsanto
2024-01-07 11:11:24.518 19222-19918 MessageFactory          cast.com.py.castmobile3              I  loginRequest: STARTED
2024-01-07 11:11:24.526 19222-19918 MessageFactory          cast.com.py.castmobile3              I  CREA MENSAJE LOGIN loginRequest: 
                                                                                                    DATA MESSAGE:
                                                                                                    - Message Has Multimedia data: false
                                                                                                    - Header fields qty: 18
                                                                                                    	Pos 0: 1
                                    

cesarockstar1985

SELECT
    distinct rw.id,
    coalesce(rw.disapproval_comment) as disapproval_comment,
    rw.end_day,
    rw.friday,
    rw.monday,
    rw.saturday,
    rw.start_day,
    rw.sunday,
    rw.thursday,

cesarockstar1985

        const body = {
            'debt': 
               {
                 'docId': 'test',
                 'amount': {
                    'currency': 'PYG',
                    'value': 5000
                },
                'label': 'Deuda desde el postman',
                'validPeriod': {

cesarockstar1985

{
    "name": "cakedc\/app-builder",
    "description": "CakePHP skeleton app",
    "homepage": "https:\/\/cakephp.org",
    "type": "project",
    "license": "MIT",
    "require": {
        "php": ">=8.1",
        "aws/aws-sdk-php": "^3.253",
        "cakedc/admin": "^7.0",

cesarockstar1985

// legacy/models/couple.php

/**
 * Returns the search data for bookshelf
 *
 * @param string
 * @param array
 * @param array
 * @return
 * @access protected