Skip to Content
Former Member
Jan 30, 2008 at 02:17 AM

Very Urgent: UDC Error in BI datasource preview


Hi All,

My requirement is to extract the data from the legacy system i.e. Sybase 12.5 using UDC to SAP BI 7.0. We have established UDC connection, created view and BI 7.0 datasource. The user has all the access i.e. select, dbo access for the view. While datasource creation I have selected UDC source object from the Sybase, used default system proposed fields and activated the datasource. When I try to check the data in the preview, I am getting following message in the status bar:

S:RSSDK:300 Query execution failed: "DB name"."dbo"."VIEW1" not found. Specify owner.objectname or use sp help to check whether the object exists (sphelp may produce lots of output). I have checked in the URL http://<hostname>:port/TestJDBC_Web/TestJDBCPage.jsp before preview, it worked fine and showed all the table names and data in tables.

By same username I have logged in Sybase and ran created view, which extracted data without any problems.

We have followed same procedure for creation of connections, views and datasources for SQL server, it is working fine without any issues. We have problem only with Sybase system. Would anyone help me in resolving this issue. ******Gurantee of award points********