SMTP Send Email

[StaHorse]

Hi,

I have this code:

LET vQwcConnectionName = 'lib://SMTP';
LET vSMTPServer = 'mail.company.co.za';
LET vPort = '25';
LET vSSLMode = 'None';
LET vTo='hosea.motshwaedi%40company.co.za';
LET vSubject = 'There+are+' & '$(vCheck)' & '+failed+reloads+on+SRV009865';
LET vHTML = 'True';
LET vFromName = 'qliksense%40company.co.za';
LET vFromEmail = 'qliksense%40company.co.za';
LET vCC = 'Lezaan.Oosthuizen%40company.co.za';
LET vIgnoreProxy = 'False';
LET vMessage = peek('email_text',-1,'Emails');

IF $(vCheck) > 0 THEN

SMTPConnector_SendEmail:
LOAD
status as SendEmail_status,
result as SendEmail_result,
filesattached as SendEmail_filesattached
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5556/data?connectorID=SMTPConnector&table=SendEmail&SMTPServer=$(vSMTPServer)&Port=...], qvx);

END IF;

DROP TABLE Emails;

when I Load it I get this error:

[ogster1974]

looks like your vCheck variable isn't being populated.  check where its being set and either debug it or add a trace.

TRACE 'vCheck: $(vCheck)';

[StaHorse]

---

@ogster1974 wrote:

looks like your vCheck variable isn't being populated.  check where its being set and either debug it or add a trace.

TRACE 'vCheck: $(vCheck)';

---

I have this code that runs before the above:

NoConcatenate
FailedReloads:
LOAD
Id,
LogTimeStamp as ErrorTime,
Hostname as ErrorHost,
"Task Name" as FailedTask,
"App Name" as FailedApp,
"Reload Status" as Failed,
Message as Message,
rowno() as FailedRow
resident TCheckReloadTasks
where LogTimeStamp > '$(vLastCheck)'
and "Reload Failure" = 1;

store FailedReloads into [$(vReadStorePath)failedreloads.xls](txt);

LET vCheck=NoOfRows('FailedReloads');

TRACE vCheck = $(vCheck);

drop table TCheckReloadTasks;

[ogster1974]

So I take it from this Failed reloads isn't being populated because you have no tasks that have failed.  

have you checked this?