[RESOLVED] runtime error '6':overflow

[alinysyahril]

hi gurus..

i need your help after a week been looking for this solution and hope i'm in the correct track.

i run a VB6 application called CRF which i bought it from a developer. there's an interface to upload data from c: into the database (mssql).
so the problem is right now, when i want to upload data yesterday, it prompted runtime error 6: overflow which before this it can be run successfully.

anyone can explain to me what had happened and how to resolve it. and for your info, i haven't touch the source code because i didn't get the source code since the application purchased. when i refer to the internet, apparently the problem is with the source code. so here i don't think some command had changed right?

i tried to reinstall the application. fortunately, the data can be uploaded but when the second time i want to do the same thing, the runtime error had prompted once again.

what shoul i do?..
thank you in advance.

[ganeshmoorthy]

this is a problem with the data supplied thru the interface. you would have sent a double value to an integer variable. so, first check your data, change it and try once again and see it..hope it will work.. and this error is not handled in your application.

[d3gerald]

well that happens when a variable cant contain the data which is assigned to it.
for example, you declared a variable a as integer and you did something like
a = 10 / 3
this one returns an error because that computation does not return an integer. it returns a double.


so therefore, the problem is with the source code.

[pnish]

well that happens when a variable cant contain the data which is assigned to it.

That is true.

for example, you declared a variable a as integer and you did something like
a = 10 / 3
this one returns an error because that computation does not return an integer. it returns a double.

Your example is not true. If a is an integer, your example would return 3 without causing an error. VB will 'coerce' the return value to fit the declared data type if it can. If it can't, then you will get an error. For example:

Dim a as Integer
a = 65535

This would cause an error because an integer (in VB speak) can only hold numbers between -32768 and +32767.

[d3gerald]

ohh, sorry, i haven't worked with integers nowadays.

[alinysyahril]

this is a problem with the data supplied thru the interface. you would have sent a double value to an integer variable. so, first check your data, change it and try once again and see it..hope it will work.. and this error is not handled in your application.

thank you sir for your reply. i really appreciate it.

what do you mean by double value of integer anyway, sir? is it while upload the data, there are duplicates data? i've checked and retried however the error is still appear.

glad to hear it is nothing to do with the source code because i never know bout it

i also tried with a couple of another data..but still got the same error.

what should i do next?

[alinysyahril]

That is true.
Your example is not true. If a is an integer, your example would return 3 without causing an error. VB will 'coerce' the return value to fit the declared data type if it can. If it can't, then you will get an error. For example:

Dim a as Integer
a = 65535

This would cause an error because an integer (in VB speak) can only hold numbers between -32768 and +32767.

ermm..you're saying here is something to do with the source code right?

but how come before this, without i know bout the source code which i didn't get it earlier as well, the upload function can be run?

or is it updates or patches issue?

[l12ngo]

It could also be because you're passing too much data in, so you could try splitting up a file if you have a huge file you're passing to it. For example, this would cause an overflow error:

Dim i As Integer
Do Until i > 32767
i = i + 1
Loop

If for example you're passing a large Excel or text file to your app which contains over 32767 lines in it, then you could try splitting it up. Without looking at the source code though and knowing what the app is trying to do it's all going to be guess work as to where it's falling over. Your best bet would probably be to mail the software vendors and ask them to fix their code.

[litlewiki]

or maybe the amount of data u uploaded is more than what ur app can hold or handle.check it in the documentation if any such limits have been mentioned

[alinysyahril]

It could also be because you're passing too much data in, so you could try splitting up a file if you have a huge file you're passing to it. For example, this would cause an overflow error:

Dim i As Integer
Do Until i > 32767
i = i + 1
Loop

If for example you're passing a large Excel or text file to your app which contains over 32767 lines in it, then you could try splitting it up. Without looking at the source code though and knowing what the app is trying to do it's all going to be guess work as to where it's falling over. Your best bet would probably be to mail the software vendors and ask them to fix their code.

thank u friend..

i've tried that as well. even i tried to upload only 1 data in 1 time..
the error still came up.

the problem is i didnt get any support from the vendor anymore. they're gone with the wind

or is it possible if my sql server problem? might be it is full or something? but it is a fool guess i think..

[l12ngo]

I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.

Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?

[litlewiki]

I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.

Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?

you are right.if problem was on the db side .the error message would come from the db i.e the error message (description) will show the error code that was encountered on the db side .but i dont think thats the problem here.so may be its a flaw in the coding itself

[l12ngo]

It could also be down to the actual data you're passing to it. Say for example (just working with integers again), you've been passing order numbers to the app via your file, the app could be then taking that order number and assigning it to a variable which now can no longer cope with the data because you've reached the limit (badly explained so here's an example)

Data file 1 contains:

OrderNo: 32764
OrderNo: 32765
OrderNo: 32766

Run app and it works because it assigns the number to a variable which has been declared as an integer. Then, when you run against Data File 2:

Data file 2 contains:

OrderNo: 32767
OrderNo: 32768
OrderNo: 32769

App will return an overflow error.

Having said all this, this wouldn't explain why the app would run the first time after installation, but fail the second. Does the app still work if you close it then re-open it? If so it may be storing the data into a global variable, which doesn't get cleared till the app is closed.

There's so many ways this could be failing it's going to be really tough for you I'm afraid

[alinysyahril]

I doubt it's a database problem with an overflow error like that, but others here would know more about the database side of things so I'll let them answer that.

Is CRF the full name of the application (or an abreviation) and do you know what the vendors name is or was? Also, what does the app do, just load a single type of file to the database (in which case is it an Excel file or something similar?) or does it grab all the files on your hard drive?

in the setup.exe the application name is CRF.exe. actually this is such a tracking system for my company to track the inventory in our warehouse. the application will upload from a notepad named MRDATA.txt from C: which the fields are OPID, Subscriber, ContractNo, Product, Media barcode, Media Name, Location code, time and date.

[ganeshmoorthy]

do you remember when it was working fine what are the data you have uploaded. if you try with same set of data are you getting errors....

[alinysyahril]

do you remember when it was working fine what are the data you have uploaded. if you try with same set of data are you getting errors....

last week it still work well and the data format is just the same..

[ganeshmoorthy]

i'm asking about the data not data format...please clarify, if the same data and error then you have to call the vendor, no other way (you can play with your db, but you should be careful when doing this) or if no error for same data then you have to check the data

[alinysyahril]

these are samples of the data :-

1234 MIH OSS0000093 T MIH 00414646 SRS260505 00384898 25/02/2006 15:03:34
1234 MIH OSS0000093 T MIH 00414645 SIGN260505 00384897 25/02/2006 15:04:01

pls make me clear what is data and data format?

anyway, one more thing, when i run and pull the database (sql server) locally (127.0.0.1) from my pc..the program and the upload interface run properly and the data can be uploaded succesfully..

???

[alinysyahril]

my problem is now had settled..thanks to all the thread under this topic guys..

there's a file in setup program didn't install together during the installation. fortunately i've copied the tiptop file so i just copy it into the folder.

but i'm still confused why sometimes the file is missing, report cant be generated and other runtime errors in the application because i'm pretty sure i didn't touch anything since the first installation.

apparently i need to get the coding, no matter what huh...

anyway, thank u very much guys

[ganeshmoorthy]

fine...protect the system files, so that it will not be deleted without your knowledge

[alinysyahril]

i've got it clearly now..

the data itself is giving me all this headache

ermm..when i try with another stack of data..the upload process is going well..

how can data can be currupted, anyway?? eventhough it is still with the same file??
what can cause it?

[alinysyahril]

is there any hint sir, which data can be overflow??

[ganeshmoorthy]

when a value to a variable exceeds the overflow error occurs...if you assign more than 32767 then it causes this....

[biswaranjan111]

if run time error -6 overflow is coming
then
just change the integer data type to long...........
as a result it can hold more than 32767 data ....