JBWEB000065: HTTP Status 500 - CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_C4C_WEBCHAT_ENALBED": invalid identifier


JBWEB000309: type JBWEB000066: Exception report

JBWEB000068: message CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_C4C_WEBCHAT_ENALBED": invalid identifier

JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.

JBWEB000070: exception

java.lang.RuntimeException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_C4C_WEBCHAT_ENALBED": invalid identifier

[++SQLSelect++]
 SELECT site_id,site_id,country_code,currency_code,default_language,hide_anon_pricing,auto_approve_pa,allow_upgrade_to_permanent,notify_on_acct_changed,acct_changed_email_to,accept_outside_acct,notify_on_acct_request,acct_request_email_to,show_cart_tools_to_anon,enable_super_cart,ENABLE_EMOLECULE_GUEST,ENABLE_STOCK_FILTER,backOrder_Alternative_Flag,better_Value_UOM_Flag,prevent_order_ntf_flag,recently_viewed_prods_track,enable_next_delivery_date,enable_reviews,enable_reviews_mod_comments,enable_registration_comments,registration_comments_required,hybrid_search_enabled,show_special_price,non_user_ntf_per_order_flag,legal_effective_date,isLegal_terms_enabled,enable_qna_functionality,enable_qna_ques_by_anonymous,enable_warehouse_display,enable_estimated_shipping_date,enable_partner_pricing,search_open_invoice_days,display_promotion,default_campaign_id,login_campaign_id,tracking_id,recommend_no_results,prop_65_warning_message_flag,cookie_preference_selection,cookie_expiry_days,analytic_cookie_refuse_banner,non_analytic_cookie_exp_days,enable_ont_terms_in_cart,enable_ont_terms_in_quote,enable_custom_peptide_request,enable_avantor_insights,enable_uom_display_in_unicorn,pdp_campaign_id,filter_campaign_id,is_c4c_cont_creation_enalbed,is_c4c_webquote_enalbed,is_c4c_webchat_enalbed
   FROM vwr_site_org
  WHERE org_id=?
-- Parameters --
p[1] = {pd} us_org (java.lang.String)
[--SQLSelect--]

	atg.adapter.gsa.GSAItemDescriptor.loadProperty(GSAItemDescriptor.java:9216)
	atg.adapter.gsa.GSAItem.getPersistentPropertyValue(GSAItem.java:1349)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1243)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1519)
	atg.repository.RepositoryItemImpl.getPropertyValue(RepositoryItemImpl.java:151)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyValue(VWRRepositoryItemImpl.java:69)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyString(VWRRepositoryItemImpl.java:101)
	com.vwr.gw.userprofiling.CountryOrgItem.getDefaultLanguage(CountryOrgItem.java:176)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultLocaleData(StoreProfileTools.java:661)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultProfile(StoreProfileTools.java:630)
	com.vwr.gw.userprofiling.StoreProfileTools.setupNewSession(StoreProfileTools.java:384)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.setShoppingContext(StoreShoppingContextServlet.java:108)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.service(StoreShoppingContextServlet.java:49)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.userprofiling.ProfileRequestServlet.service(ProfileRequestServlet.java:461)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.ondemand.servlet.pipeline.NetscalerServlet.service(NetscalerServlet.java:89)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.LanguageSwitchServlet.service(LanguageSwitchServlet.java:45)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.ProtocolSwitchServlet.service(ProtocolSwitchServlet.java:70)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.DynamoPipelineServlet.service(DynamoPipelineServlet.java:491)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.URLArgumentPipelineServlet.service(URLArgumentPipelineServlet.java:298)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.PathAuthenticationPipelineServlet.service(PathAuthenticationPipelineServlet.java:392)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.security.ThreadUserBinderServlet.service(ThreadUserBinderServlet.java:113)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.dtm.TransactionPipelineServlet.service(TransactionPipelineServlet.java:234)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.SecurityServlet.service(SecurityServlet.java:200)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.multisite.SiteContextPipelineServlet.service(SiteContextPipelineServlet.java:515)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.HeadPipelineServlet.passRequest(HeadPipelineServlet.java:1294)
	atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:963)
	atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:272)
	atg.servlet.ServletUtil.getDynamoRequest(ServletUtil.java:3502)
	atg.servlet.DynamoServlet.service(DynamoServlet.java:167)
	com.vwr.gw.servlet.P3PServletFilter.doFilter(P3PServletFilter.java:43)
	com.vwr.gw.servlet.BotsFilter.doFilter(BotsFilter.java:51)

JBWEB000071: root cause

CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_C4C_WEBCHAT_ENALBED": invalid identifier

[++SQLSelect++]
 SELECT site_id,site_id,country_code,currency_code,default_language,hide_anon_pricing,auto_approve_pa,allow_upgrade_to_permanent,notify_on_acct_changed,acct_changed_email_to,accept_outside_acct,notify_on_acct_request,acct_request_email_to,show_cart_tools_to_anon,enable_super_cart,ENABLE_EMOLECULE_GUEST,ENABLE_STOCK_FILTER,backOrder_Alternative_Flag,better_Value_UOM_Flag,prevent_order_ntf_flag,recently_viewed_prods_track,enable_next_delivery_date,enable_reviews,enable_reviews_mod_comments,enable_registration_comments,registration_comments_required,hybrid_search_enabled,show_special_price,non_user_ntf_per_order_flag,legal_effective_date,isLegal_terms_enabled,enable_qna_functionality,enable_qna_ques_by_anonymous,enable_warehouse_display,enable_estimated_shipping_date,enable_partner_pricing,search_open_invoice_days,display_promotion,default_campaign_id,login_campaign_id,tracking_id,recommend_no_results,prop_65_warning_message_flag,cookie_preference_selection,cookie_expiry_days,analytic_cookie_refuse_banner,non_analytic_cookie_exp_days,enable_ont_terms_in_cart,enable_ont_terms_in_quote,enable_custom_peptide_request,enable_avantor_insights,enable_uom_display_in_unicorn,pdp_campaign_id,filter_campaign_id,is_c4c_cont_creation_enalbed,is_c4c_webquote_enalbed,is_c4c_webchat_enalbed
   FROM vwr_site_org
  WHERE org_id=?
-- Parameters --
p[1] = {pd} us_org (java.lang.String)
[--SQLSelect--]

	atg.adapter.gsa.GSAItemDescriptor.loadProperties(GSAItemDescriptor.java:9168)
	atg.adapter.gsa.GSAItemDescriptor.loadProperty(GSAItemDescriptor.java:9208)
	atg.adapter.gsa.GSAItem.getPersistentPropertyValue(GSAItem.java:1349)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1243)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1519)
	atg.repository.RepositoryItemImpl.getPropertyValue(RepositoryItemImpl.java:151)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyValue(VWRRepositoryItemImpl.java:69)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyString(VWRRepositoryItemImpl.java:101)
	com.vwr.gw.userprofiling.CountryOrgItem.getDefaultLanguage(CountryOrgItem.java:176)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultLocaleData(StoreProfileTools.java:661)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultProfile(StoreProfileTools.java:630)
	com.vwr.gw.userprofiling.StoreProfileTools.setupNewSession(StoreProfileTools.java:384)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.setShoppingContext(StoreShoppingContextServlet.java:108)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.service(StoreShoppingContextServlet.java:49)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.userprofiling.ProfileRequestServlet.service(ProfileRequestServlet.java:461)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.ondemand.servlet.pipeline.NetscalerServlet.service(NetscalerServlet.java:89)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.LanguageSwitchServlet.service(LanguageSwitchServlet.java:45)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.ProtocolSwitchServlet.service(ProtocolSwitchServlet.java:70)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.DynamoPipelineServlet.service(DynamoPipelineServlet.java:491)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.URLArgumentPipelineServlet.service(URLArgumentPipelineServlet.java:298)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.PathAuthenticationPipelineServlet.service(PathAuthenticationPipelineServlet.java:392)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.security.ThreadUserBinderServlet.service(ThreadUserBinderServlet.java:113)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.dtm.TransactionPipelineServlet.service(TransactionPipelineServlet.java:234)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.SecurityServlet.service(SecurityServlet.java:200)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.multisite.SiteContextPipelineServlet.service(SiteContextPipelineServlet.java:515)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.HeadPipelineServlet.passRequest(HeadPipelineServlet.java:1294)
	atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:963)
	atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:272)
	atg.servlet.ServletUtil.getDynamoRequest(ServletUtil.java:3502)
	atg.servlet.DynamoServlet.service(DynamoServlet.java:167)
	com.vwr.gw.servlet.P3PServletFilter.doFilter(P3PServletFilter.java:43)
	com.vwr.gw.servlet.BotsFilter.doFilter(BotsFilter.java:51)

JBWEB000071: root cause

java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_C4C_WEBCHAT_ENALBED": invalid identifier

[++SQLSelect++]
 SELECT site_id,site_id,country_code,currency_code,default_language,hide_anon_pricing,auto_approve_pa,allow_upgrade_to_permanent,notify_on_acct_changed,acct_changed_email_to,accept_outside_acct,notify_on_acct_request,acct_request_email_to,show_cart_tools_to_anon,enable_super_cart,ENABLE_EMOLECULE_GUEST,ENABLE_STOCK_FILTER,backOrder_Alternative_Flag,better_Value_UOM_Flag,prevent_order_ntf_flag,recently_viewed_prods_track,enable_next_delivery_date,enable_reviews,enable_reviews_mod_comments,enable_registration_comments,registration_comments_required,hybrid_search_enabled,show_special_price,non_user_ntf_per_order_flag,legal_effective_date,isLegal_terms_enabled,enable_qna_functionality,enable_qna_ques_by_anonymous,enable_warehouse_display,enable_estimated_shipping_date,enable_partner_pricing,search_open_invoice_days,display_promotion,default_campaign_id,login_campaign_id,tracking_id,recommend_no_results,prop_65_warning_message_flag,cookie_preference_selection,cookie_expiry_days,analytic_cookie_refuse_banner,non_analytic_cookie_exp_days,enable_ont_terms_in_cart,enable_ont_terms_in_quote,enable_custom_peptide_request,enable_avantor_insights,enable_uom_display_in_unicorn,pdp_campaign_id,filter_campaign_id,is_c4c_cont_creation_enalbed,is_c4c_webquote_enalbed,is_c4c_webchat_enalbed
   FROM vwr_site_org
  WHERE org_id=?
-- Parameters --
p[1] = {pd} us_org (java.lang.String)
[--SQLSelect--]

	atg.adapter.gsa.SQLStatement.executeQuery(SQLStatement.java:613)
	atg.adapter.gsa.Table.loadProperties(Table.java:1212)
	atg.adapter.gsa.GSAItemDescriptor.loadProperties(GSAItemDescriptor.java:9095)
	atg.adapter.gsa.GSAItemDescriptor.loadProperty(GSAItemDescriptor.java:9208)
	atg.adapter.gsa.GSAItem.getPersistentPropertyValue(GSAItem.java:1349)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1243)
	atg.adapter.gsa.GSAItem.getPropertyValue(GSAItem.java:1519)
	atg.repository.RepositoryItemImpl.getPropertyValue(RepositoryItemImpl.java:151)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyValue(VWRRepositoryItemImpl.java:69)
	com.vwr.gw.repository.VWRRepositoryItemImpl.getPropertyString(VWRRepositoryItemImpl.java:101)
	com.vwr.gw.userprofiling.CountryOrgItem.getDefaultLanguage(CountryOrgItem.java:176)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultLocaleData(StoreProfileTools.java:661)
	com.vwr.gw.userprofiling.StoreProfileTools.setDefaultProfile(StoreProfileTools.java:630)
	com.vwr.gw.userprofiling.StoreProfileTools.setupNewSession(StoreProfileTools.java:384)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.setShoppingContext(StoreShoppingContextServlet.java:108)
	com.vwr.gw.servlet.dafpipeline.StoreShoppingContextServlet.service(StoreShoppingContextServlet.java:49)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.userprofiling.ProfileRequestServlet.service(ProfileRequestServlet.java:461)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.ondemand.servlet.pipeline.NetscalerServlet.service(NetscalerServlet.java:89)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.LanguageSwitchServlet.service(LanguageSwitchServlet.java:45)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	com.vwr.gw.servlet.dafpipeline.ProtocolSwitchServlet.service(ProtocolSwitchServlet.java:70)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.DynamoPipelineServlet.service(DynamoPipelineServlet.java:491)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.URLArgumentPipelineServlet.service(URLArgumentPipelineServlet.java:298)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.PathAuthenticationPipelineServlet.service(PathAuthenticationPipelineServlet.java:392)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.security.ThreadUserBinderServlet.service(ThreadUserBinderServlet.java:113)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.dtm.TransactionPipelineServlet.service(TransactionPipelineServlet.java:234)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.SecurityServlet.service(SecurityServlet.java:200)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.multisite.SiteContextPipelineServlet.service(SiteContextPipelineServlet.java:515)
	atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
	atg.servlet.pipeline.HeadPipelineServlet.passRequest(HeadPipelineServlet.java:1294)
	atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:963)
	atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:272)
	atg.servlet.ServletUtil.getDynamoRequest(ServletUtil.java:3502)
	atg.servlet.DynamoServlet.service(DynamoServlet.java:167)
	com.vwr.gw.servlet.P3PServletFilter.doFilter(P3PServletFilter.java:43)
	com.vwr.gw.servlet.BotsFilter.doFilter(BotsFilter.java:51)