Skip to main content
  • EN

Was previously working as intended, just tried to login.

On the login screen there is a popup “Application update error. Try cleaning the browser cache“ Cleaned browser cache but did not change.

When logged in there is no organization showing, and as such no backup/restore jobs are showing. Under Settings>Companies I get a popup error:

 

could not prepare statement; SQL with t as (SELECT c.id as id, cast(c.external_id as text) as externalId, c.name as name, SUM(CASE WHEN s.org_name='production' THEN s.sf_sfdc_used_licenses ELSE 0 END) as users, SUM(CASE WHEN s.org_name='production' THEN (cast(jsonb_extract_path(s.sf_storage, 'data', 'max') as float) - cast(jsonb_extract_path(s.sf_storage, 'data', 'remaining') as float)) ELSE 0 END) as dataSize, SUM(coalesce(s.storage_used, 0)) as storageSize, SUM(coalesce(d.db_size_bytes, 0)) as dbSizeBytes, COUNT(s) as sfOrg FROM vsf_configuration.company c LEFT JOIN vsf_configuration.sf_instance as s on c.id = s.company_id LEFT JOIN vsf_configuration.db_server as d on s.db_server_id = d.id WHERE (? = TRUE OR ((null) IS NULL OR c.id IN (null))) GROUP BY c.id, c.name) SELECT * from t order by name desc limit ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement

 

Under alerts:

 

could not prepare statement; SQL tselect notificati0_."id" as id1_28_0_, notificati1_."id" as id1_29_1_, notificati2_."id" as id1_27_2_, notificati3_."id" as id1_26_3_, notificati0_."version" as version2_28_0_, notificati0_."vsf_created_by_id" as vsf_crea3_28_0_, notificati0_."vsf_created_date" as vsf_crea4_28_0_, notificati0_."vsf_last_modified_by_id" as vsf_last5_28_0_, notificati0_."vsf_last_modified_date" as vsf_last6_28_0_, notificati0_."code" as code7_28_0_, notificati0_."on_status" as on_statu8_28_0_, notificati0_."state" as state9_28_0_, notificati0_."subject" as subject10_28_0_, notificati0_."system" as system11_28_0_, notificati0_."threshold" as thresho12_28_0_, notificati1_."version" as version2_29_1_, notificati1_."vsf_created_by_id" as vsf_crea3_29_1_, notificati1_."vsf_created_date" as vsf_crea4_29_1_, notificati1_."vsf_last_modified_by_id" as vsf_last5_29_1_, notificati1_."vsf_last_modified_date" as vsf_last6_29_1_, notificati1_."notification_rule_id" as notifica9_29_1_, notificati1_."object_id" as object_i7_29_1_, notificati1_."type" as type8_29_1_, notificati1_."notification_rule_id" as notifica9_29_0__, notificati1_."id" as id1_29_0__, notificati2_."version" as version2_27_2_, notificati2_."vsf_created_by_id" as vsf_crea3_27_2_, notificati2_."vsf_created_date" as vsf_crea4_27_2_, notificati2_."vsf_last_modified_by_id" as vsf_last5_27_2_, notificati2_."vsf_last_modified_date" as vsf_last6_27_2_, notificati2_."application" as applicat7_27_2_, notificati2_."notification_channel_id" as notifica9_27_2_, notificati2_."notification_rule_id" as notific10_27_2_, notificati2_."recipient" as recipien8_27_2_, notificati2_."notification_rule_id" as notific10_27_1__, notificati2_."id" as id1_27_1__, notificati3_."version" as version2_26_3_, notificati3_."vsf_created_by_id" as vsf_crea3_26_3_, notificati3_."vsf_created_date" as vsf_crea4_26_3_, notificati3_."vsf_last_modified_by_id" as vsf_last5_26_3_, notificati3_."vsf_last_modified_date" as vsf_last6_26_3_, notificati3_."idp_id" as idp_id11_26_3_, notificati3_."company_id" as company_7_26_3_, notificati3_."enabled" as enabled8_26_3_, notificati3_."properties" as properti9_26_3_, notificati3_."type" as type10_26_3_ from "vsf_configuration"."notification_rule" notificati0_ inner join "vsf_configuration"."notification_scope" notificati1_ on notificati0_."id"=notificati1_."notification_rule_id" inner join "vsf_configuration"."notification_destination" notificati2_ on notificati0_."id"=notificati2_."notification_rule_id" inner join "vsf_configuration"."notification_channel" notificati3_ on notificati2_."notification_channel_id"=notificati3_."id" where notificati0_."id" in (select notificati4_."id" from "vsf_configuration"."notification_rule" notificati4_ inner join "vsf_configuration"."notification_scope" notificati5_ on notificati4_."id"=notificati5_."notification_rule_id" inner join "vsf_configuration"."notification_destination" notificati6_ on notificati4_."id"=notificati6_."notification_rule_id" inner join "vsf_configuration"."notification_channel" notificati7_ on notificati6_."notification_channel_id"=notificati7_."id" where (coalesce(?, ?) is null or notificati4_."state" in (?)) and notificati4_."system"=false and (coalesce(?, ?) is null or notificati7_."type" in (?)) and (coalesce(?, ?) is null or ('ERROR' in (?)) and cast(jsonb_extract_path_text(notificati4_."on_status",'on_error') as boolean)=true or ('WARNING' in (?)) and cast(jsonb_extract_path_text(notificati4_."on_status",'on_warning') as boolean)=true or ('SUCCESS' in (?)) and cast(jsonb_extract_path_text(notificati4_."on_status",'on_success') as boolean)=true)) order by notificati0_."id" desc]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement

 

Any thoughts on how to reconnect/resolve the backup?

Hi matt111,

its fresh installation?

could you please describe closer, what did you do?

from this point is only hard guess

Hi ​@Marcel.K 

 

Did nothing. Installed and had been working fine for several months now, logged in to do a manual review of the backups and got this. 

 

Feels like something might have changed either with Veeam (update?) or Salesforce because going from working perfectly to blank is very odd.  I would have hoped in such a situation you’d at least keep the old backup data vs it being all blank now.

 

First error appears on the login screen:

 

If you then login everything is blank (no organization or backups)

 

I did notice: Your Connected App is now configured, but connections to some Salesforce organizations need attention. Please go to the Salesforce tab and re-authorize the connected organizations with the backup users credentials.

 

But there’s nothing there to re-authorize:

 

 

Comment


Terms & Conditions