Maintenance will affect our software interface between 8am and 2pm on Saturday 13 February, as we migrate our XML Platform to the cloud.
This will effect both XML filing and the image / data service.
Any attempt to access the service during this period will result in an error.
Please accept our apologies, in advance, for the above.
SDN
Simon, just to let you and your colleagues know, following your maintenance today, we are getting the 9999 fatal errors for PSCNotification submissions and an officer change submission for a change of nationality along the lines of the following
<Number>9999</Number>
<Type>fatal</Type>
<Text>...selectcol_arrayref failed....DBD ERROR: error possibly near <*> indicator</Text>
Edited 10:00am 14/02/2021
Also had three incorporation submissions, another two officer change and an officer appointment fail. The errors on the most recent ones have changed to the following:
OfficerAppointment
9999
fatal
Error executing ‘SELECT UPPER(TRIM(country_type_desc)),UPPER(TRIM(ISO_COUNTRY_LONG_CODE)) FROM country_type WHERE country_eff_date <= SYSDATE AND country_end_date > SYSDATE AND ISO_COUNTRY_LONG_CODE IS NOT NULL’: ORA-00942: table or view does not exist
ORA-02063: preceding line from CHPRD_ACCESS_USER (DBD ERROR: error possibly near <> indicator at char 78 in 'SELECT UPPER(TRIM(country_type_desc)),UPPER(TRIM(ISO_COUNTRY_LONG_CODE)) FROM <>country_type WHERE country_eff_date <= SYSDATE AND country_end_date > SYSDATE AND ISO_COUNTRY_LONG_CODE IS NOT NULL’)
Thank you Philip - I have asked for this to be investigated.
SDN
The issue has now been resolved - all should be able to file as normal.
SDN