cancel
Showing results for 
Search instead for 
Did you mean: 
Twi
Level 2

Quickbooks Pro 2024 error codes when shipping FedEx

We just upgraded to Desktop Pro 2024 and the FedEx shipping manager is getting Error codes.  It is along error that starts with this code: DBISAM Engine Error # 11949 SQL parsing error - 

 

We can't ship anything through QB until this error gets resolved.

Solved
Best answer 4 weeks ago

Best Answers
Twi
Level 2

Quickbooks Pro 2024 error codes when shipping FedEx

@4Gal Level 10

 

Thanks for all the great advice.  I did talk to a great Intuit rep in Mexico City last night and we went through every procedure in this blog. We also ran the Fix and Repair Toolkit on our server (that stores the data) and in the individual desktops. We could not even uninstall the shipping manager or change any of the FedEx settings.  The rep also recommended going back to the last QB version which was the Desktop Pro 2023.

 

We had to uninstall the the 2024 versions and reinstall it on ALL computers. That seemed to be the solution. We do not get the error messages anymore and QB does integrate with FedEx so we can now make labels from the invoices. So we did not have to go back to the previous version in the end.  The whole process including all the fix recomendations took about a day. If anyone else has this problem just try to reinstall the 2024 program and see it works on one user.  If it does then you can change on all other (if you are set up for multi-users).

 

The only problem is the LegacyWrapper 32 integrated App from Microsoft does not work properly (this runs in the back ground of the shipping integration in QB).  Instead of automatically opening in QB when you use the shipping manager, it will open in the Windows system tray. This causes a multi step process to ship something. The LegacyWrapper 32 is also unstable in the current configuration. It will freeze up and when it does you must close QB and reopen it...which is very time consuming and inconvenient. This was a problem we have had since the 2023 upgrade and it has not been fixed.

 

Microsoft blames Intuit and Intuit blames Microsoft...in the meantime we the customers pay the price.  It is sad we have to pay thousands of dollars for the ALL upgrades every year and the upgrades cause more problems than the previous versions.

View solution in original post

13 Comments 13
4Gal
Level 10

Quickbooks Pro 2024 error codes when shipping FedEx

Run the Verify/Rebuild Data utility. Did you encounter any error message?

 

AlverMarkT
QuickBooks Team

Quickbooks Pro 2024 error codes when shipping FedEx

I appreciate you for reporting this issue in the Community, @Twi .

 

Upon checking on my end, our Product Engineers are working on a fix for the error you've encountered as of posting. However, I can still guide you through possible solutions to resolve this and route you to our Support Team if the problem persists. 

 

This issue is usually system-specific, and I highly recommend collaborating with your IT expert for the steps outlined below. 

 

One fix we can perform is to register the ShipRush OCX file. 

 

  1. Click on the Windows Start menu and select All Programs. Then, select Accessories.
  2. Right-click on Command Prompt and choose Run as Administrator.
  3. In your command prompt window you need to type this command to change your working directory and after that press Enter:
       a. cd c:\Windows\syswow64
  4. You need to type the following command in your command prompt window and press Enter to register the ShipRush file:
       a. regsvr32.exe “c:\Program Files (x86)\Common Files\Intuit\ShippingManager\ZRush_ShipRush9_QB.ocx”
  5. Click OK on the message that is displayed. 
  6. Reboot the computer and set up Shipping Manager again.

 

If this doesn't work, rename the Shipping Manager folders. You can follow these steps:

 

  1. Browse to the following folders in Windows File Explorer:
       a. C:\Program Files (x86)\Common Files\Intuit\ShippingManager
       b. C:\Users\[WindowsUserName]\AppData\Roaming\Intuit\ShippingManager
  2. Right-click on the folder name, choose Rename and add OLD to the end of the name (…ShippingManagerOLD).
  3. Repair/Reinstall QuickBooks.
  4. Reboot the computer even if not prompted. 
  5. Set up the Shipping Manager again. 

 

If you encounter the same problem shipping after the steps above, I'd recommend contacting our Support Team for further assistance. This way, you'll also be notified once the error you encountered is resolved. Here's how you can reach out to them:

 

  1. In your QBDT, go to Help, then select QuickBooks Desktop Help/Contact Us.
  2. Select Contact Us. Give a brief description of your issue, then click on Continue.
  3. Sign in to your Intuit account, select Continue and Continue with my account.
  4. We'll email you a single-use code. Enter your code and select Continue.
  5. Select to Have us call you.

 

If you need a guide for setting up and managing your inventory after the issue is resolved, let me add this article as a reference: Set up Advanced Inventory in QuickBooks Desktop

 

We'll be here in the Community if you have further updates on the error you encountered when shipping within the QBDT system. We'll do our best to assist.

Twi
Level 2

Quickbooks Pro 2024 error codes when shipping FedEx

Thanks 4Gal,

 

Unfortunately that did not work.  It find several other errors though.

 

I am going to try the new post from QB that came in next.

 

This is the complete error code we are getting:

 

DBISAM Engine Error # 11949 SQL parsing error - Expected column name but instead found CargoAircraftOnly in INSERT SQL statement at line 1, column 1955
SQL: INSERT INTO Package (BOLD_ID, BOLD_TYPE, PackageTrackingNumber, RatesTotal, LabelRoutingCode, LabelURCData, PackageActualWeight, DeliverToAttnName, DeliverToPhoneNumber, PackagingType, MerchandiseDescription, VoidInd, PkgPublishedDimWt, PkgLength, PkgWidth, PkgHeight, PackageReference1, AdditionalHandling, CODType, CODFunds, CODCurrencyCode, CODAmount, DCISType, InsuranceType, InsuranceAmount, InsuranceCurrency, VerbalConfInd, VerbalConfPhone, VerbalConfName, Oversized, PackageReference2, PackageReference3, PackageReference4, PackageReference5, SpecialInstructions, DialInd, RateWeight, ShipDate, LabelTrkURL, LabelFilename, LabelFormat, RateBaseCharge, RateAdditionalCharge, RateMarkup, IsTestPackage, PostponedWeight, AdvancedSettings, DryIceFlag, DryIceWeight, PkgHasDeliveryNotification, PkgHasExceptionNotification, PkgHasReturnNotification, PkgHasShipNotification, PkgHasShipNotificationFax, PkgShipNotificationEMail, PkgShipNotificationFaxNum, PkgDeliveryNotificationEMail, PkgExceptionNotificationEMail, PkgReturnNotificationEMail, ShipperRelease, AddFreightChargesToCOD, UPSServiceType, DeliveryAddress, SenderAddress, ARSType, ShipmentID, SuppTrkNumber, EMailLabelURL, EMailLabelDateTime, EMailLabelUserID, EMailLabelPassword, IsProcessed, HistCompany, HistName, NonStandardContainerFlag, Carrier, RateDiscount, Tracking_DeliveryStatus, Tracking_DeliveryDateTime, LabelPackedData1, LabelPackedData2, LabelPackedData3, LabelPackedData4, RateCarrierCharges, RateListAdditionalCharge, RateListBaseCharges, RateListCarrierCharges, EffectiveCarrierCharges, RateListDiscount, RatesListTotal, HistZIP, HistAddress1, PackageAdmissability, CODTrackingNumber, PkgHasInboundReturnNotification, PkgInboundReturnNotificationEmail, IsLargePackage, HoldForPickup, USPSCertifiedMail, USPSElectronicReturnReceipt, USPSAutomationRate, USPSMachinable, USPSShowReturnAddress, USPSReturnToSender, USPSGirth, ExternalTransactionId, CargoAircraftOnly, FDXPriorityAlertDetailContent, FDXPriorityAlert, RestrictedDelivery, RequireSignature, PkgHasInTransitNotification, PkgInTransitNotificationEMail, DeliveryConfirmation, FDXPriorityAlertPlus, Refrigeration, ProactiveResponse, ContainsBattery, BatteryMaterial, BatteryPacking, InsuredByShipRush, InsuranceCharges, FDXDangerousGoods, DryIceMedical, Shipment) VALUES (:BOLD_ID, :BOLD_TYPE, :PackageTrackingNumber, :RatesTotal, :LabelRoutingCode, :LabelURCData, :PackageActualWeight, :DeliverToAttnName, :DeliverToPhoneNumber, :PackagingType, :MerchandiseDescription, :VoidInd, :PkgPublishedDimWt, :PkgLength, :PkgWidth, :PkgHeight, :PackageReference1, :AdditionalHandling, :CODType, :CODFunds, :CODCurrencyCode, :CODAmount, :DCISType, :InsuranceType, :InsuranceAmount, :InsuranceCurrency, :VerbalConfInd, :VerbalConfPhone, :VerbalConfName, :Oversized, :PackageReference2, :PackageReference3, :PackageReference4, :PackageReference5, :SpecialInstructions, :DialInd, :RateWeight, :ShipDate, :LabelTrkURL, :LabelFilename, :LabelFormat, :RateBaseCharge, :RateAdditionalCharge, :RateMarkup, :IsTestPackage, :PostponedWeight, :AdvancedSettings, :DryIceFlag, :DryIceWeight, :PkgHasDeliveryNotification, :PkgHasExceptionNotification, :PkgHasReturnNotification, :PkgHasShipNotification, :PkgHasShipNotificationFax, :PkgShipNotificationEMail, :PkgShipNotificationFaxNum, :PkgDeliveryNotificationEMail, :PkgExceptionNotificationEMail, :PkgReturnNotificationEMail, :ShipperRelease, :AddFreightChargesToCOD, :UPSServiceType, :DeliveryAddress, :SenderAddress, :ARSType, :ShipmentID, :SuppTrkNumber, :EMailLabelURL, :EMailLabelDateTime, :EMailLabelUserID, :EMailLabelPassword, :IsProcessed, :HistCompany, :HistName, :NonStandardContainerFlag, :Carrier, :RateDiscount, :Tracking_DeliveryStatus, :Tracking_DeliveryDateTime, :LabelPackedData1, :LabelPackedData2, :LabelPackedData3, :LabelPackedData4, :RateCarrierCharges, :RateListAdditionalCharge, :RateListBaseCharges, :RateListCarrierCharges, :EffectiveCarrierCharges, :RateListDiscount, :RatesListTotal, :HistZIP, :HistAddress1, :PackageAdmissability, :CODTrackingNumber, :PkgHasInboundReturnNotification, :PkgInboundReturnNotificationEmail, :IsLargePackage, :HoldForPickup, :USPSCertifiedMail, :USPSElectronicReturnReceipt, :USPSAutomationRate, :USPSMachinable, :USPSShowReturnAddress, :USPSReturnToSender, :USPSGirth, :ExternalTransactionId, :CargoAircraftOnly, :FDXPriorityAlertDetailContent, :FDXPriorityAlert, :RestrictedDelivery, :RequireSignature, :PkgHasInTransitNotification, :PkgInTransitNotificationEMail, :DeliveryConfirmation, :FDXPriorityAlertPlus, :Refrigeration, :ProactiveResponse, :ContainsBattery, :BatteryMaterial, :BatteryPacking, :InsuredByShipRush, :InsuranceCharges, :FDXDangerousGoods, :DryIceMedical, :Shipment)

Twi
Level 2

Quickbooks Pro 2024 error codes when shipping FedEx

 

So I followed the steps on the "ShipRush OCX file" fix.  But got this message..

 

The module “c:\Program Files (x86)\Common Files\Intuit\ShippingManager\ZRush_ShipRush9_QB.ocx” was loaded but the call to DllRegisterServer failed with error code 0x800040005

 

I will try to contact the support team by phone. Although they had this report when we upgraded the system on Friday.  They had a copy of the error report and were supposed to call me back on Monday 4/22/24 but never did.  That is why i trying to resolve this issue in the forum.

 

4Gal
Level 10

Quickbooks Pro 2024 error codes when shipping FedEx

@Twi  

It find several other errors though.

 

Can you still open your company file on QB Desktop 2021? Run the Verify/Rebuild Data utility. Did you encounter the same error message?

Twi
Level 2

Quickbooks Pro 2024 error codes when shipping FedEx

@4Gal Level 10

 

Thanks for all the great advice.  I did talk to a great Intuit rep in Mexico City last night and we went through every procedure in this blog. We also ran the Fix and Repair Toolkit on our server (that stores the data) and in the individual desktops. We could not even uninstall the shipping manager or change any of the FedEx settings.  The rep also recommended going back to the last QB version which was the Desktop Pro 2023.

 

We had to uninstall the the 2024 versions and reinstall it on ALL computers. That seemed to be the solution. We do not get the error messages anymore and QB does integrate with FedEx so we can now make labels from the invoices. So we did not have to go back to the previous version in the end.  The whole process including all the fix recomendations took about a day. If anyone else has this problem just try to reinstall the 2024 program and see it works on one user.  If it does then you can change on all other (if you are set up for multi-users).

 

The only problem is the LegacyWrapper 32 integrated App from Microsoft does not work properly (this runs in the back ground of the shipping integration in QB).  Instead of automatically opening in QB when you use the shipping manager, it will open in the Windows system tray. This causes a multi step process to ship something. The LegacyWrapper 32 is also unstable in the current configuration. It will freeze up and when it does you must close QB and reopen it...which is very time consuming and inconvenient. This was a problem we have had since the 2023 upgrade and it has not been fixed.

 

Microsoft blames Intuit and Intuit blames Microsoft...in the meantime we the customers pay the price.  It is sad we have to pay thousands of dollars for the ALL upgrades every year and the upgrades cause more problems than the previous versions.

HelloRose
Level 1

Quickbooks Pro 2024 error codes when shipping FedEx

This is the SAME error I'm encountering. Worse yet, when I try to put the Account Number into the pop-up or ANY information into the pop-up, the screen just FREEZES. Is there anyway around it? Is QB fixing the issues or link / data issues?

HelloRose
Level 1

Quickbooks Pro 2024 error codes when shipping FedEx

From the sound of it, there's NO SOLUTION for 2024 version is that correct?  The only way to resolve this issue is to downgrade to 2023 version and it'll work?  

ShyMae
QuickBooks Team

Quickbooks Pro 2024 error codes when shipping FedEx

I acknowledge the importance of fixing this as soon as possible, Rose. Let's do some troubleshooting and ensure the error will be removed. Doing so, you'll be able to use the program without any issues. 

 

There's no need to revert to the 2023 version. There are times when the program's installation files or modules can get damaged for various reasons. When this happens, they can't function properly, leading to issues like runtime errors and freezing behaviors.

 

To resolve this, we'll need to perform a clean install, which involves completely uninstalling the software from your computer and then reinstalling it. This process will remove the damaged files and modules, replacing them with new undamaged ones. It's like giving QuickBooks Desktop a fresh start.

 

Before we proceed, create a backup file of your company to prevent any potential losses due to unforeseen circumstances. 

 

To uninstall QuickBooks: 

 

  1. Open the Windows Start menu. Search the Control Panel, then open it.
  2. Choose Programs and Features or Uninstall a Program.
  3. Pick the version of QuickBooks Desktop you want to remove from the list of programs. 
  4. Hit Uninstall/ChangeRemove, and then Next.  If you don't see this option, sign out and sign back into Windows as an admin. 

 

Once done, install QuickBooks Desktop. QuickBooks will automatically create new folders and rename your old ones.

 

If the issue persists, I recommend contacting our technical support to check this matter. If necessary, our expert team can refer this to our engineering team. 

 

For future reference, you can visit these resources as a guide in handling your shipping manager and QuickBooks Desktop:

 

 

By following the troubleshooting steps, you can ensure that you can use the program with ease, allowing you to focus on your task. If you need further assistance, click the Reply button below. I'm always here for you. 

HelloRose
Level 1

Quickbooks Pro 2024 error codes when shipping FedEx

I have tried uninstalling and downloading ONE the computer and the method DOES NOT work. The issue presisted and I have called QB support twice. Both people were NOT able to solve my problem for me. Would someone be able to call me and assist me with the issue?

Nicole_N
QuickBooks Team

Quickbooks Pro 2024 error codes when shipping FedEx

I can see that you did everything you could to fix the issue, Rose and I appreciate you for that. 
 

I'm aware you've already gotten in touch with our Phone Support team, but it's the best we can do given that they have all the tools required to look at your account through screen sharing. This way, they can further investigate what's causing the error and assist you in resolving this matter timely. They can be reached while using QuickBooks. 

 

Here's how:

 

  1. In your top menu bar, go to Help, then QuickBooks Desktop Help.
  2. Click Contact Us.
  3. Enter a brief description of the issue in our Ask a question (or tell us what's wrong) field.
  4. Hit Continue.
  5. Select We’ll contact you for a callback or Message Us to start an instant messaging session.

 

Be sure to review their support hours so you'll know when agents are available. In the event you're unable to reach out to Intuit through your books, you can get in touch through our website.

 

Moreover, you'll want to visit this article to learn more about the shipping manager: Intuit QuickBooks Shipping Manager.


Please keep us updated about the result, Rose. You can also reply to this thread if you have more questions about managing the shipping manager in QuickBooks. The Community team is open 24/7 to assist you. 

Jeff DH
Returning Member

Quickbooks Pro 2024 error codes when shipping FedEx

Thank you for this post.  I am having the exact same issue, with the same error message since I upgraded.  Quickbooks customer support has been no help, I have contacted them 5 times now and keep receiving a "this is a third party application issue" and then they end the chat, glad I found this post!  Im trying to figure out how to downgrade back to Quickbooks 2023 right now.

Jeff DH
Returning Member

Quickbooks Pro 2024 error codes when shipping FedEx

I would advise not listening to this post.  Sorry, but I did a clean re-install twice, then many conversations with Quickbooks help.  From what I can tell, Quickbooks 2024 simply does not work with the shipping applications.  Figure out how to return to using Quickbooks 2023.  Support was unable to help.

Need to get in touch?

Contact us