Message
From
31/12/2022 13:38:57
To
31/12/2022 13:34:02
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
01685634
Message ID:
01685636
Views:
47
>>Hi,
>>
>>I am troubleshooting a problem where the error log has many entries like this:
>>
>>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.
>>
>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham