Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which field causes numeric overflow
Message
From
31/12/2022 13:55:51
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01685634
Message ID:
01685637
Views:
42
Hello Dmitry,

Could you tell us what precisely you can't offer that your competitors offer?

>>>Hi,
>>>
>>>I am troubleshooting a problem where the error log has many entries like this:
>>>
>>>12/30/2022 01:01:54 AM User: USERNAME. MethodName() Error: Numeric overflow. 
>>Data was lost. Value VIEW_NAME.PRINT_ORD: 3107
>>>
>>>
>>>The problem is that the field PRINT_ORD is an Integer type (accepts very large numbers). And from the error, above, the value is only 3107. Other values in the error log are all 4-digit numbers.
>>>
>>>How do I find out, from the TRY/CATCH which field actually causes the error numeric overflow?
>>
>>SQL server? Forget it. You may try with spanish inquisition, but I guess the tough guys from Redmond would never confess. Switch to postgres, there you get the field and the value.
>>
>>If you manage to talk with them, tell them that „data“ ARE plural.
>
>This is a MS SQL Server. I think before I switch to postgres, the customer will kick my ass. I am losing a lot of customers lately; not because of the SQL Server but because the competition offers something I don't have. I am guessing that what attracts customers to the competition is the Cloud. IT does not need to maintain a server and do the work. Then, they (IT) are surprised when their jobs go oversees.
>Thanks for confirming that it is a difficult problem to troubleshoot.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform