IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  Database Interface Designer / Sybase

    Posted 03/12/08 05:39 PM

    Originally posted by: SystemAdmin


    I'm not able to connect to Sybase using Database Interface Designer (WTX 8.2), it simply says connection to database failed. I'm able to use the same credentials to connect to Sybase it works, it also works in DID for Mercator 6.7.

    When I tried to run the map in WTX(this was built using Mercator 6.7),An error file (sybinit.err)got created and the following is the error message.

    The context allocation routine failed.

    The following problem caused the failure:

    Invalid context version.

    Looks like something is wrong with WTX Syabse Adapters or there is a conflict some where.
    Any help is appreciated.

    Thanks
    Karun
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: Database Interface Designer / Sybase

    Posted 03/13/08 08:18 AM

    Originally posted by: SystemAdmin


    Hi,
    I had the same problem while attempting to connect to my Sybase DB through DID.
    I had to create ODBC links instead of the Sybase connector and now it works.

    If it can help...
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Database Interface Designer / Sybase

    Posted 03/13/08 11:19 AM

    Originally posted by: SystemAdmin


    I will try the ODBC way, But I wonder why Sybase Adapter is not working. May be something to do with the Sybase drivers?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: Database Interface Designer / Sybase

    Posted 03/13/08 11:39 AM

    Originally posted by: GerryCullen


    What version of Sybase are you using? Is it supported by WTX v8.2?
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 5.  Re: Database Interface Designer / Sybase

    Posted 03/13/08 12:06 PM

    Originally posted by: SystemAdmin


    We have Sybase Adaptive Server Enterprise 12.5.0.3

    How do I find if its supported by WTX 8.2 or not?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: Database Interface Designer / Sybase

    Posted 03/13/08 02:07 PM

    Originally posted by: GerryCullen


    Best way to check is to contact Customer Support, but Sybase ASE v12.5 and v15 are supported by WTX v8.2.

    Looks like you may want to contact Customer Support about this connectivity issue. I'm guessing it may be something configuration related.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: Database Interface Designer / Sybase

    Posted 03/19/08 02:03 PM

    Originally posted by: SystemAdmin


    It appears to be the problem with Sybase Client components. We had local installation of client components, however the environment variables are mapped to shared drive. Once we re-mapped them to the local client components every thing worked fine.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


Related Content