Get Data Moving 1
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Error while changing from table to view

  1. #1
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0

    Exclamation Error while changing from table to view

    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

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    User which i am using to connect source DB is having equivalent to sysdba privileges


    Quote Originally Posted by Gadi.Farhat View Post
    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

  4. #4
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    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?

    Quote Originally Posted by Gadi.Farhat View Post
    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

  6. #6
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    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


    Quote Originally Posted by singh-santosh View Post
    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?

  7. #7
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  8. #8
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    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



    Quote Originally Posted by Gadi.Farhat View Post
    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

  9. #9
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    Hi guys,
    Can I assume it as network issue? because sometimes its populates lists of tables and views and sometimes it produce error.

    Thanks

    Quote Originally Posted by singh-santosh View Post
    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

  10. #10
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •