Skip to content

Instantly share code, notes, and snippets.

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,
//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;
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,
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
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,
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
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,
const body = {
'debt':
{
'docId': 'test',
'amount': {
'currency': 'PYG',
'value': 5000
},
'label': 'Deuda desde el postman',
'validPeriod': {
{
"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",
// legacy/models/couple.php
/**
* Returns the search data for bookshelf
*
* @param string
* @param array
* @param array
* @return
* @access protected