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

Hello I am new to supporting servers with IFS installed and wanted to know if it is ok to install SQL updates regularly on the database server that hosts the IFS database? 

Hi everyone, Related to FSM 6 UPD10, we realized that the REQUEST syncrule (Initial query) is mentioning two database views (‘task_assigment_view2’ and ‘task1_view’) that seems does not exist. If I query for the related views  I get the next error: Please, see attached document with the XML SYNCRULE. Can someone help me on this?Thanks and regards,

Hi all,another question regarding MX_U table, if FSM application is in IFS managed service, who maintains the MX_U table for deleting the old records?  As this table can be very big and the usage of old history might not be necessary anymore. If it’s customer’s responsibility to maintain it, can you describe steps to check and do it? Thanks again,~Juni

We have built a custom table and want the same on our mobile application. So we built a sync rule and were able to send data successfully from the mobile app to the back office application. However, whenever we are making any changes on the back office application, the same was not reflecting on the mobile app in real time. We were able to send the changed data through Batch Delta and Batch All methods. How can we have real time sync for a custom table?

Hi Experts,As you may know, several regions use the comma as their decimal separator in numerics. This change is accommodated in FSM web client when the regional settings have been modified. However, this is not the case for FSM mobile. Despite changing the regional settings in the mobile devise, the comma is not accepted as the default decimal separator. Is there a known fix for this? Thank you! 

Hi everyone ! We discovered that IFS accounts regulrarly log into our environement.Someone know the purpose of this user accounts : IFS_Mobile  IFS_Monitor IFS_PORTAL IFS_SCREEN_MERGE IFS_INTEGRATION_MONITORThanks you for your help, Best regards

Hi Team,We are greeting error as data member specified by req_status can not be found once we change task status to closed.I checked any BR or client scripts triggering but no BR or client script we wrote for request status.Please find below screenshot for error details. Please suggest how to solve this issue Regards,Ramya

Is there any way to restrict the selection of Task Statuses based upon the Task Type? We need this becuase certain types of tasks should only have certain statuses

Dear Experts, Can anybody help me to achieve this requirement hiding the dropdown value in tab level.Requirement: Hiding the Urgency Status dropdown in part need tab based on task type.For example: If task type = “XYZ” then part need Urgency status should have value “ABC1” , “ABC2”If task type = “MNO” then part need Urgency status should have value “GHI1” , “GHI2”. Any suggestions is appreciated.Note: Used Client script array its working fine for task or header level, need suggestion for part need or tab/line level. Thanks in advance.Kaustav.

what is the use of mx_u table in FSM?mx_u table is writing 1.5 million records daily and it is causing my table space to get filled. what is the use of this table. 

Hi,we have gathered some data from MX_U table.  But I come across to a question how to interpret some data shown. On this captured screen data of Feb. 02, 2022, at around 1 am.mx_u_01, mx_u_02 fields showed something related to mobile app.But user doesn’t have mobile device installed.The question is because: time was wee morning, user didn’t do any work, and user doesn’t have mobile device installed.And a lot of same processes.  From this data shown, what does this data mean? MX_U table no mobile device for the user Look forward to your enlightenment. :-) Cheers,~Juni

Good day Creation and management of rosters will move from FSM to PSO in my situation. Creating exclusions on a resource on the roster in PSO reflects on the PSO schedule board. As the FSM schedule board will still be used to manage some tasks, is there a way to have the exclusions created in PSO display on FSM schedule board? Regards,Hannes

We would like to visualize project milestones on the schedule board. Is there a baseline functionality to manage milestones in FSM?A workaround would be:Use milestones in ‘place view’ of the schedule board. In place view projects can be shown as they, in our case, relate to places. We created a dummy 'milestone-technician' (and Team) and used different task types for the specific differentiation of milestones themselves. Therefore the workaround isCreate Technician and Team MLSTN Create different milestone task types As said, this is just a workaround and we would like to know if there is something more project related available.Thanks in advance and regards,Thomas

Dear All, I am facing an issue in schedule board. I have a team having 15 members. And out of 15members 10 are resource. In schedule board it should come 10 resource but I can see more than 10. Those extra members coming from this 15 members list only. Can anyone tell me what might be the reason?Is there any wrong configuration happened. Thanks & Regards,Rajat

Hello community, In our understanding it is possible to expand Global Search to include more tables, by configuring the roles. However, is it possible to expand Global Search to include more fields such as user_defs and custom fields?Thanks!!Kind Regards

Hi Experts,Somewhat of a trivial question. When writing an expression for business rule based on a field update, how do we refer to the old value of the field?ex: if the task.user_def1 is updated and I want a validation as followingtask.user_def1(new) - task.user_def1(old) > some dynamic value (from a joined view)then trigger error messageHow do we write this? 

Is it possible to change the Duration of task from minute to daysi found the app param “ENABLE_TASK_DURATION_IN_DAYS” I tried using this. but it still remains same as minutes

Hi,I understood that in PSO the resources and activities can have one or more regions (to be used in different optimization parameters, like creating hard boundaries with within region multiplier, or the out of region multiplier, etc.). But it is not clear to me exactly which fields in FSM (when the tasks are create in FSM first) are mapped with these two objects in PSO (Resource & Activity), regarding the Regions. Also I will like to understand if the activity multi-regions in PSO is supported by IFS FSM, or only one region per task can be set and sync to the PSO activity. Thanks, Regards,Fernando

Dear allIn a customer’s Mobile environment we have found, that datetime fields are no exposed visible on the screen, although they are available on the database. I thought the time zone was picked up by the client itself, but don’t know how to solve this. There has to be a solution obviously, as that error does not appear on different customer’s environment: 03/02/2022 06:42:45|ERROR|ConvertDateTimeFromUIToDB|2|EXCEPTION: Argument_TimeZoneNotFound. For more information, visit http://go.microsoft.com/fwlink/?LinkId=623485 ...    at SharedLibrary!<BaseAddress>+0x61e844   at IFS.FSMW.Architecture.Utilities.MetrixDateTimeHelper.ConvertDateToOppositeTimezone(DateTime dateValue, Boolean isDBToUI) App Params, Client Scripts, Sync Rules have been aligned and match between both environments. Mobile app version is identical too. Job List - Plan Start Dttm is missingDebrief overview - Plan Start Dttm is missingDB - Plan Start Dttm available Any hints on how this can be solved?Please find at

Hi All,Can someone suggest me how to extend the field length of Existing FSM Metadata ?I want to extend the field length of TASK_TEMPLATE_ID which is of 32 characters to 100 characters.A quick response will be much appreciated. Thanks,Deepak Kumar

Hi! We’re seeing alot of these errors on our newly updated environment: “EXCEPTION Message: Følgende systemnivå unntak ble generert av programmet: Cannot create a Key when the same column is listed more than once: 'task_id'Kontakt systemadministratoren for å få hjelp. Serverlogg eller hendelsesloggen kan inneholde flere detaljer om feilen. ... Stack Trace:    at Metrix.Global.Exceptions.ExceptionManager.HandleException(Exception e)   at Metrix.BusinessServer.BusinessPolicyInterface.SelectBuilder.ProcessSelectRequest(XmlElement root, UserSession session, Dictionary`2 attachments, Boolean checkForSqlInjection, Boolean bypassTableAccessCheck, Boolean& responseIsException)   at Metrix.BusinessServer.BusinessPolicyInterface.SelectBuilder.ProcessSelectRequest(XmlElement root, UserSession session, Dictionary`2 attachments, Boolean checkForSqlInjection)   at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.ResolveRelationInfoQuery(XElement message, String tableNam

Hi,Whenever we ran the AWR report for the database server . The following below query always appear in the report on daily basis consuming more than 99% cpu on the database server .insert into MX_U_S (MX_U_S_01, MX_U_S_02, MX_U_S_03, TOTAL, CREATED_DTTM) select MX_U_01, MX_U_02, MX_U_03, count(1), sysdate from MX_U where (MX_U_06 = 'START' or MX_U_06 is null) and (created_dttm is null or created_dttm <= to_date('2022-01-05T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS')) group by MX_U_01, MX_U_02, MX_U_03 DELETE FROM MX_U where (created_dttm is null or created_dttm <= to_date('2021-10-13T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS'))Need you support on to reduce the utilization of the above query on the database server?  

Hi All,Can anyone explain the significance of TIME HORIZON parameter & TIME BEFORE SHIFT START wrt commitment with an example?Regards,Srikant

Hi,FSM user with SSO enabled and PSO System user not appearing in the PSO Application  users screen. ?Administration---->UsersNeed inputs regarding the above query  

Dear Experts,Customer is blocked from attaching Mobile attachments due to its cyber security (F5 level). Can anyone advice me on the File attachment parameters on clearing this blocking issue so that the customer can update their WAF policy?As the customer provided the error messages due to blocking of the attachments are as follows,