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

116 Views Last edit Jul 20, 2020 at 04:48 AM 2 rev

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.jpg ask-suserid.png

thanks

rama anne

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