since ‎08-07-2018
‎10-12-2019
AndrewS1
Level 2
Disabling Rights Management cache breaks External Authorizer
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
We run AEM Forms 6.4 on Windows / JBoss / SQL Server. When AEM Forms starts, it caches right-management-related information from the database. Because our database is very big, this process creates huge load on the SQL server disk. Following Adobe's advice, we disabled RM caching as follows:In the AEM Forms web UI, navigate to Home > Services > Document Security > Configuration > Manual Configuration.Export the current configuration to file.Edit the line , replace false with true.Import the conf...

Views

886

Likes

0

Replies

0
Re: Regular AEM Forms activity creates big load the database
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Thanks workflowuser​, I already did - twice. First time I was told that this is how the product behaves and it cannot be changed. They could not even explain what causes this. Second time I was told that it's caused by key rollover, and they suggested to increase the rollover frequency. As I said above, we now have it set at 9,999 days, but the issue still happens. Any ideas how to stop this activity would be appreciated. Is there some internal process (scheduler) I can stop?

Views

1.4K

Likes

0

Replies

0
Re: Regular AEM Forms activity creates big load the database
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Can somebody help please!?

Views

1.4K

Likes

0

Replies

0
Re: Regular AEM Forms activity creates big load the database
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
WASIL​ Thank you for the quick reply. Our key rollover frequency is set to 9,999 days (~ 27 years), but we still see the above activity on a regular basis. Any help on how to stop it would be really appreciated.

Views

1.4K

Likes

0

Replies

0
Regular AEM Forms activity creates big load the database
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
We run AEM Forms 6.4 on Windows 2016 Server, with the database on MS SQL Server. We only use the Document Security module. The database is very large - we have ~ 800,000 security policies (EDCPOLICYENTITY table) and ~ 100,000,000 secured documents (EDCLICENSEENTITY and EDCREVOKATIONENTITY tables).On a regular basis (maybe once a month or so) we see AEM Forms starting some activity which creates a huge load on the database. SQL Server disk queue jumps from 0.1 to 500 - 1,000 range. SQL Profiler c...

Views

3.7K

Like

1

Replies

5
Re: How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Thanks DarrenBiz, I do not know how I missed that method! Unless it was not there yet when I developed the External Authorizer, it was 3 years ago.Unfortunately it did not work, calling the method did not change the error message in Adobe Reader. But at least now I have something to go to Adobe support with.

Views

1.5K

Likes

0

Replies

0
Re: AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Mayank Gandhi, thanks for the update. Though installation to SQL 2017 does not work, upgrading an existing LC ES 4 database that already runs on SQL 2017 does work. We will use this on dev machines.In production we still run SQL 2012 which is also not officially supported, but I was able to both install to and use the product on SQL 2012.While I do understand that you cannot officially confirm that the product will work properly on SQL 2012 or 2017, is there any document security related functio...

Views

2.1K

Likes

0

Replies

0
Re: How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
DarrenBiz​ Maybe you could help me with something else please?We use External Authorizer with AEM Forms, so as per documentation we implemented public class MyExternalAuthorizer implements ExternalAuthorizer { … }, which has a method @Override public ExternalAuthResultDTO evaluate(ExternalAuthDTO authDto) { … }. In the method, we create new instance of ExternalAuthResultDTO class and call .setPermissions() on it to apply permissions as needed if the user is allowed to view the document.But if th...

Views

1.3K

Likes

0

Replies

0
Re: How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
DarrenBiz​ Thank you so much! I really cannot thank you enough!In my code, I literally replaced a call to .protectDocument() with a call to .protectDocumentWithCoverPage(), and everything worked out of the box.

Views

1.4K

Like

1

Replies

0
Re: How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Yes, but I think what I'm talking about is not metadata. That's what I'm trying to figure out - what is it? Have a look here: How to display custom content in protected PDF files? - Stack Overflow . I posted screenshots of such document when opened by Adobe Reader and by 3rd-party viewer.

Views

1.3K

Likes

0

Replies

0
Re: How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Correct, none of 3rd-part viewers will show the document content. But apparently you can add some unprotected content that will be displayed by 3rd-party viewers. While Adobe Reader does not display it and instead asks you to log in to AEM Forms.

Views

1.3K

Likes

0

Replies

0
How to display custom unprotected content in protected PDF files?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
When a PDF document is protected with a security policy from LiveCycle ES or AEM Forms, it can only be opened by Adobe Reader. Here's what it looks like when you try to open it in another PDF viewer.Microsoft Edge:Firefox (internally uses PDF.js):But I have seen secured PDF documents that in other viewers show customised content - e.g. instructions to download and install Adobe Reader. So there must be a way to add unprotected content to protected PDF files, which other PDF viewers will display....

Views

6.0K

Like

1

Replies

9
Re: AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Hi Mayank Gandhi, thank you for your reply.Regarding the EDCAUDITENTITY table, yes I know what it's for, we export audit events from this table to our product database. My question is specifically about sequencenumber column. LC ES 4 was writing incrementing integers to it, but after I migrated the DB to AEM Forms, all new records have zero. This does not impact our exporting logic, but I was concerned that maybe something went wrong during the database upgrade process from LC to AEM Forms, whic...

Views

8.5K

Likes

0

Replies

3
Re: AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
kjaeggin, Mayank Gandhi Any update regarding SQL 2017 support?Also I have another question. I noticed that after I upgraded the database from LC ES 4 to AEM Forms 6.4, all new entries going to EDCAUDITENTITY table have sequencenumber column set to zero. Is that by design?

Views

8.5K

Likes

0

Replies

5
Re: AEM Forms 6.4 Configuration Manager fails to modify lc_turnkey.xml
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
kjaeggin​ Thank you very much for detailed instructions, but this does not seem to be doing what I want to achieve. If I understood correctly, you are suggesting that I enter DB configuration to lc_turnkey.xml manually, and then make Configuration Manager skip DB configuration, so that I can reach subsequent configuration steps.I can currently achieve the same through the workaround I described in my question. What I'm asking is if there's a proper fix that would allow me to run Configuration Ma...

Views

1.4K

Likes

0

Replies

0
Re: AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
kjaeggin​, Mayank Gandhi Thank you for you replies. I will really appreciate if you can find out about official SQL 2017 support.I'm curious though why the product depends so much on the SQL version. Here are SQL supported version by AEM Forms version, according to Adobe Experience Manager Help | Supported Platforms for AEM Forms on JEE:6.2: 2012, 20146.3: 2012, 2014, 20166.4: 2016We've been using LiveCycle ES for many years, and I've seen how it uses the database (AEM Forms seems to be the same...

Views

8.5K

Likes

0

Replies

7
Re: AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
DarrenBiz​ Thank you for detailed reply.Mayank Gandhi would you be able to answer this please.

Views

8.5K

Likes

0

Replies

10
AEM Forms 6.4 Configuration Manager fails to modify lc_turnkey.xml
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
I have installed AEM Forms 6.4 on Windows Server 2012 R2 using partial turn-key installation with SQL Server 2012 database. First time installation and configuration completed successfully. But if I subsequently want to change my DB settings and run Configuration Manager, it fails on the following step:In the Configuration Manager log, I found the following error entry:Caused by: com.adobe.livecycle.lcm.core.LCMException[ALC-LCM-000-000]: Replacement failed for '>jdbc:sqlserver://localhost:1433;...

Views

3.1K

Like

1

Replies

5
AEM Forms 6.4 on SQL Server 2017
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
I'm trying to install AEM Forms 6.4 on Windows Server 2012 R2 using partial turn-key installation. If I use SQL Server 2012 as the database, installation succeeds, but it fails on SQL Server 2017, though neither one is officially supported (documentation says I need to use SQL Server 2016). What's even more interesting is that if I install to SQL 2012, then detach the DB and attach it to SQL 2017, then change DNS to point SQL Server's hostname to the SQL 2017 IP address, then AEM Forms happily w...

Views

9.1K

Like

1

Replies

12
Re: How to install AEM Forms add-on package for Windows?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Thank you, this was very helpful!

Views

2.0K

Likes

0

Replies

0
Re: How to install AEM Forms add-on package for Windows?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
I do not have "crx-repository" option on the Modules screen. The closest option I have is "Content Repository, version 6.4.0" in the "OSGi Capabilities" section. Is this the one? If yes, what is it for? As I mentioned before, we currently only use the "Document Security" module in the "JEE Capabilities" section, to protect PDF documents.Another question - what am I actually trying to install? I thought "AEM-Forms-6.4.1.0-WIN-5.1.14.zip" was an update for AEM Forms from v6.4.0 to v6.4.1. But mayb...

Views

1.6K

Likes

0

Replies

0
Re: How to install AEM Forms add-on package for Windows?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
Thanks KhushwantSingh​, I should have been more clear. I do not have AEM installed, I do not need it. I only have AEM Forms, and in there I only have one module installed - Rights Management.Does it mean that if I want to be able to install updates for AEM Forms, I need to install AEM itself as well?

Views

1.6K

Likes

0

Replies

0
How to install AEM Forms add-on package for Windows?
Avatar

AndrewS1

AndrewS1
- Adobe Experience Manager Forms
I have AEM Forms 6.4 on Windows Server. Just now downloaded AEM Forms add-on package for Windows (AEM-Forms-6.4.1.0-WIN-5.1.14.zip) from AEM Forms releases, but how to install it? I cannot see anything "installable" in the zip file.

Views

7.2K

Likes

0

Replies

6
Likes given to