SAP ABAP AS NW 7.52 SP01 Buggy (SYBASE ASE errors due to ABAP CDS)

[ramaanne]

As of Today - dated 20th July 2020

I have tried to just download the files - SAP NetWeaver AS ABAP Developer Edition 7.52 SP04
since this morning

with IE EDGE browser

Chrome

Firefox

cleared history /browing data all combinations

It keeps asking me for S-USERID does that mean it only will allow S-USERID not P-USERID

reason being I downloaded Hana Express 2.0sp03 and SAP NetWeaver AS ABAP Developer Edition 7.52 SP01 ONE or two years back (2018)

Also SAP NetWeaver AS ABAP Developer Edition 7.52 SP01 has A SAP bug in SYBASE ASE for some SAP supplied ABAP CDS view sdraft_lock as reported on sap community blogs of Julie Plummer - see below

Okay, the bug. Reason: the CDS function “TSTMP_ADD_SECONDS” is implemented differently in SYBASE ASE (works for timestamps WITHOUT microseconds) and in HANA (works for timestamps with microseconds). In the CDS view SDraft_Configuration, the following lines have the bug:( as reported by sap community member SANDRA ROSSI)

case//whenCustomer.draft_entity isnotnull//then tstmp_add_seconds(:p_current_time,//cast(-Customer.expiry_duration asabap.dec(15,0)),//'FAIL')when Entity.draft_entity isnotnulland Entity.expiry_duration >0then tstmp_add_seconds(:p_current_time,-Entity.expiry_duration,'FAIL')else tstmp_add_seconds(:p_current_time,-Global.expiry_duration,'FAIL')endas expiration_time

It could be solved if you find a way to change these lines as follows:

case//whenCustomer.draft_entity isnotnull//then tstmp_add_seconds(:p_current_time,//cast(-Customer.expiry_duration asabap.dec(15,0)),//'FAIL')when Entity.draft_entity isnotnulland Entity.expiry_duration >0then tstmp_add_seconds(floor(:p_current_time),-Entity.expiry_duration,'FAIL')+:p_current_time -floor(:p_current_time)else tstmp_add_seconds(floor(:p_current_time),-Global.expiry_duration,'FAIL')+:p_current_time -floor(:p_current_time)endas expiration_time

So I do have a - SAP NetWeaver AS ABAP Developer Edition 7.52 SP01 THE above bug is show stopper like SEPMRA_SHOP service the shopping cart items are not displayed only the total in the SAP FIORI APP ,I debugged it is in SAP STANDARD CODE in odata serviice (dump shows some 200 routine called ) something about SDraft_Configuration.... SYBASE ASE HAS ST22 DUMPS that are growing forever as any ODATA srevice with decimal/timestamp values will keep generating same errors

I have not seen a single person post how they resolved this issue ,it is just some SAP HOBBYISTS asking trivial installation steps etc

so iam basically stuck with a buggy SAP NetWeaver AS ABAP Developer Edition 7.52 SP01 edition based VM and assuming the above is fixed i do not have a S-USERID to download

SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 files ....

Can someone please help ...or post resolution

I have attached screen shots afterpscreen.jpgask-suserid.png

thanks

rama anne

afterpscreen.jpg (166.8 kB) ask-suserid.png (31.2 kB)

[ramaanne]

Open sap course extending SAP S/4 HANA to cloud by Thomas Breseir uses

ABAP as NW 7.5x sample Fori Ref app called SHOP ,PRODCTS ETC

This Shop app uses SEPMRA_SHOP odata service ,the SAP standard code deep in the service data calls uses some SDRAFT_LOCK etc which in turn calls SDraft_Configuration abap CDS view now this cds view is where they missed timestamp data in Sybase ase vs hana db ,consequence if you have varchar to decimal ,timestamp based data in odata service ,then SYBASE ASE WILL DUMP ST22 /SM21 logs ........

In the front-end you will not see ShoppingCart items in the browser only header total ... so yes it is a show stopper and potentially will affect all ODATA services

I scoured google and forums (#ABAP_TRAIL ) tag to see how others have reported or resolved the issue ....but nothing

so do not know if -- SAP ABAP AS NW 752 SP04 FIXED if fixed how to download the files .....

thanks

Rama anne