Skip to Content

Error RSDS_ACCESS023 while extracting from MSSQL through DBCONNECT

Dear Gurus,

I have to extract data from an MSSQL database. I have the source system. I have the view I want to use to extract data.à

But when I try to get sample data, I get the following error:


SQL error "207" with message: "Invalid column name 'APPROB_DIR_RECLAMATION_DECIS

Message no. RSDS_ACCESS023

It looks like the length of one column name si too long for BW (7.31 SP5). I can not change the name of the column in the original database...Has anyone faced that issue and managed to work with that ?

Thanks

P

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 09, 2014 at 07:13 PM

    Hi guys

    Actually, the length of the field that contains the name of the database column is too short (30 characters)....It is the object DBOBJECT_D

    Has some ever faced the issue ?

    PY

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 07:48 PM

    Hi

    There is some limitations on the lenght and the naming of the columns. If you can't change the table below create a view that helps you extracting the data to work around that problem.

    hope that helps

    Martin

    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.