AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Crystal security revikews 20168/19/2023 2853968 - Error: 'HY000: (120) SOQL_FIRST mode prepare failure…' when refreshing a report based off Salesforce Lightning Stored Procedure.Search the SAP Knowledge Base Articles below, which list all the known error messages and issues connecting to from Crystal Reports.If it does, then add the proxy information to the driver, by following the information found in the SAP Knowledge Base 1294512 Confirm with your Network Administrator, if your company network uses Proxy. If your computer is not within the Trusted IP Range, then ensure you are using the Security Token?įor information on how to obtain and use the Security Token to connect using external application, see the SAP Knowledge Base 2247103.Verify with your Administrator, if your computer is within the Trusted IP Range?įor information on how to add your computer to the Trusted IP Range, see the SAP Knowledge Base 1294023.Verify if the user name and password are correct by login to the website at:.General troubleshooting steps to resolve connectivity issue?.2092680 - SAP Crystal Reports, and SSL vulnerability.1376594 - Does the connectivity with Crystal Reports is supported on SAP BI Platform installed on Unix?.1294032 - What are the objects that can be used when connecting to from Crystal Reports?.2174175 - What does the option: Use Analytic API do, when connecting to from Crystal Reports?.1384116 - What are the API version supported by Crystal Reports?.1294557 - How to increase JVM memory size for Crystal Reports when reporting off ?.1294583 - How to increase the batch size when reporting off in Crystal Reports?.1294497 - How to improve report performance when reporting off in Crystal Reports?.1294510 - How to create a report off in Crystal Reports using your own SOQL query? (Command Object).1294496 - How to create a report off a report in Crystal Reports? (Stored Procedure).2247103 - How to set Salesforce Security Token, to be able to connect to from Crystal Reports?.1294023 - How to add an IP Address to the Trusted IP Ranges, to be able to connect to ?.1294512 - How to configure the HTTP proxy for the connectivity for Crystal Reports?.1206543 - not listed in available datasources in Crystal Reports.General Information on Crystal Reports connectivity to.For a list of issues, see the section: Crystal Reports 2013, 20 Initially the Salesforce ODBC drivers had many issues, and have all been resolved in later product updates, therefore we suggest to apply the latest product update to Crystal Reports. Crystal Reports was using a Java driver to connect to in the past, but from Crystal Reports 2013, it is now using an ODBC driver.In 2016, Salesforce deprecated the API url Crystal Reports was using by default to connect to, therefore reports needs to be updated to use the new url. For more information, see the SAP Knowledge Base Article 2243216.For more information, and latest update, see the SAP Knowledge Base Article 2261638 The latest updates of Crystal Reports are now using TLS 1.1 or higher. In 2017, dropped support for the encryption TLS 1.0, therefore all application using this encryption method will no longer be able to connect to, including Crystal Reports.For more details, see the SAP Knowledge Base Article 2853968 When moving to Salesforce Lightning, some reports based off Stored Procedure will start failing due to Salesforce change.
0 Comments
Read More
Leave a Reply. |