I've never seen EIE misidentify a field type, but I'll take your word for it.
Look at these lines -
[14:49:21,07/06/06] - Rule 2: 'CREATE_DATE', Value: 'óòåäá , éàìø 05, 2006 13:40:21'
[14:49:21,07/06/06] - Field 'äÁÔÁ ×ÏÚÎÉËÎÏ×ÅÎÉÑ (id: 600030005)' not set due to data conversion error.
[14:49:21,07/06/06] - *** Data Conversion Error : GetTimeValue - Unable to convert to time: óòåäá for the Field 'äÁÔÁ ×ÏÚÎÉËÎÏ×ÅÎÉÑ (id: 600030005)'.
[14:49:21,07/06/06] - Field 'äÁÔÁ ×ÏÚÎÉËÎÏ×ÅÎÉÑ (id: 600030005)' not set due to data conversion error.
[14:49:21,07/06/06] - *** Data Conversion Error : GetTimeValue - Unable to convert to time: óòåäá for the Field 'äÁÔÁ ×ÏÚÎÉËÎÏ×ÅÎÉÑ (id: 600030005)'.
Notice that the value found for the date is - 'óòåäá , éàìø 05, 2006 13:40:21'
In my exchanges it always looks like this - '05/30/2006 13:51:32'
In my exchanges it always looks like this - '05/30/2006 13:51:32'
What does the raw data in your source form look like for this field? The commas and letters seem wrong.
I'm wondering if it is the date format you are using.
As for the missing response data. The following line tells me that a roll back happens.
[14:49:21,07/06/06] - No data transferred. Exchange requires all data to be valid.
Run a sql log and I think you will see what is really happening.
---------------------
Kelly Deaver
Director, ITSM Practice
Xinify
[EMAIL PROTECTED]
---------------------
Kelly Deaver
Director, ITSM Practice
Xinify
[EMAIL PROTECTED]
-------- Original Message --------
Subject: HA: Who knows why EIE is so...?
From: "Alexander G. Zinoviev" <[EMAIL PROTECTED]>
Date: Fri, July 07, 2006 1:22 am
To: [email protected]
Hello, Kelly,
Thanks for you answer.
Vendor field in Rule 2 is character only because EIE wants it to be Character. Really it has Date type, but EIE detects char...
See theese two lines:
[14:49:21,07/06/06] - (null): 'constant|1', Value: '1'
[14:49:21,07/06/06] - Field 'PROCESSED' set to ''
EIE prepeared value "1", then post value Null. I tried - even if record processed successfull, the responce value is always NULL.
Best regards,
Alexander Zinoviev
________________________________
ïÔ: Action Request System discussion list(ARSList) ÏÔ ÉÍÅÎÉ Kelly Deaver
ïÔÐÒÁ×ÌÅÎÏ: ðÔ, 07.07.2006 3:32
ëÏÍÕ: [email protected]
ôÅÍÁ: Re: Who knows why EIE is so...?
**
Look at Rule 2 - On one side you have a date/time field on the other a char. The field types must match.
Your response rule is setting to 1 if processed. since it didn't process, it is not setting the field.
Hope this helps. If you have any further questions, feel free to contact me.
---------------------
Kelly Deaver
Director, ITSM Practice
Xinify
[EMAIL PROTECTED]
-------- Original Message --------
Subject: Who knows why EIE is so...?
From: "Alexander G. Zinoviev" <[EMAIL PROTECTED]>
Date: Thu, July 06, 2006 6:51 am
To: [email protected]
**
Hello,
Maybe I`m making wrong things?
I have two new problems with EIE functionality.
1) Response Value returning TO Remedy does not work. It is actual for SQL adapter and Oracle adapter.
2) Data conversion error during Oracle data exchange.
Configuration:
Windows 2000 sp4
MSSQL2000 patch3a
ARS 6.3 patch 14
EIE 5.1 patch 1439
SQL adapter 5.1
Oracle adapter 5.1
Exchange log:
<snip>
__20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
