Skip to content

Instantly share code, notes, and snippets.

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
// 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
]
public function edit($id = null)
{
$couple = $this->Couples->get($id, [
'contain' => [
'Males',
'Females',
'Males.Profiles',
'Females.Profiles',
]
]