since ‎13-10-2020
‎02-03-2021
Sinhue
Level 1
Personalization or Count Failed
Avatar

Sinhue

Sinhue
- Adobe Campaign Classic
Hi, I created a recurring campaign few months ago, that campaign works perfectly 2 week ago, but today I realized that the email activity had launched an error, I tried to restart many times the wf and create a new campaign with a new wf but the issue persisted, and I don't find an answer to solve my problem. I think the problem is related whit the database or the configuration but Im not sure of that.  Audit Log 02/12/2021 4:49:47 AM XSV-350122 An error occurred and the process has been stopped...

Views

141

Likes

0

Replies

1
Re: SqlSelect Function Javascript doesn't retrieve above...
Avatar

Sinhue

Sinhue
- Adobe Campaign Classic
Hi @_Manoj_Kumar thanks for you answer, but how can I do that?, the purpose of my javascript code is to get the date difference between rows.

Views

339

Likes

0

Replies

0
SqlSelect Function Javascript doesn't retrieve above 70000 rows. is that possible?
Avatar

Sinhue

Sinhue
- Adobe Campaign Classic
Hi everyone I have this javascript code after an enrichment activity:// select rows of the last transition var sql = "SELECT sVin,sMktSale,iCountVehicles,sDayDifference,tsDelivery,coalesce(tsDelivery - lag(tsDelivery) over(partition by sCustomerId order by tsDelivery), 0) as Difference FROM " + vars.tableName; var contracts = sqlSelect("resultQuery,@vin:string,@MktSale:string,@CountVehicles:int,@DayDifference:string,@deliveryDate:date,Difference:string", sql); // // Iterate each row for each(var...

Views

373

Likes

0

Replies

5
Likes given to