Errors in R4 reports

[Former Member]

Hi

We have migrated to BO 4.0 from BO 3.0 . During report testing in R4 we have found the following errors:

1. During refreashing the Report:An internal error occured while calling ‘getPromptList’ API. (error: ERR_WIS_30270)

2. During selecting LOVs for Prompt:com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occurred while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)

3. During Scheduling the report:Database error: ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.. (IES 10901)

Please share your idaes to resolve these errors.

Thanks

Ghanshyam

[CdnConnection]

      Have you run the the Configuration wizard to optimize the Adaptive processor servers and update memory settings of the split servers.  Sounds like server NOT sized / optimized properly.

Regards,

Ajay

[Former Member]

No Henry not tried through IDT.

[Former Member]

Its Sybase

[Henry_Banks]

another option/test to consider : have you tried converting the UNV to UNX (information design tool) then reworking the report to use the 64 bit connectivity layer?

[Former Member]

Hi Henry

Here are the details;

1. Service Pack of BI 4.1:SP4

2. Yes these are webi reports.

3. based on UNV universe

4. reports based on universe.Running it from BI 4.

5. No some reports are running well of different universes. But for the reports of a particular universe creating issues as mentioned.

Thanks again

[Henry_Banks]

just to clarify, what is the datasource behind these universes?  BW, Oracle, Access?

[Henry_Banks]

Hi,

There could be a very great number of things which could be tripping up this process . it'll be hard to find out what! 

it could be a prompt that needs recreating, or a formula which is broken, for example.  I'd recommend using the Note facility SAP Note & Knowledge Base Article Search | SAP Support Portal   .. and searching the keywords of the error, for example:

1596593 - Intermittent errors when refreshing a report: processDPCommands or getPromptList

2154043 - Web intelligence schedule fails intermittently with error "An internal error occurred while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)". 

regards,

H

[Henry_Banks]

Hi,

1. What Service Pack of BI 4.1 are you using?
2. Are these Webi reports? 
3. Are they based on relational universe (unv or unx) 
4. what is the source behind the query?
5. Is this a problem for all reports, or only some?

regards,

H