Skip to Content
avatar image
Former Member

Timestamp in SQL 2008

Hi All,

I am using Timestamp column in sql server 2008.

In sql 2008 the query is working fine but from query template i am getting following error:

com.sap.xmii.Illuminator.logging.LHException: Error occurred while processing records; The conversion from binary to INTEGER is unsupported.

Is this a bug of mii?

or i am miss something.

I am using Version 12.1.8 Build(20).

Regards

Anshul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 06, 2011 at 07:04 PM

    Hi Anshul,

    Take a look at this SAP Note, the issue may be related to the jdbc driver:

    [SAP Note 1487394|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1487394]

    Kind Regards,

    Diana Hoppe

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2011 at 11:23 AM

    Hi Anshul,

    Just to check, but what service pack is your NWCE installation?

    And can you please post the exact SQL Script in the Query? Please make it a Fixed Query instead of Query mode if you are not already. Or are you trying to an update or insert query?

    NOTE: Going to Fixed Query can be a useful troubleshooting tool, but does require better database skills for complex queries.

    Regards,

    Mike

    Edited by: Michael Appleby on Jul 6, 2011 1:23 PM

    Add comment
    10|10000 characters needed characters exceeded