Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

saikatk2447661
saikatk2447661
Offline

Badges

Badges
22

Accepted Solutions

Accepted Solutions
14

Likes Received

Likes Received
23

Posts

Posts
58

Discussions

Discussions
8

Questions

Questions
50

Ideas

Ideas
2

Blog Posts

Blog Posts
0
Top badges earned by saikatk2447661
Customize the badges you want to showcase on your profile
Re: Session Time Out - Database Updation - Adobe Campaign Standard 01-07-2021
Did you find any solution?@moseenkhan 

Views

213

Likes

0

Replies

0
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

Views

410

Likes

0

Replies

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

Views

564

Likes

0

Replies

0
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

Views

690

Likes

0

Replies

1
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)

Views

557

Likes

0

Replies

0
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

Views

406

Likes

0

Replies

0
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

Views

714

Likes

0

Replies

0
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

Views

849

Likes

2

Replies

1
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.

Views

568

Likes

2

Replies

3
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 ...

Views

639

Likes

0

Replies

3