Error While publishing and replacing the app in QLiksense

Sanouch — Thu, 03 Jun 2021 11:51:54 GMT

While publishing and replacing the application in QMC, I get the error "GetAll Operation Failed Error". and I cannot replace the existing

Re: Error While publishing and replacing the app in QLiksense

MayilVahanan — Tue, 01 Jun 2021 10:04:07 GMT

Hi @Sanouch

Try with this url

https://community.qlik.com/t5/New-to-Qlik-Sense/Get-Operation-failed/td-p/1811411

Re: Error While publishing and replacing the app in QLiksense

PadmaPriya — Tue, 01 Jun 2021 15:09:54 GMT

Hello @Sanouch

Error:

Command=Export app;Result=400;ResultText=Error: PersistenceFailed    322ba881-0e69-46ab-a6c2-3122ce2f2029    10f39b74-01a4-4cb4-a31c-47f14839b872    0    SEMARK    mercanza    ec5191f5-c425-40bf-8a18-e9734813b011    CMC_GeneraAportaciones_B    Repository    ManagementAccess    /qrs/app/ec5191f5-c425-40bf-8a18-e9734813b011/export    Export app    400     The "GetAll" operation failed. (HTTP code: 400)    f6624cce-6b27-4f04-87e6-8b855a92da07

Please follow the below solution:

Stop Rim node and take Repository backup
Uninstall Rim node, removing local data and certificates
Stop Central node and backup Repository
Remove Central node transaction data from C:\ProgramData\Qlik\Sense\Repository\Transactions
Create "_operation.qrs" empty file in the same Transactions folder to reset sync on Central node
Use the custom recurse_cleanup.sql script attached to remove orphans and other lint from the Repository (directly in pgAdmin)
Remove all sync sessions using the SQL script in Appendix A, changing the date to current date for a thorough cleanup
1. This step essentially returns the Central node to a "never synced" state. These sync sessions can considerably bloat the Repository over time
Start Central node services and wait for Startup Phase Complete in Repository Trace System log
Test all previously non-working operations and confirm the issues have disappeared
Remove the Rim node from QMC
1. Trying to remove the Rim node before clean-up operations can fail, in which case the Rim node will have to be manually removed from the Repository, thus avoided
Install Rim node with Engine + Proxy roles
Disable custom sync rule that makes all apps available on Rim nodes as well, this is done to avoid binary app sync before the App storage path can be changed on the Rim node. Custom rule name is ResourcesOnNonCentralNodes
1. Customer had a small C: drive that would've been quickly filled by sync transactions and apps if the rule is not disabled
Add Rim node to QMC and configure its Engine to point to the new App storage folder
Restart services on Rim node and verify that the new Engine settings have synced
1. Open pgAdmin on Rim node (even with services started) and check the DocumentDirectory column in EngineServiceSettings table
Enable previously disabled Sync Rule to begin binary app sync and monitor the appropriate app folder on Rim node for content to start appearing
Once all sync operations are complete, take backups of both Repositories in this clean and operational state

in simple you may restore the ProgreSQL Database.

Thanks,

Padma Priya

Re: Error While publishing and replacing the app in QLiksense

Maria_Halley — Thu, 03 Jun 2021 08:07:52 GMT

@Sanouch

I will move this post to the QlikSense boards

Re: Error While publishing and replacing the app in QLiksense

Sanouch — Thu, 03 Jun 2021 13:39:51 GMT

hello @PadmaPriya

I dont' have Rim Node, i have juste central Node ?

do You have annoter solution ?

Regards

topic Re: Error While publishing and replacing the app in QLiksense in Management & Governance

Error While publishing and replacing the app in QLiksense

Re: Error While publishing and replacing the app in QLiksense

Re: Error While publishing and replacing the app in QLiksense

Re: Error While publishing and replacing the app in QLiksense

Re: Error While publishing and replacing the app in QLiksense