Tips on Reading jdedebuglog FilesWord文档下载推荐.docx

Tips on Reading jdedebuglog FilesWord文档下载推荐.docx

《Tips on Reading jdedebuglog FilesWord文档下载推荐.docx》由会员分享，可在线阅读，更多相关《Tips on Reading jdedebuglog FilesWord文档下载推荐.docx（9页珍藏版）》请在冰豆网上搜索。

Turningondebuglogs

Step2:

GetintoEnterpriseOne

Step3:

Locatejdedebug.log

Step4:

Generatethejdedebug.log

Step5:

Deleteunwantedinformation

Step6:

CreatethePurchaseOrder

Step7:

Lookatthejdedebug.log

Step8:

CopyinginformationintoExcel 

Step9:

Fillinthesequencenumber

Step10:

Sortdataanddeleteunwantedinformation

Step11:

TurnoffDebugLogs

AbitofinformationontheformatofSQLstatements

Turningondebuglogs

Tobegintheprocess,turndebuggingoninthejde.ini.Thisisaccomplishedbygoingtothestartmenuandclickingon“Run”.

IntherundialogwindowtypeinC:

/winnt/jde.ini.TheNotepadprogramwillopenupanddisplaythecontentsofthejde.inifile.

Changethelinelocatedunderthe[DEBUG]stanzafromOutput=NONEtoOutput=FILE.FurtherdownalinethatreadsDebugFile=c:

\jdedebug.logindicatesthatthedebugfilewillbelocatedintheC:

\anditsnamewillbejdedebug.log.Thiscouldbenamedanything,butthedefaultvalueisfine.

SavethechangesandcloseNotepad.TheLEVELlineintheINIfilesetsuphowmuchdetailtorecordinthejdedebug.log.Thedefaultvalueisfineforthisoperation.

Anoteonthejdedebug.logfile:

ThedebuglogfilewillgrowinsizequicklywhileEnterpriseOneisused.Thisisbecauseeverycalltoatable,businessfunction,menu,objectandeverythingelseisrecorded.SettingtoadifferentLEVELofdetailcanreducethis,butstillthereisalotofdata.ThisfilecanalsobedeletedusingtheWindowsExploreranditwillsimplybecreatedagainbyEnterpriseOne.Thisfunctionalityisimportantforthisexercise.

BacktoTop

GetintoEnterpriseOne

StartupEnterpriseOne.Thisprocesswillautomaticallycreatethejdedebug.logintheC:

\directoryasspecifiedintheJDE.INIfileweeditedinstep1.

OpenupWindowsExplorerthejdedebug.logisseenRememberitislocateditintherootdirectoryofCDrive.ItmaybeatthebottomofthelistasitwillhavejustbeencreatedbyEnterpriseOne.

Generatethejdedebug.log

OnewaytousedebuglogsistofollowwhattablesarepopulatedandwhatrecordsarechangedwhenaPurchaseOrderiscreated.However,whilenavigatingthroughEnterpriseOnedataisbeingcapturedinthejdedebug.log.Itisinthisstage,thatthefunctionofthejdedebug.logbeingcontinuallyrecreatedafteritisdeletedisimportant.Togetonlytheinformationrequired,gettothepointwheretheinformationinthedebuglogisvaluable.Inthiscase,clickAdd,fillouttheinformationintheheaderanddetail,butdonotpresstheOKbuttontosavethePOyet.

Deleteunwantedinformation

Rememberthedebugfileisfullofunwantedinformation.Forthisexample,wearelookingforthedatachangedorenteredwhenIsavethePO,notallthedatarelatingtoopeningthePOmenu,verifyingitemandsuppliernumbersetc.Todothis,gobacktotheWindowsExploreranddeletethejdedebug.log….Yupdeleteit!

!

Don’tworry;

itwillberecreatedwhenthePurchaseOrderissavedwithonlythepertinentinformation.

CreatethePurchaseOrder

GobacktoEnterpriseOneandclickOK.ThePurchaseOrderissaved.DonothingelseinEnterpriseOne.

Lookatthejdedebug.log

GobacktoWindowsExplorerandlocatethenewlycreatedjdedebug.logfile.Doubleclickthefile;

itwillopenupusingtheNotepadprogram.

Itisfullofdata…wadingthroughthislookingforallthedataentriestakesalongtime.Evenusingthesearchtoolcanbedifficulttryingtofollowthechronologicalorderofthedata.ThefollowingmethodofusingExcelhelpsfilteroutonlythedatawewantandkeepitinorder.

Highlighttheentirelistofentriesinthejdedebug.log（Editmenu,SelectAll）andCopy（Ctrl+C）.OpenExcelandPaste（Ctrl+V）thecopiedinformationintofieldB1.

Fillinthesequencenumber

FillinasequenceofnumbersinColumnA.Thiscanbedonebyentering1inA1and2inA2andthenhighlightinganddraggingtotheendofthepasteddata.WidenedcolumnBsothatthepasteddataisshownmoreclearly.

NowsortthedatabycolumnCsothatitiseasytolocatetheSQLcommandsentriesSELECT,UPDATEandINSERTthesenamesareselfexplanatory,butmoredetailsofhowtheyareusedandtheformattheyareusedinwillfollow.

OncethedatahasbeensortedbycolumnCiteasytodeletealltherowsofinformationwhereSELECT,UPDATEandINSERTarenotincolumnC.

AfterdeletingalltherowswhereSELECT,UPDATEandINSERTarenotincolumnC,afewernumberofrowsareleft,showingjustthedatawewanttosee.Byonceagainsortingallthedata,butthistimeusingColumnAasthesortkeytoputtheinformationbackintochronologicalorderwhichshowsthedatainandoutoftableasithappened.

TheSELECTstatementsmaynotbenecessary,astheyareonlycallingdata,notchangingdata.Theycouldalsobedeleted.Thegraphicaboveshowsallthedatachanges（UPDATE）andrecordentries（INSERT）intheordertheyoccurredwhenaPurchaseOrderissaved.ThisisveryusefultobetterunderstandtheprocessesinEnterpriseOneandfollowexactlywhereandwhatdataisSelected,UpdatedandInsertedintotables.

WhenyouhavefinishedusingtheJDEDEBUG.LOGturnitoffsothatyoudonotclutterupyourharddrive.Seestep1tochangetheOUTPUT=FILEbacktoOUTPUT=NONE.

Select

Theselectstatementisusedtoselectdatafromatable.

SELECT 

* 

FROMF0101 

WHERE 

（ABAN8=1001.000000）

ThismeansselectAllthedata（*）fromtableF0101wherefieldABAN8（theAddressNumber）=1001.The*mayalsobereplacedby1ormanyfieldnames.

Update

Theupdatestatementisusedtochangeexistingdatainarecord.

UPDATEF4102 

SETIBITM=60003.000000,IBMCU='

30'

IBMRPC='

1'

IBUSER='

DEMO'

IBPID='

EP4310'

IBJOBN='

MEL-CG6840'

IBUPMJ=2/12/2001,IBTDAY=85439.000000WHERE 

（IBITM=60003.000000ANDIBMCU='

）

ThismeansupdatetherecordinF4102andmakethefollowingfieldshavethevaluespecified:

IBITM=60003, 

IBMCU='

30 

etc.inthistablefortherecordwhereIBITM=60003 

and 

IBMCU='

30

Insert

Theinsertisusedtoinsertanewrecordinatable.

INSERTINTOF4074VALUES（4923.000000,'

OP'

'

00001'

1.000000,0.000000,'

'

60003.000000,4343.000000,0.000000,'

USD'

EA'

0.000000,'

10.000000,0.000000,'

2/12/2001,85437.000000）

ThismeansthatanewrecordwillbeinsertedintoF4311.Thedatawillbeenteredintothefieldsintheordershownandseparatedbycommas.InsomecasesyouwillseethatZeroshavebeenusedto“pad”thecells

BottomofForm