• ...
  • Searching Availability and Calculating Your Best Vacation Deal.
  • Prefer to Call? Give us a Ring at 1.800.309.4717
New Reservation - Shopping Results - All Inclusive Vacation Packages by Vacation Express

There was an error processing your request
modShop.SeqList() Failed:
System.Exception: modFIT.FITJSONSeqList() Failed:
modShop.GetAllProducts() Failed:
Could not get products (hlp.PRODUCTS):
<?xml version="1.0" encoding="utf-8"?><Response TransType="HLP.PRODUCTS" ServerID="" SessionID="B:3366C01A-282C-42B0-A76F-8AEDEA34C6E9" Error="Y"><ProcessingTime>0.0130</ProcessingTime><ErrorMessage>clsSession.ProcessRequest() Failed:
modHelper.GetAllProducts() Failed:
Could not find any ProductCodes: clsDBAccess.DBSearch() Failed:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Query: SELECT
Product.ProductCode,
Product.ProductName,
Product.AirIncluded,
Product.AirInfo,
Product.BegDate,
Product.EndDate,
Product.NumDays,
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN '0' AND '9ZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'A' AND 'AZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'B' AND 'BZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'C' AND 'CZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'D' AND 'GZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'H' AND 'KZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'L' AND 'LZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'M' AND 'MZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'N' AND 'PZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'Q' AND 'RZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'S' AND 'SZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'T' AND 'VZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) +
dbo.fn_AggConcat(DISTINCT CASE WHEN ISNULL(CC.Description, '') BETWEEN 'W' AND 'ZZZZZZZZZ' THEN ISNULL(CC.Code, '') + '=' + ISNULL(CC.Description, '') + '|' ELSE '' END) AS AirFromCities
, CASE WHEN Product.AirCities = '[ALL]' OR ISNULL(Product.AirCities,'') = '' THEN 'ALLCITIES'
WHEN Product.AirCities = '[ALLUS]' OR Product.AirCities = 'US' THEN 'USCITIES'
ELSE 'SPECIFICCITIES'
END CityType
FROM
Product WITH (NOLOCK)
LEFT JOIN PricingProfiles WITH (NOLOCK)
ON PricingProfiles.ProductCode = Product.ProductCode
LEFT JOIN CityCodes CC WITH (NOLOCK)
ON CC.Outbound = 'Y'
AND (',' + ISNULL(CC.Grouping, '') + ',' LIKE '%,VACEXPRESS,%' OR ISNULL(CC.Grouping, '') = '')
AND
(
',' + Product.AirCities + ',' LIKE '%,' + CC.Code + ',%'
)
WHERE
DATEADD(d, 0, DATEDIFF(d, 0, GETDATE())) BETWEEN Product.BegBDate AND Product.EndBDate AND ISNULL(Product.DateSpecific, '') <> 'Y'
AND ',' + ISNULL(PricingProfiles.BrandID, '') + ',' LIKE '%,VACEXPRESS,%'
AND Product.ProductType IN ('L') AND Product.ProductCode NOT LIKE 'INSURANCE%' AND Product.ProductCode NOT LIKE 'SHIPPING%' AND Product.ProductCode NOT LIKE 'TRFPU%' AND Product.ProductStatus IN ('ACTIVE')AND Product.ProductCode IN (SELECT ProductCode FROM TOCDetails WHERE GroupID IN (SELECT DISTINCT GroupID FROM TOCHeader WHERE GroupID LIKE 'DESTINATION%' AND Brands LIKE '%VACEXPRESS%')) AND Product.ProductCode IN (SELECT ProductCode FROM PricingProfiles WITH (NOLOCK)WHERE ',' + BrandID + ',' LIKE '%,VACEXPRESS,%')AND Product.ProductCode IN (SELECT ProductCode FROM PricingProfiles WHERE ',' + BrandID + ',' LIKE '%,VACEXPRESS,%') GROUP BY Product.ProductCode,
Product.ProductName,
Product.AirIncluded,
Product.AirInfo,
Product.BegDate,
Product.EndDate,
Product.NumDays , Product.AirCities

ORDER BY
Product.ProductName,
Product.ProductCode</ErrorMessage></Response>
at SoftripNet.modFIT.FitJSONSeqList(clsSession& oU, String strSeqListResults)
at SoftripNet.modShop.SeqList(clsSession& oU, String strAirItin, String strAirResults, Boolean blnReprice)

Back

Certified by

  • Lloyds of London logo

Get deals to your inbox