Pular para o conteúdo principal

Postagem em destaque

BlackTDN :: Como Criar Relatórios de Cotações com Dados Agrupados Usando SQL

img: DALL·E 2024-08-09 07.00.00 - A high-quality image showcasing a detailed SQL query being written in a code editor, such as VS Code, on a dark theme background. ... ## Como Criar Relatórios de Cotações com Dados Agrupados Usando SQL Quando trabalhamos com sistemas ERP e precisamos gerar relatórios de cotações que apresentam dados de múltiplos fornecedores, é comum encontrarmos a necessidade de pivotar registros que, originalmente, são apresentados de forma vertical. Isso é especialmente útil quando o objetivo é comparar preços ou condições de diferentes fornecedores para um mesmo produto em uma única linha do relatório. Neste artigo, vamos explorar uma abordagem para transformar registros verticais em colunas, facilitando a impressão de relatórios que consolidam informações de vários fornecedores em uma única linha. Vamos utilizar SQL com técnicas de pivotagem, e ao final, mostraremos como estender essa técnica para um número variável de fornecedores. ### Estrutura do Relatór

BlackTDN :: TotvsAppServer : Memory Allocation Failure

[FATAL][SERVER] [Thread 3808] [THROW] Memory Allocation Failure ( 39577972 bytes ) at file c:\advtec9_101202a\lib_base\list.hpp line 794
/*-------------------------------------------------------
ERRO THREAD ([3808], marinaldo.jesus, NALDO-PC) 27/01/2012 09:59:32

Stack :
Memory Allocation Failure ( 39577972 bytes ) in file c:\advtec9_101202a\lib_base\list.hpp at line 794 on MEMTST(MEMTST.PRG) 26/01/2012 23:36:48 line : 232

[build: 7.00.101202A-20110330]
[environment: ndj_01]
[thread: 3808]
[rpodb: SQL]
[localfiles: ADS]
[remark: ]
[threadtype: RmtSockThread]
Called from U_MEMTST(MEMTST.PRG) 26/01/2012 23:36:48 line : 91
-------------------------------------------------------*/

[INFO ][SERVER] [MEMORY][27/01/2012 09:59:34] Used memory average CRITICAL.

----------- Total Thread Count ------------
Total Threads ... 17
Thread ... 2
WThread ... 9
RmtSockThread ... 1
SockServer ... 1
VtThread ... 3
VtServer ... 1

----------- Detailed Thread List ----------
[ 3808][ 0.00 MB] marinaldo.jesus NALDO-PC U_MEMTST ndj_01 Fri Jan 27 09:39:18 2012 00:20:16 394828994 64014 []
----------- Detailed Process List ----
[ 2056][ 0.00 MB][ Thread][ tMemoryMonitor][]
[ 4088][ 0.00 MB][ VtServer][ VtServer][]
[ 6096][ 0.00 MB][ VtThread][ tVTWThread][]
[ 5776][ 0.00 MB][ VtThread][ tVTWThread][]
[ 1792][ 0.00 MB][ VtThread][ tVTWThread][]
[ 4576][ 0.00 MB][ SockServer][ tMainServer][]
[ 5972][ 0.00 MB][ WThread][ tWThreadBase][]
[ 5768][ 0.00 MB][ WThread][ tWThreadBase][]
[ 5588][ 0.00 MB][ WThread][ tWThreadBase][]
[ 5316][ 0.00 MB][ WThread][ tWThreadBase][]
[ 1440][ 0.00 MB][ WThread][ tWThreadBase][]
[ 5488][ 0.00 MB][ WThread][ tWThreadBase][]
[ 4468][ 0.00 MB][ WThread][ tWThreadBase][]
[ 672][ 0.00 MB][ WThread][ tWThreadBase][]
[ 5164][ 0.00 MB][ WThread][ tWThreadBase][]
[ 3312][ 0.00 MB][ Thread][ tJobManager][]

----------- Global List Info --------------
IMAP Glb List ... 0.00 KB. Count 0
Variable Glb List ... 0.00 KB. Count 0
Session Glb List ... 0.00 KB. Count 0
SymTab List ... 469.94 KB. Count 29929


----------- SmartHeap Pools Info ----------
ctSimplePool ... 3.98 Kb. Count 0
ctDtmPool ... 3.98 Kb. Count 0
ctIntervalPool ... 3.98 Kb. Count 0
decimalPool ... 3.98 Kb. Count 0
stringPool ... 124073.67 Kb. Count 7925224
rContentPool ... 619572.67 Kb. Count 15833052
namedVarPool ... 71.95 Kb. Count 248
instrVarPool ... 495406.98 Kb. Count 15831990
sumPool ... 75.94 Kb. Count 503
comparePool ... 75.94 Kb. Count 51
asnParamPool ... 3.98 Kb. Count 0
localEnvPool ... 71.95 Kb. Count 16
interFCPool ... 75.94 Kb. Count 25
directFCPool ... 75.94 Kb. Count 181
inter4GLFCPool ... 3.98 Kb. Count 0
prgCodePool ... 6090.47 Kb. Count 18766
asnBasePool ... 75.94 Kb. Count 456
ctCodeBlockPool ... 75.94 Kb. Count 4
ctCodeBlockEnv ... 71.95 Kb. Count 1
ctCodeBlockRef ... 71.95 Kb. Count 3
ctCodeBlockInstr ... 71.95 Kb. Count 3
ctAPXmlDocInterface ... 3.98 Kb. Count 0
ctClassData ... 139.92 Kb. Count 733
ctAPXmlItem ... 3.98 Kb. Count 0
ctPrgFunctXRefEle ... 331.88 Kb. Count 12759
ctIdentifier ... 75.94 Kb. Count 6
ctNamedVarXVarRef ... 75.94 Kb. Count 695
ctParmDefDet ... 75.94 Kb. Count 554
ctVarList ... 433442.13 Kb. Count 7915617
ctStatList ... 139.92 Kb. Count 52
ctConst ... 75.94 Kb. Count 1042
ctCreateVarAbs ... 3.98 Kb. Count 0
ctParmList ... 75.94 Kb. Count 163
ctArrayElement ... 75.94 Kb. Count 2
ctBaseIf ... 75.94 Kb. Count 54
ctMethod ... 139.92 Kb. Count 1135
ctFindObject ... 71.95 Kb. Count 2
ctSelfVar ... 71.95 Kb. Count 1
ctClassProp ... 71.95 Kb. Count 1
ctClassInstance ... 3.98 Kb. Count 0
ctMethodCall ... 3.98 Kb. Count 0
ctReturn ... 75.94 Kb. Count 23
ctStaticEnv ... 75.94 Kb. Count 23
ctPrivateEnv ... 71.95 Kb. Count 17
Default Memory Pool ... 257337.05 Kb. Count 15923586

TOTAL POOLED MEMORY ... 1938505.08 Kb.


----------- OS Memory Summary -------------
Physical memory . 2035.77 MB. Used 2031.42 MB. Free 4.35 MB.
Paging file ..... 3927.52 MB. Used 2629.15 MB. Free 1298.37 MB.

----------- APP Memory Summary ------------
Service Memory Capacity ... 2047.88 MB.
Service Virtual Address ... 1946.66 MB.
Service Resident Memory ... 1918.40 MB.


[FATAL][SERVER] [MEMORY] Used memory OVER SAFE LIMIT. REMOTE CONNECTIONS ARE DISABLED.
[INFO ][SERVER] [MEMORY] VMA Avg 0.95 - Peak 1946.66 MB. - SL 2047.88 MB.

[INFO ][SERVER] [MEMORY] RES Avg 1.00 - Peak 1918.40 MB. - SL 1918.40 MB.
//=====================================================


Exception code: C0000005 ACCESS_VIOLATION


Fault address: 1002F894 01:0002E894 d:\totvs\p10\ndj\appserver\apwinnt.dll




Call stack:


Address Frame


1002F894 0190C648


Call stack:


Address Frame Logical addr Module






[WARN ][SERVER] [Thread 3808] [27/01/2012 10:01:47] Erro na finalização da Thread (marinaldo.jesus, NALDO-PC) ********************************************
*** THREAD 3808 : UNEXPECTED EXCEPTION FOUND
*** tRmtServer::RMS_REMOTESTARTED
********************************************
PLEASE, CONTACT TOTVS TECHNOLOGY DEPARTMENT.


****************************************
*** Stack Overflow found ***
*** theThreadProc -DoExecute() ***
****************************************

Comentários

  1. PLEASE, CONTACT TOTVS TECHNOLOGY DEPARTMENT.

    hehehe!
    App server is DOWN!

    ResponderExcluir

Postar um comentário

Postagens mais visitadas