since ‎05-08-2019
Online
ukender
Level 1
Re: Database Cleanup Issue
Avatar

ukender

ukender
- Adobe Campaign Classic
@wodnicki Thank you so much!

Views

11

Likes

0

Replies

0
DB Cleanup Issue
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

28

Likes

0

Replies

0
Database Cleanup Issue
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

98

Likes

0

Replies

2
Re: 554 IP name lookup failed. No PTR record found
Avatar

ukender

ukender
- Adobe Campaign Classic
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!

Views

126

Likes

0

Replies

0
Re: OOB Schema Issue - Nms:CouponValues
Avatar

ukender

ukender
- Adobe Campaign Classic
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)

Views

150

Likes

0

Replies

0
554 IP name lookup failed. No PTR record found
Avatar

ukender

ukender
- Adobe Campaign Classic
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!

Views

144

Likes

0

Replies

3
Re: OOB Schema Issue - Nms:CouponValues
Avatar

ukender

ukender
- Adobe Campaign Classic
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!

Views

171

Likes

0

Replies

0
Re: OOB Schema Issue - Nms:CouponValues
Avatar

ukender

ukender
- Adobe Campaign Classic
Hi Adithya - Thanks for the response. Yes - It is on-premise. Could you pls help me how to regenerate the schemas? Thank you!

Views

178

Likes

0

Replies

0
OOB Schema Issue - Nms:CouponValues
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

190

Likes

0

Replies

8
Re: Low Success Rate
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

207

Likes

0

Replies

0
Re: Low Success Rate
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

243

Likes

0

Replies

0
Re: Low Success Rate
Avatar

ukender

ukender
- Adobe Campaign Classic
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!

Views

225

Likes

0

Replies

0
Re: Low Success Rate
Avatar

ukender

ukender
- Adobe Campaign Classic
Hi @manoj, Thank you for the suggestion. Could please let me know how to check whether we are using advanced MTA?FYI - We are using the below version.

Views

231

Likes

0

Replies

0
Low Success Rate
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

359

Likes

0

Replies

11
Re: SMTP Configuration
Avatar

ukender

ukender
- Adobe Campaign Classic
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!

Views

197

Likes

0

Replies

0
Out of Memory - JS
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

330

Likes

0

Replies

3
Schema / Table Usage
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

198

Likes

0

Replies

2
Re: SQL Error - Admin Console
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

349

Likes

0

Replies

0
Re: SQL Error - Admin Console
Avatar

ukender

ukender
- Adobe Campaign Classic
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'...

Views

382

Likes

0

Replies

0
SQL Error - Admin Console
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

405

Likes

0

Replies

5
Re: Negative values in autopk field
Avatar

ukender

ukender
- Adobe Campaign Classic
Hi @Milan_Vucetic Thanks I really appreciate it. could you please let me know how to check XtkNewId impacted tables?

Views

250

Likes

0

Replies

0
Re: Adobe Campaign Classic - Sequences Exhaustion
Avatar

ukender

ukender
- Adobe Campaign Classic
Hi AllCould any one help me with the script please.Thanks in advance Ukender

Views

647

Likes

0

Replies

1
Re: Negative values in autopk field
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

259

Likes

0

Replies

0
Re: Font Rendering Issue in Outlook - ACC
Avatar

ukender

ukender
- Adobe Campaign Classic
We have delivered the template with closest matching fonts. 

Views

202

Likes

0

Replies

0
Re: Font Rendering Issue in Outlook - ACC
Avatar

ukender

ukender
- Adobe Campaign Classic
Thank you for the suggestions, we have delivered with closest matching font.

Views

300

Likes

0

Replies

0
Negative values in autopk field
Avatar

ukender

ukender
- Adobe Campaign Classic
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

Views

280

Likes

0

Replies

4
Re: XML-110018 Error while parsing XML string
Avatar

ukender

ukender
- Adobe Campaign Classic
Yes Please check your inbox. Thanks!

Views

856

Likes

0

Replies

0
Re: XML-110018 Error while parsing XML string
Avatar

ukender

ukender
- Adobe Campaign Classic
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 😞

Views

863

Likes

0

Replies

0
Re: XML-110018 Error while parsing XML string
Avatar

ukender

ukender
- Adobe Campaign Classic
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 .

Views

873

Likes

0

Replies

0
Re: XML-110018 Error while parsing XML string
Avatar

ukender

ukender
- Adobe Campaign Classic
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...

Views

885

Likes

0

Replies

0