Variable Creating weird Problem

[krishna20]

Hi Folks,

My Variable in APP is creating weird issue.

In Variable overview I declared values.

vADMINNTNAME = '001\A','002\B','003\C','004\D';

Dummy:
LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1
RESIDENT ADMINUser;

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0);

Test:

LOAD distinct concat(Chr(39)&NTNAME&Chr(39),',') as USER1
Resident Security
Where ACCESS = 'USER'
and wildmatch(upper(NTNAME),$(vADMINNTNAME))=0;

In the above script $(vADMINNTNAME) is creating issue.

I have not changed anything. The same code is using in two different environments.The application is not reloading .  It's working in one environment and not in another environment.

Log file :

Where ACCESS = 'USER'

03/08/2016 19:49:35: 0289 and wildmatch(upper(NTNAME),)=0

03/08/2016 19:49:35: Error: Error in expression:

I tried by using '$(vADMINNTNAME)' also , app is refreshing fine but objects are overlapping to users.

Please anyone can light up on this issue.

Updated log file error :

[krishna20]

The same code is finely running in testing but not in production.

[Anonymous]

where is the difference between resident ADMINUser on TEST and PROD?

your log comes from TEST and Shows that vADMINNTNAME is empty

debug your code and look what is invariable after this line

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0);

[krishna20]

No coding difference between TEST and PROD.

I just copied file from TEST to PROD. This issue is raised. I tried to debug, it's show the same.

[Anil_Babu_Samineni]

Wildcard looks , Try to remove or add that Variable over there

[krishna20]

Hi Anil,

It not works.

[Mark_Little]

Hi,

From the screen grab above you can see that your variable is not being populated.

thus the part wildmatch(upper(NTNAME),)=0

I would try the below.

Dummy:
LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1
RESIDENT ADMINUser;

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0,'Dummy');

Trace $(vADMINNTNAME);

Test:

LOAD distinct concat(Chr(39)&NTNAME&Chr(39),',') as USER1
Resident Security
Where ACCESS = 'USER'
and wildmatch(upper(NTNAME),$(vADMINNTNAME))=0;

If the variable is still not being populated then you need make Sure you are getting the required data in the ADMIN_NTNAME1 field.

Add an exit script after the Resident and check what values are in the field.

Mark