We have has issues with our SOAP integration. After upgrading from Shiprush 11 to 11.2 sending XML shipments via the webservice returns the following error:
DBISAM Engine Error # 11949 SQL parsing error - Expected column name but instead found C.MyShipRushShippingAccountId in SELECT SQL statement at line 1, column 2709
SQL: SELECT C.BOLD_ID, C.BOLD_TYPE, C.UPSAccount, C.Activated, C.EIN, C.PackageSeqNumber, C.bIntlShipperAgreement, C.DimWeightFactor, C.IntlDimWeightFactor, C.LabelPrinterName, C.ManifestPrinterName, C.LabelPrinterType, C.RequestNumber, C.LabelHorizontal, C.RefPointX, C.RefPointY, C.Density, C.PrintInvoice, C.PrintNAFTA, C.PrintSED, C.IsDefault, C.PrintCO, C.IsPrimary, C.NAFTACopies, C.InvoiceCopies, C.SEDCopies, C.COCopies, C.ExchangeCollect, C.BasicFlex, C.ExpandedFlex, C.TNTFlex, C.QVInbound, C.ExtendedNotif, C.AdvancedSettings, C.DefaultShipNotificationChecked, C.DefaultExceptionNotificationChecked, C.DefaultDeliveryNotificationChecked, C.DefaultDeliveryNotificationEmail, C.DefaultExceptionNotificationEmail, C.DefaultShipNotificationEmail, C.EnableFaxNotifications, C.XMLAccessLicenseNumber, C.XMLUserID, C.XMLPassword, C.XMLDeveloperLicenseNumber, C.CWTBundleType, C.CWTAirMax, C.CWTGroundMax, C.FDXExpressAccount, C.FDXGroundAccount, C.FDXMeterNumber, C.FedExSignatureReleaseNumber, C.AIBAccount, C.AIBKey, C.Carrier, C.PrintPOA, C.POACopies, C.Suspended, C.FDXExpressAvailable, C.FDXGroundAvailable, C.FDXHideFreight, C.SecondaryAccount, C.PrinterOverride, C.PrinterType, C.PrinterName, C.DefaultTaxID, C.DefaultTaxIDType, C.ISCSeeds, C.ISCPerishables, C.ISCTobacco, C.ISCPlants, C.ISCAlcohol, C.ISCDiagSpec, C.ISCSpecExcept, C.EWSTestLabelsMode, C.EWSUSPSInsurance, C.EnableExtendedInsurance, C.USPSSkipRateRequest, C.EWSSuppressPostage, C.DefaultDutiesPaidBy, C.EWSShowReturnAddress, C.EWSValidateAddress, C.EWSPrintPostageOnLabel, C.DHLAtHomeFlag, C.PaperlessInvoice, C.ThirdCountryContract, C.DHLIntlKey, C.DHLAtHomeKey, C.EWSPickupConfirmation, C.EWSPickupDate, C.EWSPickupInstructions, C.EWSPickupItemsLocation, C.FDXEnableSmartPost, C.CWTEnabled, C.CWTTier, C.EWSWarnThreshold, C.BankName, C.BankAccountType, C.BankAccountHolderName, C.AccountType, C.InsuranceEulaAccepted, C.StampsAccountType, C.UploadDocuments, C.UploadCO, C.UploadInvoice, C.UploadNAFTA, C.AutoPrintReturnLabel, C.DefaultReturnLabelWeight, C.DefaultReturnLabelService, C.AutoPrintReturnLabelCTRL, C.StandardToMexico, C.ARUseDefaultWeight, C.ARUseOutboundWeightFirst, C.ARUseOutboundWeightAll, C.ARNoReference, C.ARUseOutboundReference, C.ARSetDefaultReference, C.ARDefaultReference, C.DefaultFTR, C.UseAccountBasedRates, C.UPSInvoiceAuthenticated, C.UseListRates, C.UseDailyRates, C.UseRetailRates, C.ARUseTemplate, C.ReturnShipmentTemplate, C.DefaultTermsOfShipment, C.AutoUpgradeService, C.AutoUpgradeServiceMode, C.AutoUpgradeServiceThreshold, C.UpgradeServiceOld, C.UpgradeServiceNew, C.FedExOneRateOption, C.FDXEnablePriorityAlert, C.PrepaidReturnEnabled, C.ARPayOnUseReturn, C.MyShipRushShippingAccountId, C.UPSSettings, C.Notification, C.EmailSettings, B.READ_ONLY FROM Account C left join ZFRM_OBJECT B on (B.BOLD_ID = C.BOLD_ID) WHERE C.BOLD_ID = :ID1
Any suggestions in how to address this gratefully received.
Bookmarks