Thank you. We will experiment - so far no results returned, which is odd. No problem Maja. Once you set it up and enable it allow at least a day for information to collect. History Log will only start gathering information once it’s enabled not anything before that. So if you set few up today do not expect to see information in it from yesterday :)
Hi Maja, Speaking from Apps9 perspective but In History Log Configuration you can right click at the top and select Search History Log and then by View You could try fnd_user for your user info
Easiest method to check, browse to the site URL using e.g. a modern and up to date e.g. edge browser - if that rejects, you’ve got a problem but fixing is going to be down to wherever the hosting is which I think maybe IFS for touch apps but doesn’t have to be. Matt @cmlmfreeman thanks for all your replies! I think the issue might be with cloud.ifsworld.com I’ve reached out to IFS support as well. Thanks, Kasia Issue in fact was from IFS. Their cloud.ifsworld.com SSL certificate was expired. Therefore outside of customer’s control.
Hi Kasia, You mentioned both the Uplink and the TAS, but you’d only have one the the two, never both. Can you confirm what you use please? To clarify, if you’re currently using the Touch Apps Cloud (which by the way is going to be decommissioned by 1st March 2023), then you’d be using the Uplink. In this case, the Uplink (hosted on your infrastructure) needs to be able to reach cloud.ifsworld.com which is hosted in Azure’s North Europe region, and the Touch Apps Cloud in turn needs to be able to reach your Uplink as well. If this is your setup, then sounds like your Uplink is hosted in India. The good news though is that your apps only need to reach cloud.ifsworld.com, so you don’t need to worry about access. If you have the on premise Touch Apps Server, you don’t need the Uplink, but in this case all your apps need to be able to reach your TAS. If this is your setup, either you TAS appears to be hosted in India, or some of your apps are running on mobile devices are running in India.
Hi @martinnc You can download one from here https://www.ifs.com/sitecore/media-library/assets/2014/07/24/brochure-document-management/ Fill out little box to the right and a download window should appear when you’re finished. Thanks,Kasia
@martinnc I believe all should be documented in online documentation. Check https://docs.ifs.com/ for more info
Easiest method to check, browse to the site URL using e.g. a modern and up to date e.g. edge browser - if that rejects, you’ve got a problem but fixing is going to be down to wherever the hosting is which I think maybe IFS for touch apps but doesn’t have to be. Matt @cmlmfreeman thanks for all your replies! I think the issue might be with cloud.ifsworld.com I’ve reached out to IFS support as well. Thanks,Kasia
Hi, Have you checked if certs are SHA1 SHA256 (now needed) and TLS on the host is 1.2? If you’re below these then chances are you’ll get an SSL exception which could break the chain now. Matt Hey @cmlmfreeman,Certs seem to be SHA1 SHA265… how can I check TLS? Many thanks! Kasia
Hi @Kasia, Thanks for the info! Are you trying to print the report using the IFS PDF Archiver? Since you have mentioned that this behavior is random, could you please try to print the report using the PDF archiver and see if you are getting the error message? @Himasha Abeywickrama thanks for your quick replies! Not using this method I did try generating PDF and Printing it but no errors. Thanks,Kasia
Hi @Kasia, Could you please check the log file to see if there are any error messages? Normally, there should be an error message explaining why you are getting the “No PDF report returned from Crystal Web Service” message. Hi @Himasha Abeywickrama , I have done that, please see above I’ve pasted part of it that corresponds with the time of print job in print manager. No errors in log. I found an error but from yesterday and different report layout 30/03/2022 16:29:19[IFSCWSIFSL_1]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.30/03/2022 16:29:19[IFSCWSIFSL_1]-Logon failed.Details: [Database Vendor Code: 12514 ]Logon failed.Details: [Database Vendor Code: 12514 ]Error in File CDEOrderConfirmation {1B1A83F8-22A4-486F-AD56-C1FABEF5F2A2}.rpt:Unable to connect: incorrect log on parameters.Details: [Database Vendor Code: 12514 ] at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
Hi there, Does anyone know what countries need access to uplink / touch apps server via firewall? Thanks, Kasia To provide more info on this. We have received a list of red listed countries that needed to be blocked via our firewall. When we did that none of our TouchApps applications worked (Trip Tracker or Scan It to name a few) as they returned error 500. We went with our gut feeling and unblocked India as a country and things went back to normal but ideally we want to put it back on blocked countries list and use IP address that touchapps use to whitelist it and allow it to work while the country inbound and outbound traffic is blocked. Thanks,Kasia
2TB does sound large! Like Nick we have been using IFS for around 17 years and have not used Archiving in the application. Our production db size is currently at 552Gb. Always worth keeping an eye on your history log Configuration. We have been bitten on this in the previous version. What is being logged and how many days are you keeping history logging. I use this code to keep an eye on the History: select table_name, count(*) from history_log_tab group by table_name; Hope you find your problem. Bigger database = longer recovery time, more backup capacity req etc... @MikeArbon When you say you haven’t used archiving in application do you mean report archive only? Or more? We’ve had IFS for around 3 years but our DB is over 1Tb already….trying to see why that is. Did use your query for history log which is super handy so thanks for sharing!
Hi @Kasia I saw customers with nearly 4TB db size(1TB is very common). I first time meet so large MEDIA_ITEM objects. I suppose the problem is with LOB's. Shrink Lob Segments job could reduce size but for current size(~150GB) it will be problem to finish this - it makes copy of data in temporary datafiles. There are also plenty of Cleanup processes which could reduce db size by removind unnecessary data and keep db in good condition. Usually I faced problems with History Log and of Archive Reports size as well during yearly customer health checks. Thank you so much for your input Piotr @knepiosko :)
While doing label printing using print agent in IFS 8, the printer is printing in landscape mode. Due to this the printout is not coming correctly. It should be done in portrait mode. What is the setting/parameter required on print agent to ensure it comes correctly. The PDF file is saved in correct way and when printout is taken from report archive the printout comes correctly on the same label printer. Please advise Regards Pankaj Hi @paguin, Please check whether the rotateAndCenter parameter is set to true in ifs-printing.properties file and try setting it to false. You can refer to following documentation on printing properties in Print Agent: https://docs.ifs.com/techdocs/default.htm?openpage=https://docs.ifs.com/techdocs/foundation1/020_installation/400_installation_options/005_operational_reporting/020_install_print_agents/ Hope this helps! Did this work for you@paguin , I’m experiencing similar issue in Apps9?
I got an update from our database providers. Oracle Database has been confirmed as an unaffected product. SQL Developer and SQL Modeller may be vulnerable but Oracle have confirmed the solution to be updating this to the latest version. For anyone using above products.
Hi, Is the touch-app-server affected? If exposed, this might be the most vulnerable point. I can imagine touch apps being the biggest worry here, do we know when this is being looked at?
@Kasia not sure what window is this in the application but you can view details of a QR from windows in below navigation paths Thanks, I know that bit just fine. Just checking if I imagined there being an option to enable navigation from quick report to screen where data is coming from. This particular quick report is coming from 1 screen - 1 view - it’s made this way to enable quick export of data to Excel as it’s done on server side via quick report rather than client side on IFS screen.
Hi, Then it seems strange. Why don’t you try a dummy layout and see that is working as expected through IFS. Then you can be sure that all is going to the correct places and maybe it’s the suppression logic that is effecting it. Regards, Chanaka Hi Chanaka, It was formula. I used single quotes in one of my lines instead of double quotes. I work lots with SQL not enough with Crystal formulas... Very silly mistake. Thanks
Hi, As you talk about MWS I’m assuming this is Apps9 or above and you are using IFS EE or Aurena Client. From the system parameters check the machine where the Crystal Web Service (CWS) is installed and the virtual directly name. Make sure you copied the layouts to that folder. In the machine where you have installed CWS go to the C:\inetpub\wwwroot\<virtual directory) and edit the web.config file and check the folder under <add key="OpenReportPath" value="C:\Report Layouts" /> tag. Check if you have copied the files to the same location. Make sure that you have give the correct file name in Report Definition or Quick Report Configuration. If this is Operational Reports, then make sure that you have copied the layouts to the correct language folder(s). Make sure that when saving the report from Crystal Report Designer, that you have not saved the report with Data. (File Menu). Regards, Chanaka What if you’ve done all these things but still when report is moved to docum
This might be a more generic web service consumption question, and not so much related to IFS specifically… Here is a thread on calling a SharePoint service from Oracle PL/SQL (with some good example code): https://apexplained.wordpress.com/2015/11/05/calling-a-sharepoint-web-service-from-plsql/ This is a link to the toolkit discussed in the above link: https://github.com/mortenbra/alexandria-plsql-utils Another thread on Oracle/SharePoint integration: https://community.oracle.com/tech/developers/discussion/4212474/save-a-file-in-share-point There does not seem to be a ton of information out there, and it is possible IFS has a better way via IFS Connect. Also, at least some of the SharePoint examples I found talk about using APEX, which I am not well versed in (and do not know if it is an option in IFS/Oracle). The bottom line is that Oracle should be able to make web API calls, but there may be issues with authentication and request/response headers depending on the confi
Hi @Kasia Just one addition to above. Just try re-enter the password of IFSPRINT. IFS automatically adds (what appears to be) encrypted password text into the password field even if the password field is actually BLANK (like after you uninstall and reinstall the print agent) so if everything looks good and things still don’t work make sure you have entered the IFSPRINT user’s password! I’ve seen that in Tom’s reply. Where do you re-enter password for IFSPRINT? In the print agent configuration, you may need to rerun the print agent installation in order to re enter it. That solved the issues for us! Thanks so much for your replies everyone. Kasia
Hi @Kasia Just one addition to above. Just try re-enter the password of IFSPRINT. IFS automatically adds (what appears to be) encrypted password text into the password field even if the password field is actually BLANK (like after you uninstall and reinstall the print agent) so if everything looks good and things still don’t work make sure you have entered the IFSPRINT user’s password! I’ve seen that in Tom’s reply. Where do you re-enter password for IFSPRINT?
Just one addition to above...we had similar issue and found that IFSPRINT was NOT locked...instead we just had to re-enter the password. IFS automatically adds (what appears to be) encrypted password text into the password field even if the password field is actually BLANK (like after you uninstall and reinstall the print agent) so if everything looks good and things still don’t work...make sure you have entered the IFSPRINT user’s password! ~Tom Where did you have to re-enter the password? Having similar issues as yourself today.
Hi @Kasia Was there any recent maintenance on the environment? Could you please check whether the Print Agent is updated and its using the correct credentials? Also what is the error you get in the print agent logs? Print Queue Error says: com.datalogics.PDFL.LibraryException: License error.: License error. Error number 13 Log also has that followed by:at com.datalogics.PDFL.PDFLJNI.Document_print__SWIG_0(Native Method) at com.datalogics.PDFL.Document.print(Document.java:532) at ifs.fnd.printingnode.RemoteJob.PDFLPrintDoc(RemoteJob.java:817) at ifs.fnd.printingnode.RemoteJob.perform(RemoteJob.java:787) at ifs.fnd.printingnode.RemoteJobProcessor.run(RemoteJobProcessor.java:126)
Hi, Check if your IFSPRINT user account is locked or the user license is invalid. Regards, Chanaka All seems okay! Thanks!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
