Dear Team We are facing an weird issue while executing DB cleanup WF.It
keeps failing with an table doesn't execute issue. if we recreate the
table - the issue moves to other table. As per analysis, it is fetching
the data from sysobjects WHERE type = 'U'. Could you help me how to
resolve this issue. Log: 02/24/2021 9:12:23 AM nlmodule WDB-200001 SQL
statement 'up_updatestats' could not be executed.02/24/2021 9:12:22 AM
nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client
11.0][S...
Hi All We're facing the below error while executing the Database Cleanup
WF, Could you pl. help.Thank you! Error
Log:-------------------------------------------------------------------------------------------------------------------------02/10/2021
4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists
'wkf235202504_2_1'' could not be executed.02/10/2021 4:22:12 PM nlmodule
WDB-200001 SQL statement 'DropTableIfExists 'wkf232235642_216_1'' could
not be executed.02/10/2021 4:22:12 PM nlmo...
Hi Craig - Thanks for your suggestion. I got your point. but would like
to understand how it is been configured in Adobe Campaign.I could see
the error message has been configured in the below path but from where
we are fetching the error message is something I would like to
understand. Could you share your view on this, pls. Thank you!
Hi Adithya - Thanks for the suggestion, regenerated both coupon &
couponValue schemas. Still the columns are not reflecting in couponValue
schema.Also, I couldn't find the CouponValue schema in the wizard.
Please assist,. Thank you! fetchedthe action of fetchingMore
(Definitions, Synonyms, Translation)
Dear All We're facing an issue for a specific domain, the mails are not
delivered due to the below error.The intersting part is the mails are
delivered from production. Could you pls assist.554 IP name lookup
failed. No PTR record foundThank you!
Hi Adithya - Thank you, I have tried to regenerate the schema but it
didn't work. Also there is no null value in the table. Is there any
other way to refresh the schema? Thank you!
Dear All, Need your help here. We couldn’t find the out of the box
column values in nms : couponValues schema structure.It is properly
fetching the columns in DEV region but we are facing the issue in PROD
due to this workflows are failing.Is there a way to reload this nms
schema? since it is OOB we couldn't experiment much, Please assist.Thank
you!DEV - It is workingPROD - It is not fetching the columnsPROD -
Column Defined in Schema dobe sufficient; be adequate, either in quality
or quantityMo...
Hi Pascal (did you check with the postmaster@) - We have tried sending
mail to info@web.de but there is no response from them.due to a network
problem (IP reverse, IP binding) - The mails are delivered to those
domains but some part of users are getting blocked.It would be great if
you could guide us in fixing this issue.Thank youUkender
Hi PascalThank you for the response. Could you please elaborate about
the Boost?I have reduced the MX rule values and tried the below comment
in the server. but still we are facing the same issue. delivery success
rate is low.nlserver stat -reloadDo I have to do anything else to get
the higher success rate?Thank youUkender
Hi @manoj,Thank you so much for the link, it had the details. Our
application is hosted on primise. so enhanced feature is not applicable
for us.Could you please guide me, What would be the right value
(decrease) to get the higher success rate. Thank you!
Hi All,Our delivery success rate is very low for some domains,
deliveries were failed due to the below reason.Messages queued (dynamic
flow control).Messages queued (quotas met).I've gone thru the below
document as well but still unsure what needs to be done to increase the
success rate for those
domains.https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/deliverability-management/technical-recommendations.html?lang=en#technical-recommendationsPlease
find the screesho...
Hi DarrenThanks for enlighten me. As per config file, there is no IP's
mentioned. mxAddress value is empty. Could you pls help me, how to find
it in this case?Also I could see the IP addresses in the application
monitoring.Thank you!
Hi All We're facing an issue while executing a webApp, it throws out of
memory. I have increased the javascript limit in serverconf from 128 to
2048 MB and reloaded the severconf but it still throws the same error.
We are using a sql query which fetches 50K lines of results, Is there
any limits in running the JS? could you please help me out. I've
followed the steps provided in
https://helpx.adobe.com/campaign/kb/out-of-memory-error-in-js-code-activity-in-workflows.html
Thanks in Advance
Dear All How to identify the usage of schema / table?Example,We have
custom data schema which is creating a sql table, but we are unsure how
the data is loaded to the table. We were not able to find the WF or
WebApp is using the particular schema / table. CheersUkender
Hi David,I really appreciate it. Thanks a lot for the detailed info. Yes
you are perfectly correct. We have used only autopk not pksequence in
the schema. We are planning for the build upgrade but it is pending with
business approval. The negative key issue in Prod. So, It's making a
huge impact. That is the reason looking for a temporary / alternate
solution. Hope this will solve the issue temporarily or please suggest
if you think of any other possible solution. One last question from me,
Woul...
Hi David Thanks for the response. Yes you are right, I am trying to
create a custom sequence for one of the table. The reason for custom
sequence is xtkNewId had reached its limit and started with negative
values. I have found the above code for creating the custom sequence. So
as per your suggestion if I insert the record into xtkNewid will it
generate sequence unique primary key (same as xtkNewId)? Also would like
to know, what will be the impact for the existing primary key in the
table. Let'...
Dear All I'm getting the below error while executing the script in admin
console. could you please help me on this. Thanks in Advance SELECT
CreateSequenceIfNecessary('NeoCustomId', '1000', 'cache 1000');create or
replace function GetNeoCustomId() returns integer as 'declareiId
integer;beginselect into iId NextVal(''NeoCustomId'');return iId;end;'
language plpgsql;create or replace function GetNewNeoCustomIds(integer)
returns text as 'declarestrIds text;i integer;iId integer;beginstrIds =
'''';f...
Hi @Milan_Vucetic Thanks for the information, It is really helpful.Since
there were lot of scripts used in the video, It would be great if you
could share the document link.ThanksUkender
Dear All Hope you’re doing well! Issue : Negative values are generated
in auto generated primary key (autopk) field, could you please help on
this. This was working till last week. now It is started generating the
negative values. I don't feel there is an issue in schema, Schema
:
-2099728967-2099728966-2099728965-2099728964-20997289722076753926207675392720767539282076753929
Thanks in AdvanceUkender
Hi @manoj, Thanks for the effort. sorry to say this still I am facing
the same issue, I have tried multiple option placing the insert in ""
,'' and without any also tried with combo against the /> and >. Nothing
has turned around 😞
Hi @manoj, Yes Manoj I have verified, I have the semi colon where ever
it is necessary.I have tried to keep semi colon ; in each element end
tag as well but it didn't give me the solution,For example I have given
the ; in .
Hi @manoj, Thanks a lot for the suggestion.. I have tried your
suggestion but the below script but doesn't work for me. it failed in
compilation. The previous code works well, If I did not add '&' special
characters in the text field. So could you please suggest me some
workaround for why the '&' is not taking in the text field. Tried
Script:var creationDate=formatDate(new Date(),'%4Y-%2M-%2D
%2H:%2N:%2S');var
creationDate2=formatDate(getCurrentDate(),"%2D.%2M.%4Y");var insertxml
="
";xtk.s...
