How to use 2 PSO datasets in one FSM environment ?

Hi @NathanP,

You should be able to have multiple datasets for one FSM integrated environment. Are you able to expand on how you are prevented from running more than one dataset from one FSM environment and/or the errors or messages you receive when you try?

There is a guide here:

for the integration setup with a dataset creation section. Are you able to advise what you have setup in the THREESIXTY_DATASET_ID Global Codes table? It would be worth checking the scheduling app params as well to ensure they have not been setup only for one dataset and instead have at least app params set for all datasets.

Kind regards,

Lee Pinchbeck

Hi @Lee Pinchbeck and @Sajith Anushan,

Two different threesixty_dataset_id are configured and app params are set for all datasets. Activities from the 2 datasets are visible in PSO but only resources from the first one are visible in Scheduling->Resources. When we try to create the Rota on the second dataset, no error message is displayed and we are back on the same screen :

We also checked in the Events screen but there is no error message

Yes we did.

@NathanP The resources will come over with the scheduled load job which is usually performed overnight. Has this been setup to send both datasets over and has it been run since the resources were added that are assigned to the second dataset?

If yes to both you may want to check the ram load table in the database to check whether the resources have lines in that table. If they do they will not be resent with the load job. Creating a new resource for the second dataset that is confirmed to not be in the ram load table and then waiting for the load job to run will help then check what exactly is blocking this by reviewing the load data sent to PSO and the ram load table afterwards.

@NathanP If you can see them in planning>resources in PSO then that means they have come over as resources so no need to check the table (it is a data table in the SQL database).

If they are in planning but not scheduling it sounds like it has them but doesn’t seem them as usable for some reason. I am more FSM than PSO so I will allow people with more experience in PSO to cover that.

@tomgreenwood don’t suppose you have seen this before? 

Hi @Lee Pinchbeck and @Sajith Anushan,

 

Two different threesixty_dataset_id are configured and app params are set for all datasets. Activities from the 2 datasets are visible in PSO but only resources from the first one are visible in Scheduling->Resources. When we try to create the Rota on the second dataset, no error message is displayed and we are back on the same screen :

We also checked in the Events screen but there is no error message

So am I right in thinking that the actual problem is that you cannot create a rota for the second modelling dataset?  

Thanks,

Tom