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

Is it possible to create partition on FSM table Task, Request?Will FSM support partitioning table  like (Task, Request ,etc)

Hi Team, We are unable to complete upgrade for FSM 6.15 from 6.6 version.Please advise how to proceed with the installation. Error occurred while generating custom index script!Exception Type: System.Management.Automation.CommandNotFoundExceptionException Message: The term 'sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.Check upgradeStatus.log or recreateCustomIndexes.log for more details. Regards,Jithesh

What determines which tables I can add fields from for a mobile screen?For Example:  I’d like to add a field from the Part table to the job list screen, but part is not a table I can add fields from on that screen.  My choices are Address, Contact, Place, Product, Request and Task.I should be able to link to the part table from the product table with Product.Part_ID = Part.Part_ID Thanks.

Hi Team,Can you please assist in how we can achieve the Contract Non Part Price Agreement for specific place be used in the Quote Pricing.Tried defining the NonPart Price Agreement definition using the place ID (in the Contract Lines), but the same wasnt considered while the Quote pricing was performed.

Hi Experts,I am finding it difficult when selecting a different printing clients (pdf., server, report viewer) The output sometimes is different than I expected.I checked changing the following values.       1. Changing the value of App param ENABLE_SERVER_SIDE_CLIENT_REPORT_PROCESSINGChanging the value of “Output Type” of reports admin screen.  Printing the report from the reports screen or the respective screen.Can anyone explain to me the reason for the highlighted results. Also, Can anyone advise me if there is another way to affect the output client of a print report?Thank you,Charith Rajapaksha,

Hi team ,  Can Anyone tell me, How to Sync the Alias Table in  Mobile , Like I Have created a part need alias in FSM Smart Client (part_need_alias) . I am trying to sync the same table in mobile by creating a sync rule for part_need_alias , but I did not find any data in mobile . When tried to execute the SQL query for part_need_alias I found table or view does not exists . Please suggest.ThanksMuthujayashree R

Good Afternoon,I am trying to gauge our opportunities for using automatic Task assignment through the Work Delegation capabilities. we are on FSM 6u6 / in progress of updating to 6u15. I have a decent understanding of How FSM does what FSM does.  Through the “WORK_DEL*” app params and using Business Process 04 (Work Assignment) My questionsI can get the system to auto-assign the nearest/available tech.. but I can’t seem to figure out how to define a Start/End datetime window in which to assign resources.  Does anyone use FSM Auto Work Assignments without PSO? I would love to connect with anyone who does..Sincerely,-Rudy​​

Hi,We have an issue when initializing the mobile app. The initialization starts, however, the flatfile db, which should be created on the mobile server, is not created. We also gets this error message. Any suggestions to what could be wrong?:EXCEPTION Message: SQL logic errortable mm_keys already exists ... Stack Trace: at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)at System.Data.SQLite.SQLiteCommand.BuildNextCommand()at System.Data.SQLite.SQLiteDataReader.NextResult()at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.CreateSQLiteSystemSchema(SQLiteConnection theSQLiteDB, StringBuilder& theDelayedSchemaStringBuilder)at Metrix.B

Hi Team,How to pass the logged users in the report as input parameters?  

Trying to install IFS 6 U 16 to our Deve environment, get the same issue locally on my own PC as well. Have set up Powershell 7.2 and .Net Framework is correct at 4.8 as well but am getting “Invoke-SqlCmd’ is not recognised as the name of cmdlet etc.What am I doing wrong ? Also on all these updates, when running it, why do I get a message that says “Start: The System cannot find the file specified” when I select Deploy FSM Components on-premise, it appears three times and I hit ok, doesnt fill me with confidence.  

Looking for Reference Communication for employee awareness related to IFS FSM implementation.

What is the minimum version of TLS can that can be used between FSM Mobile service and FSM service (FSM6)?

According to a requirement in which we need to fetch SubTeam ID from table TEAM using some field values from REQUEST,PART,ADDRESS tables. This SubTeam ID then should be reflected in one of the REQUEST fields.We have written the sql query to find the particular result and also its corresponding XML that will be used in the XML Business Rule. SQL QUERY →select subteam.team_id from request, place, place_address, address, team, subteam, part, request_unitwhere 1 = 1and request.place_id = place.place_idand request.request_id = request_unit.request_idand request_unit.part_id=part.part_idand place.place_id = place_address.place_idand place_address.address_id = address.address_idand address.city = team.team_idand team.team_id = subteam.parent_team_idand subteam.user_def10=part.part_typeand subteam.user_def11=request.req_typeand subteam.user_def12= '0'and request.request_id = '853' XML →<hierarchy_select><attrs><attr>subteam.team_id</attr></attrs><primary_table&

Hi, I’m trying to check if there is a way to export/print the FSM metadata. I receive this print, but I don’t know how it was created.I need something similar to share with a client BI teamCould someone help me on this?  Thanks, Best Regards,Fernando

Hi Experts, Every 10 minutes a set of exceptions is being logged in the Server Log. This is happening in both Prod and Test environment and not in conjunction with any of our scheduled processes.No test plan for this, exceptions are being thrown every 10 minutes in all the client environments.No impact to any of the users as well because of this exceptions as well.We couldn’t find the root cause for this exceptions. A snippet of server log retrieved with maximum levels is given below,Timestamp: 2022-03-24T09:46:23.5209896-04:00Message: Exception Message : The following system level exception was generated by the application: There is no row at position 0.Contact your system administrator for assistance. The server log or event log may contain more details about the error.Source : Not AvailableTarget Site : Not AvailableHelp Link : Not AvailableInner exception message : There is no row at position 0.Inner exception source : System.DataInner exception target site : GetNodeByIndexStack Tr

Hello,Is there a way to store the image in database through odata? there are options to pass the image URL and set "stored": "Y" allows to store the image in database. But look for an option to pass the binary or base64 value of an image and store in database directly. 

Every two weeks or so, my technicians have to uninstall and reinstall the IFS app, even when we haven’t deployed any changes to the application.  We thought it might have something to do with the Microsoft patches our IT team has to run every weekend.  Has anyone else seen this issue?

Hi, Is it possible to apply dynamic filters in lookup based on condition ? for example in stock lookup, filter which is applied should work only for serial part and should not work for non serial part.Kindly suggest on same. Regards,Ramya 

Is it possible to use HTTP Authentication with FSM Mobile. Despite being cleartext authentication, behind HTTPS it should provide encryption. Can we change the paths used fromhttps://fsmmobile.domain.com/fsmmobilepath/tohttps://httpauthusername:httpauthpassword@fsmmobile.domain.com/fsmmobilepath/?This would be a different username/password per user on a reverse proxy (where we’d configure it) rather than a global username/password for all users. So more a question of whether the FSM Mobile client supports HTTP Authentication than the server, as the server would be oblivious.

FSM w3wp worker process is not releasing the memory even no one is accessing the application. W3wp worker process is consuming a lot of cpu  that is downgrading the performance of the FSM application. But even no one is accessing the application and no back ground job is running also the W3wp worker process CPU if not reducing. Only after recycling the Application pool the worker process cpu is reduced to low and we are able to access the application.

Can anyone provide the recommended specifications (size, resolution) for the LOGIN and SPLASH images for both FSM WEB and SMART environments?  I am not able to find anything in the FSM6 reference guide.

Hello,We have a requirement from business that they want the visits that are fixed to time and person in PSO to never move in the GANTT-diagram as the day progresses. Today PSO will move fixed visits based on status of other activities. This makes it hard for the resources planners to follow up on the day, since things are moving around, and sometimes are moved to the next day.

In a single team there are different work categories and each dispatcher will manage each category so at team resource and team member we need access group for roster generation.Please  note we cannot use sub team as in PSO we are avoiding increasing the dataset count.Please suggest.

In one of the customers test environment 35 technicians initialized their devices to analyze and evaluate system performance. They saw several issues. The initialization itself would run for 30+ minutes and never complete, so, They were forced to hard reboot the mobile phones.Additionally, after logging in, the techs has seen NULL NULL on their mobile phones after logging in.The environment was very slow, and, the success rates of initializations were very poor.All in all, it was a very poor experience and they need to understand how they can improve this experience. While the investigations were being carried out, it has observed that, Memory utilization was under threshold but we've noticed higher amount of CPU %, Data in/out of the Application, Read/Write operations, number of connections/requests, thread count which clearly lead to the higher response time of the App service and as a result there were failed requests with HTTP errors during that time period. From the database end t

Hi, I am trying to implement a conditional expression for a value type Business rule. My condition is belowTDC_TASK_EXT.USER_DEF103 IS NULL?1100:C_JOB_CODE.BASE_VALUEIf the value for TDC_TASK_EXT.USER_DEF103 is Null, it should set the value for TASK.USER_DEF_NUM2 as 1100 and if Not Null, it should set the value of C_JOB_CODE.BASE_VALUE.But it is always setting the value as 1100. So it seems that Boolean result for highlighted (in yellow) condition is always being true.Could someone help me understand what I am doing wrong here?