Topic
  • 3 replies
  • Latest Post - ‏2015-08-25T08:10:57Z by paul.brett
Greenspan
Greenspan
23 Posts

Pinned topic Database Interface Designer error in generating type tree

‏2013-07-24T05:21:27Z |

Hi ,

I am trying to buil a map where the input is a zOS db2 database. I am trying to create a typetree from the sql query. The query is quite small.

Select CID,DID from DA01.ID_EVNT

However I am getting an error

"could not get a temporary file name"

How do I resolve this.

I have wtx 8.4.0.2 , DB2 data service client 9.5, Access to zOS DB2 via ODBC .

  • 8F19_Jesse_Menning
    8F19_Jesse_Menning
    1 Post
    ACCEPTED ANSWER

    Re: Database Interface Designer error in generating type tree

    ‏2013-07-30T19:53:44Z  

    I had the same issue under Windows 7.  I ran database interface designer as Admin and the issue went away.

    Hope this helps,

    Jesse

  • 8F19_Jesse_Menning
    8F19_Jesse_Menning
    1 Post

    Re: Database Interface Designer error in generating type tree

    ‏2013-07-30T19:53:44Z  

    I had the same issue under Windows 7.  I ran database interface designer as Admin and the issue went away.

    Hope this helps,

    Jesse

  • VinothKumarRajkumar
    2 Posts

    Re: Database Interface Designer error in generating type tree

    ‏2015-08-25T07:45:54Z  

    Hi,

     

    Any other way to overcome this issue? Because I don't have privileges to run DID as admin. 

     

    Regards,

    Vinoth

  • paul.brett
    paul.brett
    554 Posts

    Re: Database Interface Designer error in generating type tree

    ‏2015-08-25T08:10:57Z  

    I believe if you create and save the MDQ first, then any temporary files *should* be created in the same directory as the MDQ.

    Only if you attempt to generate a Typetree before you have saved the MDQ, will the product attempt to use the WTX installation directory, and potentially fail on a locked-down Windows installation.

    Thank-you.

    Paul.

    Follow me on Twitter