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

cesarockstar1985

// CouplesTable.php

$this->addBehavior('Josegonzalez/Upload.Upload', [
    'photo' => [
        'fields' => [
            // 'dir' => Configure::read('Media.basePath'), // defaults to `dir`\
            'dir' => 'photo_dir', // defaults to `dir`
            'size' => 'photo_size', // defaults to `size`
            'type' => 'photo_type', // d
        ]

cesarockstar1985

public function edit($id = null)
    {
        $couple = $this->Couples->get($id, [
            'contain' => [
                'Males',
                'Females',
                'Males.Profiles',
                'Females.Profiles',
                ]
            ]