Skip navigation
Contact Us
7785 Views 7 Replies Latest reply: Jun 5, 2009 4:08 AM by Krishna Ramineni RSS
Dmitri Sakara Newbie 27 posts since
Jul 20, 2006
Currently Being Moderated

Jun 13, 2007 5:20 AM

RR_4035 SQL Error [] while reading via ODBC c


Hi all,



We are running PowerCenter server on Unix and using ODBC to connect to MSSQL server.



I would like to have a facility that allows me to test validity of any ODBC-based connection to MSSQL server. I tried to develop a simple workflow that takes dummy field from any public (accessible for all users) table/view and writes it to the flat file. I tried to use sysobjects or syssegments as dummy data sources. I am facing strange problem now. According to session log, I am able to initialise the reader (connect to DB with the userid & password specified in the connection definition).



READER_1_1_1> DBG_21438 Reader: Source is RR_4035 SQL Error [] while reading via ODBC c, user RR_4035 SQL Error [] while reading via ODBC c

READER_1_1_1> BLKR_16051 Source database connection RR_4035 SQL Error [] while reading via ODBC c codepage: RR_4035 SQL Error [] while reading via ODBC c

READER_1_1_1> CMN_1021 Database driver event...

CMN_1021 [ODBC Event Using single row fetch.

ODBC Event Using Array Inserts. connect string = RR_4035 SQL Error [] while reading via ODBC c. userid = RR_4035 SQL Error [] while reading via ODBC c]

READER_1_1_1> BLKR_16003 Initialization completed successfully.



But not able to read any data



READER_1_1_1> RR_4010 SQ instance RR_4035 SQL Error [] while reading via ODBC c SQL Query SELECT syssegments.name FROM syssegments

READER_1_1_1> 2007/06/13 13:32:20

READER_1_1_1> RR_4035 SQL Error [].

READER_1_1_1> 2007/06/13 13:32:20

READER_1_1_1> BLKR_16004 ERROR: Prepare failed.



The same query executed with the same user directly against DB brings expected data. What can be the problem here?



Thank you in advance,



Regards

 

  • Kieran O'Loughlin InfaEmp 1,889 posts since
    Feb 26, 2003
    Currently Being Moderated
    Jun 13, 2007 5:57 AM (in response to Dmitri Sakara)
    RR_4035 SQL Error [] while reading via ODBC c


    Do you have just one port connected out of your source qualifier? Is it the same datatype as syssegments.name? If the answer to either question is NO then the result set from the database won't be able to find correctly with the datastructure of the source qualifier.


    -




    1) If you don't have a user at http://my.informatica.com go there and register

    2) Have you searched the manuals? Up to version 7.x they can be found in the manuals subdirectory of the client installation. For version 8.x they are in a separate installation. If you don't have the manuals then you can download them from the documentation center at http://my.informatica.com

    3) Devnet search - search devnet, something similar may well have been asked before

    4) Google search - if the topic is not directly PowerCenter related, but is related to database errors, scripting, operating systems, etc. then there is a wealth of information on the web

    5) Knowledgebase search - search the Knowledgebase at http://my.informatica.com

    6) Velocity methodology - search the Velocity methodology at http://my.informatica.com

    7) If you still have a question give as much background to your issue as possible

    - Include code snippets

    - Include workflow/session logs

    - Include examples of data

    etc.


    http://www.catb.org/~esr/faqs/smart-questions.html

      • Kieran O'Loughlin InfaEmp 1,889 posts since
        Feb 26, 2003
        Currently Being Moderated
        Jun 13, 2007 7:24 AM (in response to Dmitri Sakara)
        RR_4035 SQL Error [] while reading via ODBC c


        Found this in the knowledgebase at http://my.informatica.com



        This error may occur when the ODBCINI environment variable has not been set for the user starting the PowerCenter Server.



        To resolve this issue, do the following:



        Stop the PowerCenter Server.

        Set the ODBCINI environmental variable to the odbc.ini file.

        Using a Bourne shell:

        $ ODBCINI=/$HOME/.odbc.ini; export ODBCINI

        Using a C shell:

        $ setenv ODBCINI $HOME/.odbc.ini

        Restart the PowerCenter Server.

        Run the session.






        -




        1) If you don't have a user at http://my.informatica.com go there and register

        2) Have you searched the manuals? Up to version 7.x they can be found in the manuals subdirectory of the client installation. For version 8.x they are in a separate installation. If you don't have the manuals then you can download them from the documentation center at http://my.informatica.com

        3) Devnet search - search devnet, something similar may well have been asked before

        4) Google search - if the topic is not directly PowerCenter related, but is related to database errors, scripting, operating systems, etc. then there is a wealth of information on the web

        5) Knowledgebase search - search the Knowledgebase at http://my.informatica.com

        6) Velocity methodology - search the Velocity methodology at http://my.informatica.com

        7) If you still have a question give as much background to your issue as possible

        - Include code snippets

        - Include workflow/session logs

        - Include examples of data

        etc.


        http://www.catb.org/~esr/faqs/smart-questions.html

          • Kieran O'Loughlin InfaEmp 1,889 posts since
            Feb 26, 2003
            Currently Being Moderated
            Jun 14, 2007 2:23 AM (in response to Dmitri Sakara)
            RR_4035 SQL Error [] while reading via ODBC c


            I'm wondering if it still might be environment related. Check out the Installation Guide, Chapter 16, Connecting to an ODBC Data Source. Did you set the ODBCHOME env variable to the ODBC installation location? Did you add $ODBCHOME/bin to the $PATH? Did you add $ODBCHOME/lib to the shared library env variable (LD_LIBRARY_PATH, LIBPATH, SHLIB_PATH)? Did you try the tests mentioned using ivtestlib?


            -




            1) If you don't have a user at http://my.informatica.com go there and register

            2) Have you searched the manuals? Up to version 7.x they can be found in the manuals subdirectory of the client installation. For version 8.x they are in a separate installation. If you don't have the manuals then you can download them from the documentation center at http://my.informatica.com

            3) Devnet search - search devnet, something similar may well have been asked before

            4) Google search - if the topic is not directly PowerCenter related, but is related to database errors, scripting, operating systems, etc. then there is a wealth of information on the web

            5) Knowledgebase search - search the Knowledgebase at http://my.informatica.com

            6) Velocity methodology - search the Velocity methodology at http://my.informatica.com

            7) If you still have a question give as much background to your issue as possible

            - Include code snippets

            - Include workflow/session logs

            - Include examples of data

            etc.


            http://www.catb.org/~esr/faqs/smart-questions.html

  • Krishna Ramineni Newbie 1 posts since
    Jan 4, 2006
    Currently Being Moderated
    Jun 5, 2009 4:08 AM (in response to Dmitri Sakara)
    RR_4035 SQL Error [] while reading via ODBC c

    I am facing same issue, Please let me know if you resolve this issue.

More Like This

  • Retrieving data ...

Bookmarked By (0)