saikatk2447661

Re: Session Time Out - Database Updation - Adobe Campaign Standard 01-07-2021

Did you find any solution?@moseenkhan

213

Update database stucture timeout - Adobe Campaign 16-04-2021

Hi All, Facing this problem after v7 upgrade. Update database structure is showing timeout error most of the time. The error is coming before showing the list of tables that has any change. Can anyone provide some info on what kind of sql/other back end job is executed during this database update? Do we have too many tables? Is it a issue with DB server memory? Thanks,Saikat

410

Re: How to add custom attribute that will compute a scrip... - Adobe Campaign 16-02-2021

Thanks a lot!

564

Re: Permission denied for table when querying in WebApp - Adobe Campaign 10-02-2021

Hi @vendimb15716755 , Could you please explain the reason behind "Function getpromoCode()". Is @promoCode coming from a calculated field? Thanks,Saikat

690

Re: Update database structure - many changes that are une... - Adobe Campaign 10-02-2021

Check what happens if you set the opition variable to 0. If that checkox after TSDATE gets grayed out then your assumption is true. (Assuming you have not executed the database update script already)

557

Re: How to add additional field in targetdata using script - Adobe Campaign 10-02-2021

Hi @Jonathon_wodnicki , Could you please share the process of altering Target schema with js? I remember you mentioned two js functions (something like generateSchema) in a forum post here but unfortunately I could not find that post/comment anymore. I would love to explore them. Thanks in advance,Saikat

406

Re: Dropping Data from a Temp Table - Adobe Campaign 10-02-2021

Hi @Tarquinius , Put an end block after cont. delivery block.Use this in the advanced tab of end block:sqlExec("drop TABLE "+vars.tableName);vars.tableName with contain the temp table name that gets created in backend database. It will have name like wkf1163548174_64_1 Thanks,Saikat

714

Re: How to read and save data from SQL code activity - Adobe Campaign 10-02-2021

Hi @Abhishek_Kumar_Keshri , Sql code activity does not create temp table so you can not read the result of select statement in this way. Delete the sql code activity and just use query function in js block and run it in js activity. You can read the content of any table in the database this way. https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/m-DBEngine-query.html?hl=cnx Thanks,Saikat

849

Re: Update database structure - many changes that are une... - Adobe Campaign 10-02-2021

I guess the temp table thing is happening because of the check box. Please try after unchecking it.

568

How to add custom attribute that will compute a script during delivery like delivery label - Adobe Campaign 10-02-2021

Hi All,I am trying to add a custom attribute (Delivery Label 2) that will contain a computed value from a script during delivery like delivery label. I want to put script like <%= formatDate(new Date(), "%2D/%2M/%2Y") %> and it should put the date value in a custom attribute. I duplicated code from delivery table and input form as it is but I am unable to figure out how to execute the script of labelScript_new and assign the value to Delivery Label 2.Data schema: Form: How to execute the script ...

639

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe