An ECRWeb application error has occured.
The information passed in to the application was:
Name: Value:
CLIENTSIMUC
CONFIGIDBUYER
ECRTYPE**
SAUCIBELA
SLANE40
SRUN11
SSALE19
SSLEYR2010
ECRWeb Display Error
  • PreparedStatementCallback; bad SQL grammar [select T1.SSER17 as vin, T1.sdtesl as saleDate, T1.sdterd as redemptionDate, T1.SSERL6 as lastSixVin, T1.SWO# as workOrderNum, T1.SBLU as uniqueId, T1.SSLR#U as sellerUnivNum, T1.SBUY#U as buyerUnivNum, T1.SSLEYR as saleYear, T1.SSALE# as saleNum, T1.SLANE# as laneNum, T1.SRUN# as runNum, T1.SSTK# as stockNum, T1.SLSEAC as leaseAcctNum, T1.SINV# as invoiceNum, T1.SSELLR as sellerNum, T1.SSELLN as sellerName, T1.SBUYEN as buyerName, T1.SBUYER as buyerNum, T1.SANNOU as announcements, T1.SREMAR as remarks, T1.SSLEPR as salePrice, T1.SDTERE as receivedDt, T1.SMSOTI as titleState, T1.SDTEFO as titleReceivedDt, T1.SDTEIS as inserviceDt, trim(T1.SBODY) as bodyCode, trim(T1.SGROUP) as groupCode, trim(T1.SPRIMCD) as businessUnit, trim(T1.SCOND) as preReconGrade, T1.SADJUSR as miscFields, trim(T1.SCARYR) as year, trim(T1.SMAKE) as make, trim(T1.SSUBSE) as subSeries, trim(T1.SMOD15) as model, T1.SMILES as odometer, trim(T1.STOP) as topType, trim(T1.SCOLOR) as exteriorColor, trim(T1.SINT) as interiorType, trim(T1.SINTCO) as interiorColor, T1.SODODIG as odometerDigits, trim(T1.SENG) as engineType, trim(T1.STRN) as transmission, trim(T1.SEL) as powerLocks, trim(T1.SPS) as powerSteering, trim(T1.SEW) as powerWindows, trim(T1.SES) as powerSeats, trim(T1.STILT) as tiltSteer, trim(T1.S4X4) as driveTrain, T1.SAC as airCond, T1.SCC as cruiseCtrl, T1.SRDEFR as rearDefrost, trim(T1.SRADIO) as radio, T1.SBAGS as sideAirBags, T1.SAB as airBags, T1.SPB as powerBrakes from masterf.pfpadtrn as T1 where T1.SAUCI = ? and T1.SSLEYR = ? and T1.SSALE# =? and T1.SLANE# = ? and T1.SRUN# = ? and T1.SBLU > 0 and T1.SCODE IN('SF', 'SP', 'SR', 'RC', 'SS', 'RR', 'VX') and T1.SBLU = X1.VBLU and T1.SAUCI = X1.VAUCI]; nested exception is java.sql.SQLException: [SQL5001] Column qualifier or table X1 undefined.
An Error has occured while processing your request. Please try your request again or contact Manheim support for further assistance.