Skip to Content
author's profile photo Former Member
Former Member

Table import stuck

Hello experts.

I am trying to import an external definition of a table using a JDBC reciever CC.

The JDBC is also used for interfaces and working fine.

When I search for the table in the DB - I get it alright, but when I mark it and press finish the GUI is just stuck in waiting.

I have looked in the CC monitoring and saw that the CC processed 2 messages - one after I clicked on display and

the other after I clicked finish.

Can anyone please assist?

I don't think this is a credentials issue, as I get the table name when I hit display...


table import.png (31.8 kB)
messages_JDBC.png (19.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Feb 13, 2014 at 04:05 PM

    Hi Imanuel - Is it only the problem with this perticular table? Can you try importing any other table and see if it works..

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 13, 2014 at 04:06 PM

    Hi Imanuel,

    Have you tried deleting your Java temporary files?

    Does the table have many columns?

    Regards,

    Karthik


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 13, 2014 at 04:13 PM

    Hi,

    refer the below blog for your problem, it might help

    Problems faced while connecting to SQL server using JDBC adapter in PI

    regards,

    Harish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello.

      Thanks for the link - I can't check it right now but I might later.

      However I don't think this is the issue as I already said this channel is used and working correctly on an interface. so there shouldn't be any communication problem.

      thanks again.

  • Posted on Feb 13, 2014 at 06:57 PM

    Hello,

    Check if you have the fixes in note 1966817 Importing External Definitions in Enterprise Service Repository gives error. This fixes a current known issue with this functionality.

    Regards

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2014 at 12:45 PM

    I have just tried to use a different DB (this time oracle) - and this time the import table worked in a couple of seconds. So I guess this is a problem with the DB.

    Can anyone give me a reference to the credentials I need to use for getting the dbtab?

    also - maybe this is because the PI is installed on oracle and the DB in question is MSSQL?

    Any lead will be appreciated.

    Thanks,

    Imanuel Rahamim.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.