[OA] Re: Open Admin XML Transfer - the bad record.

[Les Richardson]

Hi Methodius,

I had a look... the error is in the Grade field. It has a value of 
'PRE-K', which is NOT allowed. It must be 'PK' according to SL XML schema. 
You can eliminate this problem by changing the defaults for the grades in 
the meta table and making it a selection choice.

The student is:  Kelby Cooper (30807).

If there are lot of these, go directly to mysql and change them via SQL. 
It did this for all the mistakes in province... changed 'Sask' to 'SK', 
etc. Very quick fix.

Les



On Tue, 13 Dec 2005, Methodius Dusyk - Central Office wrote:

> Hi
>
> When I do the transfers to Sask Learning at Connaught I get
>
> 22814 - ORA-22814: attribute or element value is larger than specified in
> type.
>
> I found the following information at the Sask Learning site. Is there anything
> I can do to correct this?
>
> Problem - The XML transaction does not pass XML schema validation. One of
> the "Type" or "Code" attributes does not conform to the XML specification.
> Solution - Validate the XML document against the schema to the identify the
> problem element (use of third party XML schema validation tools can be helpful),
> correct the element, change the SL_MsgId to a unique value and re-submit the
> document. In most cases, the Country / Citizenship and Language codes could
> be using the 'old' numerical values instead of the new character values. Users
> should consult their vendor documentation and follow instructions on correcting
> tables or setting up conversion tables.
>
> Methodius
>