PSO/IFS Dataset connection broken

Hello  @HannMat ,

Could you please check the event logs, any specific errors? May be the SQM stopped?

Best Regards,
Vinu

Hi @Vinu Peiris 

I have checked the event log and it seems the SQM is running:

Should I provide system_events log file?

Regards,

Hannes

Hello  @HannMat ,

A good screenshot would do just to get a preliminary idea as well. Please make sure you get the event log as soon as it stops working (updates not pulling through from FSM).

Best Regards,

Vinu

Hi @Vinu Peiris 

Sorry for the previous screenshot. Here it is larger:

I don’t think I can grab a screenshot now of when it stops working, as this stopped working, but I don’t know exactly when it stopped working.

Regards,

Hannes

Hi @HannMat 

Just picking up on this comment “Updating any data in FSM does not pull through to PSO”.

What fields are you updating in FSM?

I’d check the input folder for PSO and see if it receives the fresh update.

I had a similar issue too, so it maybe worth checking EXPORT_TASK_UPDATE_COLUMN_CHANGED in the Scheduling App Params. Check what fields are listed in there, and see if by updating those specific fields FSM updates PSO.

Maybe the case you need more task fields adding to that parameter to get the data going from FSM to PSO.

Ady

Hi @AdrianEgley 

Fields listed under the EXPORT_TASK_UPDATE_COLUMN_CHANGED are: TASK_TYPE,ADDRESS_ID,PRIORITY,SPLIT_ALLOWED,MIN_SPLIT,INTERRUPT,COST_OF_SPLIT,DESCRIPTION,CREATED_DTTM,SCHED_REF_ID,SCHEDULE_VALUE,SCHED_TASK_DUR_MIN,PLAN_TASK_DUR_MIN,TASK_STATUS,USER_DEF16.

I have tried updating the Scheduling App Params (EXPORT_TASK_UPDATE_COLUMN_CHANGED, EXPORT_TASK_TEAMS, EXPORT_TASK_TYPES, EXPORT_TASK_STATUSES_TO_EXCLUDE etc.) but still not getting any data to push to PSO.

Regards,

Hannes

@HannMat 

Ok, if you were to change the value via the client in task.description does this generate a file into the PSO Input (Then Input History) folder? That for me the first place to check. Is the action in FSM producing the file to pass to PSO.

Ady

@AdrianEgley 

Ok, I have checked the input history folder, and it seems that the items are getting created (tasks, scheduling resources etc.). 

When doing a test, a task was created and showed up as allocated on PSO, until it got committed/assigned to a resource (who is a resource on the team in FSM, but not on PSO). The task then disappeared from PSO. 

I also sometimes get an exception message when initializing the dataset:

<perform_initialize_threesixty_result>
<result type="Exception">
<error>
<application_error>
<severity>ERROR</severity>
<message>Input Reference ID already exists: INIT_2021_6_18_15_12_26</message>
</application_error>
</error>
</result>
</perform_initialize_threesixty_result>

Regards,

Hannes

@HannMat,

That sounds like that some of the data is missing on the Inital Load from FSM to PSO.

Would you expect that resource to be in PSO? If so might just come down to setup and something a miss. Especially with what you are describing.

Might be worth getting the Initial load open in something like XMLPad to review the data and see what is getting picked up. Likewise if you’re in a non-prod environment use the logging on server logs (TR9) to get the XML query that is used and see what’s being pulled when the Initialisation runs. 
 

Might need someone at IFS to confirm, but if that resource isn’t in PSO and a tasks is allocated to them, it will remove the data. I’ll try and replicate the same thing my end too.

Ady