When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown
Trailblazer Community

When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown

Apex , API

Last updated 2020-05-28 ·Reference W-2330031 ·Reported By 413 users

Fixed

Summary
When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown from an Apex class with API version 28.0+

- Actual Result.
Throw error message "No such column 'LastViewedDate' on entity <entity-name>"

- Expected Result.
No error message thrown, SOQL query executed without error.

Repro
1) Create two Apex classes:
a) "thisIs27" that should use API version 27.0
b) "thisIs28" that should use API version 28.0.

thisIs27:
-----------------------------
public class thisIs27{
public void myQuery(){
String queryS = 'select id from contact';
database.query(queryS);
}
}
-----------------------------

thisIs28:
-----------------------------
public class thisIs28{
public void myQuery(){
String queryS = 'select lastVieweddate from Contact';
Database.query(queryS);
}
}
-----------------------------

2) Then go to the Developer Console and run the following Apex code:

thisIs27 v27 = new thisIs27();
thisIs28 v28 = new thisIs28();
v27.myQuery();
v28.myQuery();

3) After executed it, we get error: "No such column 'lastvieweddate' on entity 'Contact'"

4) Notice that if we change the order of the last two lines the code executes without error:

thisIs27 v27 = new thisIs27();
thisIs28 v28 = new thisIs28();
v28.myQuery();
v27.myQuery();

Workaround
Update the API version of every Apex classes to 28.0 and above.

Updates
This issue has been fixed by the 'Enable improved caching of org schema' critical update.

See release notes here, https://releasenotes.docs.salesforce.com/en-us/summer20/release-notes/rn_apex_enable_improved_schema_caching.htm
Knowledge Article, https://help.salesforce.com/articleView?id=000353660&language=en_US&type=1&mode=1

Reported By (413)

Priyanka Gajera Siva Palanivel Petr Chvala Nithun Gangula Donald Blay Ryan Gardiner DEV WIN Support Julien Gaiotto قمر شليله bot مجموعةمنصةشليله Jason Hartfield thomas antony Garima Agrawal RITIKA TUTEJA Vedant Gupta Saurav Kumar Ross Goldberg Anil Malneni Jose Modequillo Jr Andrew Weinstein Simran Suri Davie Ching Jia Yong Zeng Gabe Terrell Michael Grzych Pranil Sarode Prakash Dandapani (MCS) Justin Fleming Camilo Diaz Antonio Grassi Maiquel Cabrera Derek Hawley Ritika Tuteja wade liu Departamento de RR.HH. Centros Comerciales Carrefour Alexander Sullivan Saurabh Kumar Brian Chong Candice Fidino si MALAKOFF Jaswanth Kambhampati Tom Anderson David Esposito Surya Reddy Eric Kintzer Alan Nicolas (MCS) David O'Connor Marina Shuman Jeff Isom Keith Roberts Eswara Naidu Benefit Harbor services Abhishek Kulkarni Ahmada Abdullah Glen De Marcos Yesenia Fiorella Penaranda Cordero Scott Taylor Gerene Tan Leslie Linard Md Babul Hossain Brian Christian Mert Yalti Cruse Ash AnilKumar Kota Log Processor Sahil Kumar Chun Wei Lee Ben Repak Moiz Nagpurwala Joan Aparicio Matthew Souther Mayra Rock Debesh Mishra Stiliyan Stanev Henry Lilleberg Sai Pedasanaganti Nuria Paniagua Jeff Levy Gordon Arnold May Lam Adrienn Kovacs Marcio Andrade Miroslav Huska Delphine Foo-Matkin Ken Neff Facundo Capdebila Guille Zana Vimarsh Karbhari Oscar Perez Jesús Iglesias Fermín Campo Fermin Campo Cristina Matías Dileep Tandra Roger Shen Savannah Baratta Joshua Meyer Raja Valeti Mario Jimenez Kate Bischoff PolSource Brian Dowell Angus Alves Tyler Law Anand Veeramani Vijay Mohan Neal Gelderman Gina Cockrum Casey Keeling Sravya Andru Audrey Cargill Janine Braungart System Admin Glenn Rymenans Talent Peaks Stephane HERMET Maverick Lemonnier Tariq Asghar Nilam Patel Bartosz Wojciechowski Mark Stevens Derhyk Doggett Anna Moskalenko Steven Blackwell Pankaj Paryani Dorota Kluszczyńska Tomasz Murawski Marcin Pieńkowski Anna Michoń Malgorzata Dziewinska Jakub Paduszyński Michał Cnota Maciej Fojt Paweł Zabczyński Paweł Zagraba Meytal Loyfer Disha Bhagchandani Paul Narsavage Detlef Rahlf Erdem Tokmakoglu Tugce Sirin Brett Gibson (Clouding Around) Synefo Brian Landvogt Matt Hanagan Emily Tam Jorne Van Landschoot Shraddha K Avrio Admin JR Timberlake Vijaya Kumar Basa Youchen Wu Kalin Gilman OCE Admin Taylor Johnson OCE Admin Jim Morrow Anthony Sanchez Sriram Penkey Narayanan Lakshmanan Ankit Aggarwal Martin Brennan Phil Bergner Anand Chaturvedi Cyprien CHAUVIERE James Thompson joost karsten Amit Sharma Gulam Sabir Khan Aurélien FONTAINE Equipo Accenture Rajat Mittal Julie Hallstrom Rodrigo Domingues RODRIGO DOMINGUES Fabian Off Katarzyna Karabowicz Manthan Shah Gary Chan Matthew Holliday Matteo Orsenigo Lucas Louf Eirik Skeid Satoshi Nagatsuka David Johnson Teemu Ahonen Claire Oestreicher Avani Manne Hector Cabrera Diaz Vishal Jaiswal Marina AUTIN Arvind Aiah Sterling Keaton Raymond Ensley Nathan Hinchey Dan Crowdus Stanley Zapata Celeste Young Stanley Zapata Bhuvaneswary R Wijnen Robin Sarah McCaig Sergio Alcocer Vazquez Mauro Barincelli Prashant Gupta Jonathan Shinn Sebastien Sansom Lorie Miller Rachel Chand Anirudh Singh Carol Rathbun Angel Castro SANJEEV BATHINI VARMA SRIDATLA Meryem Serraj Andaloussi Jay Kapadia Shyam Kannapiran Vijay kumar Basa ROBERT CAMPBELL Sitaram Srivatsavai Andy Luciani Tay Tufenkjian Patrick Watkins Aditi Deshpande James Ellis Christian Menzinger Christian Szandor Knapp Eric Kintzer Pankaj Hingane James Melville Prabushanker K Melissa Meyers System Administrator David Habib Endiem Admin Finian O'Driscoll James Hadfield Daniel Temple Pedro Molina Hector Rodriguez Esparza Priya Marupudi Ken Human System Administrator (PK) Nathan Pilkington William Linke Fernando Herrero Brad Ciszewski sravanthi bhavanam Michael Slawnik Javier Perez Pim Uijttewaal Satoshi Takezawa NOU Sovatthymony Gustavo Tandeciarz Tiffany DeYoung Aldo Enrique Lezama Lainez Jérôme MIGNEE Anusha Vuyyuru Candy Weekes Brian Beck Craig Ceremuga Tim Skoch Brenden Wells Harri Vuori Eric Grust Kelly Song Austin Turner Chad Joubert Ajit Verma Tyler Johnston Scott Stith A Admin Marco Falconi Peter Kavanagh Willem Mulder Mohith Shrivastava Trifecta Developers Guy Snitovsky Rinku Daxini Carl Brundage (Inactive) Boss Admin Eric Stansbury Daniel Ballinger Scott Geosits Angus Thompson Nick Gibson Erin Fink Suman Banerjee Aurélien Lacenaire Austin Delorme Mohammad Unte Swayam Chouksey Craig Hayashi Matthew Soleyn Chris Minerd System Admin JD Yad Jayanth Bruce VanBuren Skye Evans Karla Smagorinsky Allison Klein David Habib PatronTech Admin Sean Barenbrugge Deepanjan Chattopadhyay Davide Redaelli Santo Scaccianoce Pasquale Romeo Dimitri Suls Nisar Ahmed Deloitte User Nerissa Tong Jacqui Lloyd Kathir Radhakrishnan Josef Kral Rosalind Holland Victor Hanson 李 志新 Behzad Bahadori Gene Izydorczyk Admin User Robin Ridgely Charlie Halpin John Thompson Manish Thaduri Nitin Sahgal Caleb Brandon Philip Nelson Harry Radenberg Gears CRM Armando Meeuwenoord Mike Gallagher Ashok Kumar Nagaleekar Yuying Chen Scott Covert Jonathan de Vries Catering 608022 Abhijit Shrikhande Product Services Abby Jones Mark Morris Susan Sparks Amy Read Sian Bradley Chloe Stephenson Javier Coca Samantha Brennand Yulia Brereton Chris Peterson Wahsitee Chongchua Diane MacRobie Vertiba Admin Arpan Patel Etude Developpement Ajay Anikar Jahanzeb Hashmi Robert Soesemann Rob Muschiana Prasad Ruwanpathirana Thomas Koegl Manish Thaduri Raj Yanambakkam Tom Fuda Blake Smith Rajpal Singh Capstorm David Habib David Robison Vish Goki Russell Potter SHAWN TAYLOR Osama Nasir Rajesh Krishnaiah Grady Duncan Ramesh Yellanki Ethan Weitz WisdomEdge Team Scott Wells Richard Blake Cloud62 Cloud62 Lukasz SKRODZKI David Sparks Tami Lau System Administrator MIS Business Analysts Matt Gvazdinskas Dan Moore David Henriquez Lissa Smith Jed Micka Eric Kong Kristoffer Jacobsen Stephen Hill Taylor Pariseau Weinheimer Shaun McInerney Mauricio 7demo Zach McElrath Hiren Patel Chirag Mehta Vigneswaran Sugumaran Melissa Hansen Michael Smith (DO NOT USE) Benj Kamm David Tondreau Jeff Clark Long Lam Holt Farley Vinylume Inc Adith Srinivasan kenichiro imasawa Paul Kissick sfpsdev Leslie Linard Nicolas Palitzyne

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP10 AP11 AP12 AP13 AP14 AP15 AP16 AP17 AP18 AP19 AP20 AP21 AP22 AP28 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS119 CS110 CS117 CS114 CS113 CS112 CS111 CS11 CS116 CS12 CS122 CS121 CS126 CS127 CS129 CS128 CS125 CS124 CS123 CS137 CS138 CS13 CS133 CS132 CS14 CS148 CS142 CS15 CS152 CS151 CS165 CS16 CS169 CS17 CS18 CS194 CS19 CS198 CS196 CS195 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS29 CS30 CS31 CS32 CS33 CS34 CS35 CS36 CS37 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS93 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 EU27 EU28 EU29 EU30 EU31 EU32 NA104 NA107 NA109 NA100 NA101 NA103 NA102 NA105 NA119 NA116 NA110 NA118 NA112 NA111 NA115 NA114 NA113 NA117 NA125 NA124 NA122 NA120 NA126 NA127 NA123 NA129 NA121 NA128 NA138 NA134 NA133 NA136 NA135 NA132 NA131 NA130 NA137 NA139 NA140 NA142 NA141 NA146 NA147 NA148 NA154 NA155 NA172 NA174 NA171 NA173 NA196 NA21 NA46 NA47 NA49 NA52 NA54 NA57 NA58 NA59 NA61 NA62 NA65 NA66 NA67 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA97 NA98 NA99 UM1 UM2 UM3 UM4 UM5 UM6 UM7

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.