Home

Toolset On-line User Guide

1. Help Date Format dd MM yyyy HH mm My Settings Re collect Re submit Hef eee ep eee He ee eee A M Reports Stats User Validation QEDOOgCOEB PED DEESD Select criteria and click Search to view results G Local intranet Protected Mode Off 100 Figure 2 3 Message Search Criteria Results Page 2 Message Search Criteria Results page 2 facilitates the execution of multiple queries in one search operation Multiple query searches are requested by uploading a file of search criteria Each record of the uploaded file represents one query and contains search criteria that augment and override the criteria defined on page 1 The simplest use of this facility 1s to upload a file with a list of MPANS User File IDs or file names 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 12 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit If the file contains a list of MPANS the search results will be augmented with an MPAN column so that the results can be correlated to the MPANS in the file In this case the message state column of the search results will be truncated to show only the code and not the description If the file contains a list of User File IDs or a list of file names the results list 1s displayed as for normal queries The User File ID is clearly displayed allowing correlation
2. Test Flag DEVELO01 NATP2 To HEG2 B To 06 Oct 2009 13 48 01 244002 0910061349490100120 Received File Name File Size Flow Count Errors Warnings 017 File has invalid characters Event starting to receive user file User file received Encrypting Encrypted Transmitted to hub Decrypting Received by hub Validating and translating Decrypted Validation translation failed Ack Encrypting Refresh j Figure 2 6 Message Details Page Events view 1 To update the Message Details page click Refresh d The Message Details page is updated displaying current information 2 To display all the MPANSs in the Message click the open icon next to the Num MPANS field OPER DEVEL001 DEV1 HEG2 A ReglestIP 2 4 440 2 txt 5045676 1 2 0 3 To toggle to the list of Message validation errors warnings click Errors To close the Message Details page click Close 5 Data in the Message Details Window that 1s supplemental to the summary search results File Size Flow Count Num MPANs list on MPANS to be viewed File DTS ID Unique internal system identifier for the file 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 18 of 22 User_Guide Audit docx File size is the count of the number of characters the file contains Flow Count is the number of flows the file contains The number of distinct MPAN references discovered in the Message
3. eee e eee e eee ee e eee e eee eee eee e ee eaaet eee eese essa s eee eee eeee 20 2 14 Messape Codes and States Rs RE RS REESE nt ns 22 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 2 of 22 User_Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit 1 DOCUMENT AUTHORISATION DOCUMENT TITLE ISSUE DATE HP ElectraLink DTS Toolset On line User 1 1 4th July 2011 Guide NAME SIGNATURE DATE AUTHOR S Gareth Hughes REVIEWERS o boo NAME SIGNATURE DATE ON BEHALF OF HP ON BEHALF OF ELECTRALINK 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 3 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit Document Control CURRENT VERSION 1 1 Project Name HP ElectraLink DTS Date 4th July 2011 AMENDMENT HISTORY Document Version Date Section Page s and Text Revised Version 15 June 2011 Gareth Hughes CCN1251 Split User Guide into separate documents Created from version 3 9 of the original user Guide 4 July 2011 Gareth Hughes Changes following ElectraLink review 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 4 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit 2 THE AUDIT TOOL The DTS records details of all file transfers and their progress through the
4. A User may have access to more than one Local Gateway and all such Gateways will be displayed in the drop list Selecting Any will search for Messages associated with any of these Gateways 1 Trusted sites The User s Host A Host is a set of directories either on the Gateway or on a server on the User s LAN that provides an interface with the Data Transfer Service for the submission and collection of User Files A User may have access to more than one Local Host and all such Hosts will be displayed in the drop list Selecting Any will search for Messages associated with any of these Hosts It is not necessary to pre select the Gateway before selecting the Host Ifa Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 7 of 22 Other Gateway Local MPID Other MPID Local Role Other Role Flow Version Test Flag State 11 07 2011 HP ElectraLink DTS Toolset On line User Guide Audit specific Host 1s selected the Gateway will be automatically set to the one associated with the selected Host The Gateway of another User A Gateway is a server that provides a User access to the Data Transfer Service A User may have access to more than one Other Gateway and all such Gateways will be displayed in the drop list Selecting Any will search for Messages associated with any of these Gateways The Local Market Participant Identifier MPID or Originator Recipient ID T
5. Hewlett Packard Development Company L P Page 14 of 22 User_Guide Audit docx 3 ES EE EN Ci a O ES EN EE 0 tn HP ElectraLink DTS Toolset On line User Guide Audit Era designator Year Month in year Week in year Week in month Day in year Day in month Day of week in month Day in week Am pm marker Hour in day 0 23 Hour in day 1 24 Hour in am pm 0 11 Hour in am pm 1 12 Minute in hour Second in minute Millisecond Time zone Time zone AD 1996 196 quil xul OF 24 2 Los 10 Z Tuesday Tue PM 0 2 4 0 12 30 515 918 Porc ean dear tne PS ATO 0 0800 3 Click Search and respond appropriately to the confirmation request Results of the search are displayed in the Message Search Results table 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P User_ Guide Audit docx Page 15 of 22 HP ElectraLink DTS Toolset On line User Guide Audit File Edit View Favorites Tools We de Electralink DTS Tools ES DTS Tools ACMT Audit Bulletin Config D FlowMast Help Test Flag My Settings Flow Re collect Re submit Reports Stats User Validation Direction D DD Gateway DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO1 DEVELOO
6. If this 1s greater than zero a folder icon will appear next to this number allowing the HP ElectraLink DTS Toolset On line User Guide Audit 2 10 MPAN LIST The MPAN List page enables the user to display the MPANS in the message A TESTOS MPAN List Microsoft Internet Explore amg Flow Version DOUG 001 File size 6691016 FilelD TESTOS Num MPANs 14 Display Format HTML 9 Excel Max MPAN to list Display P MPANs AGH berger puri erai s 2345655745520 2345655745521 234566545522 23456557 45523 2345655745524 23456557 45525 2345655 45526 23456557 45527 2345665 15578 Close be Figure 2 7 MPAN List Page The MPANS may be listed in HTML or Excel formats HTML format displays the MPANS on the MPAN List window itself Excel format opens a Microsoft Excel spreadsheet listing the MPANS Additionally the maximum number of MPANS to list may be selected The options are 10 50 100 or ALL The default for HTML format is 10 MPANSs and the default for Excel format 1s ALL This option is provided for large files which may contain large numbers of MPANS which Once the display format and number of MPANS have been selected the MPANS may be listed by clicking the Display D button 2 11 EXTRACTING RESULTS TO A FILE The results of a search or the validation errors and warnings in Messages referenced by the search results may be extracted to a spreadsheet file on your PC To do this click the Extract D button Th
7. Search D HS Stats System ime veal Select criteria and click Search to view results HD User Group EHE Validation i Trusted sites Done Figure 2 1 Message Search Criteria Page 1 Message Search Criteria Results page 1 displays the search criteria that a User can apply to search for a Message A search can use all the criteria or some of the criteria depending on the User s preference and access rights All drop list fields are mandatory The results are displayed in a table The results displayed in the table are dependent upon a User s access rights The Messages are displayed in date and time order with the most recent displayed first The Audit Tool provides the ability to refine searches for specific information For example search to find all messages that had not been delivered 2 3 SEARCHING FOR A MESSAGE 1 To search for a Message from the drop lists select the relevant criteria and in the text field enter the relevant information For all text fields except Test Flag non standard User File ID Filename and MPAN multiple entries can be entered by separating each entry with a space User File ID and Filename allow wildcard characters so that partial names can be supplied See below for more details 2 Click Search Results of the search are displayed in the Message Search Results table 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 6 of 22 User
8. current page a User is viewing and the total number of pages The total number of messages returned by the search Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 11 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit A maximum of 100 Messages are displayed per page in the Table of Results and can be viewed using the scroll bar To display the next page of Messages click Next To display the previous page of Messages click Previous To display the last page of Messages click Last Del To return to the first page of Messages click First pa To update the Message click Refresh d To display further Message details from the Message Search Results table click the relevant Message Ee ss d LU ges des The Message Details are displayed 1n a new page The Message Search Criteria Results page remains open 2 6 MESSAGE SEARCH CRITERIA RESULTS PAGE 2 um T Electralink DTS Tools Windows Internet Explorer um z e x File Edit View Favorites Tools Help OW X 3 http localhost 7001 secure index we de g Electralink DTS Tools fp E am vo Page v GToolsy 32 9 O ES DTS Tools user01 User One Vn 5 0 3 Nov 12 10 Last Login 03 Nov 11 15 Help Logout ACMT MESSAGE SEARCH CRITERIA page 2 Multi Search Criteria File Browse Page 1 Criteria File Content Reset D Search D Config D FlowMast Field delimiter Comma TE
9. service in a database This is done through a logging amp tracking subsystem known as the Audit Tool which allows a user to view details of any file successfully delivered into the Gateway and all files that were sent out via the Gateway for which they are authorised The Audit Tool allows the User to monitor Messages to and from each Gateway to which they have access A User may have access to more than one Gateway Users are able to view Messages for the last 6 months An error will be displayed if the supplied date range is wholly before this period If the date range 1s only partially before the 6 month period then a warning is displayed and the user prompted to confirm the search If a User wishes to view Message information from an earlier date then they must contact the Remote Management Centre RMC as described in the Toolset On line user Guide Overview Audit Screens can be refreshed allowing real time monitoring of Messages so that a User always has access to the most recent information about their Messages Users are also able to perform multiple searches in one search operation by uploading a file containing supplemental search criteria The Audit Tool tracks a Message from the time it is received by the local Gateway from the originating Host until the time it 1s sent by the recipient Gateway to the recipient Host Once a user has logged on to the system by entering their User ID and Password they will have access to the toolset
10. 1 DEVELOO1 DEVELOO1 r Electralink DTS Tools Windows Internet Explore a amp u QC Le I http localhost 7001 secure index User File ID Date Time From 1 Date Time To 3 Help user01 User One MESSAGE SEARCH CRITERIA page 1 Local Gateway Any Local MPID Role Any Sent 9 Date Time 02 11 09 13 45 02 11 09 13 19 02 11 09 12 47 02 11 09 12 13 02 11 09 12 12 02 11 09 11 55 13 10 09 12 01 12 10 09 16 03 12 10 09 13 02 09 10 09 16 00 08 10 09 15 53 22 10 09 11 47 22 10 09 11 45 22 10 09 11 40 22 10 09 11 28 22 10 09 11 07 amp Ses s hy B dh v E Page QTook amp 9 O G2 REG3 Oct 2009 00 00 fa Nov 2009 23 59 5j Received 1 C9 uo uo uo uo uo uo uo uo uo go uo o uo uo dO Vn 5 0 3 Nov 13 13 Other Gateway Any Other MPID Role State Any Filename Find duplicates MPAN Format Any EMS only E Both User File ID 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 861 2 2 4 810 1 2 4 810 1 2 4 810 1 2 4 810 1 2 4 810 1 gt DU gt gt gt gt gt gt gt Last Login 03 Nov 11 15 Yv Page 2 p Reset be Search pe To MPR E W State O0000 P 5 Pr Help Logout v All MPAN data items Page 1 of 1 16 messages Query Id 1 013 c 500 A 1 d Failed translation j 1 013 A 012 012 500 500 000 013 01
11. 1 poos2 DEVELOO1 13 06 11 13 16 R HBOi poos2 DEVELOOL 13 06 11 13 16 R HB02 poos2 DEVELOO1 13 06 11 13 16 S HB02 poos2 DEVELOOL 13 06 11 13 15 S HBO1 poos2 DEVELOO1 13 06 11 13 01 R HBO1 D0082 DEVELOOL 13 06 11 13 01 R HBO2 poos2 DEVELOO1 13 06 11 13 01 S HB02 poos2 DEVELOOL 13 06 11 13 00 S HBO1 poos2 DEVELOO1 13 06 11 12 46 R HBO2 poos2 DEVELOOL 13 06 11 12 46 R HBO1 poos2 DEVELOO1 13 06 11 12 46 S HB02 poos2 DEVELOOL 13 06 11 12 45 S HBOi poos2 DEVELOO1 13 06 11 12 31 R HBO1 poos2 DEVELOOL 13 06 11 12 31 R HB02 poos2 DEVELOO1 13 06 11 12 31 S HBO2 poos2 DEVELOOL 13 06 11 12 30 S HBO1 poos2 DEVELOO1 13 06 11 12 16 R HBO1 poos2 Extract D First jag Previous d Vn 001 002 001 002 003 002 002 003 001 003 003 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 vn 7 7 From TF MPID MPR TROL 01 TROL 01 TROL 01 TRO1 01 TROL 01 TROL 01 TROL 01 TROL 01 TROL 01 TROL o1 TROL 01 E TRO1 01 TROL 01 E TROL 01 TROL 01 TROL 01 TROL o1 TROL 01 TROL 01 TROL 01 TROL 01 E TROL 01 TROL 01 TROL 01 TROL 01 TROL 01 TROL 01 TROL 01 TROL 01 E Next gt Last P 15 Jun 08 52 Other Gateway Other MPID Role State Filename MPAN EMS only C Heartbeat M Last Login 14 Jun 16 13 Any Y ER Any E M All MPAN data items Page 1 of 3 Page 2 Pe Reset B Search gt 228 messages To MPID MPR E W S
12. 2 013 500 013 013 013 DUMP EE EP First lad Previous ES Next p Last be Gi Local intranet Protected Mode Off Refresh be Extract pe 10090 Figure 2 4 Multiple search criteria results 1 To reset the search criteria click Reset d Note It is important to clear the Criteria File name field for subsequent searches otherwise the criteria file will be uploaded and multiple searches performed for each request For this reason the user is asked to confirm each time a search based on a criteria file 1s requested 2 9 MESSAGE DETAILS The Message Details page displays all the details of the selected Message If the message is a sent message and there were validation errors or warnings detected then these will be shown by default Otherwise audit event history will be displayed in date and time order showing when the file passed through each stage of processing on the DTS Users can toggle between displaying errors and displaying audit events A User can open multiple Messages Details windows simultaneously Each window will use the File ID as an identifier and the File ID will be displayed in the title bar of the page The system will not allow more than one window for the same File ID to be opened If a User attempts to open the same File ID more than once the information in the original File ID window is displayed and updated 11 07 2011 User Guide Audit docx Copyright 2003 2004 2010 Hewlett Packar
13. Flow Version number The version number changes when a Data Flow is modified RGMA File Types always have a version number of 001 The Test Flag Usage Code of the Message Displays the Market Participant Identifier MPID or Originator ID from which the Message was sent Displays the Role from which the Message was sent The Role is the function a company provides within the electricity industry Displays the Market Participant Identifier MPID o Recipient ID to which the Message was sent Displays the Role to which the Message was sent The Role is the function a company provides within the electricity industry The total number of validation errors detected in the Message The total number of validation warnings detected 1n the Message Displays the current status of the Message The Message state may change when the table is refreshed Please refer to Message Codes and States at paragraph 2 14 for a complete list of Message states This column is only displayed after performing a search for files meeting criteria in which multiple or wild carded MPANS have been specified It displays the numerically lowest MPAN meeting the search criteria that is referenced in the user file This column is only displayed after performing multi criteria searches using a search criteria file See Message Search Criteria Results Page 2 at paragraph 2 6 It indicates which query in the search criteria file the result line relates to Displays the
14. Guide Audit For all other states please see Message Codes and States at paragraph 2 14 The events for a successful Message transmission are displayed below Event Starting to receive user file User file received from originator Encrypting Encrypted Transmitted to hub Received by hub Decrypting Decrypted Validating amp translating Validated amp translated Encrypting Encrypted Location of Message Message on originator s Gateway Message on originator s Gateway Message on originator s Gateway Message on originator s Gateway Message transmitted from originator s Gateway to the hub Message on hub Message on hub Message on hub Message on hub Message on hub Message on hub Message on hub Transmitted from hub to Gateway Message transmitted from hub to recipient s Gateway Received by recipient s Gateway Message on recipient s Gateway Decrypting Decrypted Transmitting to User Transmitted to User Acknowledgement created Ack Encrypting Ack Encrypted Ack Transmitted from hub to Gateway Ack Received by originator s Gateway Ack Decrypting Ack Decrypted Ack Transmitting to User Ack Transmitted to User Message on recipient s Gateway Message on recipient s Gateway Message being transmitted to recipient or copied to collection directory on recipient s Gateway Message now available to recipient Acknowledgement created on hub Acknowledgement on hub Acknowledgement on hub Acknowle
15. Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit 2 Electralink DTS Tools Microsoft Internet Explorer File Edit View Favorites Tools Help Q Bak Q x iz Search Favorites IJ a L3 de Address amp http f localhost 3080 securesindex Go Links E E EH E Hh pH CHEN DTS Tools ACMT Audit Bulletin Config D Flowlaster Database Help My Settings Re collect Re submit Reports ie E E E pEbpoobpDooO0ObpEg E Stats System User User Group Validation eds01 App Local MESSAGE SEARCH CRITERIA page 1 Local GW Host Local MPID Role Flow Test Flag User File ID Date Time From Any Few x v Any Find duplicates 13 un 2011 z oo foo E31 Date Time To 13 x Jun gt 2011 23 gt 59 Ea Direction Sent C Received C Both Gateway Date Time w D User File ID Flow DEVELOO1 13 06 11 14 01 R HB02 poos2 DEVELOOL 13 06 11 14 01 R HBO poos2 DEVELOO1 13 06 11 14 01 S HBO02 poos2 DEVELOOL 13 06 11 14 00 S HB01 poos2 DEVELOO1 13 06 11 13 46 R HBO1 poos2 DEVELOOL 13 06 11 13 46 R HB02 poos2 DEVELOO1 13 06 11 13 46 S HBO2 poos2 DEVELOOL 13 06 11 13 45 S HBO1 poos2 DEVELOO1 13 06 11 13 31 R HBO1 poos2 DEVELOOL 13 06 11 13 31 R HBO2 poos2 DEVELOO1 13 06 11 13 31 S HB02 poos2 DEVELOOL 13 06 11 13 30 S HBO
16. S ElectraLink Ap Toolset On line User Guide Audit HP ElectraLink DTS Copyright 2003 2004 2009 Hewlett Packard Development Company L P HP ElectraLink DTS Toolset On line User Guide Audit Table of Contents 1 DOCUMENT AUTHORISATION reae ne nnn eue o eoa eoo a vc ee ve ease do eeu v seuneenduenanenenntes 3 2 TH AUDIT TOOL nn nn ne nn a 5 2 1 To ACCESS Ihe Audit TOO St Eoi oi eod Co eoa obi Eo oc iere deas 5 2 3 Message Search Criteria Results Page 1 ecce Lecce ee eee e e eee eee eee eee eee e eee eee eeee 6 2 3 Searching for A M c 6 Zee CARCI CPCI Ais e M es esaee 7 2 9 Message search Results Table oie aive tte Ee ada treo eee rue xr ae RYE err eere ere 11 2 06 Message Search Criteria Results Page 2 eee ee ecce eee eee e eee e ee eese sees esses eee ee eee 12 2 7 Criteria File FOE 2 1 1 ini Din ist 13 29 Performing Viultiple Searches eio isole eve tee biegen ln ode ege uero d teste 14 29 Messac Detalls o aseeetei rm et e EE REESE UE EHE UIS RIO PIS EINE VR TUE EIE 16 210 MPAN ASC m tee 19 DAL Extracting Results to a Plein n eonun penne pna Enn esane oaea Eae e RESEP ARNSTEIN 19 2 12 Sorne Kesulls oiim Ue PERI c eb e i vs en ii meis 20 2 13 Successful Message Transmission
17. aded from the Criteria File Content drop down list 2 If the content of the supplemental criteria file is a List of queries with multiple criteria then also select the field delimiter character and date format from the Field Delimiter and Date Format fields The latter is only necessary if the criteria file contains date time fields If the standard field delimiters in the list are not appropriate select Other and enter the delimiter character s 1n the adjacent data entry field The following characters have special meaning in regular expressions so if your delimiter includes one or more of them each one should be preceded with a backslash V to ensure it is simply interpreted as that character e the opening square bracket e the closing square bracket e the backslash e the caret e the dollar sign e the period or dot e the vertical bar or pipe symbol e the question mark e the asterisk or star e the plus sign e the opening round bracket e the closing round bracket e the opening brace e the closing brace For example if your field values are separated by two asterisks enter as the delimiter If an appropriate date format pattern is not available in the list select Other and enter your custom pattern in the adjacent data entry field The characters in the pattern have the following meaning Letter Date or Time Component Examples 11 07 2011 Copyright 2003 2004 2010
18. d Development Company L P Page 16 of 22 Flow Version Sending GW Host HP ElectraLink DTS Toolset On line User Guide Audit 24 400 2 Message Details and Events Windows Internet Explorer DOO018001 Sent Test Flag DEVELOO1 NATP2 To Sending MPID Role REG B To Sent File ID File DTS ID Num MPANs Message State Lines Severity 11 ERROR 11 ERROR 06 Oct 2009 13 46 01 Received 2 4 400 2 File Name 0910061349430100120l File Size Flow Count 0 Errors Warnings 017 File has invalid characters Group Data Item Message Error PPC J0070 PPC J0070 Data item value not present in valid set Refresh pee Events j Close e Figure 2 5 Message Details Page Errors view 11 07 2011 User Guide Audit docx OPER DEVEL001 DEV1 REG A RegTestlP 2 4 440 2 txt 5045676 1 2 0 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 17 of 22 HP ElectraLink DTS Toolset On line User Guide Audit e 2 4 400 2 Message Details and Events Windows Internet Explorer in dii a GM 8 E d SO Flow Version Sending GW Host Sending MPID Role Sent File ID File DTS ID Num MPANs Message State Date Time 06 Oct 2009 13 48 01 06 Oct 2009 13 50 13 06 Oct 2009 13 50 18 06 Oct 2009 13 50 31 06 Oct 2009 13 50 33 06 Oct 2009 13 50 38 06 Oct 2009 13 50 38 06 Oct 2009 13 50 44 06 Oct 2009 13 50 44 06 Oct 2009 13 51 01 06 Oct 2009 13 51 18 D0018001 Sent
19. dgement transmitted from hub to originator s Gateway Acknowledgement on originator s Gateway Acknowledgement on originator s Gateway Acknowledgement on originator s Gateway Acknowledgement being transmitted to originator or copied to collection directory on originator s Gateway Acknowledgement now available to originator The acknowledgement is considered part of the file transfer and doesn t appear as a separate Message in the Message Search Results Table 11 07 2011 User Guide Audit docx Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 21 of 22 HP ElectraLink DTS Toolset On line User Guide Audit 2 14 MESSAGE CODES AND STATES The following Message codes and states are used by the Data Transfer Service and are useful when investigating Messages that have not been received A full event history of a Message can be viewed in Message Details page at paragraph 2 9 Code State 000 File being processed awaiting delivery confirmation 010 File not sent Failed translation code 011 File not sent Your Gateway 1s not configured to send this data flow 012 File not sent Receiving Gateway is not configured for this data flow 013 File not sent Failed translation 014 File not sent File has incorrect group count in trailer Please check 015 File not sent File header details are incorrect Please check 016 File not sent File trailer details are incorrect Please check 017 File n
20. e has the same number type and order of fields as specified in the header Each field type has the same interpretation and use as the corresponding field on page 1 of the message search criteria with the exception of QUERY ID This field allows you to correlate search results to a specific set of search criteria defined in your file If absent each query will be identified numerically by its position in the file starting at position 1 The search criteria on each line must be separated by commas pipes l spaces tabs or some other user defined sequence of characters 11 07 2011 Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 13 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit Field values must not be enclosed in quotes All lines are processed there is no provision for comment lines Lines may be terminated with UNIX lt LF gt or Windows style line terminators lt CR gt lt LF gt Example Criteria file LOCAL MPID MESSAGE STATE DIRECTION FROM DATE TO DATE POCL 500 S 01 02 2008 00 00 29 02 2008 23 59 POC2 500 9 01 02 2008 00200 29 02 2008 23 59 POC3 500 5 01 02 2008 00 00 29 02 2008 23 59 2 8 PERFORMING MULTIPLE SEARCHES 1 To perform multiple searches enter the basic search criteria on page and then enter the path to the supplemental criteria file in Criteria File using the browse facility if desired on page 2 Then select the type of data being uplo
21. e local Gateway then the sender assigns the filename If a Message i1s received by the local Gateway then the filename is assigned by the DTS MPAN If specified in the search criteria this will restrict the list of files returned by the search to those containing a reference to the given MPAN Note you may include a wildcard character 96 in the MPAN field to look for files containing MPANS that have any sequence of characters at that position Using wildcards will result in increasingly slower response times the closer to the left of the MPAN value itis used E g a query for MPANS matching 10000000000046 will be significantly quicker than a query for 1 If the All MPAN data items checkbox 1s checked then the MPAN search will include all alias and synonym fields of MPAN data items not just the J0003 MPAN data item EMS Only If selected the search results will only contain files currently held in EMS Otherwise both files in EMS and files not in EMS will be returned Date Time A User can search for Messages between a defined date range From If no date and time are defined the date defaults to the current date and the time defaults to 00 00hrs Date Time A User can search for Messages between a defined date range To If no date and time are defined the date defaults to the current date and the time defaults to 23 59hrs Direction The direction of the Message for which a User 1s searching A User can search for Messa
22. extract files is only available to view save for the course of this session and so should be saved before logging out of the tool set 2 12 SORTING RESULTS The Audit search results may be sorted in ascending descending order of most of the displayed columns If the results can be sorted by the results in a column then the column title will become underlined if the mouse pointer is hovered over it To sort click on the appropriate column heading The sort 1s initially in ascending order subsequent search on the same column will sort in descending order An up arrow or down arrow will be displayed to indicate the column and direction of the most recent sort Note The sorting of data 1s most efficient for result sets of less than 1000 files If the result set of a multiple query search contains over one thousand records attempts to re sort the results will not sort the entire set of records it will only sort the results of each individual query For more effective sorting consider running fewer queries so the result set contains less than one thousand records or extract the results to a file and use your spreadsheet program to sort the results 2 13 SUCCESSFUL MESSAGE TRANSMISSION A successful Message transmission will display the state as 500 File delivery confirmed 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 20 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User
23. ges that are either e Sent Message sent from the User s Gateway only e Received Message sent to the User s Gateway only e Both Both sent and received Messages 11 07 2011 Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 10 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit 2 5 MESSAGE SEARCH RESULTS TABLE The fields in the Message Search Results Table are detailed below Gateway Date Time E D User File ID Data Flow Vn TF From MPID From MPR To MPID To MPR E HW State MPAN Query Id Page 1 of 1 1 message 11 07 2011 The Gateway from which the Message was sent Gateway 1s a server that provides a User access to the Data Transfer Service The local Gateway ID 1s displayed where a Message has been sent The Gateway ID of the sender is displayed where a Message has been received This displays the date and time that the Message was sent or received Displays if the file is currently held in the Extended Message Store Displays S where the Message has been sent by the local Gateway Displays R where the Message has been received by the local Gateway The file identifier assigned to a Message by the sender By positioning the mouse pointer over this field the physical file name can be viewed Flow Number e g D0010 or File Type e g ONAGE etc The number or name assigned to a specific Data Flow File Type Data
24. he MPID and other identifiers are assigned by relevant bodies in the electricity and gas industries A User may have more than one identifier To enter a Local identifier type the identifier in the text field Multiple entries must be separated by a space The Market Participant Identifier MPID or Originator Recipient ID of another User The Market Participant Identifier and other identifiers are assigned by relevant bodies in the electricity and gas industries A User may have more than one identifier To enter an Other MPID type the identifier in the text field Multiple entries must be separated by a space The User s Role The Role is the function a company provides within the electricity industry To enter a Local Role type the Role in the text field Multiple entries must be separated by a space The Role of another User The Role is the function a company provides within the electricity industry To enter an Other Role type the Role in the text field Multiple entries must be separated by a space The number or name assigned to a specific Data Flow or File Type To enter a Flow type the Flow Number including the D prefix e g DOO10 or the File Type name e g ONAGE in the text field Multiple entries must be separated by a space Data Flow Version number of the Message To enter a Version type the Data Flow Version number in the text field Multiple entries must be separated by a space The Version number for RGMA flow
25. is will open the following window allowing you to initiate an extract and download extract files generated earlier within your current session 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company L P Page 19 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit E Audit Extract Status Windows Internet Explorer There are no currently no extracts to view Extract Audit Records j Extract Validation Results j Close pe Figure 2 8 Audit Extract Status prior to initiating an extract Once initiated the extract process runs in the background allowing the window to be closed and WebTools to be used in the meantime if the query takes a long time to complete Once an extract is initiated the screen will refresh every 2 seconds showing the status of the extract This will indicate if the process is still running or has completed successfully E Audit Extract Status Windows Internet Explorer Extract Type Size Bytes Time Extracted Status validation 51 03 Nov 2009 14 20 Extracting gt 9 audit 10945 03 Nov 2009 14 19 Complete Extract Audit Records j Extract Validation Results j Close j Figure 2 9 Audit Extract Status while an extract is in progress When the file is marked as Complete then it may be opened or saved to a local folder by clicking on the tick 7 Note Only one extract may be running at any given time during a user s login session A completed
26. menu and see either Audit ACMT or both and other menu items My Settings and Reports 2 1 TO ACCESS THE AUDIT TOOL 1 To access the Audit Tool from the Toolset Menu click La Audit The Audit Tool Message Search Criteria Results page 1s displayed 11 07 2011 Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 5 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit 2 2 MESSAGE SEARCH CRITERIA RESULTS PAGE 1 Electralink DTS Tools Microsoft Internet Explorer File Edit View Favorites Tools Help a Back Q a amp J Search gt Favorites 4 de 3 de Address ei http localhost 8080 secure index Go Links M EMEN DTS Tools edsO1 App Local Vn 7 7 15 Jun 08 49 Last Login 14 Jun 16 13 Help Logout em ACMT MESSAGE SEARCH CRITERIA page 1 H ig Audit Local GW Host Any ay x Other Gateway Any E 3 Bulletin aE Config Local MPID Role Other MPID Role FEX D FlowMaster Flow State Any Y Database Test Flag Any Filename Le ja ida premens I Find duplicates MPAN v All MPAN data items TA y oettings HE Re collect Date Time From 15 Jun 2011 00 x foo Es HS Re submit Date Time To 15 v un 2011 23 58 gt EMS only Page 2 P 9 Reports Direction Sent Received C Both Heartbeat Reset D
27. of the results to the queries but to view a file name the mouse must be moved over the User File ID to reveal the name in a tool tip The file name is not included on the display due to insufficient space for names that could be up to 64 characters long If this is inconvenient consider extracting the results to a file where the filenames are included in full Finally if the file contains a list of multi criteria queries the results be augmented with a query ID column so that the results can be correlated to the queries in the file Again in this case the message state column will be truncated to show only the code 2 7 CRITERIA FILE FORMAT simple criteria files are those that just contain a list of MPANS User File Identifiers or filenames These files do not require a header however each item must be on a separate line More complex queries can be specified by including multiple criteria on each line of the file In this case the file must contain a header record that identifies the content of each subsequent record The following name tokens will be recognised in the header record e QUERY ID LOCAL GATEWAY e LOCAL MPID e LOCAL ROLE e REMOTE GATEWAY e OTHER MPID e OTHER ROLE e FLOW e FLOW VERSION e FORMAT e TEST FLAG e MESSAGE STATE e USER FILE ID e FILENAME e MPAN e DIRECTION e FROM_DATE e TO DATE Any number of these may be specified and in any order The only restriction is that every record in the fil
28. ot sent File has invalid characters 018 File not sent File has an incomplete group 020 File not sent Failed encryption code 030 File not sent Failed to address file 040 File not sent Failed to queue file 050 File not sent Failed to send file 060 File not sent Failed to deliver file 070 File not sent Failed decryption 500 File delivery confirmed 11 07 2011 Copyright 2003 2004 2010 Hewlett Packard Development Company LP Page220f22 User_ Guide Audit docx
29. s is always 001 The Message Test Flag File Usage Code This can either be a standard Test Flag selected from the drop down list or a non standard free format Test Flag entered in the adjacent field The system ensures that only a single Test Flag can be supplied for a search Selecting Any will search for Messages containing any Test Flag From the drop list select the State of the Message Selecting Any will search for Messages in any state Selecting Failed due to data errors will show all files that failed validation Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 8 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit Selecting Delivered with warnings will show all files that were delivered but generated validation warnings Please refer to Message Codes and States at paragraph 2 14 for a complete list of Message states File ID The File Identifier assigned by the sender of the Message To enter a File ID type the File ID in the text field If a partial File ID 1s specified any Message whose File ID starts with the characters entered will be displayed This field also supports the use of the character as a wild card Here are some examples of how it works User File Id being searched for 0000919588 The following searches would match against this value 069 19588 wildcard at the start 009688 wildcard 1n the middle 00009195 1mplied
30. tate 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 0i 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed SSD 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed 01 500 Delivery confirmed xl Refresh de E Done Figure 2 2 Message Search Results 3 This clears all previous search criteria except 2 4 SEARCH CRITERIA To reset the search criteria click Reset P the date field which displays the current date the time from field which displays 00 00 the time to field which displays 23 59 The following criteria can be used to search for a Message Local GW Local Host 11 07 2011 User_ Guide Audit docx The User s Gateway A Gateway 1s a server that provides a User access to the Data Transfer Service
31. wildcard at the end Note that using wildcards can slow SQL queries down If the Find duplicates checkbox 1s clicked then only Messages which have duplicate File IDs within the other search criteria will be displayed Filename The Filename used by the local Gateway To enter a Filename type the Filename in the text field If a partial filename is specified any Message whose filename starts with the characters entered will be displayed This field also supports the use of the character as a wild card Here are some examples of how it works Filename being searched for rswa0000919588 usr The following searches would match against this value 260000919588 usr wildcard at the start rswa 919588 usr wildcard in the middle rswa0000919588 implied wildcard at the end 20919588 wildcard at the start and implied wildcard at the end Note that using wildcards can slow SQL queries down Note that for the standard DTS service there are two physical filenames associated with each Message The sender assigns a filename to the Message when the Message is created and this file is sent to the Data Transfer System 11 07 2011 Copyright O 2003 2004 2010 Hewlett Packard Development Company L P Page 9 of 22 User Guide Audit docx HP ElectraLink DTS Toolset On line User Guide Audit DTS The DTS then transfers the Message to the recipient Gateway and creates a new file on that Gateway with a new filename If a Message is sent from th

Toolset On-line User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents