Topic
  • 6 replies
  • Latest Post - ‏2013-05-02T13:22:42Z by TapanKumarGhosh
mparvez
mparvez
4 Posts

Pinned topic vs2012 data connection to informix - error when selecting objects

‏2013-04-16T15:40:38Z |

Hello,

I have a data connection tested successfully. But when I try to explore the database objects (tables, views, etc.), I am seeing an error "Error occurred while getting objects from the database". Clicking 'OK' on this dialog gives "Selecting objects of type 'Table_SE' is not supported".

I have all the necessary required permissions to the informix database v11.70.

Error Image Attached.

Thanks, -P.

Attachments

  • rajendrak
    rajendrak
    40 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-04-23T08:30:35Z  

    Hi,

    1) Which version of IBM DS Driver & IBM Database Add-In for Visual Studio are you using.

    2) Could you please confirm that you are using the DB2.NET provider for connecting to IDS. You will have to select 'IBM DB2 and IDS' data source while connecting through VSAI.

    3) Is this consistently reproducible? Have you tried restarting Visual Studio, especially if the connection to the server is old.

    Let us know.

    Regards,

    Raj

  • mparvez
    mparvez
    4 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-04-23T19:19:21Z  
    • rajendrak
    • ‏2013-04-23T08:30:35Z

    Hi,

    1) Which version of IBM DS Driver & IBM Database Add-In for Visual Studio are you using.

    2) Could you please confirm that you are using the DB2.NET provider for connecting to IDS. You will have to select 'IBM DB2 and IDS' data source while connecting through VSAI.

    3) Is this consistently reproducible? Have you tried restarting Visual Studio, especially if the connection to the server is old.

    Let us know.

    Regards,

    Raj


    1) Here are the two
    ibm_data_server_driver_package_win32_ v10.1
    v10.1fp2_n32_vsai


    2) Yes I am using 'IBM DB2 and IDS'
    The description 'IBM DB2 ad IDS Servers (IBM DB2 and IDS Data Provider for .NET Framework)


    3) it is consistent. Restarting vs2012 and even the computer does not help.

    *******
    Here is the connection test
    *******
    $ testconn40 "database=sample;server=servername:port;uid=username;pwd=password;authentication=server"

    Step 1: Printing version info
            .NET Framework version: 4.0.30319.18034
            DB2 .NET provider version: 9.7.4.4
            DB2 .NET file version: 10.1.2.4
            Capability bits: ALLDEFINED
            Build: s121127
            Factory for invariant name IBM.Data.DB2 verified
            Warning, failed load of DbFactory for:IBM.Data.Informix
            IBM Database Add-ins assembly version: 9.1.0.0
            IBM Database Add-ins file version: 10.1.2.133
            Elapsed: 0.3432132

    Step 2: DB2DSDRIVER_CFG_PATH env var: unset
            Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
            File C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg  missing. Nothi
    ng to validate
            Elapsed: 0.0156006

    Step 3: Connecting using "database=sample;server=servername:port;uid=username;pw
    d=password;authentication=server"
            Server type and version: IDS 11.70.0000
            Elapsed: 0.5148198

    Step 4: Selecting rows from informix.systables to validate existence of packages

       SELECT * FROM informix.systables
            Elapsed: 0.1716066

    Step 5: Calling GetSchema for tables to validate existence of schema functions
    IBM.Data.DB2.DB2Exception (0x80004005): ERROR [IX000] [IBM][IDS/UNIX64] SQL0969N
      There is no message text corresponding to SQL error "-674" in the message file
     on this workstation.  The error was returned from module "IFX11700" with origin
    al tokens "sqltables".  SQLSTATE=IX000

       at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, Stri
    ng method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skip
    Deleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
       at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, Stri
    ng method)
       at IBM.Data.DB2.DB2MetaDataFactory.b(DB2Command& A_0, String A_1)
       at IBM.Data.DB2.DB2MetaDataFactory.l(String[] A_0)
       at IBM.Data.DB2.DB2MetaDataFactory.GetSchema(String collectionName, String[]
    restrictionValues)
       at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName, String[] restr
    ictionValues)
       at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName)
       at TestConn.myClassName.GetSchemaTable()


    Test failed.

  • rajendrak
    rajendrak
    40 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-04-29T09:00:51Z  
    • mparvez
    • ‏2013-04-23T19:19:21Z


    1) Here are the two
    ibm_data_server_driver_package_win32_ v10.1
    v10.1fp2_n32_vsai


    2) Yes I am using 'IBM DB2 and IDS'
    The description 'IBM DB2 ad IDS Servers (IBM DB2 and IDS Data Provider for .NET Framework)


    3) it is consistent. Restarting vs2012 and even the computer does not help.

    *******
    Here is the connection test
    *******
    $ testconn40 "database=sample;server=servername:port;uid=username;pwd=password;authentication=server"

    Step 1: Printing version info
            .NET Framework version: 4.0.30319.18034
            DB2 .NET provider version: 9.7.4.4
            DB2 .NET file version: 10.1.2.4
            Capability bits: ALLDEFINED
            Build: s121127
            Factory for invariant name IBM.Data.DB2 verified
            Warning, failed load of DbFactory for:IBM.Data.Informix
            IBM Database Add-ins assembly version: 9.1.0.0
            IBM Database Add-ins file version: 10.1.2.133
            Elapsed: 0.3432132

    Step 2: DB2DSDRIVER_CFG_PATH env var: unset
            Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
            File C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg  missing. Nothi
    ng to validate
            Elapsed: 0.0156006

    Step 3: Connecting using "database=sample;server=servername:port;uid=username;pw
    d=password;authentication=server"
            Server type and version: IDS 11.70.0000
            Elapsed: 0.5148198

    Step 4: Selecting rows from informix.systables to validate existence of packages

       SELECT * FROM informix.systables
            Elapsed: 0.1716066

    Step 5: Calling GetSchema for tables to validate existence of schema functions
    IBM.Data.DB2.DB2Exception (0x80004005): ERROR [IX000] [IBM][IDS/UNIX64] SQL0969N
      There is no message text corresponding to SQL error "-674" in the message file
     on this workstation.  The error was returned from module "IFX11700" with origin
    al tokens "sqltables".  SQLSTATE=IX000

       at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, Stri
    ng method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skip
    Deleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
       at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, Stri
    ng method)
       at IBM.Data.DB2.DB2MetaDataFactory.b(DB2Command& A_0, String A_1)
       at IBM.Data.DB2.DB2MetaDataFactory.l(String[] A_0)
       at IBM.Data.DB2.DB2MetaDataFactory.GetSchema(String collectionName, String[]
    restrictionValues)
       at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName, String[] restr
    ictionValues)
       at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName)
       at TestConn.myClassName.GetSchemaTable()


    Test failed.

    Hi,

    We are unable to see this problem in our environment. We would preferably need traces to further troubleshoot this issue.

    To generate traces:

    a) Start the trace with "db2trc on -f trace.dmp -t"  [ -t To track the time]
    b) db2start and now run testconn40
    c) Turn off the trace - "db2trc off"
    d) Format the trace - "db2trc flw trace.dmp trace.flw"
        and "db2trc fmt trace.dmp trace.fmt"
          and "db2trc fmt -c trace.dmp trace.fmtc"
          and "db2trc fmt -cli trace.dmp trace.cli"

    e) Share the above .flw, .fmt, .fmtc, .cli trace files for further investigation.

    Considering this may be an 'involved' problem, we encourage you to reach out to IBM-Support to expedite investigation on this issue.

    Regards,

    Raj

  • mparvez
    mparvez
    4 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-04-29T15:24:11Z  
    • rajendrak
    • ‏2013-04-29T09:00:51Z

    Hi,

    We are unable to see this problem in our environment. We would preferably need traces to further troubleshoot this issue.

    To generate traces:

    a) Start the trace with "db2trc on -f trace.dmp -t"  [ -t To track the time]
    b) db2start and now run testconn40
    c) Turn off the trace - "db2trc off"
    d) Format the trace - "db2trc flw trace.dmp trace.flw"
        and "db2trc fmt trace.dmp trace.fmt"
          and "db2trc fmt -c trace.dmp trace.fmtc"
          and "db2trc fmt -cli trace.dmp trace.cli"

    e) Share the above .flw, .fmt, .fmtc, .cli trace files for further investigation.

    Considering this may be an 'involved' problem, we encourage you to reach out to IBM-Support to expedite investigation on this issue.

    Regards,

    Raj

    Here are the four files .. 

    Take a look. Thanks.

     - db, server and user names changed.

    Attachments

  • mparvez
    mparvez
    4 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-04-29T15:41:24Z  
    • mparvez
    • ‏2013-04-29T15:24:11Z

    Here are the four files .. 

    Take a look. Thanks.

     - db, server and user names changed.

    trace.fmt compressed. The file was large.

    Attachments

  • TapanKumarGhosh
    TapanKumarGhosh
    10 Posts

    Re: vs2012 data connection to informix - error when selecting objects

    ‏2013-05-02T13:22:42Z  
    • mparvez
    • ‏2013-04-29T15:41:24Z

    trace.fmt compressed. The file was large.

    Hi,

    By analyzing the trace file which you have shared, it seems that internal stored procedure is not executed successfully due to permission issue. Your userid do not seem to be have execute permission for the internal stored procedure.
    So, can you please run the "testconn40" with administrative privilege who will be having all the permission.

    Thanks,

    Tapan