top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: How to find Invalid special characters in XML

+1 vote
544 views

I am facing below error while validating XML file using Java utility, below is error message :

An invalid XML character (Unicode: 0x{2}) was found in the value of attribute "{1}" and element is "1a".

for validation I have used XMLspy however it has gave up to open file because of its huge size, please suggest how we can find this invalid character.

posted Mar 6, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

When the message is actually displayed, {2} and {1} should have been replaced with the Unicode hex value of the character and the the name of the attribute respectively. Those would tell you what to look for and where to look.

For huge documents, you may be better off using SAX-based processing (or one of the other event-driven systems) rather than DOM-based parsing, so you can decide what information needs to be kept, versus what can be processed immediately and/or discarded. If you do need a DOM, you may need to alter your Java configuration to obtain more heap or stack memory; that's typically done with -Xmx and =Xms options.

answer Mar 6, 2014 by Shweta Singh
Similar Questions
+1 vote
How to find Invalid special characters in XML

We are facing below error while validating XML file using Java utility, below is error message :

An invalid XML character (Unicode: 0x{2}) was found in the value of attribute "{1}" and
element is "1a".

for validation we have used XMLspy however it has gave up to open file because of its huge size, please suggest how we can find this invalid character.

All ideas are welcomed.

Thanks

+1 vote
Replacing special characters by null

Is there any function to replace the special characters by null in informatica

if we used replacestr function, i think we should specify all special characters

as follows replacestr(input,'!','~','@','#','$','%','^','&','*',null)

But we dont know what are teh special characters will be coming as input.

can u please let me know that which function will be suitable.

+2 votes
How to build XML in C# code?

What are some of the best ways to build XML in C# code?

0 votes
Invalid Sessions Query of Informatica

I want to do some cleanup in my project folder of Informatica. I need to find the list unused sessions/obsolete sessions in the folder. I am not able to get the correct set of record with the following query:

SELECT DISTINCT * FROM REP_ALL_TASKS A, REP_SESS_CONFIG_PARM B
WHERE A.TASK_ID = B.SESSION_ID AND TASK_TYPE_NAME = 'Session'
AND B.ATTR_ID = '202' and is_valid <> 1
AND A.SUBJECT_AREA like ('folder')
ORDER BY 1, 2

Can anyone help me?

...