Hello, I would like to present a new backup software that we N'Ware Technologies have been developing to support our customer running on Hana.
We made this backup software because existing backup software were missing basic functionality or were com...
I am having problems trying to add a column as a primary key. I can't find how to add a column and specify an unique specification. According to the documentation, I should be able to do it. Someone have an idea what I am doing wrong ? According to t...
I could not find documentation on the configuration settings idle_connection_timeout available under Configuration->indexserver.ini->session in hana studio. If someone know where to find such documentation please post back.I have a situation where th...
This guide shows common SQL differences between MSSQL and Hana and provide guidelines to ease the migration of a software to hana. It can help you using SAP Business One database/schema on Hana, and may also help you if you create your own schema lik...
I have a foreign key problem that I can't understand. I can work around this bug, but the price is high. Either we have to change every update that check data from other data, we drop all foreign keys, or set them to update cascade. Create column tab...
... and the last example with sequence show that you will insert the sequence of i into test2, and not your i variable generated by the for, so so it's normal you might not have test2.x > 100 because those are two different var.
For (1..500) might be executed in parallel. current_identity_value will probably not return the last inserted value from this thread, but any thread. In your case, execution of foreach with i = 100 started and inserted, but then another thread proces...
by the way, if you activated a new service, the scriptserver or whatever is asked in the b1 system admin guide, normally it start right away and everything is good, but maybe you could simply reboot the database to have it activated. also while I am ...
2. when you install hana, it might or might not ask you if you want to auto start the service on reboot. if you missed this settings, look at /hana/shared/<SID>/profile/<SID>_HDB00_<MACHINENAME>. there is a property AutoStart=0, set that to 1. issue ...
At this point you will need someone better than me. Look at the Diagnosis files for each landscape service to see if there is a problem. Read the sap notes on what you find. Note that it takes some time for the landscape and services and global statu...