BH.SURESH Member since 2014 15 posts
Posted: 3 years ago
Last activity: 3 years 10 months ago

Getting to Exceptions due to list view query difference in 7.1.7 compared to 6.2

Hi , We have a list view with declarative index join in 6.2 and 7.1.7 (Same list view in both versions) and they are forming queries as 6.2: SELECT "PC0".pxObjClass AS "pxObjClass", "Country".CTRY_CD AS "CountryCode", "PC0".pzPVStream AS "PC0pzPVStream", "PC0".PZINSKEY as "pxInsHandle" FROM pr_operators "PC0" JOIN AEXP_OPR_CTRY_IDX "Country" ON "PC0".pzInsKey = "Country".pxInsIndexedKey WHERE "PC0".pxObjClass = ? AND ( ( "Country".CTRY_CD = ? ) AND ( "PC0".PYWORKGROUP = ? ) ) AND "Country".pxIndexPurpose='OperatorCountryMap' 7.1.7: SELECT "PC0".pxObjClass AS "pxObjClass", "Country".CTRY_CD AS "CountryCode", "PC0".PYWORKGROUP AS "pyWorkGroup" , "PC0".PYEMAILADDRESS AS "pyAddresses(Email).pyEmailAddress" , "PC0".PYUSERIDENTIFIER AS "pyUserIdentifier", "PC0".PZINSKEY as "pxInsHandle" FROM PBSTD01.pr_operators "PC0" JOIN PBSTD01.AEXP_OPR_CTRY_IDX "Country" ON "PC0".pzInsKey = "Country".pxInsIndexedKey WHERE "PC0".pxObjClass = ? AND ( ( "Country".CTRY_CD = ? ) AND ( "PC0".PYWORKGROUP = ? ) ) AND "Country".pxIndexPurpose='OperatorCountryMap' Because of this we are getting ERROR " ** Column named pyAddresses(Email).pyEmailAddress was not found in SQL columns or embedded object " in 7.1.7 and so due to this exeception is getting raised and so getting into problem flow. But in 6.2 it is working fine. Can any one help me out. why same list view forming different queries? Thanks in advance.

***Updated by moderator: Lochan to add Categories***

Data Integration User Interface
Moderation Team has archived post
Share this page LinkedIn