PDA

View Full Version : Settings and Rate Quote not working



JamesB
05-18-2016, 03:27 AM
We're getting errors when either clicking on "Settings" section of the site, or when we try to do a rate quote. If we select a specific service type, and click "rate" that does work, but a general query across all services by clicking the magnifying glass does not work at all.

Rvanpeeren
05-18-2016, 04:55 AM
Same here.

This is the error message:
could not execute query
[ SELECT top 1 this_.pbCatalogId as pbCatalo1_32_0_, this_.accountId as accountId32_0_, this_.merchant as merchant32_0_, this_.senderId as senderId32_0_, this_.enabled as enabled32_0_, this_.setupCompleted as setupCom6_32_0_, this_.applicationSubmitted as applicat7_32_0_, this_.ftpUsername as ftpUsern8_32_0_, this_.ftpPassword as ftpPassw9_32_0_, this_.apiUsername as apiUser10_32_0_, this_.apiPassword as apiPass11_32_0_, this_.issueId as issueId32_0_, this_.phone as phone32_0_, this_.email as email32_0_, this_.filename as filename32_0_, this_.confirmationCode as confirm16_32_0_, this_.status as status32_0_, this_.uploadedAt as uploadedAt32_0_, this_.completedAt as complet19_32_0_, this_.lastCheckedAt as lastChe20_32_0_, this_.rateQuoteSelectedCoutriesOnly as rateQuo21_32_0_, this_.rateQuoteCoutries as rateQuo22_32_0_, this_.rateQuoteQuantity as rateQuo23_32_0_, this_.routeIntlShipment as routeIn24_32_0_, this_.routeToSelectedCoutriesOnly as routeTo25_32_0_, this_.routeCoutries as routeCo26_32_0_, this_.apiVersion as apiVersion32_0_ FROM PBCatalog this_ WHERE this_.accountId = @p0 ]
Name:cp0 - Value:c2155bf7-b15d-4a23-ac9e-a51501131e89
[SQL: SELECT top 1 this_.pbCatalogId as pbCatalo1_32_0_, this_.accountId as accountId32_0_, this_.merchant as merchant32_0_, this_.senderId as senderId32_0_, this_.enabled as enabled32_0_, this_.setupCompleted as setupCom6_32_0_, this_.applicationSubmitted as applicat7_32_0_, this_.ftpUsername as ftpUsern8_32_0_, this_.ftpPassword as ftpPassw9_32_0_, this_.apiUsername as apiUser10_32_0_, this_.apiPassword as apiPass11_32_0_, this_.issueId as issueId32_0_, this_.phone as phone32_0_, this_.email as email32_0_, this_.filename as filename32_0_, this_.confirmationCode as confirm16_32_0_, this_.status as status32_0_, this_.uploadedAt as uploadedAt32_0_, this_.completedAt as complet19_32_0_, this_.lastCheckedAt as lastChe20_32_0_, this_.rateQuoteSelectedCoutriesOnly as rateQuo21_32_0_, this_.rateQuoteCoutries as rateQuo22_32_0_, this_.rateQuoteQuantity as rateQuo23_32_0_, this_.routeIntlShipment as routeIn24_32_0_, this_.routeToSelectedCoutriesOnly as routeTo25_32_0_, this_.routeCoutries as routeCo26_32_0_, this_.apiVersion as apiVersion32_0_ FROM PBCatalog this_ WHERE this_.accountId = @p0]

SYSOPS
05-18-2016, 06:28 AM
We are investigating. Case 51819

Thank you,
SYSOPS

SYSOPP
05-18-2016, 06:29 AM
We believe this is resolved. Please give a look!

JamesB
05-18-2016, 06:30 AM
Seems to be back to normal now. Thanks!