Skip to content

Instantly share code, notes, and snippets.

@nalexiou-loc

nalexiou-loc/gist:f23f935dd9a6d9f1c411548096b017d0

Created June 26, 2020 21:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nalexiou-loc/f23f935dd9a6d9f1c411548096b017d0 to your computer and use it in GitHub Desktop.
Save nalexiou-loc/f23f935dd9a6d9f1c411548096b017d0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
17:14:34.926|sc:trs|lv:NOTE|id:1|tag:MACRO|cap:MacApi.ReplaceSqlMacros.Exec|dat:/XN=HTTP /OUTPUT=HTTPSTREAM /HTTPMETHOD=GET /_DC=1593206074906 /F110I=2 /STATUS=CLIP;CPN /N903=Special /TOP=500 /EXTMAXRECORDS=20 /EXTGRIDSTEP=1 /EXTGRIDSESSION=4 /EXTGRIDALIAS=CommonGrid /DN=mStore /CN=RDGJRADVGSLGLHMG /BW=CH /DBASE_TIMEOUT=20 /CODEPAGEOUT=UTF-8 /OLD_HTT=mStore_pos_cpn_list.xml /HOT_IDX_F1148=0105691060
17:14:35.060|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql|dat:Name=Q1 Sql={:RETURN_VALUE = CALL dbo.mStore_pos_cpn_offers (:ExtGridStep, :ExtGridSession, :ExtGridStart, :ExtMaxRecords, :ExtGridSort, :ExtGridOutput, :CurCustomer, :CurStore, :Top, :F01, :N01, :F02, :F03, :F04, :D09, :F16, :F17, :F18, :F110, :F110I, :F110E, :F110P, :F155, :F113, :F116, :F117, :F126, :F253D, :F255, :F383, :F903, :N903, :F1000_POS, :F1000_PRI, :F1000_LOC, :F1000_ECL, :F1014, :F1015, :F1033, :F1120, :F1232D, :F1232E, :F1785, :offerCode, :criteria, :quick)}
17:14:35.069|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql.Prms|dat:Name=Q1 Sql=0,1,'4',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
17:14:35.072|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql|dat:/* ExtGridTemp=#CPN_LIST_GENERAL4 */{0D}{0A}{09}{09} IF OBJECT_ID('tempdb..#CPN_LIST_GENERAL4') IS NOT NULL DROP TABLE #CPN_LIST_GENERAL4;CREATE TABLE #CPN_LIST_GENERAL4 ({0D}{0A}{09}{09}{09}F1000 VARCHAR(6),{0D}{0A}{09}{09}{09}F03 INTEGER, -- dept{0D}{0A}{09}{09}{09}F04 INTEGER, -- subdept{0D}{0A}{09}{09}{09}F17 INTEGER, -- category{0D}{0A}{09}{09}{09}F110 VARCHAR(2), -- coupon type{0D}{0A}{09}{09}{09}F2929 VARCHAR(200), -- bitmaps{0D}{0A}{09}{09}{09}F1007 MONEY, -- raw price{0D}{0A}{09}{09}{09}offerCode VARCHAR(13),{0D}{0A}{09}{09}{09}offerId VARCHAR(13),{0D}{0A}{09}{09}{09}offerDesc VARCHAR(60),{0D}{0A}{09}{09}{09}offerBrand VARCHAR(30),{0D}{0A}{09}{09}{09}offerOwner VARCHAR(10),{0D}{0A}{09}{09}{09}offerBuyDesc VARCHAR(120),{0D}{0A}{09}{09}{09}offerBuyValue FLOAT,{0D}{0A}{09}{09}{09}offerBuyType VARCHAR(15),{0D}{0A}{09}{09}{09}offerGetDesc VARCHAR(60),{0D}{0A}{09}{09}{09}offerValue MONEY,{0D}{0A}{09}{09}{09}offerLimitQty FLOAT,{0D}{0A}{09}{09}{09}offerLimitAmt MONEY,{0D}{0A}{09}{09}{09}offerType VARCHAR(15),{0D}{0A}{09}{09}{09}offerPointGiven INTEGER,{0D}{0A}{09}{09}{09}offerPointRedeem INTEGER,{0D}{0A}{09}{09}{09}offerRedeemProgram VARCHAR(5),{0D}{0A}{09}{09}{09}offerRedeemClip INTEGER,{0D}{0A}{09}{09}{09}offerEmiDate DATETIME,{0D}{0A}{09}{09}{09}offerExpDate DATETIME,{0D}{0A}{09}{09}{09}offerLong VARCHAR(600),{0D}{0A}{09}{09}{09}offerCriteria VARCHAR(max){0D}{0A}{09}{09})
17:14:35.076|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql|dat:Name=Q1 Sql={:RETURN_VALUE = CALL dbo.mStore_pos_cpn_offers (:ExtGridStep, :ExtGridSession, :ExtGridStart, :ExtMaxRecords, :ExtGridSort, :ExtGridOutput, :CurCustomer, :CurStore, :Top, :F01, :N01, :F02, :F03, :F04, :D09, :F16, :F17, :F18, :F110, :F110I, :F110E, :F110P, :F155, :F113, :F116, :F117, :F126, :F253D, :F255, :F383, :F903, :N903, :F1000_POS, :F1000_PRI, :F1000_LOC, :F1000_ECL, :F1014, :F1015, :F1033, :F1120, :F1232D, :F1232E, :F1785, :offerCode, :criteria, :quick)}
17:14:35.143|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql.Prms|dat:Name=Q1 Sql=0,'2','4',null,'1000','',null,'0105691060','001','500',null,null,null,null,null,null,null,null,null,null,'2',null,null,null,null,null,null,null,null,null,null,null,'Special','PAL','PAL','PAL','PAL',null,null,null,null,null,null,null,null,null,null,
17:14:37.010|sc:trs|lv:NOTE|id:1|tag:URL|cap:FMain.PostMem|dat:HTTP:/scripts/trs.exe?XN=HTTP&OUTPUT=HTTPSTREAM&HTTPMETHOD=GET&_dc=1593206077002&refresh=1&cgi=mStore_pos_cpn_list.xml&F110I=2&Status=CLIP;CPN&N903=Special&Top=500&ExtMaxRecords=20&ExtGridStep=1&ExtGridSession=4&ExtGridAlias=CommonGrid&DN=mStore&CN=RDGJRADVGSLGLHMG&BW=CH&dbase_timeout=20&CODEPAGEOUT=UTF-8
17:14:37.010|sc:trs|lv:NOTE|id:1|tag:HTM|cap:ConvertCgiFile.Output|dat:HTTPSTREAM
17:14:37.011|sc:trs|lv:NOTE|id:1|tag:DEVICE|cap:CGIFileName|dat:C:\storeManDev\Office\CGI\mStore_pos_cpn_list.xml
17:14:37.011|sc:trs|lv:NOTE|id:1|tag:MACRO|cap:MacApi.ReplaceSqlMacros.Exec|dat:/XN=HTTP /OUTPUT=HTTPSTREAM /HTTPMETHOD=GET /_DC=1593206077002 /REFRESH=1 /F110I=2 /STATUS=CLIP;CPN /N903=Special /TOP=500 /EXTMAXRECORDS=20 /EXTGRIDSTEP=1 /EXTGRIDSESSION=4 /EXTGRIDALIAS=CommonGrid /DN=mStore /CN=RDGJRADVGSLGLHMG /BW=CH /DBASE_TIMEOUT=20 /CODEPAGEOUT=UTF-8 /OLD_HTT=mStore_pos_cpn_list.xml /HOT_IDX_F1148=0105691060
17:14:37.026|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql.Prms|dat:'CGI','MSTORE_POS_CPN_LIST.XML',
17:14:37.027|sc:trs|lv:NOTE|id:1|tag:PAY|cap:XchPay.PayUser.Cmd|dat:
17:14:37.030|sc:trs|lv:NOTE|id:1|tag:PAY|cap:XchPay.PayUser.Respond|dat:
17:14:37.034|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql.Prms|dat:'0105691060','LINK','0105691060','',
17:14:37.036|sc:trs|lv:NOTE|id:1|tag:SQL|cap:DoSql.Prms|dat:'0105691060',
17:14:37.036|sc:trs|lv:ERROR|id:1|tag:SYS|cap:Step.TrsErrCltInvalid|dat:Customer not found=0105691060 fc="307"
17:14:37.037|sc:trs|lv:NOTE|id:1|tag:HTM|cap:CNO.HookExec.HookSeek|dat: EVT=ERROR Mode:CLT State:NON Device:MSTORE Mode:1
17:14:37.037|sc:trs|lv:NOTE|id:1|tag:HTM|cap:CNO.HookExec.HookFound.3|dat:cgi=mStore_base_error.xml iHook=6 Event=EVT=ERROR Device=MSTORE
17:14:37.037|sc:trs|lv:NOTE|id:1|tag:HTM|cap:CNO.HookExec.Execute.All|dat:/MESSAGE_TAG=TrsErrCltInvalid /MESSAGE_DATA=0105691060 /MESSAGE='Customer not found 0105691060' /OUTPUT=HTTPSTREAM /DN=MSTORE /HOOKSKIP=ERROR /HOOKSILENT=1 /CGI=mStore_base_error.xml
17:14:37.037|sc:trs|lv:NOTE|id:1|tag:HTM|cap:ConvertCgiFile.Output|dat:HTTPSTREAM
17:14:37.037|sc:trs|lv:NOTE|id:1|tag:DEVICE|cap:CGIFileName|dat:C:\storeManDev\Office\CGI\mStore_base_error.xml
17:14:37.039|sc:trs|lv:NOTE|id:1|tag:TCP|cap:WebSocketSendTxt.Unassigned|dat:XML=MESSAGE{0D}{0A}content-type: loc.sms.xml.hooks{0D}{0A}{0D}{0A}<root><hooks><hook><type>display</type><tag></tag><msg></msg></hook></hooks></root>{00}
17:15:06.394|sc:trs|lv:NOTE|id:0|tag:TRS|cap:VerifyMain.VerifyForNewDate|dat:
17:15:06.399|sc:trs|lv:NOTE|id:0|tag:SQL|cap:DoSql|dat:SELECT * FROM SYS_TAB
17:15:06.400|sc:trs|lv:NOTE|id:0|tag:SYS|cap:CNO.VerifyScheduler|dat:26/06/2020 5:15:06 PM
17:15:44.066|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.WorkingSet|dat:43.659264 (MB)
17:15:44.066|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.PeakWorkingSetSize|dat:72.220672 (MB)
17:15:44.066|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.PagefileUsage|dat:48.414720 (MB)
17:15:44.066|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.PeakPagefileUsage|dat:49.889280 (MB)
17:15:44.067|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.QuotaPagedPoolUsage|dat:0.305176 (MB)
17:15:44.067|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.QuotaPeakPagedPoolUsage|dat:0.315336 (MB)
17:15:44.068|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.QuotaNonPagedPoolUsage|dat:0.036664 (MB)
17:15:44.068|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.QuotaPeakNonPagedPoolUsage|dat:0.044856 (MB)
17:15:44.101|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.Delphi|dat:20.798392 (MB)
17:15:44.101|sc:trs|lv:NOTE|id:0|tag:SYS|cap:MainTimer.Execute.Memory.NumOfSessions|dat:2
17:16:07.750|sc:trs|lv:NOTE|id:0|tag:TRS|cap:VerifyMain.VerifyForNewDate|dat:
17:16:07.755|sc:trs|lv:NOTE|id:0|tag:SQL|cap:DoSql|dat:SELECT * FROM SYS_TAB
17:16:07.756|sc:trs|lv:NOTE|id:0|tag:SYS|cap:CNO.VerifyScheduler|dat:26/06/2020 5:16:07 PM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment