cancel
Showing results for 
Search instead for 
Did you mean: 

fatal cast error

marcus_herz
Explorer
0 Kudos
63

What's this:

select

cast(floor(1610 / 100) as sql_char ), floor(1610 / 100)

from system.iota

should result to  '16', 16.

But it doesn't: cast(..) results to '46251968173'

How can I distribute Ver12 and be sure the apps are running and the clients can rely on the data? Who knows whats next ????

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I can confirm this.

On Ads 12

CAST(FLOOR(INTEGER) AS SQL_INTEGER) -> Out of Range

CAST(FLOOR(FLOAT) AS SQL_INTEGER) -> SUCCESS


Greetings Mark

marcus_herz
Explorer
0 Kudos

Hi

I am still waitung for an update or at least a timeline when this will be fixed.

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

It's reported to the engineering. If you need a status update, so please open a support incident, which we can assign to the engineering and you can track the status of this issue.

marcus_herz
Explorer
0 Kudos

Hi

I move back to version 11.

I tried to create a support incident. Failed with the message:

Business Server Page (BSP) Fehler


Was ist passiert?

Der Aufruf der BSP-Seite wurde aufgrund eines Fehlers abgebrochen.

Hinweis
  • Folgender Fehlertext wurde im System prozessiert:
    BSP Exception: Das Objekt `../bosap_sysdata/system_main.htm in der URL /sap(bD1kZSZjPTAwMQ==)/bc/bsp/spn/create_sysid/%60../bosap_sysdata/system_main.htm?sysnr=000000000900064608&smpsrv=http://service.sap.com` ist nicht gültig.

Fehlerart:

Ihr SAP Business Server Pages Team

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Please contact CIC by phone, so they can forward this issue (problem creation support incident) to the right place: https://websmp209.sap-ag.de/~SAPIDP/002006825000000234912001E

Former Member
0 Kudos

Hi Marcus,

i've tested your query with ads 11.10.0.10 over arc 11 and it shows '16', 16 ..

Whats your environment?

marcus_herz
Explorer
0 Kudos

Hi

I am talking of vers. 12, that is what I am testing....