Hi,
My job design: input: OraConnector -> XML Stage
OraConnector -> XML stage
output: ISD output with JSON data
The same job works with DEVL database, but not INTG database.
The data in INTG database must contain special characters( non-printable characters). I use regexp_replace(achievement_name, '( *[[:cntrl:]])', '') in my query trying to remove the non-printable characters but still does not work.
Any advice, really appreciate!
Here is the error message:
XMLStage 3.0, Build Number: 9.1.0.0.575
Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_engine_msgs_en_US, key E2ILParseException.errorDuringDocumentCreation
main_program: Fatal Error: [Input link 0] ErrorDuringDocumentCreation cause = 'java.util.InvalidPropertiesFormatException'
thanks!
Jane
XML stage error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 3
- Joined: Fri Feb 27, 2015 1:41 pm
XML stage error
Jane liu
In your shoes I wouldn't make any assumptions about what the error means. If no-one comes around that has actually dealt with this "InvalidPropertiesFormatException" before then I would suggest you involve you official support provider. Or do that while you wait.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Likely anything could happen if you have truly invalid characters, but as Craig notes, perhaps they have nothing to do with it. Personally, if I has suspect characters I would pass the data thru a Basic Transformer and use a nested ereplace() to zap whatever I have......usually by identifying the offending characters and their replacement using char(nn) which represents a decimal.
.....like replacing char(00) with char(20) for example.
Ernie
.....like replacing char(00) with char(20) for example.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Premium Member
- Posts: 3
- Joined: Fri Feb 27, 2015 1:41 pm
Thank you for your quick response. I have been seeking IBM support, but have not got any progress yet.
After several tries, I agree with you. It might not be the data issue. Because the web service called the used-to-worked job (DEVL DB) again, it does not work any more with the same error.
After several tries, I agree with you. It might not be the data issue. Because the web service called the used-to-worked job (DEVL DB) again, it does not work any more with the same error.
Jane liu