Changing Datasource Location for existing Crystal Reports - After Migrating from MsSQL to HANA 2.0

[paul_theconsultant]

Hi All,

I am working on Windows Server 2012 Standard 64 bit. I am attempting to replace the "current data source" with the "replace with" data source option in Crystal Reports 2016 SP07. In Crystal Reports, under “Set Data source Location” the:

“Current Data Source”: Is a SAP Business One (v9.3 PL05) database on MsSQL 2014 and

“Replace with”: Is a migrated SAP Business One (v10 PL01) database on HANA 2.0. It is an ODBC connection (32 bit) set-datasource-location.jpgto HANA 2.0

In view of this, I am receiving two (2) error messages, one is the attached screenshot and the following system message:

“Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables.”

I have attempted to apply the recommendations (creating a new Key) on the registry as laid out on the link below on both the DatabaseOptions and DatabaseServer. But this does not resolve the issue.

https://answers.sap.com/questions/7563678/crystal-reports-2008-mysql-jdbc-and-odbc.html?sort=newest

Registry Path:

-HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions

-HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseServer

I welcome any suggestions to resolve this data source location or replacement issue

[mgregur · Accepted solution]

Hi Paul,

HANA uses different syntax and is case sensitive. So, a query in SQL which would be

SELECT T0.[ItemCode] FROM INV1 T0

would in HANA SQL be

SELECT T0."ItemCode" FROM INV1 T0

You would need to update your query in order to change the datasource.

BR,

Matija