Skip to main content

Hello,

After updating the PSO to version 6.14.0.38, I’ve noticed that a lot of errors appear in the Events tab:

Error
ARC
Failed to select from ARC_Snapshot_Timetable_Usage.

Going on deeper details, we can see Oracle error:

Database Error: 936 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression https://docs.oracle.com/error-help/db/ora-00936/ at OracleInternal.ServiceObjects.OracleFailoverMgrImpl.OnError(OracleConnection connection, CallHistoryRecord chr, Object mi, Exception ex, Boolean bTopLevelCall, Boolean& bCanRecordNewCall) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at ThreeSixty.DAL.DBAccess.RetrieveData(IDbCommand command, DataTable dtTableToSelect, Boolean bCheckForDuplicates, Boolean bFirstRowOnly, Boolean bAdditionalRows, List`1 lstrExcludedColumns)

Looks like some sql definiton error from ARC service...but I couldn’t find the rootcause of it.
We have 3 environments of PSO, after the 6.14.0.38 update this error showed up on each. On 2 envs it has just disappeared without any fix or solution...Unfortunately it is still spamming the event tab of the last environment.

Did anyone else had the same error ? 

Hi Tomasz,

this is a known bug in 6.14 when using an Oracle DB. It was recently fixed in support release 6.14.0.49.

Release Notes:
 

--------------------------------------------------------------------------------------------------------------------------------------------
Software Released    19/11/2024    6.14.0.49
--------------------------------------------------------------------------------------------------------------------------------------------

ARC   TEPSO-3627      Fixed issue with querying for database table columns on Oracle
DSE   TEPSO-3603      Fixed issue with handling multiple split carry over activities in parallel routes.
PSW   TEPSO-3601      Fix URL returning HTTP 404 issue
DSE   CS0313781       Reduce memory usage when caching travel estimates, and optionally limit the size of the travel cache.
DSE   CS0311775       Fixed issue with the calculation of a shift's end time when using leeways and the shift began with a private activity
SQM   CS0239796       Implicit breaks will no longer be counted in activity counts on the Analysis page
PSW   CS0306347       Fix resource icon not displayed correctly in detail panel issue
DSE   CS0302713       Fixed issue where overlapping region availabilities were ignoring the override_priority field
ABE   CS0305300       Fixed issue with handling updates to global part stock when appointment booking
PSW   CS0273285       Fix the bulk manual changes issue
PSW   CS0309788       (3612) Removed region as an option in the lists and updated documentation.
PSW   CS0226714       Fixed issue with resource location travel distance display
PSW   TEPSO-3576      Fixed issue where the shift time selected status did not update when the schedule date was changed

 

However, as far as I remember you are using PSO K8s, correct? It’s not available yet in JFROG repo.

Best regards
Roman

Hi Roman,

Thanks for the answer,  as you mentioned we have PSO in Kubernetes instance. Guess we will have to wait for the new release :) 

Reply


Terms & ConditionsCookie settings