Hi @god_prophet , Please check the values of SQL Table name with name "sqltable" and also the SQL Column name "sqlname" from the Preview Tab of Data Schema and try running the SQL Code . In your Example, the SQL Code can be as shown below: SELECT COUNT(DISTINCT {sqlname to be checked in Preview Tab ...

Hi @AdobeCampaignProxd , Please use the below syntax to configure the Url in the Personalization Block The Url for Webapp will be found in the Dashboard Page and will be live after Publishing the Webapp. It can be configured as shown below inside the Personalization Block: <a href="<%@ include optio...

Hi @Shrutii, Please refer to the below Adobe documentation Link on how to perform DB Vaccum activity. https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/database-maintenance/rdbms-specific-recommendations.html?lang=en Regards,Pravallika.

Hi @aggabhi , Thanks for sharing the first tool kit to prepare for Business Practitioner Exam. I have answered few questions in the Community, you can have a look at it and provide your inputs https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/wkdlv-815003218-observed-...

Hi @Shrutii , If your Instance is On premise , your Team can perform the DB Vaccum activity or If your Instance is a hosted Environment, then all the Operations at Backend are managed by Adobe Team , then you have to raise an Adobe ticket. Regards,Pravallika. @aggabhi 

Hi @Shrutii , Could you Please uncheck the Interim results Option in the Production Workflows and also ask Adobe Team to do a DB Vaccum activity to drop all these Temp Tables to clear the DB Space. It is a best practice to do the DB Vaccum activity once in a month to avoid the memory issues for DB S...

Hi @_abhishek_ , Please cross check the Variables mapped at Analytics end, because the error Screenshot you have pasted is looking for a variable of type "metric", but the Campaign ID which is configured is not a metric variable   This needs to be checked at Analytics end also to refresh the Variabl...

Hi @_abhishek_ , Please enable only one External account for Analytics Integration in your Instance and disable the other External accounts having Analytics Integration if any and Please try running this OOTB Workflow. Few times the issue can come up due to multiple External accounts for same Integr...

Hi @CampaignerForLife , You can create the Index directly on the Calculated attribute as shown below For Example, consider you have created the Calculated field on @email , then you can use the below syntax as an example for Calculating the length of this field. <attribute desc="Test calc field" exp...

Hi @Shruti1 , Could you Please check the Target Schema used in your Workflow is occupying how much space in your Database memory and if it occupies more DB Space, it would be better to upscale your DB Size or Optimize the Data in this Schema so that this error dont occur again and also Please try op...