Skip to Content
0
Former Member
Jul 11, 2011 at 06:31 AM

Publication getting failed for WEBI Report. Unable to connect to SAP BW

1112 Views

I am scheduling a publication for a webi Report.

I have imported SAP Users From BW into BO CMC.

Created a universe based on BEx query.USed SSO option in desginer.

In BW run the query with SAP user id,query runs fine.

When publication runs, it shows as a failed giving the below error

2011-07-11 11:55:01,093 ERROR [PublishingService:HandlerPool-89] BusinessObjects_PublicationAdminErrorLog_Instance_409861 - [Publication ID # 409861] - Scheduling document job "Report Burst" (ID: 409,844) failed: A database error occured. The database error text is: Unable to connect to SAP BW server Incomplete logon data.. (WIS 10901) Scheduling document 'Report Burst' (ID: 409,844) failed for the following users: BWP~300/100392R3 (ID: 405381) . These users had the following profile values: [No profile values] (FBE60502) [1 recipients processed.]

The Log file containd the below message.

2011-07-11 11:54:57,234 INFO [pool-4-thread-16] BusinessObjects_PublicationAdminLog_Instance_409861 - [Publication ID # 409861] - Running publication instance.

2011-07-11 11:54:57,327 INFO [pool-4-thread-16] BusinessObjects_PublicationAdminLog_Instance_409861 - [Publication ID # 409861] - The global delivery rule for this publication was met; publication processing will now begin.

2011-07-11 11:55:01,093 ERROR [PublishingService:HandlerPool-89] BusinessObjects_PublicationAdminLog_Instance_409861 - [Publication ID # 409861] - Scheduling document job "Report Burst" (ID: 409,844) failed: A database error occured. The database error text is: Unable to connect to SAP BW server Incomplete logon data.. (WIS 10901)

Scheduling document 'Report Burst' (ID: 409,844) failed for the following users:

BWP~300/100392R3 (ID: 405381)

. These users had the following profile values:

[No profile values]

(FBE60502)

2011-07-11 11:55:01,234 INFO [pool-4-thread-16] BusinessObjects_PublicationAdminLog_Instance_409861 - [Publication ID # 409861] - Publication scheduling complete.

Please help to resolve the issue.