Get Data Moving 1
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Error while changing from table to view

  1. #11
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    i have checked with different server and different DBs..sometimes it gives error and sometimes it works perfect.not able to figure out exact cause

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

  2. #12
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    below is the log details

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


    [2010-05-25T11:49:14.193]; Oracle-CDC for SSIS Log (V5.1.0.99, INTEL-NT 32-bit) Started at 2010-05-25T11:49:14
    [2010-05-25T11:49:14.193]; Development license issued by Attunity UK on 06-May-2010 (55000923)
    Licensed to HCL India for ORACLE8,CDCStorage,ORACDCA,DISAM on 10.112.99.180 (WindowsX64)
    Running on host hddlrcc22a8878.HCLT.CORP.HCL.IN, IP address 10.112.99.180
    [2010-05-25T11:49:15.272]; [C043] Failed to connect to host 127.0.0.1:2182:none; IRPC: Connect failed - Connection refused.
    [2010-05-25T11:49:15.272]; [C06A] Failed to connect to server
    [2010-05-25T11:49:15.287]; [A0AB] Can't find remote binding entry BINDURL1.
    [2010-05-25T11:49:15.287]; [C06A] Failed to connect to server
    [2010-05-25T11:49:15.287];
    [2010-05-25T11:49:16.787]; [C043] Failed to connect to host 127.0.0.1:2182:none; IRPC: Connect failed - Connection refused.
    [2010-05-25T11:49:16.787]; [C06A] Failed to connect to server
    [2010-05-25T11:49:16.787]; [A0AB] Can't find remote binding entry BINDURL1.
    [2010-05-25T11:49:16.787]; [C06A] Failed to connect to server
    [2010-05-25T11:49:16.787];
    [2010-05-25T11:49:18.209]; [C043] Failed to connect to host 127.0.0.1:2182:none; IRPC: Connect failed - Connection refused.
    [2010-05-25T11:49:18.209]; [C06A] Failed to connect to server
    [2010-05-25T11:49:18.209]; [A0AB] Can't find remote binding entry BINDURL1.
    [2010-05-25T11:49:18.209]; [C06A] Failed to connect to server
    [2010-05-25T11:49:18.209];
    (1) [2010-05-25T12:00:13.767]; Connecting to 127.0.0.1:2440:tcp:17035
    (3) [2010-05-25T12:01:48.532]; Connecting to 127.0.0.1:2375:tcp:23811
    (3) [2010-05-25T12:01:49.126]; Info: Temporary feature 'dbCaseSensitiveQuoted' is enabled with a value of 'true'
    (2) [2010-05-25T12:03:30.454]; Connecting to 127.0.0.1:2607:tcp:31322
    (5) [2010-05-25T12:03:57.203]; Connecting to 127.0.0.1:2614:tcp:4664
    (3) [2010-05-25T12:05:20.750]; Connecting to 127.0.0.1:2375:tcp:28253
    (5) [2010-05-25T12:06:08.671]; Connecting to 127.0.0.1:2607:tcp:6868
    (3) [2010-05-25T12:07:38.061]; Connecting to 127.0.0.1:2614:tcp:25547
    (4) [2010-05-25T12:09:16.342]; Connecting to 127.0.0.1:2375:tcp:27644
    (5) [2010-05-25T12:09:18.764]; Connecting to 127.0.0.1:2607:tcp:32662
    (5) [2010-05-25T12:10:24.295]; [C042] Remote call to nav_get_contents failed; IRPC: Timed out
    (5) [2010-05-25T12:10:24.295]; [C06B] Disconnecting from server
    (5) [2010-05-25T12:10:24.295]; [C071] Connection to server BINDURL1 was disconnected. Cursors state was lost.
    (5) SDK9051E: FETCH ERROR
    SDK9051X: Failed to Get contents of table
    (5) (Last message occurred 2 times)
    (5) [2010-05-25T12:10:24.295]; SDK9051E: <:FETCH ERROR:>
    SDK9051X: Failed to Get contents of table
    (5) [2010-05-25T12:10:24.310]; [A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
    (5) [2010-05-25T12:10:24.310]; [8001] GetNextRows: Failed to get rows.
    (3) [2010-05-25T12:11:08.248]; Connecting to 127.0.0.1:2614:tcp:32757
    (5) [2010-05-25T12:11:10.919]; Connecting to 127.0.0.1:2375:tcp:20037
    (5) [2010-05-25T12:11:11.732]; [C072] Reconnect to server BINDURL1
    (5) [2010-05-25T12:12:16.732]; [C042] Remote call to nav_get_contents failed; IRPC: Timed out
    (5) [2010-05-25T12:12:16.732]; [C06B] Disconnecting from server
    (5) [2010-05-25T12:12:16.732]; [C071] Connection to server BINDURL1 was disconnected. Cursors state was lost.
    (5) SDK9051E: FETCH ERROR
    SDK9051X: Failed to Get contents of table
    (5) [2010-05-25T12:12:16.732]; SDK9051E: <:FETCH ERROR:>
    SDK9051X: Failed to Get contents of table
    (5) [2010-05-25T12:12:16.732]; [A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
    (5) [2010-05-25T12:12:16.732]; [8001] GetNextRows: Failed to get rows.
    (4) [2010-05-25T12:13:25.481]; Connecting to 127.0.0.1:2607:tcp:12859
    (4) [2010-05-25T12:13:25.497]; [C072] Reconnect to server BINDURL1
    (4) [2010-05-25T12:13:26.262]; [C072] Reconnect to server BINDURL1
    (3) [2010-05-25T12:22:34.415]; Connecting to 127.0.0.1:2614:tcp:8723
    (5) [2010-05-25T12:22:37.915]; Connecting to 127.0.0.1:2607:tcp:9741
    (5) [2010-05-25T12:23:43.649]; [C042] Remote call to nav_get_contents failed; IRPC: Timed out
    (5) [2010-05-25T12:23:43.649]; [C06B] Disconnecting from server
    (5) [2010-05-25T12:23:43.649]; [C071] Connection to server BINDURL1 was disconnected. Cursors state was lost.
    (5) SDK9051E: FETCH ERROR
    SDK9051X: Failed to Get contents of table
    (5) (Last message occurred 2 times)
    (5) [2010-05-25T12:23:43.649]; SDK9051E: <:FETCH ERROR:>
    SDK9051X: Failed to Get contents of table
    (5) [2010-05-25T12:23:43.649]; [A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
    (5) [2010-05-25T12:23:43.649]; [8001] GetNextRows: Failed to get rows.
    (4) [2010-05-25T12:24:46.664]; Connecting to 127.0.0.1:2375:tcp:27529
    (4) [2010-05-25T12:24:46.680]; [C072] Reconnect to server BINDURL1
    (4) [2010-05-25T12:24:47.008]; [C072] Reconnect to server BINDURL1
    (3) [2010-05-25T12:29:59.459]; Connecting to 127.0.0.1:2614:tcp:778
    (5) [2010-05-25T12:30:12.021]; Connecting to 127.0.0.1:2375:tcp:12316
    (5) [2010-05-25T12:31:17.771]; [C042] Remote call to nav_get_contents failed; IRPC: Timed out
    (5) [2010-05-25T12:31:17.771]; [C06B] Disconnecting from server
    (5) [2010-05-25T12:31:17.771]; [C071] Connection to server BINDURL1 was disconnected. Cursors state was lost.
    (5) SDK9051E: FETCH ERROR
    SDK9051X: Failed to Get contents of table
    (5) (Last message occurred 2 times)
    (5) [2010-05-25T12:31:17.771]; SDK9051E: <:FETCH ERROR:>
    SDK9051X: Failed to Get contents of table
    (5) [2010-05-25T12:31:17.771]; [A016] GetRows on RowCursor failed on table name 'SP_OLE_TABLES'.
    (5) [2010-05-25T12:31:17.771]; [8001] GetNextRows: Failed to get rows.
    (5) Closing log file at TUE MAY 25 12:31:32 2010


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


    Quote Originally Posted by singh-santosh View Post
    i have checked with different server and different DBs..sometimes it gives error and sometimes it works perfect.not able to figure out exact cause

  3. #13
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Thank you!

    The client is reporting a timeout error when getting the tables list takes a long time.

    Anyway, you may specify the table name manually, in the advanced editor component properties page, instead of seleting the table from the list.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  4. #14
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    Thanks alot,
    But can you please guide me from where i can assign manually.
    I am not able to get about advance component editor.


    Thanks

    Quote Originally Posted by Gadi.Farhat View Post
    Thank you!

    The client is reporting a timeout error when getting the tables list takes a long time.

    Anyway, you may specify the table name manually, in the advanced editor component properties page, instead of seleting the table from the list.


    Regards,

    Gadi

  5. #15
    singh-santosh is offline Junior Member
    Join Date
    May 2010
    Posts
    11
    Rep Power
    0
    Thanks Gadi..
    Apologise my mistakes..i got it

    Thanks alot

    Quote Originally Posted by singh-santosh View Post
    Thanks alot,
    But can you please guide me from where i can assign manually.
    I am not able to get about advance component editor.


    Thanks

Page 2 of 2 FirstFirst 12

Posting Permissions

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