saikatk2447661

Adobe Experience Manager

Adobe Campaign Classic

Adobe Campaign Standard

Adobe Experience Platform

Adobe Analytics

Adobe Audience Manager

Adobe Target

Adobe Experience Cloud

Adobe I/O Cloud Extensibility

Adobe Advertising Cloud

Marketo

Magento

Adobe Creative Cloud

Adobe Document Cloud

Workfront, an Adobe company

since

‎17-04-2021

Level 3

Update database stucture timeout - 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

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

Thanks a lot!

131

Re: Permission denied for table when querying in WebApp - Adobe Campaign Classic

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

134

Re: Update database structure - many changes that are une... - 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)

188

Re: How to add additional field in targetdata using script - Adobe Campaign Classic

Hi @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

137

Re: Dropping Data from a Temp Table - 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

111

Re: How to read and save data from SQL code activity - 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

138

Re: Update database structure - many changes that are une... - Adobe Campaign Classic

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

199

How to add custom attribute that will compute a script during delivery like delivery label - 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 ...

204

Re: Generating counts of dates - Adobe Campaign Classic

Use a query block and add two columns like this: And in advanced parameter, check the 4th box.

1.6K

Re: Data encrypted with "cryptString" function cannot be... - 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

2.0K

Re: Error in AEM content Synchronization - Adobe Campaign... - 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.

3.9K

Re: Error in AEM content Synchronization - Adobe Campaign... - Adobe Campaign Classic

Got this issue before. This has to be fixed from AEM side. Just some configuration change.

3.9K

Update block running for indefinite duration - 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.

2.7K

Re: execCommand() is not working in workflow. - Adobe Campaign Classic

1. No idea.2. Adhiyan told me few months back.

2.2K

Re: execCommand() is not working in workflow. - Adobe Campaign Classic

If this is windows server try logInfo(execCommand("cmd /c cd",true));

3.2K

Re: Can Adobe Campaign Classic execute an API call into a 3rd party system in order to retrieve data? - 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

1.5K

Re: A text in a preview workflow become an integer in an Excel export. - Adobe Campaign Classic

Please check the last check box.

1.5K

Re: Speed up big queries - 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

1.9K

Re: Limit rows in each group using Split - 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

2.5K

Re: Direct DB insert to nms:recipient - 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

6.2K

Re: Enable multiple selection in Enrichment Activity - Adobe Campaign Classic

Also in data extraction block.

4.2K

Client console for linux - 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.

2.5K

Re: Input Forms issue - Adobe Campaign Classic

Hi Bittu,Can you paste the input form XML here?Thanks,Saikat

1.9K

Re: Encryption and XSS protection on client-side in web application - 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

1.6K

Re: Encryption and XSS protection on client-side in web application - 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

1.6K