|
| Informações Técnicas |
| Tipo de Erro | 256 |
| Descrição do Erro | ERROR: invalid input syntax for type json
DETAIL: Token "-" is invalid.
CONTEXT: JSON data, line 1: - |
| URL | licenciamento.agenciaambientaldovale.sp.gov.br/publicas/tbl_compensacao_tcra_tac_list.php?masterkey1=3741&mastertable=app.tbl_requerimento1 |
| Arquivo de Erro | /usr/share/nginx/static/sp.lia.apps/publicas/connections/Connection.php |
| Linha com Erro | 668 |
| Consulta de SQL | SELECT
"uid", "descricao", "tipo", "validade", "uid_requer", "uid_lic_aut", "num_solicitacao", "num_lic_aut", "arq_assinado", "data_dilacao", "justifica_dilacao", "resposta_dilacao", "congelado", "finalizado", "enviado", "tela_edit", "tela_dilacao", "tela_finaliza", "data_atende", "comprovante", "encerramento", "tela_comprovante", "prazo_exe_meses", "data_inicio", "token", REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label", REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivofim", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "labelfim", "arq_pub"
FROM "app"."tbl_compensacao_tcra_tac" WHERE ( ( ( ( uid_requer=3741 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0 |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. ERROR: invalid input syntax for type json
DETAIL: Token "-" is invalid.
CONTEXT: JSON data, line 1: - |
| #1 |
connections/PostgreConnection.php:104 |
PostgreConnection->query |
0. SELECT
"uid", "descricao", "tipo", "validade", "uid_requer", "uid_lic_aut", "num_solicitacao", "num_lic_aut", "arq_assinado", "data_dilacao", "justifica_dilacao", "resposta_dilacao", "congelado", "finalizado", "enviado", "tela_edit", "tela_dilacao", "tela_finaliza", "data_atende", "comprovante", "encerramento", "tela_comprovante", "prazo_exe_meses", "data_inicio", "token", REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label", REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivofim", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "labelfim", "arq_pub"
FROM "app"."tbl_compensacao_tcra_tac" WHERE ( ( ( ( uid_requer=3741 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0 |
| #2 |
connections/dbfunctions/PostgreFunctions.php:122 |
PostgreFunctions->limitedQuery |
0. PostgreConnection
1. SELECT
"uid", "descricao", "tipo", "validade", "uid_requer", "uid_lic_aut", "num_solicitacao", "num_lic_aut", "arq_assinado", "data_dilacao", "justifica_dilacao", "resposta_dilacao", "congelado", "finalizado", "enviado", "tela_edit", "tela_dilacao", "tela_finaliza", "data_atende", "comprovante", "encerramento", "tela_comprovante", "prazo_exe_meses", "data_inicio", "token", REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label", REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivofim", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "labelfim", "arq_pub"
FROM "app"."tbl_compensacao_tcra_tac" WHERE ( ( ( ( uid_requer=3741 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0
2. 0
3. 10
4. 1 |
| #3 |
connections/Connection.php:608 |
Connection->limitedQuery |
0. SELECT
"uid", "descricao", "tipo", "validade", "uid_requer", "uid_lic_aut", "num_solicitacao", "num_lic_aut", "arq_assinado", "data_dilacao", "justifica_dilacao", "resposta_dilacao", "congelado", "finalizado", "enviado", "tela_edit", "tela_dilacao", "tela_finaliza", "data_atende", "comprovante", "encerramento", "tela_comprovante", "prazo_exe_meses", "data_inicio", "token", REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arq_doc, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label", REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivofim", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(encerramento, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "labelfim", "arq_pub"
FROM "app"."tbl_compensacao_tcra_tac" WHERE ( ( ( ( uid_requer=3741 ) ) ) ) ORDER BY 1 ASC
1. 0
2. 10
3. 1 |
| #4 |
classes/datasource/table.php:629 |
DataSourceTable->getListImpl |
0. DsCommand |
| #5 |
classes/datasource/datasource.php:44 |
DataSource->getList |
0. DsCommand |
| #6 |
classes/listpage.php:2053 |
ListPage->getRecordset |
N/A |
| #7 |
classes/listpage.php:2204 |
ListPage->prepareForBuildPage |
N/A |
| #8 |
tbl_compensacao_tcra_tac_list.php:158 |
Global scope |
N/A |