Hi, I need help I'm trying to figure out what's causing this strange behavior on my LU function. I'm not quite sure what's going on. It's happening sometimes and sometimes it's not. This is the error message "NUMERIC CONVERSION ERROR - EXTERNAL FILE = ITEM_LOC" . thanks
Click the link below to see the new game I'm developing!
strange behavior
Started by
mmeneses
, Oct 08 2003 02:56 PM
6 replies to this topic
#2
Chris Pepper
-
- Members
-
- 369 posts
ProIV Guru
- Gender:Male
- Location:United Kingdom
Posted 08 October 2003 - 03:17 PM
This error occurs when ProIV is trying to parse the record it has just read from a file. It's trying to convert the field ITEM_LOC into an internal ProIV numeric using the rules in the extended (EXTERNAL) part of the file definintion - and failing. Exactly what's going wrong may depend on your database. Is there anything different about the record that's failing?
It's likely that some other program may have written the record differently to the way ProIV is expecting it.
How is the external file stored & what is the extended definintion of the field?
It's likely that some other program may have written the record differently to the way ProIV is expecting it.
How is the external file stored & what is the extended definintion of the field?
#3
mmeneses
-
- Members
-
- 43 posts
Member
- Gender:Male
Posted 08 October 2003 - 03:46 PM
Hi Chris,
"It's likely that some other program may have written the record differently to the way ProIV is expecting it."
If the program was written differently well I guess this behavior is not strange anymore because we will have this error everyday. The error is like an isolated case but I cant figure it out how to work on this problem.
by the way the ITEM_LOC is not a field it is a glovia standard table and it was used by glovia standard program. So far I dont know exactly what field is failing.
thanks a bunch,
Mike
"It's likely that some other program may have written the record differently to the way ProIV is expecting it."
If the program was written differently well I guess this behavior is not strange anymore because we will have this error everyday. The error is like an isolated case but I cant figure it out how to work on this problem.
by the way the ITEM_LOC is not a field it is a glovia standard table and it was used by glovia standard program. So far I dont know exactly what field is failing.
thanks a bunch,
Mike
Attached Files
-
ITEM_LOC.TXT 4.12KB
99 downloads
#4
Vol Yip
-
- Members
-
- 393 posts
ProIV Guru
- Gender:Male
- Location:Hong Kong
Posted 14 October 2003 - 05:47 AM
Mike,
What DB are you using? Oracle? C-ISAM?
It look likes the file definition of ITEM_LOC in PRO-IV is different from the actual schema of the DB.
Check the file defintion of ITEM_LOC in PRO-IV and Superlayer level and regen the file / function involved.
Regards,
Vol
What DB are you using? Oracle? C-ISAM?
It look likes the file definition of ITEM_LOC in PRO-IV is different from the actual schema of the DB.
Check the file defintion of ITEM_LOC in PRO-IV and Superlayer level and regen the file / function involved.
Regards,
Vol
#5
Dan Shannon
-
- Members
-
- 374 posts
ProIV Guru
- Gender:Male
- Location:Australia
Posted 14 October 2003 - 11:46 AM
What version of PRO-IV? Vol's right - it's probably to do with a mismatch between PRO-IV filedef and table definition. We used to get this problem a fair bit with 4.6, not so much with 5.0 now.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
