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

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
    ACCEPTED ANSWER

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

    ‏2013-04-23T08:30:35Z  in response to mparvez

    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
      ACCEPTED ANSWER

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

      ‏2013-04-23T19:19:21Z  in response to rajendrak


      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
        ACCEPTED ANSWER

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

        ‏2013-04-29T09:00:51Z  in response to mparvez

        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
          ACCEPTED ANSWER

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

          ‏2013-04-29T15:24:11Z  in response to rajendrak

          Here are the four files .. 

          Take a look. Thanks.

           - db, server and user names changed.

          Attachments

          • mparvez
            mparvez
            4 Posts
            ACCEPTED ANSWER

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

            ‏2013-04-29T15:41:24Z  in response to mparvez

            trace.fmt compressed. The file was large.

            Attachments

            • TapanKumarGhosh
              TapanKumarGhosh
              10 Posts
              ACCEPTED ANSWER

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

              ‏2013-05-02T13:22:42Z  in response to mparvez

              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