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

[DipenShah]

Hi Paul,

I think as per your error in Screenshot, its related to query issue.

Can you please also double check your query.

Thanks and Regards,

Dipen Shah

[DipenShah]

Hi Paul,

Can you please try to use HANA Connection string for getting HANA queries.

Thanks and Regards,

Dipen Shah

[paul_theconsultant]

Thank you for your suggestion.

I have created a HANA string connection using HDBODBC32 driver. After expanding the connection, I have noticed that the database (HANA_TEST) does not display SAP Business One tables. However, a previously migrated database (CSHP_TEST) which is a newer or recently created database does display the SAP B1 tables. See attached the screenshot.

Using the newly created HANA string connection, when I attempt to update the “Data Source Location” I get the same system error. See attached screenshot.

hana-test-dxconnection2.png

set-database-source.png