cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in retrieving SAP BI query

0 Kudos

Hi Experts!

I'm testing Visual composer 7.0 preliminary version(Flex availble) in NW2004s sneak preview.

When I find SAP BI query service in Find data area, inforarea tree and query list are listed up well in VC.

But, When I try to drill down to characteristics, there is an error.

"Error-30027Cannot retrieve structure Cannot read query definition:com.sap.engine.lib.xml.parser.ParserException:Unsupported character:8c(:main;, row:1, col:919)"

and also I cannot drag query or query view to VC workspace. Another error message pop up.

"Error-30005Cannot create the BI data service Cannot add BI data service to iView MYiView"

How can I fix it? I've tried to do "How to resolve visual composer issues" guide. but it was not helpful.

Help me!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

That seems to be a bug with special characters. Try to rename texts of the charcateristics in the query definition (with BEx Query Designer).

Mario

0 Kudos

this problem happens with double byte characters. to walkaround this problem, you can set your logon language to EN, by setting portal user's default language.

a fix to this problem is provided in SPS8.

0 Kudos

Yes, you're right...

I've also tested it as you let me know. It works well.

If I set my portal logon user language to Korean, It doesn't work. I think it cause double byte problem.

Thank you for your reply and I will wait SPS8.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Shan Jiang,

Can u please tell were do i set this portal user's default language

My user's language is set to English already.

Gtng the same error.

Aanchal

Former Member
0 Kudos

Dear all,

Firstly, i'm new to this forum, and started working with VC since last week. So hello to you all.

Secondly, i've got a similar error as Young Seol Sohn once did (although still different).

I have several queries...and a model in VC. Everything is working fine (except some 32kb flex errors so now and then).

Now i want to include traffic light exceptions in my model. So i adjust 1 query (in query designer), include the preferred exception, and try to refresh (the same query) in my VC model.

The error i get is:

ERROR -30005: Cannot create the BI data service Cannot retrieve structure Cannot read query definition:null:null

If i remove the exception, i can refresh again. Anybody any clues?

Thanks in advance.

Kind Regards,

Bart

Former Member
0 Kudos

well, dont bother anymore, the problem is solved.

I've adjusted my exception in QD: under the defintion tab the keyfigure wasn't set to the correct value.

Well if anybody else ever encounters the same error message, maybe this helps?

Regards,

Bart