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

Getting PB hanged(Not Responding) status while creating DW object using SQL Select

I am creating DW using SQL Select, when I select SQL Select data source and click on Next in DW painter my PB got hanged(Not Responding) status.

Also getting same probelm when creating DW through Stored Procedure.

I am having 1500 tables in my database.

Please help me...

Thanks ,

Pralhad.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2014 at 06:01 AM

    Hi,

    First of all you should have mentioned following details:

    PB version/build

    DB version/build

    connectivity method/layer (as many details as possible)

    on top of that:

    have you checked your connection?

    have you tried to trace your session on DB?

    can you see any objects on this connection?

    can you run a simple sql from ISQL?

    have you got enough privs on this db.

    Chris

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2014 at 01:51 PM

    Hi Pralhad;

    In these type of situations I would normally suspect the DB drivers & connectivity mechanism.

    As Chris mentions above - we really need your environment details to better assess your situation.

    Regards ... Chris

    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.