- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by ruben.maas

35 Replies

Newest first

Oldest first

venkateshDo Gooder (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

PSO Staging logic inbound issue

Hi @venkatesh \ @SAMLK , The schema of the i_xml table is not valid. This i_xml table you have in your environment has probably been installed in earlier version and does NOT have all fields available to support the staging logic. the inbound staging table should match the following schema (SQL Server):CREATE TABLE [dbo].[i_xml_pso]( [message_id] [nvarchar] (64) NOT NULL, [message_name] [nvarchar] (128) NULL, [message_operation] [nvarchar] (16) NULL, [message_priority] [numeric](28, 10) NULL, [message_reference] [nvarchar] (128) NULL, [message_response] [nvarchar] (MAX) NULL, [message_response_code] [numeric](28, 10) NULL, [message_status] [nvarchar] (32) NULL, [message_type] [nvarchar] (128) NULL, [message_xml] [nvarchar] (128) NULL, [modified_by] [nvarchar] (32) NULL, [modified_dttm] [datetime] NULL, [node] [nvarchar] (256) NULL, [not_after_dttm] [datetime] NULL, [not_before_dttm] [datetime] NULL, [problem_desc] [nvar

AWLFSidekick (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Automatic e-mail notice to place contact - Scheduling freeze PSO

Hi @AWLF , Yes this is possible.Although there are different options available please use steps below:1. verify what the task committed status is by getting the value for Scheduling App Params (threesixty_app_params) where param name is "COMMITTED_TASK_STATUS". by default the committed task status = "COMMITTED".2. ensure a task_event is created when status of task is changed to "COMMITTED". use business rule Process "03" - TASK_EVENT_GEN for this.3. Create substitution map (From menu choose Admin-->Notifications-->Substitution Map) to resolve the place.email from TASK_EVENT.4. Setup distribution list which uses the substitution map as wild card member5. Setup notification message.6. create notification rule when task_event for COMMITTED is created. use business rule process "08" - TASK_EVENT_NOTIFY use distribution list defined in step #4 user notification message defined in step #5 Hope this helps. Cheers, Ruben

KavindiGunasingheDo Gooder (Employee)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

DistributedTransactionSettings Function

Hi @KavindiGunasinghe , This segment in the web.config is used to configure the database transaction, which are utilized by FSM Application server. The only setting in this segment is “TransactionTimeout”:Maximum transaction time allowed before forcing timeout and abort transaction, specified in seconds (default 300 seconds = 5 minutes). Cheers, Ruben

seedaDo Gooder

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Roll back Array of tasks

Hi @Saranga Amaraweera \ @seeda ,Using an XML map all primary records are processed sequential independently, we can’t change that behavior with configuration. so if TASK is the primary table of the XML map it is not possible to rollback all tasks in case of an exception. The only way to accomplish this requirement is to change the primary table of the XML to a parent object, e.g. REQUEST and process the associated tasks as child transactions. That way, if one task failed to update the other related to the same parent object (REUQEST) will be rolledback. Cheers, Ruben

KiththaSidekick (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Use third party java script bundle in FSM WebClient page/pages

Hi @Kiththa, Unfortunately, you cannot include JavaScript files to the FSM web client, not without changing the core \ baseline at least. Alternatively, to perform address lookups against external services from the web client would in my view only be possible through the FSM App Server. To accomplish this you could develop a custom MPM in FSM, which will perform the address lookup and return collection of rows. This MPM can be invoked by client script from web client. The user experience will likely be different comparing the pre-bundled drop script you’ve been referring too but these are the options available in the FSM web client. Cheers, Ruben

seedaDo Gooder

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Proxy Configuration

Hi @seeda , for setting default proxy server in web.config please see MSDN article below: https://docs.microsoft.com/en-us/dotnet/framework/network-programming/proxy-configuration for changing the application pool identity, see article below:https://docs.microsoft.com/en-us/iis/manage/configuring-security/application-pool-identities Hope that helps :) Ruben

CKOppBoxHero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM : UI Designer : Child Relation Editor

Hi @CKOppBox , Child relations \ join constraints must be based on columns sharing the same data type. In your case I would recommend to create \ setup a custom view which takes responsibility of the casting so you can join it on the task screen accordingly. Cheers, Ruben

Hasara DinuHero (Employee)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

SFTP support for integration

Hi @Hasara Dinu , No the baseline FTPExtractHandler does not support SFTP unfortunately. Best Regards, Ruben

TatSrikaDDo Gooder (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM : Unrecognized Business Object 'Integration Routing Rule' and 'Integration references'

Hi @TatSrikaD , I would start with checking the following: is FSM Connect installed and does it reflect the correct version in relation to FSM baseline server. Login the FSM Smart Client, open the “About” window and click on details: Check if FSM baseline meta data exists for table CUST_INT_ROUTING_RULE. Login FSM Smart Client as studio user and open FSM Meta Data screen and search for table “CUST_INT_ROUTING_RULE”. Check if there is any custom meta data defined for table CUST_INT_ROUTING_RULE. if exists ensure there’s no value defined in field Table Namespace. Best Regards, Ruben

seedaDo Gooder

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Proxy Configuration

Hi @seeda , Proxy settings cannot be specified for appropriate extract specifically. Though, default proxy settings can be specified in the web.config.As far as I am aware of you cannot specify credentials unless a code change \ implementation is made. I would recommend to ensure the application pool identity, under which the FSM Application Server is hosted, is authorized to access the proxy server. It will use the default credentials of the application pool identity to authenticate to the proxy server eventually. Best Regards, Ruben

seedaDo Gooder

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Capture response Metrix 5 XML

Hi @seeda , You can use the Process Result Mapping to map the result to the respective record. For fetching the task_id the easiest solution is to use xpath “//task_id”, this will just return the value of the first <task_id> element in the xml response. But what is it what you want to accomplish exactly?hence, a create_task will only initialize a new task_id, it won’t actually create the task record for you. Thanks, Ruben

Kelum Pradeep KumaraSuperhero (Employee)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM - continuously inserting records in to mm_message_out table

Hi @Kelum Niranjana , yes the mm_message_out will basically act as the message queue for data that need to be pushed to the mobile devices. information stored in this table is based on FSM Sync Rules in combination with FSM Extracts. I would start with checking the mm_message_out.table_name and possibly mm_message_out.message and check if these messages are legit.If not, you may need to redefine the FSM Extract conditions and or FSM sync rule. Best Regards, Ruben

TatKhandMSidekick

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

what is the use of mx_u table in FSM?

In my opinion we should at least have a setting or parameter available that allows us to disable the generation of MX_U records. The data generated in an high volume production environment can be enormous. Yes we can truncate the data in MX_U, but we should ask ourselves whether this data is really needed and how often has it been used for analysis before? In case there are a lot of records in the MX_U table calling perform_analyze_usage can cause a significant performance issue. This is because the analyze usage selects all data in memory dataset.

TaTSouraDSidekick (Partner)

asked in Service (Touch Apps, MWO, MRO)

Updating a field value to SYSDATE by XML business rule

Hi @TaTSouraD , In addition, an expression can also be used using the @expression[] substitution. for example: <update_request_event> <request_event> <request_id>@request_id</request_id> <sequence /> <event_type>MANUAL</event_type> <user_def_dttm1>@expression[Now()]</user_def_dttm1> <insert_update is_initialized="False" /> </request_event></update_request_event> -Ruben

ERCESEGSILDo Gooder (Customer)

asked in Service (Touch Apps, MWO, MRO)

Error while connecting with external interface

Hi @ERCESEGSIL , The FSM Gateway is a custom web service provided for Ericsson.Based on the error it looks like it did not got deployed entirely in the appropriate environment. For this service to run the following files must exists:[APP_ROOT]\App_Code\FSMGateway.cs[APP_ROOT]\MetrixIntegrationService\FSMGateway.asmx These files can be taken from harvest or from the in-house ericsson environment. Ruben

Ann DegroatHero (Employee)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Parameter count mismatch

Hi @andeus , I have not experienced similar error before, my suspicion is it is an error caused by .NET reflection. So I expect this is caused at FSM Client side. Can you check whether this is a client error or server error? The easiest way to find out is by clicking on the little “Details” button of the error dialog. if there’s an XML request \ response we know it’s an server error, in that case we can set the server log EX to 9 to get the stacktrace. this could indicate from where this error is raised. If the error details shows no xml request \ repsonse, but an error stacktrace instead, we know this error is raised at FSM client side. please share the error details \ stacktrace in that case. if it’s a FSM client error, check if any client customizations are applied.if so, re-test with the client customizations de-activated. Ruben

mmathiasSidekick (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM 6u6 - Part Needs Duplicating

Hi @mmathias , it’s difficult to pinpoint what exactly causes the error you’re experiencing. Probably best would be to look at the baseline view replenish_stock_bin_view and see if this is returning the wrong quantities based on certain data. -Ruben

pravinl.patelDo Gooder (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Multiple application Installation on Same Server

Hi @pravinl.patel , You can install multiple FSM instances on a single server.You can find the hardware sizing recommendation of both products in the installation guide, in the pre requisites chapter. ruben

JMouraDo Gooder (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM 6 - Upload to SFTP Server

Hi @JMoura , Yes you are absolutely correct.The key here is to place the attachments, which needs to be upoaded to sftp folder, in an separate folder.This can be done using Business Process 81 I expect. The rest can be configured outside FSM.-Ruben

JMouraDo Gooder (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM 6 - Upload to SFTP Server

Hi @JMoura , This cannot be done easily through configuration. Yes, FSM can extract data in XML,JSON or CSV. but extracting an attachment is unfortunately not supported through configuration. (with custom code this can be done off course). Besides, for sFTP we rely on third-party software nevertheless.For FSM on-premise the sFTP upload is done by WinSCP component, however this is not supported in the cloud though. I would recommend to implement such requirement outside FSM. You can use Business Rule Process “81” - Attachment Directory, to set the attachment folder for certain type of attachments.Then use an external solution e.g. WinSCP (but there should be plenty of others i think) to automatically upload the file from the FSM Attachment folder to the sftp server.https://winscp.net/eng/docs/guide_automation hope that helps, Ruben

nickzSuperhero (Employee)

asked in Service (Touch Apps, MWO, MRO)

UI Differing behaviour between Web and Smart client?

Hi @nickz , I think the way to accomplish this is by Quick Search. In the UI Designer, you can define multiple quick search groups.So you would have to create a quick search group which includes the price type default constraint, then you make that the default \ initial search. Have not tried it myself :) but should work i think. Let me know if that helps. Cheers, Ruben

YonathaDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Query Element Parens

Hi @Yonatha , See example below:<hierarchy_select> <primary_table>request</primary_table> <attrs> <attr>request.request_id</attr> <attr>request.req_status</attr> </attrs> <from> <table>request</table> </from> <where> <data_constraint> <parens> <constraint> <left_operand>request.status</left_operand> <operator>eq</operator> <right_operand>HO</right_operand> </constraint> <or /> <constraint> <left_operand>request.status</left_operand> <operator>eq</operator> <right_operand>CA</right_operand> </constraint> </parens> </data_constraint> </where></hierarchy_select> -Ruben

TatKhandMSidekick

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

In FSM , which type of encryption logic is used for password at client UI Level

Hi @TatKhandM , If you want to authorize messages as part of a volume \ performance test you can provide the person_id and password unencrypted in the authentication <perform_login> <authentication> <logon_info> <person_id>RUMANL</person_id> <password>PASSWORDUNENCRYPTED</password> <ignore_password_expiry_check>true</ignore_password_expiry_check> </logon_info> </authentication></perform_login> You don’t necessarily have to create a session though. you can also add the authentication block to the individual transactions (unencrypted ) like this:<hierarchy_select> <authentication> <logon_info> <person_id>RUMANL</person_id> <password>PASSWORDUNENCRYPTED</password> </logon_info> </authentication> <primary_table>request</primary_table> <attrs> <attr>request.*</attr> </attrs> <from

TatKhandMSidekick

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

In FSM , which type of encryption logic is used for password at client UI Level

Hi @TatKhandM , Passwords as well as Application parameters are encrypted at FSM server side. What is the requirement? Thank you, Ruben

AngeloPavDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM Mobile (Android) will not initialise (database not found)

HI @AngeloPav , Normally the User Access Control settings should be set by the mobile service installer. But you can check whether the correct access control settings are used by opening the download folder properties from windows file explorer. Make sure the folder is not marked as read-only and the local IIS_IUSRS has read and write access to the download folder. Hope this helps. -ruben

1
2

Page 1 / 2

Badges

André Silvahas earned the badge 1st Topic
FLEhas earned the badge 1st Topic
rajkumarhas earned the badge 1st Topic
BytAlberGhas earned the badge 10th Reply
Claire Valentinehas earned the badge 10th Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK