Skip to Content
0
Dec 01, 2011 at 09:36 PM

Strange Error Saving Qry in Query Designer

35 Views

I am getting a strange error when saving a BEx query.

The error looks like:

Formal error in table: CON, IOBJNM: 1SORTINFO, field: CONTYPE, value: 5

If I go ahead and save this and run it using RSRT I get the error a bit more detailed:

Message Text

Formal error in table: CON, IOBJNM: 1SORTINFO, field: CONTYPE, value: 5

Technical Data

Message type__________ E (Error)

Message class_________ BRAIN (Messages: BRAIN)

Message number________ 450

Message variable 1____ CON

Message variable 2____ 1SORTINFO

Message variable 3____ CONTYPE

Message variable 4____ 5

It happens on miscellaneous cubes, multi-providers, and even dso. However, some objects I don't get the error.

My scenario for duplicating this error is:

1) create new qry, select cube or multi-provider

2) drag a char into the rows

3) drag a key fig in the cols

4) press the "qry check" link

ERROR appears.

All these objects are activated.

It must have happened during our change to 7.0 enh 1, but only ocurrs in our DEV and SND systems, QA, and PRD are fine.

Anyone see this before?

Mike