error when taking date fields in query

[Former Member]

hi

when ever i am creating without date fields it is working fine

but i have date fields in query it is showing me an error

how to fix this

[Former Member · Accepted solution]

when i click execute in rsrv for thes two objects for checking inconsistencies

every thing is green but when i check ods i am getting errors in this way

for ods

The SID values are missing for 1 specifications for characteristic CMOD_ON

The SID values are missing for 1 specifications for characteristic CLST_RON

for that two info objects

<u>Check master data for characteristic CMOD_ON</u>

Parameters

Char. = CMOD_ON

Elementary Tests

Check object version of the values in characteristic CMOD_ON

Value flagged for deletion in active version. No M-version available: Characteristic CMOD_ON

A and M versions of a value are available. D-flag blank for character.CMOD_ON

Time intervals in Q table for a characteristic with time-dep. master data

Compare number range for SID of characteristic CMOD_ON / 0DATE with max. SID

Check blank entries in SID and master data tables of characteristic CMOD_ON

Check for Characteristic Values from Text Table in SID Table

Compare characteristic values in SID/P/and Q tables for characteristic CMOD_ON

Check if blank values of attributes in characteristic CMOD_ON are type-related

Check existence of values for navigation attributes in characteristic CMOD_ON

SID values in X and Y table: Characteristic 'CMOD_ON'

Compare sizes of P or Q and X or Y tables for characteristic CMOD_ON

Check flags in the SID table for characteristic with master data

Characters not allowed in characteristic values (characteristic CMOD_ON)

<u>Check master data for characteristic CLST_RON</u>

Parameters

Char. = CLST_RON

Elementary Tests

Check object version of the values in characteristic CLST_RON

Value flagged for deletion in active version. No M-version available: Characteristic CLST_RON

A and M versions of a value are available. D-flag blank for character.CLST_RON

Time intervals in Q table for a characteristic with time-dep. master data

Compare number range for SID of characteristic CLST_RON / 0DATE with max. SID

Check blank entries in SID and master data tables of characteristic CLST_RON

Check for Characteristic Values from Text Table in SID Table

Compare characteristic values in SID/P/and Q tables for characteristic CLST_RON

Check if blank values of attributes in characteristic CLST_RON are type-related

Check existence of values for navigation attributes in characteristic CLST_RON

SID values in X and Y table: Characteristic 'CLST_RON'

Compare sizes of P or Q and X or Y tables for characteristic CLST_RON

Check flags in the SID table for characteristic with master data

Characters not allowed in characteristic values (characteristic CLST_RON)

[Former Member · Accepted solution]

Try loading the master data for these objects and activate it.

These error comes when transactional data is loaded first without master data and system is not able to locate the SID.

regards.

[Former Member]

I faced this issue after the upgrade to BI7 when loading data from extenal datasource like DB-Connect and solved that by changing the null date values in source data to eight zeros '00000000' and the time to 6 zeros.

If your data source in oracle view then use

NVL(TO_CHAR(n.effdate,'YYYYmmdd'),to_char('00000000')) EFFDATE,

Regards

Abdullah

[Former Member]

thanks for answering

now i know these two fields r causing a problem during the execution of the query

but i went to rsrv checked the consistencies

everything is fine over there

how to fix this because i need those objects in my query

[Former Member]

Use the repair functionality for these two objects in RSRV itself. once fixed you can use them in your query.

Regards.

[Former Member]

i went in rsrv transaction

i checked for error by going in ods objests

i found these two errors

how to solve this

The SID values are missing for 1 specifications for characteristic CMOD_ON

The SID values are missing for 1 specifications for characteristic CLST_RON

note:these two fields r date fields

[Former Member]

In RSRV Goto All Combined Test -> Master Data -> Check Master Data for characteristic.

Once it gives you the error, try the repair option from there.

After that try executing the query.

I believe it should work

Regards.

[Former Member]

thanks for answering

actually the data target is dso but it is showing in the erroir msg as

cube

i dont know why it is showing

[Former Member]

Hi Vishal,

What error message you are getting.

regards.

[Former Member]

Termination message sent

SUCCESS BRAIN (603): The definition of query SUB_TEST1 (InfoCube LEV_1) was saved.

MSGV1: SUB_TEST1

MSGV2: LEV_1

SUCCESS BRAIN (608): Query SUB_TEST1 (InfoCube LEV_1) was saved.

MSGV1: SUB_TEST1

MSGV2: LEV_1

ABEND RSBOLAP (000): Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

MSGV1: SAPMSSY1

MSGV3: UNCAUGHT_EXCEPTION

com.sap.ip.bi.base.application.exceptions.AbortMessageRuntimeException: Termination message sent

SUCCESS BRAIN (603): The definition of query SUB_TEST1 (InfoCube LEV_1) was saved.

MSGV1: SUB_TEST1

MSGV2: LEV_1

SUCCESS BRAIN (608): Query SUB_TEST1 (InfoCube LEV_1) was saved.

MSGV1: SUB_TEST1

[...]

SUCCESS: The definition of query SUB_TEST1 (InfoCube LEV_1) was saved.

SUCCESS: Query SUB_TEST1 (InfoCube LEV_1) was saved.

ABEND: Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

ABEND: Error reading the data of InfoProvider LEV_1

ABEND: ORA-01722: invalid number

[Former Member]

Hi Vishal,

Try to see the contents of the cube via listcube for the same condition you are giving in your query and see if you are getting any records.

Also you can check the status of the data in your cube by this test.

RSRV -> All Combined data -> Transactional data -> Status of the data in the Infocubes

Hope that helps.

regards.

[Former Member]

Hi,

Are you getting any error description? If so, provide the error. Or else, it is very hard to analyze the thing.

Is both dates also in the time characteristics. I think one or more date is maintaining in the key figure column. If that is the case, you cant get the proper formated report. May be error will come. Not sure.

Regards,

Vivek V

[Former Member]

thanks for answering

if i have only one date in the query

my query is getting executed

if i have more than one i get errors

[Former Member]

Hi Vishal,

Go to querry designer and right click on info object and go to properties there u can maintain settings for u r date object.

Other wise in the info object level also in u can set settings of u r info object.

Before that check the data of of u r date field in concern info providers. Whether it is properply maintained or not.

Hope this will help

HARI GUPTA