Forums   »   Courses   »   WebMethods :

Topic:   We have migrated to 9.5 Version. All environments are working fine but getting error (S0005 by 8114) Error converting data type nvarchar to uniqueidentifier
Aug 04, 2014 23:36 7 Replies 1485 Views shoson30
Prev Next
Topic Replies (7)
  1. 1
    idnkx user

    shoson30

    Hello All, We have migrated to 9.5 Version. All environments are working fine. I have installed 9.5 in local system also (client machine only) but its giving some jdbc errors while processing sp requests for SQL Server 2008. Can you please guide whats the latest jar files for sql 2008 or any other configurations ?

    1
    idnkx user

    shoson30

    Please note , i have sqljdbc4.jar in common\lib folder

    1
    idnkx user

    Nancy

    Hi Shoson30...can you list out that error information...

    1
    idnkx user

    Sashi

    Shoson30 this lib should be in integrationserver/lib folder...

    1
    idnkx user

    shoson30

    Hi nans4int . this is the error :- '(S0005/8114) Error converting data type nvarchar to uniqueidentifier.,errorCode=316,pipeline=null,stack=com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to uniqueidentifier'

    1
    idnkx user

    shoson30

    sashi_vsp .. for 9.5 jar file is in common/lib folder .... It's working in all environments except local . Another observation is that this error is coming while updating the data . if it's jet get sp , then working fine

    1
    idnkx user

    Nancy

    Hi Shoson30... There is no special jar file for latest version of webMethods.... sqljdbc4.jar works fine ..... can you check the following links..........

Leave a Reply
Guest User

Not sure what solution is right for you?

Choose the right one for you.
Get the help of the experts and find a solution that best suits your needs.

Let`s Connect