on 04-14-2016 6:41 AM
Hi experts,
I have replicated a table "gg_color1" from sybase to HANA successfully. I can see data in HANA Studio.
Now I want to add a field "CHANGE_DATE" to the target table and give it the value SYSDATE.
First, I add table in Table Settings in LTRS. I can find the table "gg_color1" in the list,
But when I click YES, it popups a message showing the table not exists in the source system.
Anyway , I click Yes and the table is added with its table structure. I add a new field CHANGE_DATE. Then I want to create a new event-based rule to assign value to it. But it shows ABAP code contains syntax errors.
I check the syntax and it shows:
then I find that the table "gg_color" does not exist in HANA DB any longer. It seems to be deleted.
I use the same way as I deal with ECC tables, but it doesn't work anyway.
So what's the process to create a rule to assign value to a new added field for a sybase table?
Thank you for your any input!
Regards,
Chong
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chong,
You have to follow the same process as ECC.
- Add new field in structure and then do the transformation.
Along with that also check,
- If table is having same name in source as you are adding in "gg_color1".
- check if DD0* tables have any entries in HANA (they should have).
- Go through the SAP note 2125689
Regards
BJ
Hi BJ,
Once again I did it following the same process as ECC, but no luck.
The same error occurred when I change the rule status from New to Released.
update my check as you mentioned:
1. table name is just "gg_color1" in SYBASE database.
2. DD02L and DD02T has data about the tables' information in SYBASE.
3. I don't think this note is fitfor our system as we have higher version.
Regards,
Chong
Hi BJ,
Once again I did it following the same process as ECC, but no luck.
The same error occurred when I change the rule status from New to Released.
update my check as you mentioned:
1. table name is just "gg_color1" in SYBASE database.
2. DD02L and DD02T has data about the tables' information in SYBASE.
3. I don't think this note is fitfor our system as we have higher version.
Regards,
Chong
Hi BJ,
found the reason. It's about the letter upper/lower of tables' name in sybase.
If the table's name is lower case , it will fail.
SAP system treats it as upper case, so it pops up a message showing the table not exists in source.
But I still think this is a problem, as SYBASE is case sensitive. There must be some settings to handle it.
Anyway I will mark this thread as solved. Thank you for your attention.
Regards,
Chong
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.