Hi @Luca_Lattarini - To access Adobe.io for your company you have to be a System Admin for your Org or be assigned a Developer role in the admin console: https://www.adobe.io/apis/experienceplatform/console/docs.html#!AdobeDocs/adobeio-console/master/faq.md#why-cant-i-create-a-project-for-my-organiz...

Hi @akashaj7696 - that would be dependant on your database implementation. I would look for documentation on PostgreSQL or SQL Server. That isnt really Campaign specific, unless you are after a data dictionary for Adobe Campaign then you just look at the schema definitions in Data schemas. Cheers Da...

Hi @akashaj7696 - Florian has some great blog posts / snippets on lots of different topics including queryDef & custom SQL functions:https://blog.floriancourgey.com/2018/08/use-querydef-the-database-toolkit-in-adobe-campaignhttps://blog.floriancourgey.com/2020/01/adobe-campaign-snippetshttps://blog....

@akashaj7696 - you mention you only want to populat the bestZip (12345) for ID1. If the use case is this simple then just use an Enrichment activity that looks for CCT_ID = "ID1" then set the bestZip value to 12345. If its more complex than this, like you have more than one CCT_ID that you need to l...

Hi @akashaj7696 - I have tried to do this and I found that its easier to write back to another schema than the one you are querying in the queryDef. You can then query the temporary table later in the workflow.I could never get the xtk.session.Write() function to actually work correctly so I used sq...

Hi @Greeshma_Sampath1 - There are a couple of strange time entries in there. The first one is when the workflow ran at 02:31:51 PM - that's almost a 2 minute schedule delay. It could indicate your system is under large performance load.The 20 minute delay at 03:50:12 PM is pretty extreme though.The ...

Hi @gnals12. If you just delete the data in the BroadLog then the primary key will continue where it left off. Its a database sequence and will continue to increase unless you reset it (usually not recommended). Unsure why you want to "clean" the BroadLog. It should be regularly purged as part of th...

Hi @gnals12 - The screenshot you showed has the administration folder/node on it.Do you mean the folder is there but you cant access it? If that's the case then talk to your sysadmin - they haven't enabled the admin rights correctly.CheersDarren

Hi @drewettj - an easy way to do this is to subtract the last run time from the current time and see if its less than 3 days. e.g. (getCurrentDate().getTime() - getOption("lastRunDate_TECHNICALWORKFLOW").getTime())<=259200000 Date.getTime() returns milliseconds for for 3 days = (3 * 1000 * 60 * 60 *...

Hi @gnals12 - The broadLog primary key (@id) is the unique identifier for a message created in ACC. Every message created (including control, seeds and proofs) will have a unique broadLog identifier. You can find it in the nms:broadLogRcp table.CheersDarren