on 2011 Oct 24 11:01 AM
Forum,
I have a scenario in SBO where for one business partner only, we're unable to update any amendments to the remarks. Each time anything is amended, the client crashes. This happens for all users on all pc's - again it's only for one BP record.
Has anyone ever come across a similar issue before?
Regards,
Juan
Did you import data from another system or did any back-end update? This would be the most likely cause of your problem. I suggest checking the ORCD table which is the primary table. See if you have any invalid characters or field lenght has been exceeded. Then check the CRD1 table to see if the address are entered correctly. Also there might be an issue with database schema if bad job was done on the back-end.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Juan,
Try SELECT * FROM OCRD T0 WHERE T0.CardCode = '[%0\]' for this BP. If nothing wrong, continue check CRD1 etc.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
you need to check what is present in this particular BP that other BP do not have. you can try to check this using a simple Query
Select * from OCRD
tip: while viewing the Query result need to eye on special characters i.e (*, ',#, etc)
regards,
Fidel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.