Home

Confirm Task Processor - Reference.mapinfo.com

1. Pitney Bowes 6 of 41 Confirm Task Processor G8 C Windows system32 cmd exe Cola Please read the Database Configuration section of Confirm Task Processor documentation before executing this script xx Select your database type 1 for Oracle 2 for Sql Server 1 Create Oracle Database Script all Confirm Schema names separated by comma CCASESENSITIVE e g HIGHWAYS TREES GROUNDS etc HIGHWAYS GROUNDS Creation of the script file Qutput Database Script sql complete You may now connect to the Database as a DBA and run the script Press any key to continue The batch file will create a sql script named Output Database Script sq in the location where the batch file exists Step 2 Running the Script Login into the database with DBA permissions Open script Output Database Script sql Run the script e Commit to database e Logout from the database The scripts will create the following jobs in the Oracle database for each schema which need to be enabled from within the database e JOB_TASKMAINTENANCE e JOB_TASKSCHEDULER Once the database configuration is complete Task Processor needs to be setup SQL Server Prerequisite Enable SQL Server Agent from the SQL Server Configuration Manager The SQL Server Configuration Manager is installed with the SQL Server and can be opened from Microsoft SQL Server gt Configuration Tools in the Start Menu The screen shot below shows from whe
2. 7 Ensure the Task Processor is configured and running Pitney Bowes 24 of 41 Confirm Task Processor CRM Agent Overview This Agent is used to export newly created Enquiries and Enquiry updates to a Web Service If new customer information is added to an Enquiry then this will also be exported with the Enquiry Operation On each scheduled run the Agent checks whether a new Enquiry has been created or updated and if customer details have been applied or amended against an Enquiry These details will then be ex ported by the CRM Agent to a configured Web Service The Web Service may be a client specific plug in that transforms the data into a format supported by the Clients Web Service The following changes to an Enquiry will trigger an export of the information after the next agent run Anew Enquiry has been created An existing Customer has been added to an Enquiry An Enquiry has been updated A new Customer has been added to an Enquiry If the export fails for any reason e g Web Service is down then the export will be retried on the next agent run Newer exports will be given priority It is possible to limit the number of exports the Agent will attempt to send on each run in the CRM Agent System Settings screen When this limit is reached any Enquiries not yet exported will be sent on the next run of the Agent This prevents the Agent from attempting to send a large number of En quires that may have built up if
3. the MapXtreme install requires both the 32 bit and 64 bit versions of Visual C 2012 Redistributable to be installed These are supplied with the Confirm prerequis ites The desktop heap of the Task Processor machine should be increased This is optional but recommen ded The Task Processor uses a number of background processes named TaskProcessorService exe These are launched by the Task Processor Windows Service to process scheduled tasks Windows limits the amount of Desktop Heap these processes have access to which can cause problems in high load situations where multiple copies of the TaskProcessorService exe processes are run in parallel To ensure stable running of the Task Processor under load please make a change to the fol lowing registry setting on your server 1 Run RegEdit as an Administrator and browse to the following registry location HKEY_LOCAL_MA CHINE SYSTEM CurrentControlSet Control Session Manager SubSystem 2 Select the Windows key within this location and edit its value 3 Find within the value the string SharedSection which is followed by 3 numbers such as Shared Section 1024 20480 768 4 Edit the third value in the above example this will be 768 to be 4096 so our example will look like SharedSection 1024 20480 4096 Do not change any other values in this string even if they differ from those in this example 5 Save your changes by clicking OK The server will now
4. when the security window appears click apply e Click the advanced button and tick the allow inheritable permissions from parent to propagate to this object click apply then click ok and finally click ok Connector Agent Overview This Agent polls configured directories for files which are then sent to the Confirm Connector This provides a way of accessing the functionality without the need for sending requests to a Web Service Pitney Bowes 40 of 41 Confirm Task Processor Configure the Import Transformations screen within the Confirm Client application with a Process Type of Connector Agent When files are found to be processed they will be transformed if required and sent to the Connector Note The resulting XML cannot contain an Authentication element as the Task Processor user details will be used Each file can only contain one XML transaction e This Agent requires the Confirm Connector to be installed on the same machine as the Task Processor in order to process Pitney Bowes 41 of 41
5. Directory A corresponding err file will be created in the same location detailing the reasons for failure Note that the Agent generally handles errors at file level so any error detected within a file will result in the entire file being rejected Import Data Utility The Import Data Utility within the Confirm Client can also be used to import files and provides the same functionality as the Agent Pitney Bowes 28 of 41 Confirm Task Processor Specification The Specification section for this agent provides more details on file format and structure Configuration This section details how to configure the Import Anything Agent 1 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 2 Setup an Import Transformation via the Import Transformation screen Set the Process Type field to Generic Import 3 Create the directory structure on the Confirm Task Processor server for imported files The import folder should match the folder specified in the import transformation and will need an Invalid and Read directory created under it 4 Ensure the Task Processor is configured and running Photo Upload Agent Overview This Agent moves entity task photos that have been uploaded from a mobile device from the Confirm database to a pre configured data store location The photos can then be viewed or managed from the data store Operation Photos are uploaded from mobi
6. Specification The Specification section for this agent provides more details on file format and structure Configuration This section details how to configure the Contractor Access XML Agent 1 Check that the Contract Access XML Agent Module 1620 is enabled 2 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 3 Setup any Import Transformations required To do this go to the Contractor Lookup and retrieve the Contractor you wish to configure Then click on the Import button to access the Import Trans formation screen for that Contractor 4 Setup any Export Transformations required To do this go to the Contractor Lookup and retrieve the Contractor you wish to configure Then click on the Export button to access the Export Trans formation screen for that Contractor 5 Authorise Contractors to be able to change a Jobs Status via an import file This is achieved via the Job Status Lookup To authorise a Job Status for a Contractor retrieve the Job Status in the lookup and tick the Available to Contractor check box 6 Create the directory structure on the Confirm Task Processor server for imports and exports The following shows the preferred directory structure for the Contractor Access XML Agent where lt Contractor Name gt denotes a separate sub directory for each Contractor 4 d Contract a l lt Contractor Name gt 4 Import dJ Invalid di Read i Export Wb XSL
7. a Failed Status Once all new data has been exported the Agent will then attempt to resend any previous exports that are at a Pending Resend Status These could be failed exports to a Web Service as mentioned above or exports manually selected to be resent by a User Import The Agent can also import data from a Contractor system in a variety of file formats The following data can be imported e Job Status Updates e Job Items e Job Document Links e Variation Orders e Payment Requests Pitney Bowes 23 of 41 Confirm Task Processor The Agent first checks for any files in the Import Directory specified on the Additional tab of the Con tractor screen Files imported from the Import Directory must be in the tab delimited format defined in the Contractor Access XML Agent Specification The Agent then checks each configured Import Transformation for the Contractor to see whether files are present in its Input Directory If the Import Transformation has a Stylesheet specified then the transformed file must meet the specification Agent Export Log The Agent Export Log screen can be used from within Confirm client to view the status of recent or historic exports and for example to see response detail to determine reasons for failure It also allows previous exports to be flagged to be resent next time the Agent runs and anything currently flagged to be resent to be cancelled See Agent Export Log for more details
8. access should be provided on that folder to a Domain User If the folder resides on a network location access should be provided on that folder to a Domain User w 3 File Sharing Choose people on your network to share with Type a name and then click Add or click the arrow to find someone v Name Permission Level amp Administrators Owner 2 Task Processor User Read Write v I m having trouble sharing f amp Share Cancel J The following are some examples folders which need to be provided permissions to the Task Processor user e Where the Task Processors configuration file is accessed from Log file where Task Processor will write logs see logging section All folders where individual agents need to read corresponding files or data All folders where individual agents need to write corresponding files or data Configure Task Processor LogOn details This needs to be done only if domain user account has not been set at the time of installation To assign a user account to the Task Processor service Open a prompt and type services msc followed by lt return gt to open the services screen Double click on the Confirm Task Processor service e Click on the Log On tab and set the user account to be used together with its password e Click on Apply and then close the screen Pitney Bowes 17 of 41 Confirm Task Processor Confirm password ssssssseee Help me configure user a
9. the Order Number are checked If the Order is ina pending status and a PO Number has been specified on the import file the Order will be set to a committed status If a PO Number is not specified on the import file and the Order is at a Committed status the Order will be set back to a pending status Specification The Specification section for this agent provides more details on file format and structure Configuration This section details how to configure the Financial Interface XML Agent 1 Check that the Financial System Agent Module 1710 is enabled 2 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 3 If financial authorisation is to be imported via the agent ensure that the Contract s have been set to require authorisation This is achieved via the Contract Interface tab on the Contract Lookup Set the Financial Interface field to Requires Authorisation 4 If financial authorisation is to be imported via the agent ensure that the Import Transformation is setup To do this go to the Import Transformations Lookup and create a transformation that has a Process Type of Financial XML Agent 5 Setup any Export Transformations required To do this go to the Financial Interface Export Transformations lookup and set the transformation with any stylesheets that need applying 6 Create the directory structure on the Confirm Task Proc
10. Organisation belongs to If the Organisation field is cleared then it will check all the Organisations belonging to the specified Group e Click the Other button and select Export via ETON The batch Recipients screen will appear assuming this is the first time you have run the Export if it is not the first time then you will be asked if you wish to modify the existing batch In the To field enter the Organisation you wish to send the currently selected Organisation details to e Click Save this will save the batch making it available for export using Street Works Transfer Finally run the Street Works Transfer Agent to export the OD Batch information to the selected Or ganisation Should this fail for any reason check the Street Work Transfer trace log file and information log file Troubleshooting ORA 12638 Credential Retrieval Failed Error If the following error is received Microsoft NET Framework application If you click Continue the application will ignore this error and attempt to continue Q Unhandled exception has occurred in a component in your OR4 12638 Credential retrieval failed See the end of this message for details on invoking a just in time JIT debugging instead of this dialog box XXXXXXXXXXXXXX E xception Text XXXXXXXXXXXXXX System Data OracleClient OracleE xception ORA 12638 Credential retrieval failed at MapInfo Confirm Common E ception andling Han
11. Pitney Bowes Confirm Task Processor Add values to the following registry keys Registry Key Description LoggingEnabled Defaults as No When logging is set to Yes all provider level logging will be written to the log file When disabled logging is cached and only written when an error occurs LogFile Sets the path and filename for the Confirm Task Processor logging Note These logging settings are common for all databases that are being serviced by the Task Processor When upgrading the Task Processor existing entries are retained Configuring Database Logging To enable logging for each database go to the Task Processor Settings screen in the Confirm Client for the tenant you wish to configure Tenant logging can be turned on or off in this screen and the log file name and location can be set Log Settings Logging v Log File CONVMCONFIRM Fileshare Task Processor TenantLogs HDh Default Login Details User System Supervisor SBS Password Email Settings From Name Confirm Task Processor on HDM4 From Address asupervisor 152 144 2P6 4 mail OK Cancel Save Configuring Login Details The Task Processor requires the User ID and Password of a Confirm User in order to run successfully These need to be populated on the Task Processor Settings screen in the Confirm Client Pitney Bowes 15 of 41 Confirm Task Processor If the Task Processor is being configured to multiple database connections thi
12. URL gt eton4webservice asmx This indicates that an EToN transaction is being sent to a web service e Receiver Fault received from Web Service Error Error processing request This indicates that an error has been received from the destination web service Contact the Organ isation which you are sending to In the case of another Confirm system review the Trace log file for their web service e BatchFailed Record created BatchID 1234567 This indicates that the EToN transaction failed to be sent to the web service The next time the Street Works Transfer runs it will attempt to re send the same transaction e Due to Previous Notice failure Previous Works WZ00180000001 e Notice Validation Error The element xxxxxxxxx in namespace http www wrcplc co uk Schem as ETON has invalid child element xxxxxxx in namespace http www wrcplc co uk Schemas ETON This indicates that the Operational District OD data which the Street Works Transfer is trying to send does not pass the ETON Schema validation checks Refer to the Street Works user manual Organisation section for details on how the Organisation data should be completed Error Client found response content type of text html but expected application soap xml The following error can occur when the Web Service receiving the notice has incorrectly configured on an IIS 7 server 26 04 2010 10 42 52 Error Error Client found response content type of text
13. account This account is required for the Task Processor service to access shared files and folders on the network If you are not logged in as domain user skip this step and you may set the domain user account as part of Configuration Logon Information Specify the user account that the service can use to log on Setting up the user account may take a while Domain Username Domain TaskProcessorUser Note Leave the details as blank if you are not installing as a domain user InstallShield lt Back It is recommended to use a unique domain user whose password is set to never get locked or expire This user should only be used to run the Confirm Task Processor service Pitney Bowes 12 of 41 Confirm Task Processor Note This User should have same regional settings like Date Format Timezone as that of Task Processor machine 5 Select your preferred installation location If you have not previously enabled the Confirm User Experience Improvement Program UEIP on the target machine you will see a checkbox allowing you to enable it now Click the UEIP Details button for full details of this program Click Next to continue la ter Destination Folder Click Next to install to this folder or click Change to install to a different folder Install Confirm Task Processor to C Program Files x86 Pitney Bowes Confirm Task Processor InstallShield 6 Click Install to begin the installati
14. ask that is responsible for sending ETON 4 or above notices This covers Notices Comments ETON 6 or above Inspections Fixed Penalty Notices Restrictions Operational District Data and also progresses Events and Diversions through their lifecycle Operation Testing OD Batch XML The steps below configure data in order to test the sending of your OD Batch information e Launch Confirm and open the Organisation Lookup screen Street Works gt Street Works Lookups gt Organisation e Retrieve your Organisation details e Refer to the Online help file Organisation Operational District OD transactions section to setup all the required fields Click the Other button and select Export to OD Batch XML Ping Get Restrictions Export to OD Batch XML Export via EToN Pitney Bowes 34 of 41 Confirm Task Processor e Select an OD Filename location and ensure the Preview option is enabled click save then click ok The Operational District Export preview screen will appear displaying whether the Organisation details pass validation Assuming it passes validation click Close and you will be returned to the Organisation screen Note By default the Validation process will only check the Organisation you currently have selected when the ETON export is performed it will attempt to send the information for all Organisations belonging to the Organisation Group that this
15. ation options Street Works Transfer uses XML via HTTP in order to send notices and the Web Service receives ETON notices Pitney Bowes 37 of 41 Confirm Task Processor Transfer Files Description Confirm Transfer ETONXML Parent Transfer directory for ETON XML Notices Export Parent directory for the Export of ETON XML notices Sent Sent Failed Location of the unsuccessfully sent xml files Pre requisities Street Works Transfer requires the following to be installed and configured in order to successfully transfer notices via ETON Ability to send XML data via HTTP e Optional SMTP mail access for sending of Alert emails Transferring Notices ETON version 4 and above transfer data in XML format The Street Works Transfer Agent will export the XML transactions for Notices Inspections ETON 6 and above Comments Restrictions and Op erational District OD data Make the following changes to process all XML notices Update TaskProcessorService exe config file located in the Confirm Task Processor installed directory e g C Program Files Pitney Bowes Confirm Task Processor lt add key WebServiceCallTimeout value 120000 gt This is the length of time that the Street Works Transfer will wait for the Web Service to respond in milliseconds For General Settings of Street Works refer to Street Works Transfer System Settings Email Options The email functionality for Street Works Transfer will alert the
16. cation Date Time Char 30 Scheduled Reporting Agent This Agent extracts information from the Confirm database at regular intervals and publishes it It can be used to drive email alerts to publish management reports for interfaces exporting data to other systems and to provide the data behind Confirm Dashboards This is achieved by configuring a number of Scheduled Reports to be run by the Agent Each of these has a Data Source determining what results it will retrieve and a Follow Up determining the frequency at which it will be run Each Scheduled Report is also configured as to how its results are published Any combination of the following can be chosen e Results saved to one or more files e Results sent via email to one or more Contacts e Results saved to the database for use in Confirm Dashboards Operation The Agent will process all Scheduled Reports with a Next Run Time less than the time at which it runs It does this in order of Next Run Time with the Scheduled Report with the earliest Next Run Time being processed first If a Scheduled Report has Process Backlog ticked then its entire backlog will be processed before moving on to the next Scheduled Report A Scheduled Report with a blank Next Run Time will be ignored by the Agent so clearing the Next Run Time in the screen in Confirm can be used as a way to temporarily or permanently disable a particular Scheduled Report A Scheduled Report wi
17. ccount log on options It is recommended to use a unique domain user whose password is set to never get locked or expire This user should only be used to run the Confirm Task Processor service Starting the Task Processor Once Task Processor has been configured follow these steps to start the Task Processor service Open a command prompt and type services msc followed by lt return gt to open the services screen e Find the Confirm Task Processor service and start it Note The Task Processor will only process agent tasks scheduled in the Scheduled Tasks screen within the Confirm Client Pitney Bowes 18 of 41 Confirm Task Processor FAQ Q I am using the Confirm System Agent What steps should follow to install the Confirm Task Processor A Please follow the steps as provided in the order below Upgrade the Confirm Client to V14 or above e Wait for agent tasks that are running to complete and then suspend all agent tasks in Scheduled Tasks screen applicable only if upgrading from V12 20 Stop the System Agent Run the database configuration script against the database Run the Task Processor installer e Configure the Task Processor Enable database queue and maintenance job scripts e Enable the agent tasks in the Scheduled Tasks screen Q I am using MSMQ to process Scheduled Tasks Do need to take any extra care while up grading to Confirm Task Processor A The Syste
18. dleE xception E xception e at MapInfo Confirm Entities Management Entity anager 1 Save T obj IList1 othe at Maplnfo Confirm Entities Management Entity anager Save T obj at MapInfo Confirm Business StreetWorks StreetworksProcess Savel at Maplnfo Confirm Business Streetworks UK NoticeProcess Savel lt Locate the SQLNET ora file This will be found where the Oracle client has been installed Edit the file with a text editor and change the line SQLNET AUTHENTICATION_SERVICES NTS to SQLNET AUTHENTICATION_SERVICES NONE NTS is Windows Native Authentication and uses the client login to Access Windows NT Server and the database running on that server This generally doesn t work for access to the Confirm database Pitney Bowes 35 of 41 Confirm Task Processor Setting it to None means no special Authentication method is used and the database Username and Password are obtained from Confirm correctly in the normal way Logging The Confirm Task Processor creates a log file as specified on the Task Processor System Settings This will contain information of all transactions done by the Street Works Transfer Agent along side all other Agents This file will have following messages e Notice Sent Updated Database successfully This indicates that the transaction has been sent to a receiving web service and has been accepted Sending lt Temp File Path gt lt Filename xml gt to http lt
19. e time even if your database server is setup with a different time zone from your Task Processor server Pitney Bowes 21 of 41 Confirm Task Processor Agents The following sections outline the Agents can be run from the Confirm Task Processor Alerts and Notifications Agent Overview This Agent organises emails and notifications that are used to alert a user to a particular event which has happened or is about to happen in Confirm Alerts can be delivered to an email address a Confirm Inbox or both Alerts can be setup for the following entities Enquiries e Jobs e Offences and Fixed Penalty Notices e Street Works Operation On each scheduled run the Agent checks all Alert Types that have been configured It then checks the specific criteria of each Alert Type against its relevant entities e g Jobs and then processes the alert and sends it to the configured user in their chosen format All Alert Types are processed in turn until there are no more alerts to process Configuration This section details how to configure the Alerts and Notifications Agent 1 Check that the Alert Modules you require are enabled 2 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 3 Setup the Alert Types that are required e For Enquiries module 1420 go to the Enquiry Alert Type lookup e For Jobs module 0785 go to the Job Alert Type lookup e For Offences and Fixed P
20. ed Tasks are getting processed How do troubleshoot A Verify the following e Confirm Task Processor is installed in administrative mode and running as a Windows Service The Task Processor Service account user has access to the configuration file e Check configuration file for any error To verify try connecting Confirm Client with the same config uration file e Verify that User Login details on Task Processor Settings screen are correctly populated in the Confirm Client e Check the logs and event viewer for any errors e If error is logged in log file as System OutOfMemoryException then try increasing the desktop heap size of the Task Processor machines as mentioned in Pre requisite e For Oracle database If error is logged in log file as Check Configuration file or Unable to dequeue then there may be a problem with ODP Net installation Un install ODP Net from the machine and re install as per steps given in Pre requisite Q My tasks are constantly failing how do I troubleshoot A Ensure that connection string for each database in configuration file is correct and drivers are installed on Task Processor machine as per connection string details Q l m writing a Data Source that looks at the scheduled_task table but the times aren t consistent with what I see on the screen A Date times in the scheduled_task table are stored in Coordinated Universal Time UTC This is to ensure tasks run at the appropriat
21. enalties module 2710 go to the Offence and Fixed Penalty Notice Alert Type lookup e For Street Works module 3520 go to the Street Works Alert Type lookup 4 Ensure that all users to be used with alerts have their Message Preference field set in the User Security lookup 5 Check that all specified email addresses are valid 6 Ensure the Task Processor is configured and running Contractor Access XML Agent This Agent provides an automated method of interfacing between Confirm and multiple Contractor systems The Agent can be used for the following e Send requests for quotes for work from the Contractor Pitney Bowes 22 of 41 Confirm Task Processor e Receive quotes from the Contractor items and quantities e Send Committed Works Orders to the Contractor for work to be carried out e Receive Job Status Updates on completion of work or at interim stages e Receive Payment Requests for interim or final payment e Send Payment confirmation Information is transferred from Confirm to the Contractor systems by means of text files or requests to a Web Service and can be received from Contractor systems by means of text files in a variety of formats Operation On each scheduled run the Agent processes all configured Contractors in turn It first of all checks whether there are any Jobs Works Orders Variation Orders or Payments for the Contractor awaiting export and if so exports them to each configured Export Transfor
22. essor server for imports and exports Pitney Bowes 27 of 41 Confirm Task Processor 7 Ensure the Task Processor is configured and running Import Anything Agent This Agent provides an automated method of importing several different types of record into the Confirm database in a variety of file formats The records that can be imported include Features Inventory Jobs Defects and Traffic Count Surveys The full list of supported record types and the associated Module requirements can be found in the specification The Agent can be used to set up a folder where users can drop files to be imported or to configure an interface for external systems to load data into Confirm This is achieved by configuring a number of Import Transformations to be run by the Agent Each of these polls a particular folder for any file waiting to be imported transforms the file to the Agent s preferred format validates the content and if there are no errors saves the results to the database The same functionality is available interactively using the Import Data option on the Confirm menu Operation When the Agent is triggered it processes all defined Import Transformations with the Generic Import Process Type Each Import Transformation has a specified Input Directory and a File Name Mask by default used as a filter so the Agent does not attempt to import inappropriate files The Agent will identify all files in the Input Director
23. f this entry is not specified for any database Task Processor s will use the default limit of 10 parallel tasks for that database Q How can I ensure that Task Processor s always have capacity to process critical tasks A Following entry in Task Processor configuration file will reserve the number of tasks that can run only if they are critical ReservedCriticalTlasks lt number gt This limit is a subset of total tasks that can run in parallel for a database and is limited by it If this entry is not specified for any database Task Processor s will use the default number of 0 reserve slot for critical tasks for that database Q None of the Scheduled Tasks are getting queued How do troubleshoot A Verify the following for your database SQL Database e SQL Server Agent is started e Database configuration has been successfully done The jobs created by the database configuration script are enabled SQL Service Broker is enabled This can be verified from Service Broker section within the database properties e Check View History of database jobs for any setup related errors and take corrective action Oracle Database Database configuration has been successfully done The jobs created by the database configuration script are enabled e Check Run Log of database jobs for any setup related errors and take corrective action Pitney Bowes 20 of 41 Confirm Task Processor Q None of the Queued Schedul
24. features would be left as they are in the case of no geometry being present on the Feature in Confirm Configuration How to configure Referential Integrity 1 Ensure that both Map 0425 and Referential Integrity 0440 modules are enabled 2 Create a layer with the correct fields according to the specification 3 A file based layer should be in a location that is visible both to the Task Processor server and the Confirm Client 4 Use the Map Workspace Manager to register the layer 5 For Defects Jobs Enquiries and Street Works open the Map Settings screen and specify the registered map layer Note With the exception of GPS Logging layers are not created automatically Blank entity layers can be supplied upon request 6 For Features the user can set different map layers for each of their Feature groups Open the Feature Group screen and find the appropriate Feature Group Specify the registered map layer in the Map Layer field on the Additional tab 7 On the Scheduled Tasks screen add the Referential Integrity task and set the correct schedule and a Supervisor email address 8 Ensure the Task Processor is running 9 Once the Task Processor is running only Confirm Entities that are subsequently updated will be reflected on the corresponding Map layer As such existing data will not be automatically shown Pitney Bowes 30 of 41 Confirm Task Processor on the map In order to populate this data onto the Map Layers SQL wi
25. firm if Central Asset Id is being used as the primary column Otherwise Asset Id will contain the Central Asset Id a MR a e Enquiry Referential Integrity Map Layer The layer must contain this primary column Enquiry_Number enq no Decimal 8 0 For full functionality the layer must also contain the following columns e Service Char 4 e Subject Char 4 e Description descript Char 254 e Location Char 254 e Logged Date log date Date Time e Enquiry Status enq status Char 4 e Site Code Char 10 Job Referential Integrity Map Layer The layer must contain this primary column e Job Number Decimal 8 0 The layer may also contain the following optional columns These attributes of the map layer record will be updated if present e Location Character 250 e Notes Character 250 e Job Status Char 4 Pitney Bowes 32 of 41 Confirm Task Processor e Site Code Char 10 e Plot Number plot no Decimal 10 2 GPS Logging Referential Integrity Map Layer Referential Integrity will automatically create this layer The layer will be populated with the Action Officer s current GPS location information when updates are received via the Confirm Connector The layer must contain this primary column e Officer Code Char 4 The layer will also contain the following columns e Officer Name Char 30 e Work Group Char 4 e Officer Telephone Char 20 e Location Key Decimal 9 0 e Lo
26. ge the entry within quotes in the value e lt add key SMTPHostlPAddress value 127 0 0 1 gt Set to the IP Address of your SMTP server e lt add key SMTPHostPort value 25 gt Set to the port number your SMTP server is running on For General Settings of FPN Email refer to Penalty System Settings Proxy Server Settings It is possible to configure the Street Works Transfer to use a Proxy Server when transferring Notices via the HTTP protocol In practice this means Notices for EToN 4 or above The Street Works Transfer will not use a Proxy server by default In order to enable the use of a proxy server you must edit the TaskProcessorService exe config file found in the Confirm Task Processor Installation directory and set the following key to Y e lt add key ProxyEnabled value Y gt You must then put proxy server connection settings in one of two places In the Confirm database These settings The General Systems Settings screen of the Confirm System Administration module e The TaskProcessorService exe config text file Settings found in the TaskProcessorService exe config file will be used in preference to those in the General System Settings screen but it is not necessary to have settings in the TaskProcessorSer vice exe config file if they are set inside Confirm The TaskProcessorService exe config proxy connection settings are as follows e lt add key ProxyAddressAndPort value 127 0 0 1 8050 gt E
27. html but expected application soap xml 500 Internal server error Note There is more content in the error Error Client found response content type of text html charset utf 8 but expected applica tion soap xml The following error can occur when the Web Service receiving the notice has incorrectly configured on an IIS 7 server 26 04 2010 13 48 48 Error Error Client found response content type of text html charset uttf 8 but expected application soap xml lt title gt Runtime Error lt title gt Note There is more content in the error Pitney Bowes 36 of 41 Confirm Task Processor Error Log An Error Log file is created in parallel with the Log File specified above The file name of the Error Log file will be the same as the Log File with error prefixed to it The Error Log file contains only error trace messages and all other messages are omitted Configuration Related Documentation The following is a list of documentation related to Street Works Transfer e CHA16002 Confirm Street Works TMA Deployment Implications Note Street Works Transfer only exports data The Street Works ETON Web Service CHA17408 does the Importing The above example displays two Confirm Environments for ETON 4 and above Transfers Street Works Transfer Agent Directory Structures The below is an example directory structure for Street Works Transfer Agent and may vary depending on your configur
28. icenses LICENSE 2 0 The source code for this software is available from http nodatime org Chromium Embedded Framework version 3 which is licensed under the New BSD License The li cense can be downloaded from http opensource org licenses BSD 3 Clause The source code for this software is available from http code google com p chromiumembedded downloads list Xilium CefGlue version 3 which is licensed under the MIT License with portions licensed under the New BSD License The licenses can be downloaded from http opensource org licenses MIT and http opensource org licenses BSD 3 Clause The source code for this software is available from http xilium bitbucket org cefglue D3 Data Driven Documentation version 3 4 1 which is licensed under the New BSD License The license can be downloaded from from https github com mbostock d3 blob master LICENSE The source code for this software is available from http d3js org OpenLayers version 2 12 which is licensed under the Modified BSD License The license can be downloaded from http svn openlayers org trunk openlayers license txt The source code for this software is available from http trac osgeo org openlayers browser Proj4js version 1 which is licensed under the Apache License Version 2 January 2004 The license can be downloaded from http www apache org licenses LICENSE 2 0 html The source code for this software is available from http trac osgeo org proj4js requ
29. ies a Gy Storage A Security Once the database configuration is complete Task Processor needs to be setup Pitney Bowes 9 of 41 Confirm Task Processor Setup The Confirm Task Processor takes tasks off the queue of scheduled tasks on the database and pro cesses them Database configuration controls when those tasks are placed on the database queue based on the timings configured against the tasks in the Scheduled Tasks screen within Confirm Database configuration needs to be done before the Confirm Task Processor is able to process tasks Pre requisites The following steps should be performed before commencing installation of the Confirm Task Processor The pre requisites are supplied on the Confirm Media unless otherwise stated e Microsoft NET Framework 4 0 should be installed e Microsoft NET Framework 3 5 SP1 should be installed e MapXtreme requires Visual C 2012 redistributable e Visual C 2010 redistributable e Oracle or SQL Server Database client drivers not supplied on Confirm Media e Oracle ODP Net 12c 32 bit if an Oracle database is being used To install ODP Net 32bit follow these steps 1 Make sure the correct Oracle Client driver is installed 2 Use ODP Net 32bit only even if the machine is 64 bit 3 Run selecthome bat located within the bin folder of the Oracle ODP home as local administrator 4 Once installation is complete restart the machine Note For 64 bit environments
30. ireJS version 2 1 2 which is licensed under the MIT License or the New BSD License The license can be downloaded from https github com jrourke requirejs blob master LICENSE The source code for this software is available from http requirejs org Apache Cordova version 4 2 0 which is licensed under the Apache License Version 2 January 2004 The license can be downloaded from http www apache org licenses LICENSE 2 0 html The source code for this software is available from http ohonegap com download December 11 2015 Table of Contents Confirm Task Processor Database Configuration Oracle SQL Server Setup Pre requisites Installation Configuration FAQ Agents Alerts and Notifications Agent Contractor Access XML Agent CRM Agent Enquiry FPN Delivery Financial Interface XML Agent Import Anything Agent Photo Upload Agent Referential Integrity Agent Scheduled Reporting Agent Street Works Transfer Connector Agent 10 10 10 15 19 22 22 22 25 26 26 28 29 29 33 34 40 Confirm Task Processor The Confirm Task Processor is an individual component within the Confirm release package and is installed as a Windows service through its installer It supports processing of the Agents that are available within the Scheduled Tasks screen In this section Database Configuration 6 Setup 10 FAQ 19 Agents 22 Confirm Task Processor Database Configuration Task run times are set withi
31. le devices to the Confirm database On each scheduled run the Agent checks for any new photos that have been added to the database The Agent will then check the Document Links System Settings screen and retrieve the document store details The Agent will then copy the photos to the document store and remove the photos from the database Configuration This section details how to configure the Photo Upload Agent 1 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 2 Check that the Document Store is configured in the Document Links System Settings screen 3 Ensure the Task Processor is configured and running Referential Integrity Agent This Agent synchronizes changes made to entity records in the Confirm database with their corres ponding map layer record This ensures that entities can be accurately tracked on the Map The following entities are supported e Defects Enquiries Pitney Bowes 29 of 41 Confirm Task Processor e Features e Jobs e Street Works only ETON 4 and above records are updated on the map Operation When a Confirm entity of a type configured for Referential Integrity is added amended or deleted within Confirm it is flagged for processing by the Referential Integrity Agent This is done by means of a record being inserted in the entity_modify table in the database When the Referential Integrity Agent is run it examines the contents of the e
32. ll also be ignored if it has no Recipients and there are no Dashboards dependent on its results In this case the Agent will log a warning and then move on to process the next Scheduled Report The Agent has some Tolerance checks in place to detect Scheduled Reports that take too many re sources as detailed in the following table Pitney Bowes 33 of 41 Confirm Task Processor Tolerance Default Value Time Warning Tolerance 15 minutes If the time taken for a Scheduled Report to retrieve its data exceeds this Tolerance a warning is logged and emailed to the Agent Supervisor Time Error Tolerance 1 hour If the time taken for a Scheduled Report to retrieve its data exceeds this Tolerance the Scheduled Report is aborted and the Agent proceeds to the next one Memory Tolerance 1 8 GB If the total memory allocated to the Task Processor exceeds this value then the current Scheduled Report is aborted Note the memory is not neces sarily released immediately so subsequent Scheduled Reports may also be aborted Note The Tolerances may be adjusted from their default values using settings in the database If the values above are found to be not appropriate SQL can be obtained from Pitney Bowes to do this Configuration The detailed configuration is done in the Scheduled Reports screen where the behaviour of each in dividual Scheduled Report is specified Street Works Transfer Overview Street Works Transfer is a Scheduled T
33. ll be required and can be supplied upon request Street Works and Layer Colours The Referential Integrity process will colour items on the layer according to the Promoters Organisation via the Additional Tab Whilst it is possible to change these colours only Notices which have updates will be re coloured by the Referential Integrity Agent Map Layer Specification The Referential Integrity Agent will update the following columns depending on the Confirm entity being processed Referential Integrity will not automatically create the map layer unless stated in the section below Street Works Referential Integrity Map Layer The layer must contain these primary columns e Work Number Char 12 The layer may also contain the following optional columns These attributes of the map layer record will be updated if present e Organisation Char 100 e Description Char 254 e Start Date Date Time e End Date Date Time e Organisation Code Char 8 e Works Reference Char 20 Defect Referential Integrity Map Layer The layer must contain this primary column e Defect Number defect_no Decimal 8 The layer may also contain the following optional columns These attributes of the map layer record will be updated if present e Defect Type def type Char 4 e Description descript Char 254 e Location Char 254 e Defect Date def date Date Time e Defect Status def status Char 1 Feature Referential Integri
34. m Agent running in Scheduling only mode should be stopped Wait for running agent tasks to complete Then stop the System Agent instances running in Processing only mode Installation of the Task Processor can then be done Q How do upgrade my Task Processor A It is recommended to wait for running agent tasks to complete Then suspend all agent tasks in Scheduled Tasks screen The Task Processor can then be upgraded using its installer Once done suspended tasks may be enabled Q Can I upgrade Task Processor in silent mode A It is recommended to upgrade using setup exe However in case silent upgrade is required follow the steps provided below e Prepare the silent upgrade command Copy the following command in any text editor like Notepad setup exe s v qb IS_NET_APIl_LOGON_USERNAME lt Domain Task Processor User gt IS NET _APl_LOGON_PASSWORD lt Password gt e Replace lt Domain Task Processor User gt with domain and user account used by Task Processor service e Replace lt Password gt with actual password Copy the Task Processor setup installation folder at the local drive on installation machine Open command prompt as administrator e Change the directory to point at local installation folder e Run the command prepared in step 1 to perform silent upgrade Screen shot below is an example of the steps described above Pitney Bowes 19 of 41 Confirm Task Processor rm Co
35. mation for that Contractor It then checks whether there are files in any of the import folders configured for the Contractor and if so imports each one in turn Export The Agent extracts information relevant to the Contractor from the Confirm database and creates an XML structure containing that information to be sent to the Contractor system The following types of record are included in the XML data e Jobs at an Export to Contractor Status and with a preferred Contract which is assigned to this Contractor e Committed Works Orders e Committed Variation Orders Committed Payments The XML data is then processed by all the Export Transformations configured for the Contractor Each of these may optionally transform the data using an XSL stylesheet e g to select which parts of the data to output or to define the format of that output and determines whether the transformed data is exported to a file or to a Web Service Each export is recorded in the database with a Status of Successful or Failed and other information such as details of response from the destination Web Service Previous exports can be seen on the Agent Export Log screen see below Note that an export to a Web Service which fails due to a receiver error for example the Web Service is currently down will be set to a Pending Resend Status providing it has not already been sent 10 times If it has reached this limit it will be set to
36. mputer Local Disk C Task Processor Installer v z Search Task Processor Installer Hl OO j y Incdudeinlibrary Share with New folder ha ml Name Date modified Type Size B Confirm Task Processor 04 03 2014 15 23 windows Installer P 9 625 KB Datar 04 03 2014 15 23 Cabinet File 15 826 KB setup 04 03 2014 15 23 Application 2 933 KB Splash 04 03 2014 12 40 Bitmap image 440 KB fox Administrator C Windows System32 cmd exe Microsoft Windows Uersion 6 1 7601 Copyright lt c gt 2669 Microsoft Corporation All rights reserved C Windows system32 gt cd C Task Processor Installer C Task Processor Installer gt setup exe s v qht IS NET API LOGON USERNAME Domai n TaskProcessorUser IS NET API LOGON PASSWORD PasswordY Q use mapped drives to read and write to network locations These mapped drives are used by multiple agent tasks to process data Will they work with the Task Processor A It is recommended to use UNC fully qualified paths when referring to network locations The Task Processor can read write data from a mapped drive only if a setting has been added in the Mapped Drive Settings screen Q I have multiple databases like live dev and test to be serviced by Task Processor s How can allocate different processing power to each database A Following entry in Task Processor configuration file will limit the number of tasks that can run in parallel for a database MaxTasks lt number gt I
37. n the Scheduled Tasks screen on the Confirm Client When tasks reach their next scheduled run time they are placed on a database queue Queued tasks are then taken from the queue and processed by the Confirm Task Processor For tasks to be placed on the database queue a database script need to be run before processing can take place Upgrade the database before running the script There are separate scripts for Oracle and SQL databases The script should only be executed by a database administrator The batch utility to create the script is located on the Confirm media in the Resources Task Processor Database Configuration folder The database script needs to be executed only once and at the time of setting up the Confirm Task Processor for a database All subsequent upgrades will be taken care by the installers Note The database script should not be executed if already using Confirm Task Processor upgrading from v14 00 or above Oracle Step 1 Creating the Script Copy the Task Processor Database Configuration folder to the local drive from Resources folder within Confirm media Ensure following files exist in the same folder 1 Create Database Script bat 2 Oracle File1 txt 3 Oracle File2 txt e Launch Create Database Script bat batch file Enter 1 when prompted for type of database e Enter all Confirm Schema names separated by comma The screen shot below is an example of how the entries may look like
38. need to be restarted for the changes to take effect Once the Task Processor pre requisites are installed Task Processor Installation needs to be done Installation The Confirm Task Processor is available as a separate installer It should be installed with administrator privileges on the machine Follow the steps below to install the Task Processor Pitney Bowes 10 of 41 Confirm Task Processor 1 Launch the installation using Run as administrator option from Setup exe from the Task Processor folder 5 Confirm Task Processor msi 3 Datal cab setup exe ness amp Splash omp Run as administrator Troubleshoot compatibility 2 You will see the Confirm Task Processor Installer Welcome Screen Click Next Welcome to the InstallShield Wizard for Confirm Task Processor Confirm The InstallShield R Wizard will install Confirm Task Processor on your computer To continue click Next WARNING This program is protected by copyright law and international treaties 3 The Task Processor uses the configuration file created in Step 1 in the same way as the Confirm Client Enter the path to the configuration file as shown in the screenshot below path filename cfg Click Next Pitney Bowes 11 of 41 Confirm Task Processor Shared Profile Path Please specify the full path to the Confirm shared configuration file or leave blank to retain any existing settings 4 Specify a domain user
39. nter the IP address and port number of your Proxy Server Make sure you use a colon to separate the IP address and port number e lt add key ProxyUserName value gt Enter the username if required for authenticating against your Proxy Server e lt add key ProxyPasswora value gt Enter the password for the username being used in step 3 Pitney Bowes 39 of 41 Confirm Task Processor Folder Permissions When Street Works Transfer attempts to send a Notice it will create an XML file in the Sent or Failed directories see section 3 2 step 5 and 6 In order for this to work you will need to grant the following permissions Grant Full access to the account being used to run the Confirm Task Processor to the Confirm Task Processor directory and all sub directories This will allow the creation of the log file and the generation of the XML Notice files Note If you change the default location of the FailedFiles and SentFiles you will need to make sure you grant full permissions to the directories you have used Oracle Client When using Oracle as the DBMS of choice the Task Processor will need to be able to access the Oracle client drivers in order to connect to the Confirm database by default permission to these drivers is denied Follow the steps below to grant permissions to the Oracle client drivers for the Task Processor e Launch Windows Explorer and navigate to the ORACLE HOME directory this is the pa
40. ntity_modify table and processes each as follows If no map layer record exists and the Confirm entity has coordinates a map layer record is created using the coordinates of the Confirm entity The attributes of the new map layer record are set to those of the Confirm entity If a map layer record already exists its coordinates and attributes are updated to match those of the Confirm entity e When a Feature is deleted or a Street Works is cancelled then the record on the map layer is deleted When a Feature changes Feature Group if the corresponding map layer is now different the Feature is deleted from the previous map layer and inserted onto the new map layer Once a record in the entity_modify table has been processed successfully it is deleted Once 1000 records have been successfully processed for a particular Confirm entity type then the Referential Integrity Agent will move onto the next entity type so it does not delay processing of other entities if there is a large backlog for one particular type Note When processing Features the geometry stored against the Feature is used in preference to coordinate data stored in Confirm if the Use Confirm Database Map Layer option is selected on the Feature Group If no geometry is present and the corresponding feature on the map layer already exists then the centroid coordinate will be used to update the location of the current map feature if it is a point Line and polygon map
41. on process Pitney Bowes 13 of 41 Confirm Task Processor Ready to Install the Program The wizard is ready to begin installation Click Install to begin the installation If you want to review or change any of your installation settings dick Back Click Cancel to exit the wizard 7 Once the installer has completed click Finish to complete the installation The Task Processor service is created and is stopped by default It requires manual configuration before it is started In case of upgrade Start Service Now is available can be checked to start the service immediately InstallShield Wizard Completed Confirm The wizard was interrupted before Confirm Task Processor could be completely installed Your system has not been modified To complete installation at another time please run setup again Click Finish to exit the wizard Once the Task Processor installation is complete Task Processor Configuration needs to be done In case of upgrade no configuration is required Pitney Bowes 14 of 41 Confirm Task Processor Configuration Configuring Provider Logging The Task Processor can be configured to produce provider logging if required To enable follow these steps e Open the registry In the registry go to this location 32 bit Machine HKEY_LOCAL_MACHINE SOFTWARE Pitney Bowes Confirm Task Processor 64 bit Machine HKEY_LOCAL_MACHINE SOFTWARE Wow6432Node
42. pitney bowes Location Intelligence Confirm Confirm Task Processor Version v16 00a AM Information in this document is subject to change without notice and does not represent a commitment on the part of the vendor or its representatives No part of this document may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying without the written permission of Pitney Bowes Inc One Global View Troy New York 12180 8399 2015 Pitney Bowes All rights reserved MapInfo the MapInfo logo and Confirm are trademarks of Pitney Bowes and or its affiliates Corporate Headquarters Phone 518 285 6000 Fax 518 285 6070 Sales 800 327 8627 Government Sales 800 619 2333 Technical Support 518 285 7283 http www pitneybowes com us UK and EMEA Headquarters Phone 1 800 840 0001 Technical Support UK 1 800 840 0001 Technical Support International 44 1634 880141 http www pitneybowes com uk Asia Pacific Headquarters Phone 61 2 9437 6255 Fax 61 2 9439 1773 Technical Support 1 800 648 899 www pitneybowes com au software Contact information for all Pitney Bowes offices is located at http www pitneybowes com uk contact us Products named herein may be trademarks of their respective manufacturers and are hereby recognized Trademarked names are used editorially to the benefit of the trademark owner with no intent to infringe on the trademark Open Source Att
43. processes all configured Financial XML Import and Export trans formations in turn It first checks for any export transformations configured If there are any new Committed Works Orders Variation Orders or Payment Orders due to be exported these are exported to their appropriate export transformation Then a check is made to see if there are any files in any of the import folders configured in the import transformations and if so imports each one in turn Export When a Works Order Variation Order or Payment Order is committed in Confirm this acts as a trigger that the details need to be exported The Agent extracts the information and exports it to the relevant directory and file name specified in the export transformation Export transformations can have a stylesheet applied to regulate the information that is exported to that transformation Import Only one type of import file is received via the agent and this is an authorisation file Contract Orders requiring this authorisation will need to have their lookup configured accordingly see the Configuration section of this agent for more details Once the Contract is setup to require authorisation any Orders that are committed against this Contract will be set to a pending status and will require an authorisation file to be imported When a valid import file is received for the Order it will then be set to a committed status When the import file is received the Contract and
44. r that corresponds to Schema e Repeat above two steps if you have more than one Confirm dataset installed The script is not to be run against SBS schema The screen shot below is an example of how the entries may look like F E C Windows system32 cmd exe xy x Please read the Database Configuration section of Confirm Task Processor BB documentation before executing this script Select your database type 1 for Oracle 2 for Sql Server 2 Create SQL Server Database Script Database Name Ce g MyCompany_Live gt MyDatabase Name Cin UPPERCASE e g CONFIRM or HIGHWAYS etc gt HIGHWAYS fisset Login Name e g confirm or highways etc gt highways have another schema asset you wish to configure y n gt y Name lt in UPPERCASE e g CONFIRM or HIGHWAYS etc gt GROUNDS 7 Asset Login Name e g confirm or highways etc gt grounds have another schema asset you wish to configure Cy n gt n Creation of the script file _Output Database Script sql complete You may now connect to the Database as a DBA and run the script Press any key to continue The batch file will create a sql script named Output Database Script sq in the location where the batch file exists Note For Microsoft SQL Server versions from 2008SP1 to 2008SP3 please contact Pitney Bowes Support for database scripts Step 2 Running the Script e Login into the database with DBA permissions Open script O
45. rName Optional Required only if authentication is needed to access the SMTP Server SmtpUserPassword Optional Required only if authentication is needed to access the SMTP Server SupervisorEmail Set to an email address which will receive emails should there be a problem with the Confirm Task Processor This email address is normally an IT repres entative or principal user whom is responsible for maintaining the Confirm Task Processor UnhandledEmail Set to an email address that will be used to forward any email which is not handled by Task Processor If this setting is left empty Task Processor will not auto forward unhandled emails ForwardEmail Set to an email address where you would like to forward any read by Confirm Task Processor email to e An email address needs to be set for the Task Processor which will be the from address whenever the Task Processor sends an email alert This email address is configured in the Task Processor Settings screen in the Confirm Client Note The Task Processor only supports SMTP for sending mail Pitney Bowes 16 of 41 Confirm Task Processor Folder Access Permissions The Task Processor works in a non interactive mode This means that the user configured for the Task Processor service needs to have read write permissions to all folders where the Task Processor will need to read data from or write data to If such a folder resides on the machine where Task Pro cessor is installed
46. re to enable the SQL Server Agent in Micosoft SQL Server 2012 di Microsoft SQL Server 2012 Download Microsoft SQL Server Cor 4 Import and Export Data 32 bit 4 Import and Export Data 64 bit aa Sq Server Configuration Manager 00 SQL Server Data Tools leu Action x etn Help Alo a 8 Sa SQL Server Management Studio d Analysis Services d Configuration Tools SQL Server Integration De Reporting Services Configuratior fa SQL Server Configuration Manac SQL Server Error and Usage Repo B SQL Server Browser nning ie NT AUTHORITY LO 11700 BH SQL Server Installation Center 6 Hid SQL Server Agent MSSQLSERVER Running Automatic NT Service SQUSERV _ 16392 SQL Agent d Data Quality Services d Documentation amp Community Jy Integration Services t Master Data Services d Performance Tools Pitney Bowes 7 of 41 Confirm Task Processor Step 1 Creating the Script Copy the Task Processor Database Configuration folder to the local drive from Resources folder within Confirm media Ensure following files exist in the same folder 1 Create Database Script bat 2 MSSQL File1 txt 3 MSSQL File2 txt 4 MSSQL File3 txt e Launch Create Database Script bat batch file Enter 2 when prompted for type of database Enter Confirm Database name when prompted Enter Schema Name in Uppercase Each dataset of Confirm corresponds to a Schema in the data base Enter Schema Login Name schema asset owne
47. ribution Notice The Confirm suite of products contain the following open source software e Feature Data Objects v 3 5 0 which is licensed under GNU Lesser General Public License Version 2 1 February 1999 with the unRAR restriction The license can be downloaded from http fdo os geo org licenceAndGovernance html The source code for this software is available from ht tp fdo osgeo org content fdo 350 downloads e MrSID software specifically the mrsid32 dll is used under license and is Copyright 1995 2002 LizardTech Inc 1008 Western Ave Suite 200 Seattle WA 98104 All rights reserved MrSID is protected by U S Patent No 5 710 835 Foreign patents are pending Unauthorized use or duplication prohibited Patented technology in the Software was developed in part through a project at the Los Alamos National Laboratory funded by the U S Government and managed by the University of California The U S Government has reserved rights in the technology including a non exclusive nontransfer able irrevocable paid up license to practice or have practiced throughout the world for or on behalf of the United States inventions covered by the patent and has other rights under 35 U S C 200 212 and applicable implementing regulations For further information contact Lizardtech NodaTime version number 1 3 10 which is licensed under the Apache license version number 2 0 The license can be downloaded from http www apache org l
48. s how to configure the Enquiry Fixed Penalty Delivery 1 Ensure the Enquiry Fixed Penalty Delivery is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 2 Ensure the FPN Email settings have been specified in the Penalty System Settings screen 3 Ensure the Task Processor has been installed and configured with email settings specified in the task processor configuration file see below FPN Email Settings The following settings define the structure and contents of FPN emails and any error emails that are generated Update TaskProcessorService exe config file located in the Confirm Task Processor installed directory e g C Program Files Pitney Bowes Confirm Task Processor Note For all of the below steps ensure that you change the entry within quotes in the value e lt add key SMTPHostlPAddress value 127 0 0 1 gt Set to the IP Address of your SMTP server e lt add key SMTPHostPort value 25 gt Set to the port number your SMTP server is running on Financial Interface XML Agent Overview This Agent is used to import authorisation on pending Orders from an external financial system It can also be used to export the following to external financial systems in XML format e Pending Order details Committed Order details Committed Variation details e Committed Payment details Pitney Bowes 26 of 41 Confirm Task Processor Operation On each scheduled run the Agent
49. s needs to be done for each database Configuring Email Alerts The Confirm Task Processor requires the use of an email account to send alert emails Email alerts regarding specific agent tasks can be sent to an email address set up in the Scheduled Tasks screen for that agent If no agent tasks have been configured to send email alerts the default email behaviour will be used to alert the System Supervisor the individual responsible for maintaining the Confirm Task Processor if there is a problem with the Confirm Task Processor itself To set up email alerts follow these steps e Open the registry e Back the existing registry settings In the registry go to this location 32 bit Machine HKEY_LOCAL_MACHINE SOFTWARE Pitney Bowes Confirm Task Processor 64 bit Machine HKEY_LOCAL_MACHINE SOFTWARE Wow6432Node Pitney Bowes Confirm Task Processor Add values to the following registry keys Registry Key Description MailRequired This option toggles email on or off To be set as Yes if mailing is required Note All the following settings in this table are mandatory if MailRequired is set to Yes SmtpServer Set to either the mail server name or IP address To connect the Confirm Task Processor to an SMTP server which is running on a non standard port number 25 then append portnumber to the server name IP address SmtpDomain Optional Required only if authentication is needed to access the SMTP Server SmtpUse
50. selected email address when the following scenarios occur Connection to database is lost or unavailable e When 3 failed attempts of the same notice have occurred To enable emails make the following changes Description Location SmtpServer Set to either the mail server name or In the registry IP address To connect the Confirm 2 bit Machine Task Processor to an SMTP server 32 bit Machine which is running on a non standard HKEY_LOCAL_MACHINE SOFT port number 25 then append port WARE Pitney Bowes Confirm Task number to the server name IP ad Processor dress e 64 bit Machine HKEY LOCAL MACHINE SOFT WARE Wow6432Node Pitney Bowes Confirm Task Processor Pitney Bowes 38 of 41 Confirm Task Processor Setting Description Location From Name Set to the name you wish the email to Refer to Task Processor Settings come from From Address Set to the email address to be used to Refer to Task Processor Settings send emails Supervisor Email Set to the email address to be used to Refer to Supervisor Email within receive emails Scheduled Task Screen FPN Email Settings The following settings define the structure and contents of FPN emails and any error emails that are generated e Update TaskProcessorService exe config file located in the Confirm Task Processor installed directory e g C Program Files Pitney Bowes Confirm Task Processor Note For all of the below steps ensure that you chan
51. th where the Oracle client has been installed Right click on the ORACLE HOME folder and choose the Properties option from the drop down list Click on the Security tab of the Properties window e Click Authenticated Users item in the Name list on Windows XP the Name list is called Group or User Names e Uncheck the Read and Execute box in the Permissions list called Permissions for Authenticated Users e Re check the Read and Execute box under the Allow column this is the box you have just un checked e Click the advanced button and in the Permissions Entries list make sure you see the Authenticated Users listed there with e Permission Read amp Execute Apply To This folder subfolders and files If this is not the case edit that line and make sure the Apply onto drop down is set to This folder subfolders and files This should already be set properly but it is important you verify this e Click the Ok button until you close out all of the security properties windows It has been known for the above process not to fix the problem if you encounter this situation then follow the steps below e Use Windows explorer and navigate to the Oracle home directory right click then select properties select the security tab Tick allow inheritable permissions from parent to propagate to this object Click copy
52. the Agent has not been able to run for some time Export Restrictions The following can restrict or prevent Enquiry information being exported The Export flag on Enquiry Subject should be checked The configured Confirm users data security access to the Enquiry Subject Enquiry information will not be exported to the same external system that the Enquiry or update ori ginated from Configuration This section details how to configure the CRM Agent 1 Check that the CRM Agent Module 1437 is enabled 2 Ensure that the agent is scheduled as a Task in the Scheduled Tasks screen within the Confirm client 3 Configure the details of the Web Service that will receive the exported Enquiry information This is achieved via the CRM Agent System Settings screen 4 Ensure that the configured Web Service is configured and running 5 Ensure the Task Processor is configured and running Pitney Bowes 25 of 41 Confirm Task Processor Enquiry FPN Delivery Overview Enquiry FPN Delivery is a Scheduled Task that is responsible for sending Fixed Penalty Notices for Enquiries via email to their recipients Operation The Enquiry FPN Delivery schedule will attempt to send FPN s via email to the specified email address Penalties will only be sent once if this fails then they will be reset to a Valid status This allows the correction of email addresses should they have been entered incorrectly Configuration This section detail
53. ty Map Layer The layer must contain one of these primary columns e Central Asset Id Char 20 e Asset Id Char 15 Pitney Bowes 31 of 41 Confirm Task Processor The layer may also contain the following optional columns These attributes of the map layer record will be updated if present Confirm columns can relate to different map column names depending on the flavour of Confirm being used and the layer s mapping technology Below are the map column names that Referential Integrity can update e Site Code Char 10 e Site Name Street Name Road Name Building Name Char 40 e Plot Number Plot No Asset Number Sequence Number Feature Number Section Number Decimal 10 2 e Feature Id Asset Id Tag Number Road Number Label Char 15 e Feature Type Char 4 populated with the Feature Type Code e Feature Type Name Type Species Carriageway Type Char 30 e Feature Group Code Feature Gp Char 4 e Feature Location Location Tree Location Feature Location Section Location Char 254 Primary Measure Prim_Meas Decimal 10 2 e Unit Of Measure unit Char 15 e Layer Char 50 e Start Date Date Time e End Date Date Time e Centroid_Easting Decimal 10 2 e Centroid_Northing Decimal 10 2 Extent_Easting_1 Decimal 10 2 e Extent_Northing_1 Decimal 10 2 e Extent_Easting_2 Decimal 10 2 e Extent_Northing_2 Decimal 10 2 Asset Id is only populated with the Feature Id column from Con
54. utput Database Script sql Run the script In case more than one connections are open you ll get the following error Detected existing connections Ensure all other connections are dropped before executing this script To re solve close all existing connections and run the script again e Logout from the database The scripts will create following jobs which needs to be enabled from within the database e job_TaskMaintenance_ lt Database Name gt _ lt SCHEMA NAME gt e job_TaskScheduler_ lt Database Name gt _ lt SCHEMA NAME gt Pitney Bowes 8 of 41 Confirm Task Processor The screen shot below is a sample representation of the entities created by the MSSQL Script wh ema i L Server Agent Gy Database Diagrams a SQ g Tables CH Jobs Gy Views aq job_TaskMaintenance_DemoDB_GROUNDS i Synonyms job_TaskMaintenance_DemoDB_HIGHWAYS awe as i job_TaskScheduler_DemoDB_GROUNDS gt job_TaskScheduler_DemoDB_HIGHWAYS rs Types ca ig System Message Types Contracts Gy System Contracts lt contract_CriticalXml EJ contract_HighXml E contract_LowXml contract_NormalXml G Queues fil System Queues 15 dbo QUEVE_SCHEDULEDTASKSINITIATOR 1 grounds QUEUE_SCHEDULEDTASKS J highways QUEUE_SCHEDULEDTASKS 5 Gey Services A System Services sve_ScheduledTaskslnitiator svc_ScheduledTasksTarget_GROUNDS Pa svc_ScheduledTasksTarget_ HIGHWAYS Ca Routes fil Remote Service Binding O Broker Priorit
55. y matching the specified mask and will attempt to import each one in turn The files are processed in date created order from the oldest to the most recent Before being imported the file may be transformed to the format Import Anything expects The trans formation to be carried out is determined by the File Pre processing Format specified on the Import Transformation record as follows e None the file is already in Import Anything format as defined in the specification e XML the file is an XML file and a Stylesheet will be used to transform it to Import Anything format Others the file is in a delimited text format which will be pre processed to XML and then a Stylesheet applied Once transformed data will be loaded into memory from the file and then validation will be applied depending on the type of data being loaded This includes ensuring required Modules are present all mandatory fields have been supplied referenced lookup values exist duplicates are not being created etc If the validation is successful data will be saved to the database and the import file moved to a Read subfolder within the Input Directory In the event of any warning messages being generated for example descriptive data being truncated to fit a field a corresponding err file will be created in the same loc ation If the validation is not successful the import file will be moved to an Invalid subfolder within the Input

Confirm Task Processor - Reference.mapinfo.com

Contents

Download Pdf Manuals

Related Search

Related Contents