BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: SAP BOBJ User Group DC: Nov 30.

WebI Refresh error message


 
Search this topic... | Search WebIntelligence Version 6... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence Version 6  Previous TopicPrint TopicNext Topic
Author Message
Pan
Forum Member
Forum Member



Joined: 10 May 2013

Posts: 14


flag
PostPosted: Mon Apr 10, 2017 6:49 am 
Post subject: WebI Refresh error message

Hi there,

I am currently in the process of upgrading our Business Objects from XI 3.1 to BI 4.2, and have also migrated all the WebI reports across.

There are a number of WebI reports, which produce the following error message when refreshed: “The following database error occurred: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near ‘,’… For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Portal…”

These same reports work fine on XI3.1, but not on BI 4.2.

When I refresh the queries of these reports individually through the query panel they do refresh fine. Please note, that two out of the three queries are not returning any records. Once I select “Apply changes and Close”, then there are no rows returned for any queries, and all the report pages have therefore no records.

Any help on this problem will be greatly appreciated, because I’ve not been able to get to the bottom of this error message for some time now.

Many thanks in advance

Pan
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13962
Location: London


flag
PostPosted: Tue Apr 11, 2017 3:52 am 
Post subject: Re: WebI Refresh error message

Do the reports have prompts on them?

Quote:
When I refresh the queries of these reports individually through the query panel they do refresh fine. Please note, that two out of the three queries are not returning any records. Once I select “Apply changes and Close”, then there are no rows returned for any queries, and all the report pages have therefore no records


A little confused are you getting back any records or not?

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Pan
Forum Member
Forum Member



Joined: 10 May 2013

Posts: 14


flag
PostPosted: Tue Apr 11, 2017 5:10 am 
Post subject: Re: WebI Refresh error message

Yes, the reports in question do have prompts. The queries do actually return records when different dates are selected while they are refreshed individually within the query panel.

After the “Apply changes and Close” option is chosen (when leaving the query panel) they do return rows, but the reports do not refresh.

When I try to refresh the reports I am getting the above mentioned error message.
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13962
Location: London


flag
PostPosted: Tue Apr 11, 2017 5:25 am 
Post subject: Re: WebI Refresh error message

How are your user preferences set for Webi, this can affect date input formats?

Does this happen with both Java, Interactive viewer and scheduler?

Was there any changes to your SQL server prm file from version 3, you have not applied to the new 4 install?

How are the prompts defined, is it a certain prompt causing an issue?

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Pan
Forum Member
Forum Member



Joined: 10 May 2013

Posts: 14


flag
PostPosted: Tue Apr 11, 2017 7:02 am 
Post subject: Re: WebI Refresh error message

How are your user preferences set for Webi, this can affect date input formats?

When you say user preferences; are you referring to the access levels, where the user belongs to? I have been getting this error message, when logged in as the administrator.

Does this happen with both Java, Interactive viewer and scheduler?

Yes, this error happens when the Web Intelligence modify options have been set to HTML, as well as, Applet. I’m also getting this error message when I’m trying to schedule this report.

Was there any changes to your SQL server prm file from version 3, you have not applied to the new 4 install?"

I have had a brief look at the sqlsrv.prm files (MS SQL database is being used by the universe) on both BOXI and BI, but couldn’t find any particular issues.

How are the prompts defined, is it a certain prompt causing an issue?

I presume that the prompts are working fine, because the queries are running fine through the query panel, while the prompts are being used.

What do you think?

Thank you very much for your help and time icon_smile.gif
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13962
Location: London


flag
PostPosted: Tue Apr 11, 2017 7:11 am 
Post subject: Re: WebI Refresh error message

The user preferences are the Webi user preferences, where you can select the locales and time zone.

I have a feeling this could be to do with the wrong date format being passed to the database.

One other thing is if you schedule it, let it fail, then you edit the instance you may see something wrong in the SQL code that has actually being submitted (check the dates).

The next thing I would be doing is to try and build the same query from scratch and see what happens then.

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence Version 6  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0240 seconds using 17 queries. (SQL 0.0036 Parse 0.0006 Other 0.0198)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo