Runtime Errors: DBIF_DSQL2_SQL_ERROR

[former_member224276]

Hello Friends,

I am useing 4 keyfigures ie CALENDER DAYS,SHUT DOWN DAYS,AVAILABLE HOURS PER DAY,ROLLING RATE for these keyfigures I am using the data type NUMBER ,NUMBER,NUMBER,NUMBER respectivelly like this and in Planning Area for these keyfigures Keyfigure Aggregation Tab page menction like this

CALCULATION TYPE TIME BASED DIS

CALENDER DAYS: S P

SHUT DOWN DAYS: S P

AVAILABLE HOURS PER DAY: A P

ROLLING RATE : A P

based on these 4 key fig we can calculate the Production State Forecast:

example : CALENDER DAYS: 31

SHUT DOWN DAYS: 2

AVAILABLE HOURS PER DAY: 22

ROLLING RATE :170

through macro iam getting:

Production State Forecast=(31-2)22170=108460 tons

after that i want to save the data that time system goes to DUMP from SAP.

I am getting the error like this Runtime Errors: DBIF_DSQL2_SQL_ERROR

Pl thorough me some light on me.

Edited by: sivaram2411 on Dec 28, 2010 1:29 PM

[Former Member]

Hi

I will suggest to go to ST22 and find the logs from dump and provide us.

This will help us to understand the issue in detail . In mean time, I will also suggest to check the SAP Note 723149 - Error due to incorrect SQL syntax

Thanks

Amol