SAP HANA 2.0 now released for SAP Solution Manager 7.2
Great news: SAP HANA 2.0 has been officially released also for SAP Solution Manager 7.2! With this release, you can now run your SAP Solution Manager system using SAP HANA 2.0 as a database.
Find more detailed release information in the Product Availability Matrix (PAM).
More information about SAP Solution Manager is available on the SAP Support Portal.
Information about SAP HANA 2.0 is available here.
Excellent news, thanks a lot
Finalmente!
Hi Benjamin - Is there a minimum SSM7.2 SP-level you need to be on, for migrating to HANA2.0? KR Dino
H,hello
Indeed a good news!
However when looking to the details I still see some restrictions at least for HANA on POWER
The Solution Manager 7.2 ABAP stack on HANA DB 2.0 is support on both LINUX on POWER BIG ENDIAN and LITTLE ENDIAN!
However the Java stack is “currently” support only on LINUX on POWER BIG ENDIAN which is not support on SUSE 12
Means we have 2 options:
- LITTLE ENDIAN: ABAP + HANA DB 2.0 on SUSE12
- BIG INDIAN: JAVA + HANA DB 2.0 on SUSE 11
When can we expect that JAVA stack is released also on SUSE 12 with LITTEL ENDIAN?
With regards,
Abdelhadi
Hi Abdelhadi,
it is not possible to run HANA 2.0 on Linux on Power BE. Please read note 2235581 (SAP HANA: Supported Operating Systems). HANA 2.0 is connected to SLES12 - Intel and PowerPC:
What you can do is connect an application server running on Linux on Power SLES11 BE to a HANA 2.0:
Hello Jens,
Thank you for the update!
We prefer to have all SOLMAN 7.2 server components (JAVA, ABAP and HANA) on one LPAR, with the given restrictions with HANA DB2.0 it is currently not possible 🙁
Best regards.
We're currently running SolMan 7.2 on a RHEL 7 VM (both ABAP and Java instances) and connecting to a HANA 1.0 database on another instance.
Are we good just to upgrade the HANA instance to HANA 2.0, or is there something will need to be done on the App side of things as well?
Awesome article. Thanks for making that available. I've been using your help to build my own POC and will publish the steps in <a href="https://asha24.com/blog/sap-hana-architecture">another blog</a>soon.
I have a hdbdd defined as below, but the fuzzy search I tried using this search query as doesn't works.
https://xxxxxxxx.xxx.xx.xxxxx.com/xxxxx.xsodata/LandValue?$format=json&search=singaporw
Only maps to full text. E.g. "Singapore" instead of "singaporw" or "sing"
namespace xxx;
@Schema : 'XXX'
context fuzzysearch
{
@Catalog.tableType : #COLUMN
entity ADDRESS {
key id : Integer;
street : String(80);
zipCode : Integer;
city : String(80);
@SearchIndex.text.enabled : true
@SearchIndex.fuzzy.enabled : true
country : String(80);
};
@Search.searchable: true
define view V_ADDRESS as select from ADDRESS as ADDRESS {
@EnterpriseSearch.key : true
ADDRESS.id,
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
@Search.fuzzinessThreshold : 0.7
ADDRESS.country
};
};
Appreciate your effort for making such useful blogs and helping the community.
Obrigado,
Rahul Mahajan
Hi Ben,
Thanks so much for this article! I tried to follow some instructions from few other article and got in over my head. This worked so quickly and your instructions were very easy to follow. Really appreciate this.
after installing and configuring Agile Data Preparation SP23 on my HANA Express Edition 2.2 Server, I encounter the following error when trying to de-duplicate my data:
pop.addInputNodeMapping('INPUT_1sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_','INPUT_1sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_')
[4437]{205738}[26/1426526] 2018-03-05 08:00:19.066832 e cePlanExec cePlanExecutor.cpp(08147) : Error during Plan execution of model HXE::SAP_HANA_IM_ADP_STAGING:sap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1 (t -1), reason: executor: plan operation failed;Execution of Adapter operation within node CLEANSE_Addresssap.hana.im.adp.target.transformation::FG_383B8DD8CB8E44C1B5ADD8E48804E417_1_TEMPLATE_ failed: exception 141005: Failed to create or initialize HanaTransform object
[2727]{-1}[-1/-1] 2018-03-05 08:00:20.584812 e xsa:sap.hana.im. SandBox.cpp(01560) : Found the following errors:
===========================
ApplicationException: Last transformation was unsuccessful while running flowgraph. (line 30 position 1 in /sap/hana/im/adp/adp/Errors.xsjslib)
Could anyone point me into the director where to look for the cause? I could not find any SAP Notes or other documentation regarding this behavior.
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Obrigado,
Irene Hynes
---------------------------------------------------------------------------------------------------------
Hello,
Thanks for the post. Very good details. Worked like a charm. Good directions.
I know that we can use some general aggregation functions such as sum, min, max,avg in cal view. but I need to use the STRING_AGG aggregation function which in hana lib, can I use this in Calculation view? and how can i use other aggregation functions which in hana lib in Calculation View?
I have developed the store procedure in hana.
Now i want to call that procedure in SAP query manager with two parameter (BP group, BP name).
Please suggest how to call ...
By the way do you have any YouTube videos, would love to watch it. I would like to connect you onLinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Please keep providing such valuable information. </a>
Cheers,
Irene Hynes
Dear All,
I am facing an issue during install Solution Manager 7.2 JAVA.
Under the installation, I need to use SAPJVM6.1
Is HANA DB 2.0 SP03 working with SAPJVM6.1?
My Error is va.lang.UnsupportedClassVersionError: <path> has been compiled by a more recent version of the Java Runtime (class file version 51.0), this version of the Java Runtime only recognizes class file versions up to 50.0
according to the note
https://launchpad.support.sap.com/#/notes/2681874
Thanks,
Gotfrid Spath