Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rwnetwork
Creator
Creator

Token | was not valid

Hello

Getting this error that I cannot figure out when a tas400input step runs into a tmap:

 

"select fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk
from data.fpf fpf​
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp​
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst​
where fdstcd = '"+((String)globalMap.get("X.State"))+"'​
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'​
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'​
and fddgrp = '"+((String)globalMap.get"(X.Group"))+"'​
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'​
and fddate = (​
Select Max(fddate) from data.fpf fpf ​
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp​
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst​
where fdstcd = '"+((String)globalMap.get("X.State"))+"'​
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'​
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'​
and fddgrp = '"+((String)globalMap.get("X.Group"))+"'​
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'​
)​
group by fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk"

 

Any suggestions please?

0683p000009M90I.png0683p000009M8xx.png

Labels (2)
1 Solution

Accepted Solutions
rwnetwork
Creator
Creator
Author

Letting community know I figured this out. 

There were non compliant characters coming through in the query.  I copied and pasted the code from an email and in turn, it brought in odd and invisible characters.  I placed the query in notepad++ and stepped through the query and edited it.

View solution in original post

1 Reply
rwnetwork
Creator
Creator
Author

Letting community know I figured this out. 

There were non compliant characters coming through in the query.  I copied and pasted the code from an email and in turn, it brought in odd and invisible characters.  I placed the query in notepad++ and stepped through the query and edited it.