Can't select tables using SAC SQL Databases

[former_member788960]

Hi,

I'm not sure if others are having this issue. I'm using the SACKIT339 to deploy the SAP Cloud Connector and Cloud Agent. I'm able to configure the Cloud Agent to correctly connect to the MS SQL Server database but no tables are shown to select when the Build a Query dialog box is shown.

Is anyone else having this issue? It was working in previous versions of SAC (2018.22.2) but seems to not work in my current tenant (2022.2.2)

I have tried to troubleshoot the issue with various MS SQL JDBC drivers and DriverConfig.properties settings but no combination of JDBC driver and MS SQL Server 2008, 2012, 2014, 2016 combination resolves the issue.

I have created SAC Connections with Users that have full Administrator rights to the databases but that doesn't seem to resolve this issue either.

Any guidance would be appreciated.

Thanks!

[ashokkumar_kn]

HI,

In order to make sure it is not a configuration issue, could you confirm that you are able to fire Freehand SQL and get data.

If you are able to data via Freehand SQL, this could be an issue that needs investigation. Please reaise support ticket with MS SQLserver Database version.

Thanks,

[former_member788960]

Hi Ashok,

Yes. I am able to use Freehand SQL as an alternative currently and it brings back data. I have been attempting to raise an incident with SAP but my SAP Support Portal rights currently will not allow me to create a system to place the incident ticket against. I'm working on adjusting that this week.