Rank: Newbie
Joined: 24/04/2023(UTC)
Posts: 7
|
Pozdrav, dešava nam se da prilikom generisanja izvještaja 164 - Obračun izdatih računa detaljno, sistem javi kako ne postoji niti jedan zapis. Dok na drugom računaru, isti ispis, pod istim kriterijima uspješno generiše!!! Eh, sad, naredni dan, dešava se obrnuta situacija, na računaru na kojem ispis prethodnog dana nije radio sada radi i obratno 🤔🤔 Radi se o mrežnom okruženju, Pantheon bazu pogoni namjenski server, radne stanice se preko TCP/IP vežu na server. Zbog sumnje da je "nešto" u mreži krivac za smetnju, napravljeno je skeniranje mreže na Broadcast Flood sa Wiresharkom, iperf-om potvrđeno da je ping od radnih stanica do servera 1ms, čak sam koristio drugi zamjenski switch, kako bi isključio mogućnost da smetnju uzrokuje upravo switch. Ako neko ima sugestiju, bio bi zahvalan, pošto nam ova smetnja stvara poprilične probleme u svakodnevnom radu. U prilogu je isječak loga sa jedne radne stanice, prilikom neuspješnog generisanja navedenog izvještaja:[img]https://1drv.ms/i/s!AgnPzSdOHEB84GsNvKrO4M4SLbAQ?e=DVYSFq[/img] U nastavku Query koji kreira DataSet za navedeni ispis:SQL --> SELECT G.acKey, G.acDocType, D.acName AS PoslDogN, G.acCurrency, G.adDate, G.acReceiver, G.acPrsn3,
dbo.fHR_GetSubjectName2(G.acReceiver,255) as acReceiverName2, dbo.fHR_GetSubjectName2(G.acPrsn3,255) as acPrsn3Name2, M.acSupplier, P.acIdent, P.acName, IsNull(DK.anQtyReport, P.anQty) as anQty, P.acUM, M.acUM2, M.anUMToUM2,
P.anPrice AS CenaPoz, P.anRebate, P.anRebate1, P.anRebate2, P.anRebate3,
Round(P.anVAT,1) as anVAT, P.anSalePrice, P.anExcise, P.anExciseP, G.acDoc1, G.acDoc2, G.adDateDoc1, G.adDateDoc2, P.anStockPrice, M.acClassif, M.acClassif2, M.acCustTariff, G.adDateDue, G.adDateVAT, G.adDateInv,
M.acFieldSJ, dbo.fPA_KeyRet(G.acKey, SP.anDocKeyLenYear, SP.anDocKeyLenDocType, SP.anDocKeyLenNumber) as acKeyView, G.acDelivery, G.acPayMethod, G.anClerk, P.anDimVolume, P.anDimWeight, P.anDimWeightBrutto,
IsNull(DK.acDept, P.acDept) as acDept, IsNull(DK.acCostDrv, P.acCostDrv) as acCostDrv, P.anNo,
G.anFXRate, G.acStatement, G.acParity, G.acParityPost,
T.anPrice, T.cVrednost, T.cDavek, T.cPopust, T.cZaPlacilo, T.acValue, T.cPopust AS anDiscount, T.anVATValueWithVCR,
C.acUserId as acClerkId, C.acName as acClerkName, C.acSurname as acClerkSurname , M.anWSPrice, M.anWSPrice2
, G.adSigned1, G.adSigned2, G.adSigned3, MF.acHRFiskalNumber, CASE WHEN ISNULL(MF.acSIFiskalNumber, '') = '' THEN MOP.acHRFiskalNumber ELSE MF.acSIFiskalNumber END AS acSIFiskalNumber
, G.acFiscSalesBookSetNo, G.acFiscSalesBookSerNo, G.acFiscSalesBookDocNo,
S1.anQid as anQIdGDPRLogS0, S2.anQId as anQIdGDPRLogS1
, (Select ISNULL(US1.acName,' ') + ' ' + ISNULL(US1.acSurName,' ') from tHE_SetSubjContact US1 where US1.anUserID = G.anSigner1) as acSignerName1
, (Select ISNULL(US2.acName,' ') + ' ' + ISNULL(US2.acSurName,' ') from tHE_SetSubjContact US2 where US2.anUserID = G.anSigner2) as acSignerName2
, (Select ISNULL(US3.acName,' ') + ' ' + ISNULL(US3.acSurName,' ') from tHE_SetSubjContact US3 where US3.anUserID = G.anSigner3) as acSignerName3
FROM #lHE_MovePrtInvDet T JOIN tHE_Move G ON G.acKey = T.acKey
LEFT JOIN vHE_MoveFiscalisation MF on MF.acKey = G.acKey
JOIN tHE_MoveItem P ON P.acKey = T.acKey AND P.anNo = T.anNo
JOIN tPA_SetDocType D ON G.acDocType = D.acDocType
JOIN tHE_SetItem M ON P.acIdent = M.acIdent
JOIN tHE_SetSubjContact C ON G b .anClerk = C.anUserId
JOIN tHE_SetSubj S1 ON G.acReceiver = S1.acSubject
JOIN tHE_SetSubj S2 ON G.acPrsn3 = S2.acSubject
LEFT JOIN vHE_MoveItemDistKeyItem DK ON DK.acKey = P.acKey AND DK.anNo = P.anNo AND DK.anSubNo = T.anSubNo
LEFT JOIN vHE_MoveOutPos MOP ON G.acKey = MOP.acKey
CROSS JOIN tPA_SysParam SP
ORDER BY G.acDocType, G.acKey, P.anNo, T.anSubNo File Attachment(s):  PANTHEON LOG PRILIKOM GREŠKE GENERISANJA ISPISA.png (187kb) downloaded 2 time(s).You cannot view/download attachments. Try to login or register.
|