Topic
2 replies Latest Post - ‏2012-08-27T16:01:54Z by SystemAdmin
SystemAdmin
SystemAdmin
7754 Posts
ACCEPTED ANSWER

Pinned topic IIS-CONN-DAAPI-000296] SAX parser exception thrown

‏2012-08-27T11:21:04Z |
Hi ALL,

I am getting this fatal error:-
ODBC_OprrskSmy: IIS-CONN-DAAPI-000296 SAX parser exception thrown: The input ended before all started tags were ended. Last tag started was 'SelectStatement' (CC_PropertySet::fatalError, file CC_PropertySet.cpp, line 2,071)

Source is SQL server 2008, I am using ODBC connector stage. Both my target and src is my SQL db 2008. Datastage 8.1.0.

Any idea what is this error.I am not getting to how to remove the fatal.

Thanks,
Ajay
Updated on 2012-08-27T16:01:54Z at 2012-08-27T16:01:54Z by SystemAdmin
  • RobertDickson
    RobertDickson
    33 Posts
    ACCEPTED ANSWER

    Re: IIS-CONN-DAAPI-000296] SAX parser exception thrown

    ‏2012-08-27T12:00:14Z  in response to SystemAdmin
    Hi,

    Can you please provide more detail on the SQL being used? Is it auto-generated or user-defined? Are you passing SQL via parameters?


    Regards,
    Robert
  • SystemAdmin
    SystemAdmin
    7754 Posts
    ACCEPTED ANSWER

    Re: IIS-CONN-DAAPI-000296] SAX parser exception thrown

    ‏2012-08-27T16:01:54Z  in response to SystemAdmin
    If you are receiving a SAX exception, then there is some XML being parsed. Is the stored data in XML format or are you converting it to XML format? That should narrow down your search some.