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

Table not found error : Importing External SQL SERVER 2008 Table definition

Hello Friends,

I have a problem with external JDBC table definition import.

Database I am trying to connect is SQL SERVER 2008. I have created a communication channel receiver JDBC. Driver being used is SQLServer 2000 Driver for JDBC

Here is the connection string:

jdbc:microsoft:sqlserver://XXXXXXXXXXXXXX\XXXXX:40006;databaseName=XXXX_XXXX;SelectMethod=Cursor

User has db_owner auth on the database.

Which trying to hit DISPLAY the only response i see is "Table not found"

am i missing any steps here ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 17, 2010 at 03:39 AM

    Hi,

    Please monitor your communication channel first,if no errors found then create external definition with option db tab then select your cc and try to import.

    if you getting error table not found then check your table not exists in data base really table created or not.then try to import other table...let me know if still same error persist.

    Regards,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2010 at 05:33 PM

    Thank you, I already checked on communication channel no errors there it says successful message.

    I also created a trace on the SQL DB and found that PI is doing sp_tables to check if table exists. When executed using local client like SQL management studio with same userid , its returning right value but still shows in ESR of PI as table not found.

    Also the table is existing and user has role of db_owner so I doubt if authorizations problem exist.

    Edited by: Krishna_PI on Jul 17, 2010 7:34 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Was there a resolution to this? I get a similar issue.

      I have created my communication channel and created an external definition. When I try to Display I only get some table, not all. If I log in view SQL Management Studio with the same user I get all table.

      Can someone help?

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.