This article addresses an error encountered during a patch upgrade from Data Platform version 5.5.77 to 5.5.78, where a SQL script fails to execute successfully.
Error message:
ERROR Error occurred while executing the SQL script.
Script path = E:\Program Files\BDNA\Data Platform\Update\5.5.65_DLLS_Do_NOT_Delete\5.5.65_DP_DB_Do_NOT_Delete\Patch_Files\SQLServer\update_tables_sqlserver2041175501.sql
This issue typically occurs when the system is unable to properly impersonate the database user during the patch process, which prevents updates to the required SQL tables.
To resolve the issue:
- Grant local administrator privileges to the service account being used for the Data Platform and User Console services.
- Update the logon settings:
- Open Services (services.msc).
- Locate both Flexera Data Platform and User Console services.
- Right-click each service. Select Properties > Log On tab.
- Change the logon from Local System account to the designated service account.
- Restart the services after updating the logon settings.
- Reapply the patch once the services are running under the correct account.
After applying these steps, the patch should complete successfully, and the SQL table updates should process without errors during the upgrade from version 5.5.77 to 5.5.78.
Related Articles
Failed to apply 5.5.51 (or higher version) patches for both User Console and Data Platform 10Number of Views Failed to apply patch "5.5.22_Analyze_NBIDLLS.zip" to User Console 9Number of Views Steps to enable auto-apply for Data Platform and User Console patches 7Number of Views InstallShield fails to create Patch/Upgrade from a compressed setup.exe 6Number of Views How to re-apply an update from SLM 106Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago