tag:blogger.com,1999:blog-21122514.post3491156829338514396..comments2024-03-14T09:05:49.445+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Free Oracle Cloud: 8. Setup APEX Office Print (AOP) to export to PDF, Excel, Word, Powerpoint, HTML and TextDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger25125tag:blogger.com,1999:blog-21122514.post-39674347825926744012021-10-21T18:51:01.352+02:002021-10-21T18:51:01.352+02:00Hi Femi,
Most of the time it means there are not ...Hi Femi,<br /><br />Most of the time it means there are not enough grants <br />- GRANT EXECUTE ON SYS.UTL_HTTP TO your_schema;<br />- GRANT EXECUTE ON SYS.UTL_FILE TO your_schema;<br /><br />Next try to run aop_db_pkg.sql again in SQL Workshop > SQL Scripts<br /><br />Hope that helps,<br />Dimitri<br />Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-4970783013329067512021-10-21T18:37:32.357+02:002021-10-21T18:37:32.357+02:00Hello Dimtri.
Thank you for your guide on how to ...Hello Dimtri.<br /><br />Thank you for your guide on how to install AOP.<br /><br />Using the aop_win_v21.1.2 zip file, I attempted to install AOP Windows version on the Apex installation running on my laptop.<br /><br />Two out of the nine statements failed as shown below:<br /><br />create or replace package body aop_api21_pkg wrapped a00000 Error at line 0: PLS-00753: malformed or corrupted wrapped unit<br /><br />create or replace package body aop_convert21_pkg wrapped a0 Error at line 0: PLS-00753: malformed or corrupted wrapped unit<br /><br />How should I proceed from here?<br /><br />Regards,<br />Femi Feminoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-16528671182933041762021-06-09T19:57:18.065+02:002021-06-09T19:57:18.065+02:00Hello, Can you please contact support@apexofficepr...Hello, Can you please contact support@apexofficeprint.com<br /><br />I encourage you to run in APEX Debug mode and see what the exact error is.<br /><br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-86471720684501658852021-06-09T15:12:06.060+02:002021-06-09T15:12:06.060+02:00Hi ,
I have upgrade APEX from 5.1 to 21.1.
Now I... Hi ,<br /><br />I have upgrade APEX from 5.1 to 21.1.<br /><br />Now I am trying to upgrade AOP from 3.0 to 21.1. I am performing below steps.<br /><br />1. Download cloud package of AOP 21.1<br />2. Unzip AOP 21.1 on local machine<br />3. Upload aop_db_pkg.sql - navigate to SQL Workshop -> SQL Scripts -> Upload.<br /><br />But I am getting below error while uploading aop_db_pkg.sql , please help to solve this.<br /><br />"Error processing Request , Contact your application administrator"<br /><br />Please help how to solve this issue.Mukesh Oracle Apps DBAhttps://www.blogger.com/profile/13279162827432558515noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-44324262651779207182021-05-11T14:47:51.511+02:002021-05-11T14:47:51.511+02:00Hi,
https://objectstorage.us-ashburn-1.oracleclou...Hi,<br /><br />https://objectstorage.us-ashburn-1.oraclecloud.com/n/id9u4qbhnjxj/b/apexofficeprint/o/aop_free_oracle_cloud.zip is invalid in the meantime.Holger Lehmannhttps://www.blogger.com/profile/09341184547449792659noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-45516674384541604812021-04-15T14:40:29.185+02:002021-04-15T14:40:29.185+02:00In case you encounter the error 413 Request Entity...In case you encounter the error <b>413 Request Entity Too Large</b> when importing the AOP Sample APEX app you have to adjust the <b>client_max_body_size</b> setting in the file <b>/etc/nginx/nginx.conf</b>. In the previous step you've probably set this to 50M, but <b>aop_sample_apex_app.sql</b> is 66M. I've adjusted it to 100M and the error was gone.Yvo Breuerhttp://ybis.nlnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-9317501748914551852020-04-15T16:57:33.218+02:002020-04-15T16:57:33.218+02:00Hi Dimtri,
Ignore my previous comment. Your examp...Hi Dimtri,<br /><br />Ignore my previous comment. Your examples are with http rather than https<br /><br />It works<br /><br />HaziUnknownhttps://www.blogger.com/profile/06366436983454443658noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-27067800293196674522020-04-15T16:17:35.603+02:002020-04-15T16:17:35.603+02:00Hi Dimtri,
Great work for speeling out AOP on Ora...Hi Dimtri,<br /><br />Great work for speeling out AOP on Oracle cloud services. I haven't installed the VM just the AOP on APEX. I get the following Oracle error.<br /><br />ORA-20000: Issue calling Main AOP Service (REST call: ): ORA-20987: The requested URL has been prohibited. Contact your administrator.<br /><br />I know this is an Oracle issue as I have another AOP running on Digital Ocean without any issues. Any help is appreciated.<br /><br />Thanks<br /><br />HaziUnknownhttps://www.blogger.com/profile/06366436983454443658noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-52014919159599017082020-02-05T18:39:15.499+01:002020-02-05T18:39:15.499+01:00Thanks a lot for the quick reply.
I will try this...Thanks a lot for the quick reply.<br /><br />I will try this and let you know.<br /><br />Regards.juanjf9https://www.blogger.com/profile/12595667120452019974noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-39773013937277054032020-02-05T14:53:10.173+01:002020-02-05T14:53:10.173+01:00Are you sure you use the HTTPS URL of your VM?
Yo...Are you sure you use the HTTPS URL of your VM?<br /><br />You can't really use the IP address, as Oracle doesn't allow outgoing HTTP requests, they have to be HTTPS.<br /><br />see this post how to setup HTTPS and get your domain URL pointing to your VM (AOP instance): https://dgielis.blogspot.com/2019/09/free-oracle-cloud-7-setup-web-server-on.html<br /><br />Hope that helps,<br />Dimitri<br />Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-73360539445044623972020-02-05T01:55:47.382+01:002020-02-05T01:55:47.382+01:00Hi Dimitri, I'm using an ORACLE Cloud instance...Hi Dimitri, I'm using an ORACLE Cloud instance (VM) to install the on-premise AOP server.<br /><br />I followed your steps until YAY! AOP its running. <br /><br />but then I'm not able to modify any conf file.<br /><br />I have installed the AOP 19.3 Sample Application and changed AOP URL to my VM public IP Address.<br /><br />when testing I get the following:<br />Contacting AOP Server failed!<br />< Please check if you ACL has been configured properly. <br />Error: <br />ORA-29273: HTTP request failed ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1036 ORA-12535: TNS:operation timed out ORA-06512: at "SYS.UTL_HTTP", line 639 ORA-06512: at "SYS.UTL_HTTP", line 1415 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 934 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1566 ORA-06512: at "APEX_190100.WWV_FLOW_WEBSERVICES_API", line 408<br /><br />Any advice!juanjf9https://www.blogger.com/profile/12595667120452019974noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-56415237617241692722019-10-18T13:48:48.855+02:002019-10-18T13:48:48.855+02:00Hello Dimitri,
Now it's clear for me. Thanks ...Hello Dimitri,<br /><br />Now it's clear for me. Thanks for explanation.<br /><br />Have a nice weekend,<br />CarstenCarsten Cernyhttps://www.blogger.com/profile/09838800030547509552noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-90990560478683701372019-10-18T09:40:12.319+02:002019-10-18T09:40:12.319+02:00Hi Carsten,
> If I get you right: I have to pa...Hi Carsten,<br /><br />> If I get you right: I have to pay if I will use AOP on my own installation. Otherwise I can use https://api.apexofficeprint.com with my API key for free? That was not clear for me reading your blog post.<br /><br />Sorry if it was not clear.<br />- With https://api.apexofficeprint.com we offer the FREE AOP Cloud (30 reports/month every month for ever and unlimited dev credits) If you need more, there are paid plans too.<br />- With the on-premises AOP version you have unlimited DEV reports (basically all functionality is there, but there's a small watermark). If you don't want the watermark, you can buy an on-premises version.<br /><br />Hope that explains better.<br /><br />Thanks,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-25653488524064139392019-10-18T09:35:42.207+02:002019-10-18T09:35:42.207+02:00Hello Dimitri,
Thanks for your answer. I followed...Hello Dimitri,<br /><br />Thanks for your answer. I followed your post about the AOP installation and changed the URL at the end to my own domain (Oracle VM instance).<br /><br />If I get you right: I have to pay if I will use AOP on my own installation. Otherwise I can use https://api.apexofficeprint.com with my API key for free? That was not clear for me reading your blog post.<br /><br />Best,<br />CarstenCarsten Cernyhttps://www.blogger.com/profile/09838800030547509552noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-70531633125817556972019-10-17T11:51:18.017+02:002019-10-17T11:51:18.017+02:00Hi Carsten,
What URL do you use in APEX > Shar...Hi Carsten,<br /><br />What URL do you use in APEX > Shared Components > Component Settings?<br />if this is https://api.apexofficeprint.com, you are connecting to our Cloud and you don't need to run the executable.<br />Our own Cloud will check the API key you provide.<br /><br />Alternatively, If the URL specified is your own domain/aop url it means you connect to your own AOP Server. Then you need a license file, otherwise, the AOP Server will run in Trial Mode. The license file can be generated by specifying -a (to activate AOP). Note you would need to have bought the AOP Server in order to activate.<br /><br />Hope that clarifies,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-62001546505206065692019-10-17T11:44:18.209+02:002019-10-17T11:44:18.209+02:00Hello,
all was working with AOP. After a few days...Hello,<br /><br />all was working with AOP. After a few days I tried to access via https://my_domain.com/aop and got an bad gateway error from nginx.<br /><br />The AOP server wasn't running anymore. I started it again with <br /><br /><i>./opt/aop/v19.2.3/server/APEXOfficePrintLinux64 --enable_printlog &</i><br /><br />It's running again now but I see the following message on the console:<br /><br /><i><br />Could not find the license file. Expecting it to be in /opt/aop/v19.2.3/server/aop.license.<br />If your license file is somewhere else please give in the location with --license argument.<br />Trial has been enabled. Activate the software with '--activate' or '-a' option<br /></i><br /><br />I got the license key and put this in the shared components part but I didn't receive a license file. And how can I check why the AOP server was stopped?<br /><br />Best,<br />CarstenCarsten Cernyhttps://www.blogger.com/profile/09838800030547509552noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-25990093706120201042019-10-10T00:10:45.205+02:002019-10-10T00:10:45.205+02:00Thank you Dimitri,
The statement returned no erro...Thank you Dimitri,<br /><br />The statement returned no error, so the only thing I could think of was to delete the plugins and retry. <br />That fixed it.<br /><br />thumbs up!<br /><br />MarcMarchttps://www.blogger.com/profile/10882109772699211911noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-730733235443735242019-10-09T18:28:07.301+02:002019-10-09T18:28:07.301+02:00Hi Marc,
That is a strange error. It looks like a...Hi Marc,<br /><br />That is a strange error. It looks like an ACL issue or firewall issue.<br />Does your instance can connect to the internet?<br /><br />In SQL Workshop can you try:<br />select apex_web_service.make_rest_request('https://www.google.com','GET')<br /> from dual;<br /><br />If you get the same error it means your user can't go outside... you want to check your firewalls then.<br /><br />Dimitri<br />Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-59354031454001989602019-10-09T12:41:38.334+02:002019-10-09T12:41:38.334+02:00Hi Dimitri,
Thanks for the quick response.
After...Hi Dimitri, <br />Thanks for the quick response.<br /><br />After adding the s , (I overlooked your clear instruction) something did change. <br /><br />A different error, but, now in my own language.<br /><br />AOP downloadAOPFile Error ORA-20000: Issue calling Main AOP Service (REST call: ): <br />ORA-29273: HTTP-aanvraag is mislukt.Marchttps://www.blogger.com/profile/10882109772699211911noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-78478938634088873282019-10-09T11:32:24.467+02:002019-10-09T11:32:24.467+02:00Hi Marc,
If you go to Shared Components > Comp...Hi Marc,<br /><br />If you go to Shared Components > Component Settings > APEX Office Print<br />Make sure the URL you use is HTTPS://api.apexofficeprint.com (or your own AOP Server, but it has to be https)<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-69295565728550830272019-10-09T11:30:52.692+02:002019-10-09T11:30:52.692+02:00Hi Dimitri,
I think I followed all the posts up t...Hi Dimitri,<br /><br />I think I followed all the posts up to this one to the letter. They all work (thank you for that!). <br /><br />But I am having issues with this one, the AOP step.<br />After creating the package and the DA's, I tried to create my first print, but I got this error:<br /> ORA-20000: Issue calling Main AOP Service (REST call: ): <br /> ORA-20987: The requested URL has been prohibited. Contact your administrator. <br /><br />Maybe the problem lies in the region, I entered the closest to home, Frankfurt.<br /><br />Thanks in advanceMarchttps://www.blogger.com/profile/10882109772699211911noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-38064014626500867372019-09-26T10:30:24.858+02:002019-09-26T10:30:24.858+02:00Hi Dimitri,
The point with the Sample Database Ap...Hi Dimitri,<br /><br />The point with the Sample Database Application was the right one. After installing that I could install the AOP Sample app.<br /><br />Thanks for that,<br />CarstenCarsten Cernyhttps://www.blogger.com/profile/09838800030547509552noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-30070029666209750272019-09-26T09:41:13.707+02:002019-09-26T09:41:13.707+02:00Hi Carsten,
I believe your error is with the Supp...Hi Carsten,<br /><br />I believe your error is with the Supporting Objects?<br />If you look into the details, does it say in which script it was?<br /><br />The Supporting Objects will install the AOP PL/SQL API and some sample packages. Those sample packages use some tables from the Sample Database Application. Is it possible that this application was not installed yet? If you install the Sample Database Application, you should be able to recompile the AOP packages.<br /><br />Feel free to send us an email at support@apexofficeprint.com and we can do a quick session with you too, to make sure all is up-and-running on your side :)<br /><br />Hope that helps,<br />Dimitri<br /><br />Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-90577649701307187842019-09-26T08:32:53.609+02:002019-09-26T08:32:53.609+02:00Hi and good morning,
I tried to install the sampl...Hi and good morning,<br /><br />I tried to install the sample app from AOP (aop_sample_apex_app.sql) in my Oracle VM but I got an error. At the end of "Install Summary" is written:<br /><br />ORA-24344: success with compilation error<br />ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 592<br />ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658<br />ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 578<br />ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033<br /><br />What did I wrong?Carsten Cernyhttps://www.blogger.com/profile/09838800030547509552noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-42294559544716140112019-09-26T04:52:54.007+02:002019-09-26T04:52:54.007+02:00Thanks.useful content.Thanks.useful content.Normanhttps://www.blogger.com/profile/12009264016901702600noreply@blogger.com