Datastage : DB2 Lookup Stage : SAX parser exception thrown: The input ended before all started tags were ended
by Frederick Tybalt on Jun.30, 2017, under Error and Issues
Error :
Unrecognized argument: variant=’9.1\’,
library=ccdb2,
version=1.0,
variantlist=\’V1;9.1::ccdb2\’,
versionlist=\’1.0\’,
name=DB2Connector
}’
SAX parser exception thrown: The input ended before all started tags were ended. Last tag started was ‘before’ (CC_PropertySet::fatalError, file CC_PropertySet.cpp, line 2,236)
Resolution:
There are lot of references in google that the similar kind of error occurred in the XML stage and it it XML stage related error. But in my case this occurred in the DB2 lookup stage. After serval analysis, I found that, there was a environment variable defined for the table name and during the migration the environment variable was not added in the job parameter.
example :
SELECT COL1, COL2 FROM #$SrcTbl#
$SrcTbl was missing in the job parameter list.
This looks to weird since if this was in DB2 source or target stage, the error will be table not found.
Platform :
Datastage 11.5 on Linux
August 6th, 2020 on 3:23 pm
This helped fix my issue and stop wasting time looking at oracle stuff. Thanks for posting.