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
Community profile saikatk2447661 Level 4
Job title here
Location here
22 BADGES
Level 4

Level 4

Learn more
Joined the community 26-09-2016 9:25:56 PM
Offline
Top badges earned by saikatk2447661
Customize the badges you want to showcase on your profile
Re: Session Time Out - Database Updation
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Standard
Did you find any solution?@moseenkhan 

Views

74

Likes

0

Replies

0
Update database stucture timeout
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

222

Likes

0

Replies

2
Re: How to add custom attribute that will compute a scrip...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Thanks a lot!

Views

312

Likes

0

Replies

0
Re: Permission denied for table when querying in WebApp
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi @vendimb15716755 , Could you please explain the reason behind "Function getpromoCode()". Is @promoCode coming from a calculated field? Thanks,Saikat

Views

328

Likes

0

Replies

1
Re: Update database structure - many changes that are une...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

365

Likes

0

Replies

0
Re: How to add additional field in targetdata using script
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

292

Likes

0

Replies

0
Re: Dropping Data from a Temp Table
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

285

Likes

0

Replies

0
Re: How to read and save data from SQL code activity
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

369

Likes

2

Replies

1
Re: Update database structure - many changes that are une...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
I guess the temp table thing is happening because of the check box. Please try after unchecking it.

Views

376

Likes

2

Replies

3
How to add custom attribute that will compute a script during delivery like delivery label
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
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

387

Likes

0

Replies

3
Re: Generating counts of dates
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Use a query block and add two columns like this: And in advanced parameter, check the 4th box.

Views

1.7K

Likes

0

Replies

0
Re: Data encrypted with "cryptString" function cannot be...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
One more interesting thing: If you encrypt same string with same password and without salt, you will get same result most of the time. But some time you will get different result. Also, sometimes, decryptstring will not be able to decrypt the encrypted text

Views

2.5K

Likes

0

Replies

0
Re: Error in AEM content Synchronization - Adobe Campaign...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Unfortunately I have no idea what was changed by AEM team at that time. But I can assure you that this is not a problem with ACC.

Views

4.1K

Likes

0

Replies

0
Re: Error in AEM content Synchronization - Adobe Campaign...
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Got this issue before. This has to be fixed from AEM side. Just some configuration change.

Views

4.1K

Likes

0

Replies

3
Update block running for indefinite duration
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
If someone creates an entry in update block like the second one in the screenshot with Source expression empty (not even two single quotes) then the update block goes on and on without any error message.Is this a bug?It would be really nice if Adobe Campaign Classic shows some error message in journal.

Views

2.8K

Like

1

Replies

1
Re: execCommand() is not working in workflow.
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
1. No idea.2. Adhiyan​​ told me few months back.

Views

2.5K

Likes

0

Replies

0
Re: execCommand() is not working in workflow.
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
If this is windows server try logInfo(execCommand("cmd /c cd",true));

Views

3.5K

Like

1

Replies

1
Re: Can Adobe Campaign Classic execute an API call into a 3rd party system in order to retrieve data?
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi Bob,You can use this HttpClientRequest (Class) to call 3rd party API and the use this SOAP methods in JavaScript to load it.Thanks,Saikat

Views

1.6K

Likes

0

Replies

0
Re: A text in a preview workflow become an integer in an Excel export.
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Please check the last check box.

Views

1.6K

Likes

0

Replies

0
Re: Speed up big queries
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi Milan,You can join them using the Add a linked table option on the IDThen in Edit query you can pass an option like thisThanks,Saikat

Views

2.0K

Likes

0

Replies

0
Re: Limit rows in each group using Split
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi Naveen,You can do this in the first query block using window function.You have to create an additional attribute as RowNum(PartitionBy(Delivery), OrderBy(Desc(count)))Then you can create a filter in refine target as line Number <= 2Thanks,Saikat

Views

2.8K

Likes

4

Replies

0
Re: Direct DB insert to nms:recipient
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi,You can keep the autopk="true" and use the following sql syntax:INSERT INTO nmsrecipient (irecipientid,semail,saccount,sfirstName,slastName) VALUES (GetNewId(),'adobe@adbc.com','7835845','s','b');Or you can create a custom recipient specific sequence and custom new id function and use that one too as mentioned by Jon.Thanks,Saikat

Views

6.5K

Likes

0

Replies

0
Re: Enable multiple selection in Enrichment Activity
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Also in data extraction block.

Views

4.3K

Likes

0

Replies

0
Client console for linux
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
It would be great if there is ACC client console for linux. Right now, just to use this console we have to depend on windows.

Views

2.5K

Like

1

Replies

1
Re: Input Forms issue
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi Bittu,Can you paste the input form XML here?Thanks,Saikat

Views

2.0K

Like

1

Replies

0
Re: Encryption and XSS protection on client-side in web application
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi Mary,When you are doing this, the server is serving the web page to the client after doing the encryption in server side. if you open the webapp in a browser, reload the page and check in developer mode, you must be seeing the encrypted value from the beginning.If you are using https then you are already using standard encryption.Thanks,Saikat

Views

1.7K

Likes

0

Replies

0
Re: Encryption and XSS protection on client-side in web application
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Hi, document.controller.setValue() is running on client side. But cryptString is a server side function. I guess only way to solve this is to send the value to server unencrypted (just by document.controller.submit('next'); ). And then use a Script activity to do the encryption server side.Thanks,Saikat

Views

1.8K

Like

1

Replies

0
Re: Limit???
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Standard
As per the query def schema, noLineCount="true" should work.But it seems not working.Any idea why? PabloRosero​

Views

3.0K

Likes

0

Replies

0
Re: QueryDef inside componment after a split
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Is it possible for you to post a screenshot of the workflow? I am assuming it is something like this... Please confirm.

Views

5.6K

Likes

0

Replies

2
Re: QueryDef inside componment after a split
Avatar
Ignite 5
Level 4
saikatk2447661
Level 4

Likes

23 likes

Total Posts

58 posts

Correct reply

14 solutions
Top badges earned
Ignite 5
Give Back 25
Ignite 3
Give Back 10
Ignite 1
View profile
saikatk2447661
- Adobe Campaign Classic
Try using different segment codes for different branch in split block and use those values of segment codes to filter them inside the querydef.

Views

5.6K

Likes

0

Replies

4