Untitled Document
Results 1 to 2 of 2

Thread: DBISAM Error after upgrading

  1. #1
    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.

  2. #2

    Join Date
    Apr 2004
    Posts
    16,462
    SYSOPS is offline
    Error typically means the database is damaged. You can try to restore the backup that was made during the update. Alternately, you can create a new database.

    The backup would have been made in the database\backup folder

    To restore,
    Shut all ShipRush related items down
    Rename the database folder
    Create a new folder called database
    Use the ShipRush DB Manager tool in the program files\zf\shiprush folder
    Use the restore function and browse out to the backup that was made before, in the renamed database\backup directory

    HTH,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •