Error while changing from table to view

[singh-santosh]

Hi,
I am getting following error while changing from table to view after configuration of full load and cdc package.

TITLE: Microsoft Visual Studio
------------------------------

Could not retrieve the table information for the connection manager 'Full Load OLEDB Source DB Connection'.
[8001] GetNextRows: Failed to get rows.
[A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
SDK9051E: FETCH ERROR
SDK9051X: Failed to Get contents of table

------------------------------
ADDITIONAL INFORMATION:

[8001] GetNextRows: Failed to get rows.
[A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
SDK9051E: FETCH ERROR
SDK9051X: Failed to Get contents of table (AttunityOracleCDC)

------------------------------

Please help

[Gadi.Farhat]

Hi,

This error indicates that the source component, using the 'Full Load OLEDB Source DB Connection' can't find the specified view.

Check that the user specified in the connection manager configuration has privileges to access the specified view.


Regards,

Gadi

[singh-santosh]

User which i am using to connect source DB is having equivalent to sysdba privileges

Hi,

This error indicates that the source component, using the 'Full Load OLEDB Source DB Connection' can't find the specified view.

Check that the user specified in the connection manager configuration has privileges to access the specified view.


Regards,

Gadi

[Gadi.Farhat]

In the Source Component, try to change the Data access mode to SQL command, and in the SQL command text specify something like: "select * from view"


Gadi

[singh-santosh]

I have just checked changing it with SQL command in Data Access Mode
and wrote a query select * from myview and checked with preview data was showing properly..any clue?

In the Source Component, try to change the Data access mode to SQL command, and in the SQL command text specify something like: "select * from view"


Gadi

[singh-santosh]

One more information..i am not getting this error on regular basis...like i have just checked with small number of tables and view..and its working fine...but when i am using like 45-50 tables/views it gives the same error.

hope this will help you to figure out the root cause.

Thanks

I have just checked changing it with SQL command in Data Access Mode
and wrote a query select * from myview and checked with preview data was showing properly..any clue?

[Gadi.Farhat]

Hi,

Is there somthing special with the problematic table/view names, like special characters or lower/upper case or maybe the name length? Can you give an example?


Thanks,

Gadi

[singh-santosh]

view names are

VWAP_ALLOC_BASELINE
VWAUTOPLANALLOCATION
VWAUTOPLANTASK
VWEDFI
VWPROJECT
VWPROJECTTSL
VWTIMESHEET
VWWORKFLOWITEMACTORDATA
VWWORKFLOWITEMDATA
VWWORKFLOWITEMSTAGE

I don't think there should be problem with these names

Hi,

Is there somthing special with the problematic table/view names, like special characters or lower/upper case or maybe the name length? Can you give an example?


Thanks,

Gadi

[singh-santosh]

Hi guys,
Can I assume it as network issue? because sometimes its populates lists of tables and views and sometimes it produce error.

Thanks

view names are

VWAP_ALLOC_BASELINE
VWAUTOPLANALLOCATION
VWAUTOPLANTASK
VWEDFI
VWPROJECT
VWPROJECTTSL
VWTIMESHEET
VWWORKFLOWITEMACTORDATA
VWWORKFLOWITEMDATA
VWWORKFLOWITEMSTAGE

I don't think there should be problem with these names

[Gadi.Farhat]

Hi,

You mentioned that with small number of tables and views it is working fine but, when using like 45-50 tables and views it gives the error. How did you do that? Using different database or owner that have different number of tables? If so, this sounds like a network timeout error causing the problem. To verify, you can check the log files under the temp folder in the product installation folder.


Thanks,

Gadi