cancel
Showing results for 
Search instead for 
Did you mean: 

Error when refreshing document (Webi Rich Client from XLS file)

Former Member
0 Kudos

Dear all,

Hope you're doing well.

I need to develop a simple "feasibility test" report on Webi Rich Client (Data source : xls file) and I have to publish it in infoview with possibility of refresh (when XLS file is updated).

So, this is what I did : I develop it on Webi Rich Client and I publish the table as Web Service, then I create an other report which is pointing on the web service that I created, so far so good.

But when I export in infoview then refresh my document (pointing on Web service of course), I meet the following error : An internal error occurred while calling the 'processDPCommands API' (Error: WIS 30270)

Can you help me to resolve this issue?

Thanks so much.

Mouhsine T.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Copy File from Client system to server in same folder location .

Make sure in Edit Query option Editable & Refreshable options are checked .

Please check the links below  .

Former Member
0 Kudos

Hi Nikhil,

Thank you for your answer. I seen all this links before posting this discussion and your first link seems be the nearest from my issue.

However, XLS file should be in the network, but it's accessible.

Any other ideas ?

Regards,

Mouhsine

Former Member
0 Kudos

Hi,

Which version are you using ?

Please check the link below .

http://www.forumtopics.com/busobj/viewtopic.php?p=926558&sid=1c139a580100a647b0c137eb19f66a6c

Else Try Creating & Using Universe ( UNV or UNX ) on top of Excel .

Former Member
0 Kudos

Hi,

The solution described in the link was done and there is no change.

Version is SAP BusinessObjects Enterprise XI 3.1 SP4.

The Universe solution is the current one and my client would like to apply the solution using web services in its environment.

Regards,

Mouhsine

Former Member
0 Kudos

Hi,

There are few links

Link Below is 4.1 SP2 related but see if you find any option like that (I can not test it now ).

Link below has Explained 2 Scenarios in middle of discussion also Registry setting for Excel .

http://www.forumtopics.com/busobj/viewtopic.php?p=777435

http://scn.sap.com/message/9582368#9582368

Answers (1)

Answers (1)

Former Member
0 Kudos

Copy XLS file on the server.

Create Universe on top of the XLS file in the server.

Create Webi on that universe and publish the block as Web Service, this should work.

Former Member
0 Kudos

Hi Varjit,

Thanks for your answer.

This is not really the real issue. I need to create a simple report based on an xls file using Rich Client. The file is located in the network and accessible to all (server and users)

I would like to refresh it on infoview. I know that it's possible to do that using publishing bloc as web service since SP3.

Everything works fine out on Rich Client, but I meet an error on infoview.

Regards,

Mouhsine T.

former_member188911
Active Contributor
0 Kudos

Hi Mouhsine

does the error have additional details, normally WIS 30270 comes with other information.

Also, gettting trace logs as per KBA 1335757 should help understanding what is going on

Thanks

Simone

Former Member
0 Kudos

Hi Simone,

Thanks for your answer.

The issue is not resolved yet. I think that next SP resolves this issue. But the customer should not delay to migrate to SAP BI 4.1, so I'm waiting for the new plateforme...

Regards,

Mouhsine