Hi @VinuP,
We cannot use comma separated values for the HierarchicalDatabaseMatrixId as per the current design. Instead, we must create separate PSO profiles if multiple HTMs are being used, Then, reference the Profile on the Dataset's Input_Reference when sending the xml in to the scheduling system.
‘NA’ is of course the correct matrix-Id value we should use when using an NA V3 HTM.
To narrow down the issues related to the warnings here, you may:
- Verify if IFS PSO services have been configured to access the HTM database using the correct user in the “connection string”. This can be done by using the installer to reinstall the services and setting the connection string on the databases page.
- Verify if the PSO parameter 'TravelCalculationOption' is set to 'HierarchicalTravelMatrix'
- Verify if the ‘HierarchicalDatabaseMatrixID’ is set to the correct value (eg: NA)
Hope this will help.
Best regards,
Pubudu
Hello @Pubudu Dharmarathne ,
Many thanks for the response. I know what I'm about to say should not make sense, but when i enter NA,US,CA the above error message will not appear.
We are still checking other options as well. We tried re-installing the HTM, re-installing the PSO version as well, None of it worked.
Please let me now if you have any thoughts on this. :)
Best Regards,
Vinu
Hello @Pubudu Dharmarathne ,
I’ve checked the Parameters again, and re-installed the HTM and as you have mentioned the connection string addition to the HTM database was not connected properly so made the connection and the verification file works fine now. :)
Many thanks & Regards,
Vinu.